Importing Products
Instead of configuring products one at a time, you can set up many products and variants at once from a CSV file: their type, whether they're enabled, their settings, and the content they deliver. This is the quickest way to move your products over from another app.
License keys aren't part of a product import. Add them to your Download & License products afterwards, by hand or from a CSV file.
Importing a file
- On the Products page, click Import.
- Click Download the template. It has every column, and example rows to show the format. The template, below, explains what goes in each column.
- Fill in one row per product, or per variant, in a spreadsheet, then save it as a CSV file. Keep the header row as it is. Columns can be in any order.
- Add the file to the import window. It's validated right away, and nothing is imported yet.
- If any rows have problems, the window sums them up. Click Download Validation Report to see what's wrong with each row, fix them, and add the file again. Or tick the box to skip those rows and import the rest. See Validating your file.
- Click Start Import.
The import runs in the background, so you can close the window and leave the page. While it runs, the Products page shows its progress. When it's done, the page shows the results, and they're also added to the alerts on your dashboard. Dismiss them in either place, and they're gone from both.
Import your products leaving enabled empty, so they're set up disabled while you migrate everything. Then take each product live when you're ready. See Migrating from another App.
Validating your file
When you add your file, it's validated before anything is imported. The import window shows the results in one banner:
- Red if any rows have problems: how many rows have problems, out of how many, and each kind of problem with how many rows have it.
- Green if every row is ready to import, with anything you should know about them, such as products that are already set up, which only get the content they're missing.
Warnings, such as rows that set products up enabled, show in their own yellow banner. Read them before you start.
The validation report
To see every row, click Download Validation Report. It's your file as a CSV, with two columns added at the front:
| Column | What's in it |
|---|---|
result | Ready, or Problem. |
details | For a problem, what's wrong and how to fix it. For a ready row, anything you should know, such as that the product is already set up. |
Everything else is just as you wrote it: your columns, in their order, with their headers, even ones the import doesn't use.
To fix the problems, edit the rows marked Problem, in the report or in your spreadsheet, and add the file again. The result and details columns are ignored on import, and replaced each time the file is validated, so you can keep fixing the same report until every row is ready. If you open it in Excel, see Editing in Excel first.
The validation report is made in your browser from your file. Nothing is imported or saved until you click Start Import. After the import runs, it has its own report of what happened to each row: see When rows fail.
The template
| Column | Required | What to put in it |
|---|---|---|
product_id | Yes, unless variant_id has the variant's address | The product. See Product and variant IDs. |
variant_id | No | To set up one variant: its ID or address. Leave it empty to set up every variant of the product the same way. |
type | Yes | Download Only or Download & License. See Configuring a Product. |
enabled | No | TRUE or FALSE. Leave it empty to set it up disabled, as when you configure a product by hand. See Enabling products. |
content | No | Content from your library to link, separated by ;. See Linking content. |
download_button_text | No | The download button's text, or OFF for the default text. |
multi_content_button_text | No | The text of the button that opens the list of downloads, for products with more than one piece of content. OFF for the default text. |
license_key_terminology | No | What its license keys are called, such as Activation Code, or OFF. |
auto_sync_inventory | No | TRUE or FALSE. |
inventory_location | No | The location Auto Sync Inventory updates, by its name in your Shopify admin. Only with auto_sync_inventory set to TRUE. Leave it empty to use the location Shopify stocks it at. |
auto_restock_inventory | No | TRUE or FALSE. |
unused_key_restock_days | No | A number of days, from 2 to 36,500, or OFF. |
The last five columns are only for Download & License products. A Download Only row with any of them filled in has a problem.
The settings columns set the product's own override of your store-wide setting, as on its settings page, and work like every other override: see Setting Priority. A value is On with that value, OFF or FALSE is Off, and an empty cell is Not Set, so the product follows your store-wide setting. See Product Settings for what each one does. You can change them later on the product's page.
Product and variant IDs
product_id and variant_id each take one ID, in any of these formats:
| Format | Example | Where to find it |
|---|---|---|
| Product address | https://admin.shopify.com/store/your-store/products/8123456789 | Open the product in your Shopify admin, and copy the address from your browser. |
| Variant address | https://admin.shopify.com/store/your-store/products/8123456789/variants/44123456789 | Open the variant from the product's page, and copy the address. It includes the product, so product_id can be left empty. |
| Product or variant ID | 8123456789 | The number at the end of the product's or variant's address. |
| Shopify API ID | gid://shopify/Product/8123456789, gid://shopify/ProductVariant/44123456789 | Exports and apps that use Shopify's API. |
A plain number is read as a product in product_id, and as a variant in variant_id. A file exported from the Products page has both, so it can be imported as it is.
Each variant in one row
A row without a variant_id covers every variant of its product. So a file can't have a row for a product and a row for one of its variants, or the same variant twice. To set up a product's variants differently, give each variant its own row.
Linking content
Content has to be in your library before a product can be linked to it. Each value in content must match exactly one item:
| Value | It matches |
|---|---|
| The address of the content's page in the app | That content. Open it in the app, and copy the address from your browser. |
| Any other web address | A link with that address, or a file imported from it. |
| Anything else | Content with that exact name. Capital letters don't matter. |
If a value matches nothing, or more than one item, such as two pieces of content with the same name, the row has a problem. Use the content's page address instead. The same goes for content with a ; in its name.
It's simplest to import your products first, then link your content to them from the content import, as the Onboarding Guide does.
Products that are already set up
An import never changes a product or variant that's already set up in the app, and never sets one up twice. So once you've fixed the rows that failed, you can import the whole file again, or just the failed rows.
When a row's product or variant is already set up:
- Its type, whether it's enabled, and its settings stay as they are, whatever the row says. Change them on its page.
- It's linked to any of the row's content it doesn't have yet. If it has all of it, the row is skipped.
- If the product has variants that aren't set up yet, such as ones you added in Shopify since, they're set up from the row.
Because an import never changes a product that's already set up, you can't use it to change many products' type, status, or settings at once. Make those changes on each product's page.
Enabling products
A product set up enabled goes live as soon as its row is imported: new orders for it are processed from then on. If you're migrating from another app, make sure it has stopped processing the product's orders first, or leave enabled empty and take your products live later.
- Download & License products have no keys yet. One enabled by an import sends orders without keys until you add some. See When You Run Out of Keys.
- Your Shopify inventory doesn't change. The import leaves it as it is, even with Auto Sync Inventory on. It's updated once you add license keys to an enabled product, or when you enable a product with Update Shopify Inventory ticked.
Editing in Excel
Excel changes some values when it opens a CSV file, and saves them changed:
- Long numbers turn into scientific notation. A variant ID like
44123456789012shows as4.41235E+13, and that's what's saved, with the rest of its digits gone. - Leading zeros are dropped, so
00123is saved as123. - Some values turn into dates, such as
3-12.
To keep your values as they are, open the file from Excel's Data tab with From Text/CSV, and under Data Type Detection choose Do not detect data types, so every column stays text. Or set a column's format to Text before you paste into it. It matters most for product_id and variant_id. Other spreadsheet apps can change values too, so the same goes for them.
Product and variant addresses and Shopify API IDs are text, so they're never changed. If an ID was changed to scientific notation, the import says so: paste it again in a column formatted as Text.
When rows fail
The results show how many rows were imported, skipped, and failed. Click Download Report to see what happened to each row. It's your file as a CSV, with a result column (Imported, Skipped, or Failed) and a details column that says what went wrong with a failed row, or why a row was skipped. To retry the failed rows, fix them in the report and import it as it is: the result and details columns are ignored, and the rows that were already imported are skipped.
Products are looked up in Shopify when their row is imported, not when you add the file, so a product that isn't in your store shows up in the results.
Common problems:
| Problem | Fix |
|---|---|
| A required column is empty | Fill in product_id and type. |
| Only a variant ID, with no product | Add the product's ID to product_id, or use the variant's address, which includes it. |
| More than one ID in a cell | Give each product or variant its own row. |
An ID in scientific notation, such as 5.14516E+13 | Your spreadsheet app changed it. See Editing in Excel. |
| The product isn't in your store | Check the ID. The product may have been deleted in Shopify. |
| The variant isn't in this product | Check the variant's ID, and that product_id is its product. |
| The same variants as an earlier row | See Each variant in one row. |
| The content isn't in your library, or matches more than one item | See Linking content. |
| A license column on a Download Only row | Leave it empty, or change the row's type to Download & License. |
| The location isn't one of your store's | Use its name exactly as it appears in Settings → Locations in your Shopify admin. The location must be active. |
| A location without Auto Sync Inventory | Set auto_sync_inventory to TRUE, or leave the location empty. |
| Shopify couldn't be reached | Import the failed rows again. |
Limits
- 5 MB and 5,000 rows per CSV file. Split a bigger catalog into several files.
- One import at a time, of any kind: wait for a product, content, or license key import to finish before starting the next.
- Saving from Excel with
;between columns is fine. The import works out which separator the file uses.
Importing products needs the Create and Edit permission for products. That includes their settings, without the Settings permission. Downloading the import's report needs the Export permission for products, unless you started the import. See Staff & Permissions.