Skip to main content

Importing Content

Instead of adding content one item at a time, you can import a whole library of files and links from a CSV file, configure settings, and link it to its products in the same step. This is the quickest way to move your content over from another app.

Importing a file​

  1. On the Content Management page, click Import.
  2. Click Download the template. It has every column, and example rows to show the format. The template, below, explains what goes in each column.
  3. Fill in one row per content item in a spreadsheet, then save it as a CSV file. Keep the header row as it is. Columns can be in any order.
  4. Add the file to the import window. It's validated right away, and nothing is imported yet.
  5. 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.
  6. Click Start Import.

Due to the nature of possibly needing to migrate large files, the import runs in the background, so you can close the window and leave the page. While it runs, the Content page will continue to show its progress. When it's done, the page shows the results, and they are also added to the alerts on your dashboard. Dismiss them in either place, and they're gone from both.

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 content that's already in your library, which is only linked to the products it's missing.

Warnings, such as rows that link content to enabled products, whose customers get it right away, 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:

ColumnWhat's in it
resultReady, or Problem.
detailsFor a problem, what's wrong and how to fix it. For a ready row, anything you should know, such as that the content is already in your library.

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​

ColumnRequiredWhat to put in it
typeYesFILE or LINK. See Files and links.
nameYesThe name you see in the app.
urlYesFor a link, the address customers open. For a file, a direct download link to the file. Either way, it must start with https:// or http://, and open without signing in.
display_nameNoThe name customers see. Leave it empty to use name.
sizeNoA link's size, shown to customers, such as 500 MB or 1.2 GB. A number on its own is read as bytes. Leave it empty for a file: its size is measured when it's imported.
enabledNoTRUE or FALSE. Disabled content isn't available to customers until you enable it. Leave it empty to enable the content.
download_limitNoHow many times customers can download it, such as 5, or OFF for no limit. Leave it empty to use your store-wide download limit.
time_limit_hoursNoHow many hours after their order customers can download it, such as 720 for 30 days, or OFF for no time limit. Leave it empty to use your store-wide time limit.
product_idsNoThe products to link the content to, separated by ;. Every variant of each product gets the content.
variant_idsNoThe variants to link the content to, separated by ;. Only these variants get it.

Leave both product_ids and variant_ids empty to add the content to your library without linking it to products or variants.

download_limit and time_limit_hours set the content's own override of your global setting, just as on its settings page, and work like every other override: see Setting Priority. A setting is On if you provide a limit, provide OFF to configure the setting completely Off, and leave the cell empty to configure Not Set (content follows your global setting). You can change them later on the content's page.

Product and variant IDs​

product_ids and variant_ids accept any of these:

FormatExampleWhere to find it
Product addresshttps://admin.shopify.com/store/your-store/products/8123456789Open the product in your Shopify admin, and copy the address from your browser.
Variant addresshttps://admin.shopify.com/store/your-store/products/8123456789/variants/44123456789Open the variant from the product's page, and copy the address.
Product or variant ID8123456789The number at the end of the product's or variant's address.
Shopify API IDgid://shopify/Product/8123456789, gid://shopify/ProductVariant/44123456789Exports and apps that use Shopify's API.
  • A link points customers to a file you host somewhere else, as when you add a link. The import just saves its address.
  • A file is copied into the app from its URL, as if you'd uploaded it. After that, the URL is no longer used: customers download the copy, and it counts toward your storage and bandwidth like any upload.

Importing files​

  • Use a direct download link: one that downloads the file straight away in a private browser window, without signing in. A share page, such as a Google Drive or Dropbox page with a download button, is a web page, not the file. Use the service's direct download link instead.
  • Up to 20 GB per file. Upload larger files yourself on the Content page.
  • Most file types are fine, as with uploads. A few that can run code on a customer's computer, such as .scr and .vbs, can't be imported.
  • The file keeps its own name and type, from its server or the end of its URL. Customers download it under its display name, with that file type. If its type can't be worked out, the row fails: use a URL that ends with the file's name, such as setup.zip.

Products must be set up first​

Content can only be linked to products and variants that are set up in the app. To set up many at once, import them first. The pre-import check tells you which ones aren't:

  • A product in product_ids must have all of its variants set up. Otherwise customers who bought the other variants wouldn't get the content. Set up the missing variants, or list only the set-up ones under variant_ids instead.
  • A variant in variant_ids must be set up, too.
Linking content to an enabled product

Content you link to an enabled product is available right away to every customer who already bought it, not only to new orders. The import tells you how many rows do this before you start.

Importing the same file again​

An import never adds the same content twice. So once you've fixed the rows that failed, you can import the whole file again, or just the failed rows.

A row matches content that's already in your library when:

TypeIt matches
LinkA link in your library with the same URL.
FileA file imported from the same URL before.

When a row matches:

  • The content is linked to any of the row's products and variants it isn't linked to yet. If it's linked to them all, the row is skipped.
  • Nothing else changes. Nothing is unlinked, and the content keeps its name, display name, and settings. Change those on the content's page.
  • Files will not be downloaded again.
warning

A file you uploaded manually yourself never matches, because it wasn't imported from a URL. Therefore, we have no way of determining if this file is a duplicate. Importing it adds a second copy.

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 44123456789012 shows as 4.41235E+13, and that's what's saved, with the rest of its digits gone.
  • Leading zeros are dropped, so 00123 is saved as 123.
  • 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_ids and variant_ids. 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.

Common problems:

ProblemFix
A required column is emptyFill in type, name, and url.
The URL isn't a web addressUse the full address, starting with https://.
The size isn't understoodUse a number of bytes, or a number with KB, MB, GB, or TB. Use a dot for decimals: 1.5 GB, not 1,5 GB.
The same URL as an earlier rowEach URL can only appear once in a file. Combine the rows, listing all of their products.
A product or variant isn't set up in the appSee Products must be set up first.
An ID in scientific notation, such as 5.14516E+13Your spreadsheet app changed it. See Editing in Excel.
The file couldn't be downloadedOpen the URL in a private browser window. It should download the file without signing in. The message ends with the server's answer when there is one, such as 404 (not found) or 403 (not allowed).
The URL opens a web page, not the fileUse the file's direct download link, not its share page.
The URL points to a private network addressThe file must be on the public internet.
The file is larger than 20 GBUpload it yourself on the Content page.
This type of file can't be uploadedIt's one of the few blocked types.
The file's type couldn't be worked outUse a URL that ends with the file's name, such as setup.zip.

Limits​

  • 5 MB and 5,000 rows per CSV file. Split a bigger library into several files.
  • 20 GB per imported file, with two downloading at a time.
  • One import at a time, of any kind: wait for one to finish before starting the next.
  • Saving from Excel with ; between columns is fine. The import works out which separator the file uses.
note

Importing content needs the Create and Edit permission for content. That includes its settings, without the Settings permission. Downloading the import's report needs the Export permission for content, unless you started the import. See Staff & Permissions.