Skip to main content
Question

Virtual warehouse / inventory for drop shipping

  • 28 September 2023
  • 2 replies
  • 117 views

Forum|alt.badge.img+1

Does anyone know if it’s possible to have a virtual warehouse/inventory in Acumatica? We receive inventory files from vendors and it would be great to be able to “receive” that inventory into a virtual warehouse so our salespeople can see available quantities from the vendor. In theory we could then also sync that inventory to Shopify so we can prevent overselling on drop ship inventory.

If it’s not currently possible in native Acumatica, are there any 3rd party solutions? Or ideas for workarounds?

2 replies

Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@mikeho , I haven’t found a way to do this.  The closest I could get was to create an attribute for each product, for each virtual warehouse, and have visibility that way.  The connector to Shopify will need to be modified to pick up those numbers and push them to Shopify.

The issue with standard Acumatica warehouses is that you can’t easily update data in those warehouses.  Say, your vendor sends you a new file where some items are completely depleted, on some, the inventory went down, on some - it went up…  The only way you can change inventory in that warehouse in Acumatica is through 1) adjustments; 2) receipts (you can use negative receipt to adjust inventory).

In addition, this inventory is on your books. Of course, you can receive it at $0.00 cost, but then when you sell one of these items, you will need to employ a custom processing workflow in Acumatica (possibly, to change warehouse from your virtual, to a real warehouse, do a drop-ship order, etc.) so that the cost accounting would kick in correctly.

I know it’s not an answer to your problem, but something you should be thinking about when you’re working on a workaround.


Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • 228 replies
  • September 29, 2023

Thank you, @Yuri Karpenko. Yes, the financial impacts are definitely important to us (and why I was hoping there might be some sort 3rd party option or a good workaround).

I’ve thought about the attribute route but I can’t see how we would go about depreciating the # in that attribute field when purchases are made in Shopify. I’m also not a fan of customizing the connector in general as - in my experience - that can be problematic, but it sounds like that might be the only way to go about this.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings