Bulk updating inventory with a CSV file in Shopify

To turn on inventory tracking and stop overselling for many products at once, export your products from Shopify, set two columns in the CSV, and import the file back with overwrite turned on.

1. Export your products

1. In your Shopify admin, go to Products.
2. Click Export.
3. Choose which products to export and pick CSV file for Excel, Numbers, or another spreadsheet program.
4. Click Export products. Large exports are emailed to you.

2. Edit the inventory columns

For every variant row you want to batch track in Freshly:

• Set Inventory tracker to shopify . This turns on Track quantity for the variant.
• Set Continue selling when out of stock to deny . This stops sales once the variant and all of its batches reach 0.

Leave the Inventory quantity column alone. Changing stock through a CSV import doesn't update your Freshly batches, so your batches and Shopify quantity will no longer match. Add stock through Freshly instead. (That column also only works for stores with a single location.)

For the full list of columns, see Shopify's Using CSV files to import and export products.

3. Import the file

1. In your Shopify admin, go to Products.
2. Click Import, then Add file and choose your CSV.
3. Select Overwrite products with matching handles so your existing products are updated.
4. Click Upload and continue, review the details, then click Import products.

Imports can't be canceled once they start. See Shopify's guide to importing products with a CSV file.

The CSV doesn't control which locations stock a product. To stock a variant at a location, use Edit locations on the product page, as described in Setting up products and variants in Shopify.

If you have questions about getting your products tracked properly, contact our team.