How to use different UOM than the Sales UOM for the Commerce Orders?

  • 2 February 2023
  • 0 replies
  • 191 views

Userlevel 7
Badge +2

Use Case: Users would like to sell in Commerce sites the same product in different UOMs than the default Sales UOM in Acumatica. Example, merchant could sell apples in Kilogram(KG) and also in Pounds(LBS). In Acumatica, the user could have the Sales UOM as LBS but sells in Commerce site as KG. Most of the sites do not support UOM. Both Shopify and BigCommerce does not support it. 

Solution: Provide the SKU code of the product in Commerce site in the Cross-Reference tab in the Alternate ID field with the required UOM in the Stock/Non-Stock forms in Acumatica. Commerce Connector, will get the SKU code from the Commerce site’s sales order product and checks in Acumatica if there is a matching Inventory ID, if it finds, then it will be used with this UOM in Acumatica SO Line. If not, connector will check the Alternate ID from the Cross-Reference tab with Alternate Type as Global. If it matches, then the UOM will be taken from the cross reference tab for the SO Line. 

Please see below screenshots. 

Acumatica Stock Item: 


Shopify Product:

 

Acumatica Sales Order:

Please note that the main Inventory ID stays the same as APPLES but the Alternative ID matches with the SKU code in Shopify and the UOM is taken from the Alternative ID instead of the main Inventory ID. 


0 replies

Be the first to reply!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved