Basic Requirements for Inventory Sync
- Send a file with a consistent naming convention
- We recommend “inventory_*timestamp*” in .csv or .txt formats
- Excel formats not allowed
- Delimiter should be comma or tab
- The Inventory integration can process files in two ways: overwrite or update. Specify to your JOOR Integration Manager which of these you would like to utilise
- Overwrite clears all existing inventory and loads new positions included in the file for the specified warehouse(s). Warehouses not included in the file will not be affected
- Update only loads positions included in the file. SKUs on JOOR not included with the file will be untouched.
- Files must be listed with one size per row
- The best format for the inventory integration matches updates based on UPC/EAN. When using this format, the minimum required columns are UPC and quantity. UPC information will also need to be loaded to the product data on JOOR.
- If UPC/EANs are not available, we can match inventory on SKU information. Minimum required columns for this format are style number, color name/code, size name, and quantity.
- To use multiple warehouses, these will need to be loaded to JOOR beforehand. Please provide a complete list to your JOOR representative.
- The Date column is only necessary if you plan to use WIP inventory. This column should not be populated for immediate or available to sell quantities
Additional Resources
For info on inventory sync, review complete documentation here, and find UPC and SKU templates attached.
Find a list of recommended Inventory Sync testing scenarios here. Use this list as a guideline as you test different scenarios relevant to your business. Once all tests have been executed successfully, your integration should be ready to activate.