Question

Is there a way to get rid of/combine duplicate item lines when syncing orders from BigCommerce containing multiple discounts on the same item?

  • 2 April 2024
  • 0 replies
  • 16 views

Userlevel 5
Badge +1

We have just come across this issue having been using Acumatica with Bigcommerce for a couple of years.  We have a promotion for an item XYZ which means a discount is applied when ordering 12 or over. We have also added a promotion for that same item when bought with another item ABC where it will be discounted by 2%. 

In BigCommerce this results in 11 items at the reduced price from the dozens discount with 1 item at a further reduced price from the ‘buy with item ABC’ discount.  This is fine and as expected. 

Our BigCommerce store in Acumatica is set up to show discounts at the document level.

The problem is that when the item syncs to Acumatica it results in multiple lines for item XYZ. One for the first 11 and another for a single item.  These show the same price (the reduced dozens discount price) for both lines as the discount is being shown at the document level.

I would expect as the discount is being applied at the document level these would be combined.  This is causing extra work and confusion for our warehouse as sometimes the extra line can be much further down in the details depending when the extra item that triggers the second discount is applied on BigCommerce so we are having to manually combine them every time this occurs.

Am I missing a setting somewhere for this?

 

Thanks for any advice/help you can provide,

Phil

 


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