Exporting or importing inventory with a CSV file

You can export an inventory CSV file that contains your inventory quantities at your locations. You can use that exported CSV file as a template to update the inventory quantities. Then, you can import the CSV file to update Shopify with the inventory quantities for each product in each location.

Export inventory

You can export an inventory CSV file either to create a template that contains your uniquely identified products or product variants for the specified locations, or to export the inventory quantities for use in other systems or processes.

You can specify whether you want to export the data for all of your locations or just for one specific location.

Depending on the size of the export, the file will either be downloaded in your browser or emailed to you.

Steps:

  1. Go to Products > Inventory.
  2. Click Export.
  3. Specify the rows you want to export and whether you want to export from all locations or a single location.
  4. Click Export inventory.

Update the inventory amounts

After you've exported the CSV file to get a template, you need to update the inventory quantities in the file.

The CSV file has several columns to help you identify your product, as described in Inventory CSV file format. When you're converting your store to use multiple locations, edit only the location columns.

Steps:

  1. Open your exported CSV file in a spreadsheet program.

  2. If your CSV file contains location columns that you don't want to update the inventory for, then delete the entire columns for those locations, including their headings.

  3. Update the quantities in the remaining location columns. The numbers that you enter in each row can be positive, negative, or 0. You can also enter Not stocked to indicate that the product is never stocked at the location.

  4. Save the CSV file.

Import inventory

Before you import inventory, make sure that your CSV file is in the correct file format.

If you don't want to update quantities for a location, then make sure that the column for the location, including the column heading, was removed from the CSV file.

The import procedure updates (overwrites) inventory quantities only. It doesn’t create locations or update the product identification values.

Importing inventory quantities overwrites your inventory data, so you should import your inventory only when other inventory adjustments, such as ongoing sales or manual changes, aren’t taking place.

Steps:

  1. Go to Products > Inventory.
  2. Click Import.
  3. Choose your updated CSV file.
  4. Click Import inventory.
  5. Verify what you intend to import, and click Start import.

Inventory CSV file format

The inventory CSV file contains information that uniquely identifies a product or product variant and the inventory quantities at the specified locations. It's similar to other CSV files that you use with Shopify, but has different columns.

The inventory CSV file has the following columns:

  • Handle - Handles are unique names for each product. They can contain letters, dashes and numbers, but no spaces. A handle is used in the URL for each product.
  • Title - The Title column is optional. If you include it, then the values can be left blank.
  • Option1 Name - If a product has an option, then enter its name. For example, Color. For products with only a single option, this should be set to Title.
  • Option1 Value - If a product has an option, then enter its value. For example, Black. For products with only a single option, this should be set to Default Title.
  • Option2 Name - As above, but can be left blank.
  • Option2 Value - As above, but can be left blank.
  • Option3 Name - As above, but can be left blank.
  • Option3 Value - As above, but can be left blank.
  • SKU - The SKU column is optional. If you include it, then the values can be left blank. Currently, in Shopify, SKUs do not need to be unique.
  • <Name of location> - The amount of inventory in the location specified by the column name.

    When importing, include a column for each location that you want to update inventory for and remove all the other location columns and headings.

    The column heading is case sensitive and must be the name of one of your locations. The number can be positive, negative, or 0. You can also enter Not stocked to indicate that the product is never stocked at the location.

To uniquely identify a variant, specify values for the Handle, Option1 Value, Option2 Value, and Option3 Value columns.

Your inventory CSV file must be in the correct format and needs to have a .csv file extension.

Ready to start selling with Shopify?

Try it free