We are using the Shopify Connector, and have the Shopify Warehouses mapped to Acumatica Warehouses. Whether I select a Location for the mapping or leave it blank, it seems to ignore anything <UNASSIGNED> regardless of Allocated or not. This is not ideal because it reports a higher inventory number than is actually available to be sold, resulting in over-selling, upset customers, etc.
Am I missing something?
+1i just had a similar issue. I’m on 24R2 build 07.
I had a location designated in my shopify store mapping, for inventory warehouse export mapping. And my availability was set to “Available to Ship”. It kept sending 1 QTY back to Shopify even though we had 3 orders (Allocation type) with the product allocated with 1 QTY per order.
When product availability ran it was not paying attention to the inventory on allocated orders because they are ‘UNASSIGNED’ until shipped. Since I had selected another ‘location’ in my settings it wasn’t using the right number.
Looking at the inventory summary, I saw that the TOTAL was correct for available for shipment, BUT the 2nd ROW was my location that was designated on the store mapping and the connector was picking that 1 QTY up and sending it to Shopify:
By removing the location from shopify store settings and making sure that any warehouse locations I don’t want to be included in availability are unchecked it now works.
Hope that helps.
Hi
This might primarily be happening because of the definition in the Availability Calculation Rules. Please check if Deduct Quantity on Sales Orders is selected.
If not, you can check that and then execute the Recalculate Inventory process.
Let me know if that helps please.
I removed the location from one of my warehouses to experiment, but it didn’t seem to affect things. Also though, my availability mode in the store is currently set to “Available”.
+1we always use available for shipment, so yes we kept that setting.
Hi
I removed the location from one of my warehouses to experiment, but it didn’t seem to affect things. Also though, my availability mode in the store is currently set to “Available”.
Did you ever find a solution for this issue? We are experiencing the same thing. We need Shopify to look into all warehouse locations so they are listed. only one that cannot be mapped is the <UNAVAILABLE> bin allocated items seem to fall into. We are using “Available to Ship” do I need to switch this to “Available” to work?
Hi
Were you? We have been dealing with this issue for months. If I remove locations then none of the inventory is correct. Our POS is a location in our main warehouse. I can map that location and it works. If I take the location out for the bin an item is in (shared bin with other items ) none of the variants have the correct inventory they all went to zero.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
