Import & export products

Solidshop reads and writes a single CSV file with one row per variant — the same shape Shopify exports. If you already have a catalogue in a spreadsheet or another cart, that file is usually close enough to import as-is.

Everything lives under Solidshop → Import / Export, and the Products list has Import and Export buttons in its toolbar.

Exporting

Open the Export tab, choose whether to export the whole catalogue or just what the products list is currently filtered to, and download the file. What comes out is import-ready: export, edit prices or stock in a spreadsheet, import the same file back.

The Export button on the products list is the shortcut for both: tick some rows to export only those, or tick nothing and get everything the current search and filters show.

  • Translation columns — adds a set of per-language columns for each language you select. Leave it empty for a single-language file.
  • Separator — use a semicolon if your spreadsheet is set to a locale that expects one.
  • Byte-order mark — keep this on for Excel, which otherwise misreads accented characters.

Importing

  1. Upload a .csv file. Comma, semicolon, tab and pipe separators are detected automatically, as is a byte-order mark.
  2. Match your columns. Solidshop guesses the mapping from the headings — including Shopify and WooCommerce spellings such as Handle, Title, Body (HTML) and Variant Inventory Qty — and shows sample data from your file next to each one so you can check it. Anything unrecognised is left for you to map or ignore.
  3. Run it. The import works through the file in batches so a large catalogue never hits a PHP timeout. Anything it could not do is listed as you go, with the line number from your file.

Nothing is written until you have seen the mapping screen. Download the blank template from the upload step if you would rather start from Solidshop’s own column names.

How rows become products

Rows that share the same value in the match column (Alias by default) are one product, and they must sit next to each other in the file. The first of those rows carries the product; every row carries one variant. A WooCommerce export is read differently: every row is a product of its own, and a variation is found through the product its Parent column names, wherever it is in the file.

Alias,Name,Price,Option1 Name,Option1 Value,Variant SKU,Variant Price
cotton-tee,Cotton Tee,19.00,Size,S,TEE-S,19.00
cotton-tee,,,Size,M,TEE-M,19.00
cotton-tee,,,Size,L,TEE-L,21.00
mug,Enamel Mug,9.50,,,,

That file creates two products: a tee with three size variants, and a mug with no variants at all (its price and stock live on the product itself). You can match on SKU or ID instead of alias if that suits your source data better.

Blank cells never erase anything

A column you mapped but left empty means “leave this alone”, not “set this to empty”. That is what makes a two-column file — alias and price — a safe way to bulk-update prices without touching descriptions, images or stock. One exception: in a WooCommerce export, a blank Sale price means the product is not on sale, so its compare-at price is removed (see From WooCommerce).

Creating versus updating

The When a product already exists option decides:

  • Update it, and create the ones that are new — the default.
  • Skip it — only create new products — existing ones are skipped and listed.
  • Update it — never create anything.

Column reference

Headings are matched case- and punctuation-insensitively, so price_origin, Price Origin and Compare At Price all mean the same column.

Product

  • ID, Alias, Name, SKU, Barcode
  • Product Type — physical, virtual, and any type added by an installed plugin. An unknown type leaves the existing one untouched.
  • Published, Featured — 1/0, yes/no and true/false are all understood.
  • Category — a path such as Apparel/Shirts. Missing levels are created unless you turn that off.
  • Additional Categories — the other categories that list the product, as paths separated by |: Home care|Gifts/Under 50. A filled cell replaces the product’s additional categories; a blank cell, or a file without the column, leaves them alone, so a file cannot clear them — do that on the product form or with Batch. Paths are matched, and missing levels created, as for Category. See Additional categories.
  • Categories — WooCommerce’s column, read on import only: every category in one cell, separated by commas, with > between levels: Clothing, Clothing > Hoodies, Music. WooCommerce has no main category and lists them alphabetically, so the deepest one becomes the main category (Hoodies here; the first of them if several are as deep) and the others become additional categories. A / is part of a name in this column, and \, is a comma inside a name, as WooCommerce writes it. A row that also fills Category uses Category.
  • Brand, Store, Tax Class, Access — matched by name.
  • Language — the source language tag, e.g. en-GB.
  • Publish Up, Publish Down (Start publishing and Finish publishing on the mapping screen) — read as UTC.

Content & SEO

  • Summary, Description, Page Title, Meta Description
  • Specifications — the product’s specification rows, one row per line inside the cell, written Label: Value (a tab, or a colon without the space, also separates them). Commas and pipes are ordinary characters in a value. Spreadsheet applications keep line breaks inside a cell; press Alt+Enter in Excel for Windows, or Ctrl+Enter in LibreOffice Calc and Google Sheets, to start a new line. A filled cell replaces the product’s whole list; a blank cell leaves it alone, so a file cannot clear the list — remove rows on the product form. A line without a label or value is reported against its row and not imported.
  • Media — one or more paths relative to your shop media folder, separated by a pipe (|). Remote image URLs are not downloaded; upload the files first and reference them by path.

Pricing & inventory

  • Price, Compare At Price, Cost Per Item — currency symbols and both decimal conventions (1,299.50 and 1.299,50) are handled.
  • Weight, Quantity, Track Quantity
  • One Per Order — 1 limits the product to one per order (see Products). WooCommerce's Sold individually? column maps onto it.

Options & variants

  • Option1 Name / Option1 Value through Option3 — up to three options per product.
  • Option1 Display — how the option’s values are shown on the product page: text, color, or image. Repeats on every row like the name; a blank column leaves the stored mode alone.
  • Option1 Swatch — the row’s value’s swatch: a hex colour such as #1f2a44 (two joined by / for a two-tone value) under color, or the file name of an image in the store’s swatch library, such as navy-fabric.jpg, under image (upload swatches from the product form first; the file name is what the picker shows under each tile). A value that repeats across variants only needs its swatch filled on one row. Leaving the column out of the file keeps the swatches a product already has; changing a swatch never rebuilds variants.
  • Variant SKU, Variant Barcode, Variant Price, Variant Compare At Price, Variant Cost Per Item, Variant Quantity, Variant Track Quantity, Variant Weight, Variant Image — a blank cell keeps what the variant has. A new variant whose Variant Price is blank takes the product’s Price.

A product has a variant for every combination of its option values. A new combination your file does not list, such as Red / XL when the file has red only in S and M, is created out of stock at the product’s lowest variant price, so it cannot be sold until you give it stock. The import lists the products that have one.

Adding an option value a product did not have before rebuilds its whole variant set; variants your file does not list keep their prices, stock and SKUs. Renaming, adding or removing an option rebuilds it from your file alone, so list every variant you want to sell — export the product first and every variant is in the file.

Translations

On a multilingual site, add a language tag to any of Name, Alias, Summary, Description, Specifications, Page Title or Meta Description: Name [vi-VN], Description (fr-FR) and summary:de-DE are all recognised. Those values are written to the product’s translation for that language, leaving the source language alone. As everywhere else, a blank translation cell changes nothing: a file with only Description [vi-VN] filled keeps the Vietnamese name and alias already saved, and a translation without a name or alias of its own uses the product’s.

Coming from another cart

Export from your current cart, then upload that file here. A Shopify products export maps almost entirely on its own, and so does a WooCommerce one (below). For carts without a compatible export, put your data into the template from the upload step — alias, name, category and price are enough to get a catalogue in, and everything else can follow in a second import.

From WooCommerce

Export from Products → Export in WordPress with all columns, and upload the file as it is. Solidshop reads WooCommerce’s columns this way:

  • Matching — the file has no alias, so the mapping screen sets Match products on to SKU. A product without a SKU is listed and skipped: give it one in WooCommerce and export again. A new product whose name another product in the store already uses gets a numbered alias, such as classic-tee-2.
  • Prices — a product on sale gets its Sale price as its price and its Regular price as the compare-at price. Otherwise the regular price is the price and any compare-at price is removed. Solidshop has no scheduled prices: a sale that has not started yet, or has ended, imports the regular price, and a sale price with an end date stays the price until you change it (the import lists those products).
  • Stock — stock that WooCommerce counted keeps its quantity and is tracked. Stock it did not count is not tracked, so the product stays orderable; if it was out of stock, it is tracked with none left. A product on backorder is not tracked.
  • Weight — WooCommerce names its unit in the heading, such as Weight (lbs). The weight is converted to the unit your store keeps (kilograms or grams, set on the store). Solidshop keeps no length, width or height, so those columns are left out.
  • Attributes — an attribute fills the product custom field of the same name, so create a Color field before importing if shoppers should filter by colour. Any other attribute shown on the product page becomes a specification row, such as Color: Blue, Green; hidden ones are left out. An attribute a variable product’s variations choose by becomes one of its options instead.
  • Categories — every category comes along, the deepest as the main one (see Categories above).
  • Virtual and downloadable products — a new product marked virtual in WooCommerce becomes a virtual product, and one marked downloadable becomes a downloadable product with its download limit and expiry, when the Downloadable add-on is installed (a virtual product otherwise). The files themselves are not downloaded: add them on the product’s Downloads tab. A product already in your shop keeps its type.
  • Variable products — each variation becomes a variant of its product, with its own price, sale price, stock, weight, SKU and barcode. The attributes the variations choose by become the product’s options, and the product is priced from its lowest variation. WooCommerce sells only the combinations it has a variation for, while a Solidshop product has a variant for every combination: the others come in sold out at the lowest variation price, as do disabled variations and variations without a price, and the import lists those products. A variation left at “any” value becomes a variant for each value; stock it counted is split between them, and a SKU it carries is left off. Variation images are not downloaded. With more than three variation attributes, or more than 150 combinations, a new product comes in without its variations, unpublished and without a price, and so does a grouped product, as Solidshop has none.
  • Barcodes — the GTIN, UPC, EAN, or ISBN column fills the product’s barcode, and a variation’s fills its variant’s.
  • Images are web addresses in the file, and are not downloaded (see Media above).
  • Left out — Tags, Brands, Shipping class, Upsells, Cross-sells, Grouped products, External URL and Button text are not imported. An external or affiliate product comes in as an ordinary product, without its link.

WooCommerce writes its column headings in the shop’s language, such as Catégories and Poids (livres) from a French shop. Solidshop recognises them in 36 languages, regional variants included, as WooCommerce’s own translations spell them. A heading worded differently, as by an older WooCommerce, may not be recognised: set that column on the mapping screen.