# Import products from a spreadsheet

> Go to Products and click Import. Upload a CSV, Excel or JSON file, match its columns to product fields, choose whether to create new products, update existing ones or both, and click Start import. Already selling on Shopify, WooCommerce, Squarespace or Big Cartel? Paste your shop's address on the same page instead.

Help Centre / Products - Updated 9 November 2026

Instead of adding products one at a time, you can bring a whole catalogue in from a spreadsheet: names, descriptions, prices, stock, variants, categories and pictures. The same import also updates products you already have, so it is a quick way to change prices or stock across many products at once.

## Before you begin

- Your file can be a CSV, an Excel file (`.xlsx`, `.xls`) or a JSON file, up to 10MB. Save CSV files as UTF-8.
- To see the expected layout, go to **Products**, click **Import**, then click **Download CSV template** at the top right. It is a short example with a product that has two sizes and a product with none.
- To edit many products you already have, start from an export. See [Export your products](https://shoprocket.io/help/export-products.md). The export uses the same columns as the importer, so every column is matched for you when you import it back.
- To import, your staff account needs permission to create products.

## How the file is laid out

- The first row must be column headers.
- Each product is one row. Extra variants go on the rows below it. On those rows, leave **Product Name** blank or set **Row Type** to `VARIANT`.
- Prices are decimals in your store's currency, like `16.00`. Currency symbols are ignored.
- Separate several categories or picture addresses in one cell with semicolons, for example `Coffee;Beans`. Categories that don't exist yet are created.
- Pictures are given as web addresses in **Image URLs**. Shoprocket copies them in the background after the import.

For example, a Portland coffee shop's file might look like this:

```
Row Type,Product Name,Description,SKU,Price,Stock,Option 1 Name,Option 1 Value,Categories,Image URLs
PRODUCT,Portland Morning Blend,A bright medium roast,PMB-12,16.00,40,Size,12 oz,Coffee;Beans,https://example.com/morning-blend.jpg
VARIANT,,,PMB-2LB,38.00,15,Size,2 lb,,
PRODUCT,Stoneware Mug,Hand-glazed in Oregon,MUG-01,18.00,25,,,Accessories,
```

A product export from WooCommerce, Wix or BigCommerce, or Ecwid's catalogue export, imports as it is, with its variants.

## Step 1: Upload your file

1. Go to **Products** and click **Import**.
2. Click **Choose a CSV, Excel or JSON file** and pick your file.
3. Click **Upload & continue**.

![The Import products page with the file upload box, the Download CSV template button, the CSV format & tips panel and the shop address card below](https://shoprocket.io/img/help/import-products/upload-step.webp)

## Step 2: Match your columns

The **Map CSV columns** list shows each column in your file, with a few example values from it. Beside each one, use **Map to** to pick the product field it fills, or **(Skip this column)** to leave it out. Columns Shoprocket recognises are matched for you and marked **Auto-detected**. It is still worth checking them.

The fields you can map:

- **Product**: **Product name** (required), **Slug / handle**, **Summary**, **Description**, **Status** (`active`, `draft` or `archived`), **Brand / vendor**, **Tax class**, **SEO title**, **SEO description**, **Shipping mode**, **Shipping amount**.
- **Variant**: **SKU**, **Parent product**, **Price**, **Compare-at price**, **Cost price**, **Stock quantity**, **Barcode**, and one weight column: **Weight (grams)**, **Weight (kg)**, **Weight (lb)** or **Weight (oz)**.
- **Options**: **Option 1 name** and **Option 1 value**, up to option 3, or **Options (all in one cell)**.
- **Relationships**: **Categories**, **Image URLs**.
- **Control**: **Row type**.

You must map **Product name**, and also **Price** or **SKU**. If you map an option's name, map its value too.

If you picked the wrong file, click **Change file**.

## Step 3: Choose how the import works

Under **Import settings**, pick an **Import mode**:

- **Import all (create + update)**: new products are created, and products you already have are updated.
- **Only create new**: rows that match an existing product are skipped, and nothing you already have changes.
- **Only update existing**: only products that match are updated, and rows without a match are skipped.

When you update products, **Match existing by** sets how Shoprocket matches each row to a product: by **SKU** (the default) or by **Product name**. Empty cells keep the product's current value, so you can change prices by importing a file with just a SKU column and a price column.

The **How your import will work** box sums up your choice. Then click **Start import**.

![The Map CSV columns step, with columns matched to product fields and the Import settings panel showing Import mode and Match existing by](https://shoprocket.io/img/help/import-products/map-columns.webp)

## Step 4: Check the result

The page shows the import's progress and then how many products were **Created**, **Updated** and **Failed**. While it runs, **Cancel import** stops it.

- If any rows failed, or were imported with a change, click **Download error report** (or **Download report**). It shows which rows to fix in your file before you import it again.
- Imported products start as **Draft** unless your file has a **Status** column, so customers don't see them yet. Check them, then set them to **Active**.

Click **View products** to go to your product list, or **Import another file**.

## Importing from your shop's address

If your shop is on Shopify, WooCommerce, Squarespace or Big Cartel, you can skip the spreadsheet. On the same **Import products** page, under **Moving from Shopify, WooCommerce, Squarespace or Big Cartel?**:

1. Type your shop's address in **Your shop's address**, for example `portlandroasters.com`.
2. Click **Read my shop**. Shoprocket reads the products your shop shows publicly and tells you what it found, before anything is imported.
3. Click **Import them all**.

Your products come across with their variants, pictures and categories. Shoprocket can only see the products that are live in your old shop, so they import as active. The old web addresses of your products redirect to their new pages. If you run it again later, it updates the products instead of adding copies. To try another shop, click **Use a different address**. To use a file after all, click **Or upload a CSV instead**.

The same page also has a **Moving from Ecwid?** card for importing an Ecwid store.

## Related

- [Export your products](https://shoprocket.io/help/export-products.md)
- [Add your first product](https://shoprocket.io/help/add-your-first-product.md)
- [Product variants and options](https://shoprocket.io/help/product-variants-and-options.md)
- [Categories](https://shoprocket.io/help/categories.md)
- [Track stock and inventory](https://shoprocket.io/help/track-stock-and-inventory.md)

[Open Import products in your dashboard](https://app.shoprocket.io/go/products/import)

---

- HTML version: https://shoprocket.io/help/import-products
- Language: English (en)
- Also in: [العربية](https://shoprocket.io/ar/help/import-products.md), [Deutsch](https://shoprocket.io/de/hilfe/produkte-aus-tabelle-importieren.md), [Ελληνικά](https://shoprocket.io/el/help/import-products.md), [Español](https://shoprocket.io/es/ayuda/importar-productos-desde-hoja-de-calculo.md), [Français](https://shoprocket.io/fr/aide/importer-des-produits-depuis-un-tableur.md), [עברית](https://shoprocket.io/he/help/import-products.md), [हिन्दी](https://shoprocket.io/hi/help/import-products.md), [Bahasa Indonesia](https://shoprocket.io/id/bantuan/impor-produk-dari-spreadsheet.md), [Italiano](https://shoprocket.io/it/aiuto/importare-prodotti-da-un-foglio-di-calcolo.md), [日本語](https://shoprocket.io/ja/help/import-products.md), [Lietuvių](https://shoprocket.io/lt/pagalba/importuokite-prekes-is-skaiciuokles.md), [Norsk](https://shoprocket.io/nb/hjelp/importer-produkter-fra-et-regneark.md), [Nederlands](https://shoprocket.io/nl/hulp/producten-importeren-uit-spreadsheet.md), [Polski](https://shoprocket.io/pl/pomoc/importowanie-produktow-z-arkusza.md), [Português](https://shoprocket.io/pt/ajuda/importar-produtos-de-planilha.md), [Română](https://shoprocket.io/ro/ajutor/importa-produse-dintr-un-tabel.md), [Русский](https://shoprocket.io/ru/help/import-products.md), [ไทย](https://shoprocket.io/th/help/import-products.md), [Türkçe](https://shoprocket.io/tr/yardim/urunleri-elektronik-tablodan-ice-aktarin.md), [中文](https://shoprocket.io/zh/help/import-products.md)
