I wish to use the plugins for a books retailer's online website which syncs with amazon off the WooCommerce product database. The number of SKUs (or books) is in thousands, as is the nature of any bookshop's product list.
There are two locations A,B with inventory having processing time 3 days and has one location C with 6 days processing time for orders received.
Prices for the books in the 1st two locations A,B would remain the same whereas the price would differ should stock come from location C. For this, there is a separate price field for each location. But on front end it need not show the price range rather just the price for that particular location which is currently on priority.
Across all products, there should be priority for the location A then B then C, based on which location has a product in stock.
Each location sends their stock list daily by CSV with fields being ISBN (Barcode), Selling Price and Stock. Therefore there would need to be an import for each location daily, with the ISBN (Barcode) being a commonly used SKUs for the product. In other words, all three locations use the same SKUs for a product and as such, should be the key product identifier in the imports.
Purchase prices, suppliers, POs will not be modules that are used in this scenario. Just different locations with different prices and processing times, with all of them sharing the same SKUs for a product.
With all this, the third party plugin that syncs woocommerce with amazon uses the default "Price", "Stock" and "SKU" fields to send data to Amazon. After all the magic is done, will ATUM be updating these default fields so that the syncer can do the syncing or is data stored across different columns and magic done only on front end as necessary? "Processing time" should also be a field for each item that the syncer can refer and send to Amazon.
Thanks for taking the time to read my post, this is my case and I hope it spills my requirements clearly so you may be able to tell me if this is all possible. I have gone through the Demos and I think it will take me a lot of time to conclude on my own if this is all possible, rather if you can let me know, that would be extremely helpful.
Thanks