Last item in stock that is on an Acumatica sales order still shows on the Big Commerce website as available for sale
We do not want items sold out or not available for sale to show up on our Big Commerce Website. Here is our problem: When the last item in stock of a particular SKU is on an Acumatica sales order (but not invoiced) it still shows on the Big Commerce website as available for sale. How can we configure our Acumatica connector so when the last item of a SKU is on a sales order the item will not show up as available for sale on the Big Commerce website?
We are on Acumatica 2020 R1.
Page 1 / 1
Hi @dougmcbride79! I think you can update availability calculation mode to the following settings:
In the Connector Store set the Order Type to SA instead of SO. This will make automatic allocation of all the commerce items for the sales order. This item won’t be available for the other orders
On the Availability Calculation Rules make sure that the Availability calculation includes deduction for the sales Order
I think this should help.
Thank you. We have checked our settings and our configuration already was deducting for items on sales orders. See below. What is the next thing we should check?
@dougmcbride79 please check following things:
You use order Type SA or another type with allocation.
In Store Preferences you use Qty Available.
If that does not work, please submit a support case. You can refer to this discussion for the faster response.
We use order type “SA”, so items on a sales order are allocated and not available for sale.
Our Store Preferences use Track Qty. See image below:
So I think I need to open a case. You agree?
@dougmcbride79 you should change this to Available. Available for Shipping does not count allocated items.
Thank you. I have changed the “Availability Mode” from “Shipping” to “Available”.
We made the change from “shipment” to “Available”. After this change, we get 100% sync error. See below. What is wrong?
@dougmcbride79 , it’s probably too late to address your issue. But when configuration changes are done (like changing type of availability), you would need to do a Full Sync (instead of Incremental Sync) or even go to Entities, select Product Availability, CLEAR SYNC HISTORY, and then re-prepare and re-process that data. I have found in my experience that it usually helps.