How to import products from a file (including Shopify)
You can add many products to a TeleportHQ store at once by importing a file: a CSV, an Excel sheet, JSON, a plain text list, or a ZIP that holds one of them with the product pictures. In the E-Commerce panel, click More actions (…) next to Products, choose Import Products, and drop your file. A product export from Shopify works as it is, including variants. A file with other column names, or a list written as text, is read with AI. Check the products, change any that came out wrong, then click Import [number] Products.
Before you start
- The file can be
.csv,.tsv,.xlsx,.xls,.json,.txtor.md, up to 10 MB, or a.zipof up to 50 MB holding one product file and its pictures. - Every product needs at least a name and a price. Everything else is optional.
- Reading a file with AI uses AI tokens: each AI pass needs at least 300 AI tokens in your workspace. A file in the expected format, or a Shopify export, is read without AI. See What uses AI tokens, and how much?
- From Shopify: in your Shopify admin, export your products as a CSV file.
Steps
- In the editor's left sidebar (the icon column), click E-commerce (the card icon). If you don't see it, click Plugins, then E-commerce, then Open next to E-commerce panel. The E-Commerce panel opens.
- Next to Products, click More actions (the … button, left of +).
- Click Import Products.
- The Import Products panel opens beside the E-Commerce panel. Under Import from File, drag your file onto "Drop your product list here, or click to browse", or click that box to choose the file. The line under it reads "CSV, Excel, JSON, text or a ZIP with pictures — Shopify exports work as they are".
- Check the file review. TeleportHQ shows the file name and size, the file type it recognized (for example a Shopify export, with how many rows became how many products with their variants), any errors and warnings, the columns it will skip, and the list "[number] products ready to import — click one to check or change it".
- To correct a product before it's created, click it in the list (tooltip Check or change this product). Change its Name, Price, Currency, Status, Category, SKU, Quantity or Description. A Quantity left empty shows Not tracked: the product is imported without stock tracking.
- Click Import [number] Products, for example Import 48 Products.
- Wait while Uploading pictures (for a ZIP), Importing products and then Linking variants count up. With more than 1,000 products, the panel warns: "Large import detected. This may take a few minutes to complete."
When TeleportHQ reads your file with AI
When your file doesn't use the expected column names, or holds a list written as text, TeleportHQ reads it with AI on its own, right after you drop it:
- "Working out your columns…" shows while the AI works out which column is which. For a list it can't read as columns, "Converting products… [n] of [total] batches" shows while it reads the products out of the file.
- If the Map your file with AI window asks questions, answer the ones you can, or keep Let the AI decide, then click Apply mapping.
- When it's done, the review says "The AI worked out which column is which. Review the products below before importing." or "The AI read the products out of this file. Review them below before importing."
To have the AI read the file differently, type what to change in Tell the AI what to change, for example prices are in EUR, put Material and Size into the description, and click Apply. If some rows still couldn't be read, click Read it with AI (or Read it again with AI). Changes you made by hand in the list are kept when the AI reads the file again, unless the AI changes that same value: the review then says which ones it changed.
File format
Any file works, but TeleportHQ reads the columns below without AI. To see them in TeleportHQ, click Format requirements & examples under the drop box in the Import Products panel. It has a CSV Example, a JSON Example and a ZIP with pictures example, each with a copy button.
The CSV example uses these columns:
name, price, currency, description, status, payment_type, quantity, sku, category, tags, weight, weight_unit, dimensions, image_url, gallery_images, trial_days, is_digital, download_limit, download_expiry_days
- name and price are required.
- status is
active,inactive,draftorarchived. An empty or unknown status imports asactive. - category is a category name. A category that doesn't exist yet is created.
- image_url is the main photo's web address. gallery_images holds more photo addresses: a JSON list in CSV (for example
["https://example.com/img1.jpg","https://example.com/img2.jpg"]) or a normal list in JSON. - Pictures in a ZIP: put your product file (for example products.csv, .xlsx or .json) in a ZIP together with the pictures, and write each picture's path inside the ZIP in image_url or gallery_images, for example
pictures/black-bird-feathers-1.jpg. The review says how many pictures from the ZIP will be added to your files, and which picture paths aren't in the ZIP. Web addresses still work as they are. - Subscriptions: set payment_type to
recurring, and add recurring_interval (week,monthoryear), recurring_interval_count (for example3withmonthfor every 3 months) and, for a free trial, trial_days. See How to sell subscriptions and manage subscribers. - Digital products: set is_digital to
true, with download_limit and download_expiry_days if you want limits. The files themselves are added in the product form. See How to sell digital products (downloads and license keys). - More columns the import reads: slug, image_alt, brand, gtin, mpn, condition, variant_options and variants (variants, best in JSON), discounts, option_groups (product options) and product_page (a custom product page that already exists in the store). A file exported from TeleportHQ uses these names.
- Several languages? When your site has more than one language, add translation columns named
{language}_{field}, for examplefr_nameores_description. The examples then show them.
Check that it worked
The message "Successfully imported 48 products" appears (with "(2 failed)" if some couldn't be added), the panel closes, and the products are in the Products list. Open a few products to check prices, photos and variants.
Troubleshooting
"Please upload a CSV, Excel, JSON or text file, or a ZIP holding one with its pictures." or "This file could not be read. Upload a CSV, Excel, JSON or text file, or a ZIP holding one with its pictures." The file isn't one of the types TeleportHQ reads, or it's damaged. Save your list as a CSV or Excel file (in Google Sheets, use File → Download), then try again.
"File is too large. Maximum size is 10MB." (or 50MB for a ZIP) Split the file into smaller files and import them one by one. For a ZIP, make the pictures smaller or import the products in several ZIPs.
"The ZIP holds no product file. Put a products.csv, .xlsx, .json or .txt inside it, next to the pictures." Add your product list to the ZIP and try again.
"The AI could not map this file to our product fields.", "We could not find any products in this file." or "The AI could not find products in this file. Check that it contains product data." The file may have no product rows, or no names and prices. Check the file, add name and price columns, and try again. If your workspace is out of AI tokens, the AI can't read the file: use the columns from Format requirements & examples, or buy tokens.
"Import failed. No products were imported." Nothing was added. Check the errors in the file review, fix the file and import again.
Products show up twice, with "(1)" after the name The import always adds new products. It doesn't update products that already exist, so a product with a name that's already in your store gets a number added. Delete the copies, or import only the new rows.
Good to know
- Connecting directly to a platform isn't available yet. Under or connect a platform, Shopify, Wix, BigCommerce, Squarespace, Square and Ecwid are marked Coming Soon. Export a file from the platform and import it instead. Below them, Product Imports Coming Soon lets you ask to be told when your platform is ready. See What can't the TeleportHQ store do yet?.
- Photos from web addresses stay where they are. The import saves each photo's web address as it is. It doesn't copy those photos into your project, so the links must stay public and online. Pictures you put in a ZIP are uploaded to your project's files.
- Product options come along. If the file has product options, TeleportHQ also gets the product page ready to show them. See How to let shoppers personalize a product (product options).
- New store with AI? The Upload my own products step of the AI store builder uses the same import. See How to generate an online store or web app with AI.