The best way to set up your inventory's initial stock levels is by uploading a specially-formatted CSV with your stock level and inventory location information.
First, you'll want export an 'Inventory-formatted' CSV file containing your existing products.
Click on the Products tab.
Next, select Inventory from the sidebar on the left.
Now that you're on the Inventory grid, click Export.
In the new window, choose the "Export ALL active Standalone and Variant products with or without inventory." option and click Export Now.
When the export's complete, click the link in the top right to download the file.
*Important: Do not edit, add, remove, or move any of the CSV's column headers!
Open the CSV and enter the stock levels (and their inventory locations, if applicable) for your products into their corresponding fields. The CSV's Loc1, Loc2, Loc3, and Loc4 columns map to the Area, Unit, Shelf, and Bin portion of the Warehouse Layout, respectively.
*If you have multiple Inventory Warehouses, please note that ShipStation can only import inventory for one Inventory Warehouse at a time.
When you're done editing the spreadsheet file, save it as a CSV. Then click Import on the Inventory page's action bar.
Select your Inventory CSV and then select the correct warehouse from the drop down. Click Start Import.
Once your import is complete, your stock levels and locations will be established for that Inventory Warehouse! Simply repeat this process for each Inventory Warehouse you have stock counts for.
Here are some additional details for the Inventory Import CSV process:
- The SKU and Stock fields are required!
- The CSV's Loc1, Loc2, Loc3, and Loc4 columns map to the Area, Unit, Shelf, and Bin portion of the Warehouse Layout, respectively.
- If you don't specify at least one 'Loc' value during the import, ShipStation will display the Inventory Warehouse Location as (Unspecified).
- You may add additional rows in the CSV that specify additional Inventory Warehouse Locations for a single product, and ShipStation will add them to that SKU.
- You can include multiple Inventory Warehouses on a single CSV file, but to upload the inventory for multiple Inventory Warehouses, you will need to do multiple imports, selecting the Warehouse to apply the import to each time.
(If you prefer to load your initial stock levels manually, you'll first need to manually set up all inventory locations within your Inventory Warehouse. Once you've done that, click on individual SKUs in the Products grid and click on the Inventory tab. Once there, click Add to Alternate Location to create an initial inventory record for that SKU.)
Also, make sure you have Enable Inventory Tracking turned on so the deductions will happen!
Download this sample CSV below to see how to format your Inventory CSV!