How to Set Up Inventory Manual Uploads

1. Ensure your products' SKUs are correctly mapped to the vendor's. The CSV mapping file should contain no errors, such as duplicate entries, typos, etc. Mapping instructions can be found here.

2. Prepare the inventory file, make sure it contains no errors, i.e duplicate entries, typos, etc.. Upload a sample file, and click 'Update'. Then, you need to map the columns and update the settings.

 

3. Upload the inventory file manually. 

 Inventory Settings Notes: 

  • The delimiter field should be the same as in the inventory file. Delimiters can be commas, semicolons, pipe delimiters.. etc.
  • Checking the box for 'Update Inventory Quantity in Shopping Cart' will push the inventory update from your vendor's feed to your shopping cart.
  • Setting a number for 'Shopping Cart Update Threshold' will make Spark Shipping skip updating quantities higher than this number. If the quantity at the vendor feed falls below this number, Spark Shipping will push the update to your shopping cart. This helps reduce the number of API calls made to your site.
  • Setting a number for 'Out of stock threshold quantity' will make Spark Shipping set the quantity as 0 in your shopping cart if the quantity falls below this number in your vendor's feed. This helps avoid overselling a product.