Is it possible to make this subtract from Shopify inventory in any way? Does DSYNC have a solution for that?
Case Study Shopify to XML to Cash register inventory update
Shopify is main inventory and a cash register system sends updates via XML to a ftp store every time there is a physical sale.
Shopify -> Sale -> generate xml -> post xml to filestore with custom mapping (need help setting this up – This xml needs to contain the current inventory status, after the sale of the sold product, not just a -1 on SKU.)
Cash Register -> Receives the xml and updates it’s own inventory. (this is ready and waiting. It currently scans an ftp folder for xml, updates its inventory and deletes the file)
Cash Register -> Sale -> posts xml to filestore with information (already active)
Shopify picks up xml and deducts the corresponing SKUs. (need help to make this happen)
DSYNC will be able to handle this. But those two post.xml can't be the same name though, or else it might cause a loop. I would suggest they have different name.
The configuration is now complete - ready for your review/testing.
1. From Shopify to Cash Register
There is a webhook created in the dsync1 shopify which sends data to DSYNC whenever a new fulfilment is created. The data from the fulfilment is captured and processed via few callbacks and finally an XML file is generated for each article in that fulfilment in the XML format requested. The output to FTP is currently disabled so that you can review the XML generated we have configured a link point which is accessible
To test this, log in to the DSYNC1 Shopify and create an order, then fulfill the order and check the link point URL (you will always get the last product in the fulfillment on the URL however you are able to see all the XMLs for all the products in the fulfillment in the jobs history from the DSYNC UI.
2. From Cash Register to Shopify
Again, as per above due to review/testing, this is currently configured from a manual upload of any of the XML files which currently sit on the FTP host in /Omega/FromPOS/ folder. The link configured goes from this manual upload endpoint link into the 'Batch Variants (Sender)' endpoint in Shopify. To test this, right click on the link and select 'RUN'. You will be prompted to upload an XML file - upon saving the job will run and update the inventory levels for all the products in your XML file.
To avoid processing of the same file twice, we should have another folder next to the '/FromPOS' called something like 'FromPOS_Processed' where we should move all already processed files. Can you please create such folder? The path of this folder should be on the same hierarchy as the existing folder: /Omega/FromPOS_Processed'.