Question

Big Commerce sales price sync with wrong unit of measure (UOM)

  • 14 September 2021
  • 4 replies
  • 38 views

Userlevel 1
Badge +1

For some reason the pricing sync for Big Commerce when you have multiple units of measure enabled is to use the base unit and not the sales unit.  This is a major problem because customers build pricing based on the sales unit and not the base/stocking unit.  How do we go about getting this changed?  This is a critical issue for one of our clients.

 

https://help-2021r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=994bc074-79eb-403b-81c4-9545d470a01d

Limitations of Sales Price Synchronization

  • UOM-specific prices: In Acumatica ERP, if the Multiple Units of Measure feature is enabled on the Enable/Disable Features (CS100000) form, you can define a sales price of an item for each of the units of measure in which your company sells this item. However, only prices defined for the base UOM can be exported to BigCommerce.

4 replies

Userlevel 3
Badge +1

@KurtBauer Thanks for the question. 

It is designed as such because the Base unit of measure is not likely to change when compared with Sales unit of measure. Sales Price sync is complicated. Imagine you have synced the prices with UOM being EA with BigCommerce(BC) and then you simply go to Stock Item and change the UOM to PIECE but this change will not be reflected to Sales Price because the last modified date of the Sales Price will not be updated with this change of UOM in Stock Item. So the price from EA has to be removed and price from PIECE must be update in BC which will never be reflected. So that's why we say it is complicated and we went with the option which would have minimum changes. 

Nevertheless, your request is valid, we will discuss internally and get back to you. 

Thank you

Userlevel 1
Badge +1

Karthik,

Thanks for the explanation.  It all makes sense.  

Could an update be made to the Last Modified Date on the ARSalesPrices table for the InventoryID and UOM to then cause the sync to recognize the change in the sales price record?

The client doesn’t plan on changing the sales unit on the inventory item, so I’m sure they would be fine with a small customization to use SalesUnit instead of BaseUnit in the BC Sync engine.

Thanks

Kurt

 

Userlevel 1
Badge +1

@KarthikGajendran 

Any updates on a possible fix to the UOM issue?  The client cannot continue with testing and implementation without proper pricing.

Thanks,

Kurt Bauer

Userlevel 3
Badge +1

@KurtBauer I have already created the ticket with our engineering team and we have planned it for the next sprint. Even when it is developed, mostly it would be available in 2021R1(29-Oct-21) and 2021R2(08-Oct-21) latest builds.  

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 — 2020  Acumatica, Inc. All rights reserved