Import Products

The Stock CSV importer supports large, observable imports with row validation, duplicate detection, batched inserts, image uploads, retry handling, cancellation, and local recovery after an interrupted run.

Open the importer

1. Go to Stock > Products.
2. Open Import / Export.
3. Select Import CSV.

The same importer is also available at /stock/products/import for direct links and recovery workflows.

Download the template

Select Download sample CSV in the importer. The template includes one hosted-image example and one local-image-folder example.

Only these columns are required:

Supported optional columns:

Example:

sku,name,description,category,unit,is_active,sale_price,image_paths
LAMP-04,Brass desk lamp,Mid-century brass lamp,Lighting,unit,true,65,lamp-04.jpg|lamp-04-detail.jpg

Choose an import action

Insert new products

Use this for the initial catalog load.

• New valid SKUs are inserted in batches.
• SKUs that already exist in the workspace are skipped.
• A duplicate SKU repeated inside the same CSV is reported as an error.
• Rows missing SKU or name are skipped.
• A failure in one row does not roll back successful rows from the same import.
• Imported products are not automatically published to the public storefront.

Update existing photos

Use this to attach or refresh local photos without replacing other product data.

• Rows match existing products by SKU.
• SKUs that do not exist are reported as errors.
• Rows without local image references are skipped.
• Uploaded images are merged into the product gallery and the first available image becomes the primary image when needed.

Choose product status

For Insert new products, choose one status policy after the CSV has parsed:

• Active — import every valid row as active; this is the recommended default.
• Inactive — import every valid row as hidden/archived.
• Use CSV values — read is_active for every row.

The importer warns when the CSV contains inactive rows but Active is selected, because the selected policy overrides those values.

Import hosted images

• Put a single public URL in image_url.
• Put multiple URLs in image_urls, separated with |, or provide a JSON array.
• You do not need to attach a local folder for hosted URLs.

Import local images

1. Put the image filenames in image_paths, separated with |.
2. Select or drop the CSV.
3. Attach the folder containing those files when the folder picker appears.
4. Confirm that the importer finds the referenced filenames.
5. Start the import.

The importer indexes attached files by basename and relative path. Missing files and failed uploads appear in the row outcomes. Local images are resized to a maximum dimension of 1600px before upload.

Monitor and recover

The status panel reports these phases:

Checking SKUs -> Uploading -> Validating -> Inserting -> Done

It also shows row outcomes, progress, retries, network health, and errors. You can cancel an active run.

After every completed batch, recovery state is stored locally in the browser. If the tab closes or refreshes:

1. Reopen the importer in the same workspace and browser.
2. Re-upload the same CSV.
3. Choose Resume on next import.
4. Already completed SKUs are skipped.

You can discard the saved run if you intend to start over.

After the import

1. Review the inserted, skipped, and error totals.
2. Filter Stock > Products by active/inactive state.
3. Open representative products and verify descriptions, prices, and photos.
4. Add opening stock through the appropriate movement workflow.
5. If you use the storefront, bulk-publish only the reviewed products and then enable the storefront under Stock > Settings.

Common problems