Controlling Quantities across WMS

Hi everyone!

I am currently using Shopify Plus in conjunction with Thomax’s dotWMS (.WMS) for fulfilment and stock management. The platforms manage a multitude of products and SKUs.

What I am curious to know, as Shopify is the master of the two, is if there is a way that when a product is ADJUSTED from the .WMS side, whether up or down, that Shopify can ping the .WMS for the total AVAILABLE stock on hand quantity of that SKU and return it to update the Shopify quantity, opposed to simply applying the adjustment.

I am currently seeing odd occurrences of quantities not matching up between the two platforms and am yet to find the cause, but if there can be a SKU specific trigger that forces Shopify to auto-match/update with the available quantity in the WMS then the cause of these inconsistencies will be null and all SKUs will automatically be corrected any time they are used.

If the trigger from the WMS being an ADJUSTMENT is not applicable, please suggest other triggers. Another thought I had was every LIVE SKU gets automatically matched on a consistent time interval? Open to ideas! The less manual, the better.

Thank you in advance!

Dan.

Yes, it is possible to set up a real-time inventory sync between Shopify and your .WMS system, so that the available stock on hand quantity for each SKU is updated automatically in Shopify whenever there is a change in your .WMS system.

One approach is to use a webhook integration to trigger an inventory update in Shopify whenever there is a change in your .WMS system. This can be set up so that the inventory levels in Shopify are updated in real-time whenever a new order is placed or whenever there is an adjustment in your .WMS system.

Another approach is to use an API integration to sync your inventory levels between Shopify and your .WMS system. This can be set up to run on a regular interval (e.g. every hour or every day), so that the inventory levels in Shopify are updated automatically based on the latest data from your .WMS system.

1 Like

Thank you very much!