Skip to main content
Open Import Products. The page explains that you will select one or more product subcategories, choose the details you want to include, download a workbook template, and upload it to publish your listings. Use ← Back to Dashboard to leave the wizard.

Step 1: Select Product Categories

Section heading: Step 1: Select Product Categories. When this step is done, a Complete pill can appear next to the heading.
  • Under Product family and subcategory, use Search categories or browse Product family and Subcategory like on the single-product form.
  • You can select multiple subcategories. They appear under Selected subcategories as chips you can remove.
  • Choose Continue with selected categories (enabled only after at least one subcategory is selected).

Step 2: Add Product Details

Section heading: Step 2: Add Product Details.
  • For each selected subcategory, an accordion section opens so you can set titles, descriptions, brand, stock location, and which columns to include in the Excel workbook (SKU-defining columns, per-variation detail columns, and so on—labels match your subcategory).
  • When everything required is filled, choose Create Drafts & Download Workbook.
A note on the page: If a cell is locked in Excel, you cannot change or add anything there. Do not try to edit locked columns in the downloaded file.

Step 3: Download Workbook

Section heading: Step 3: Download Workbook.
  • Text explains that drafts are created and you should download the workbook, fill it in, then proceed to upload.
  • Use Download Workbook to get the .xlsx file. There is one sheet per subcategory you selected.

How the workbook is organized

  • Instruction rows at the top explain how to fill the sheet.
  • Locked columns (often including draft reference and title) must stay as provided.
  • SKU-defining columns (blue-tinted in the file) are the combinations that create separate variations.
  • Per-variation detail columns (purple-tinted) add extra information per row.
  • Required columns (yellow-tinted, often marked with *) include Price, Stock, and Lead Time. Values must follow the rules shown in the sheet (for example: positive price with up to two decimal places using a dot, whole-number stock, Lead Time exactly matching one of the allowed options).

Step 4: Upload Product File

Section heading: Step 4: Upload Product File.
  • The page states that error-free upload only stages data and publishing requires explicit confirmation per product.
  • Under Workbook, choose your filled .xlsx file, then Upload Workbook.
  • If the upload reports problems, use Download Errors (when shown) to see what to fix, correct the workbook, and upload again.

Step 5: Review & Confirm

Section heading: Step 5: Review & Confirm.
  • Ready items have at least one valid variation row and no blocking errors.
  • Use Confirm & Publish all ready products when you want to publish everything that is ready, or publish one product at a time from the list (buttons or actions shown per draft).
  • Each draft shows status such as ready, errors, no rows, or published, depending on your batch.

Danger Zone

At the bottom, open Danger Zone if you need to delete all draft products created by the current active bulk batch and reset this flow.
  • In Type DELETE to enable reset, enter the word DELETE exactly.
  • Then Delete All Batch Drafts & Reset becomes available. Use this only when you intend to start over; it removes that batch’s drafts.

Related: Create a single product listing · Update multiple listings at once