What this helps you do

Create up to 5,000 product rows from a CSV file or download product data from Upstorr.

Before you start

Open Products → Import, then download both Sample CSV and Instructions. Use those current files as the source of truth. The CSV must be 25 MB or smaller.

Steps

Import products

  1. Select Import on the Products page.
  2. Download Sample CSV and Instructions.
  3. Fill the sample using the exact allowed column names and values.
  4. Keep all rows for one variant product together with the same handle.
  5. Select Add file and choose a .csv file.
  6. Select Upload CSV once and wait for the result.
  7. If Upstorr reports bad rows, download the error file.
  8. Fix every named row and upload the corrected file again.

The import is all-or-nothing. If one row or grouped product is invalid, Upstorr imports nothing. This prevents a half-finished catalogue.

Export products

  1. Select Export.
  2. Choose Currently loaded products, All products, Selected products only, or Products matching your search.
  3. Select Export products.
  4. Keep the downloaded file private because it contains business and catalogue data.

Understand the important CSV columns

  • handle: the unique, readable product address name. It is required, groups variant rows, and must not already exist in the store.
  • status: ACTIVE, DRAFT, or ARCHIVED. A blank value becomes DRAFT.
  • category / category_handle: an existing product category. If both are filled, they must identify the same category.
  • vendor: an existing vendor name, or a new vendor Upstorr creates during a valid import.
  • tags: comma-separated labels. Missing tags are created during a valid import.
  • collections: existing collection names. A missing collection rejects the product.
  • fulfillment_kind: PHYSICAL, SERVICE, or DIGITAL. A blank value becomes PHYSICAL.
  • digital_subtype: DIGITAL_GOOD or GIFT_CARD for a digital product. Leave it blank for physical products and services.
  • digital_download_limit / digital_access_duration_days: a positive whole number for a normal digital file, or blank for unlimited. Leave them blank for other product kinds.
  • gst_product_type: GST classification GOODS or SERVICE. It is separate from fulfilment kind.
  • unit_quantity_code: GST unit code. A blank value defaults to PCS for goods and OTH for services.
  • option1_name through option3_name: category option names such as Size or Colour.
  • option1_value through option3_value: the exact option values for this variant row.
  • variant_name: optional display name. When blank, Upstorr builds it from option values.
  • track_quantity: whether stock controls availability.
  • sell_out_of_stock: whether sales may continue at zero stock.
  • image_urls / variant_image_urls: comma-separated public image or video addresses. The first media item must be an image.

Boolean columns accept 1, true, yes, y, or on for yes, and 0, false, no, n, or off for no. Any other word is rejected.

Variant rules

Upstorr treats rows as variants when several rows share one handle, an option value is filled, or a variant name is filled. A variant product needs an existing category whose option names and allowed values exactly match the CSV. Every required category option must be present.

For example, two rows with handle cotton-kurta, category Clothing, option name Size, and values S and M create two variants of one product—not two products.

Digital-file safety

Private digital files are never imported or exported through the CSV. Import a normal digital product as DRAFT with both publishing values false. Then open it, upload its private files, and activate it only after Upstorr confirms file coverage.

What the export choices mean

  • Currently loaded products: only rows already loaded into the table, not every later result.
  • All products: every product across the store’s pages.
  • Selected products only: only products whose checkboxes are selected.
  • Products matching your search: all products matching the current search in the All tab, including matching results not yet loaded on screen.

What happens next

A successful import creates the complete checked set and refreshes Products. An export downloads a dated CSV using the same columns as the import template.

Common problems

  • The entire file was rejected: Fix every row in the downloadable error report; nothing was partly imported.
  • Handle already exists: Imports create products; they do not overwrite an existing product with the same handle.
  • Variant option is rejected: Make its category, option names, and values exactly match the category setup in Upstorr.
  • A video is rejected: Add at least one image and make an image the first media item.
  • File is too large: Keep it at 25 MB or less and no more than 5,000 data rows, or split it.
  • Products matching search is unavailable: Use the All tab and start a search first.