CSV import and export

For a catalog of hundreds or thousands of products the spreadsheet is faster than the page. The export gives you one row per product with every value; the import writes your changes back.

Export

On the Products page open More actions and choose Export CSV. The file lists active products (every product, including drafts and archived ones, with the All products option) with these columns:

id,handle,title,tile_length (in),tile_width (in),tile_thickness (in),pieces_per_box,coverage_per_box (sqft),coverage_per_gallon (sqft),sample_product_handle,container_label,piece_label

The unit in brackets is your store's unit; the import ignores the brackets, so a file exported in inches and square feet imports the same way.

Import

container_label and piece_label are the tile's container and piece words (crate, sheet; box|boxes for an irregular plural); clear removes one. Variant container sizes are not in the CSV; set them on the Products page.

1. Edit the file in your spreadsheet tool. Keep the header row and the id or handle column; you can delete the columns you are not changing.
2. On the Products page choose More actions and Import CSV, then pick the file.
3. The preview shows how many rows were read, how many matched a product, how many will change, and any rows with a problem (a handle that does not exist, a value that is not a number).
4. Click Import. The app saves in batches of 100 products and shows the progress.

Rules the import follows:

• Rows are matched on id when present, otherwise on handle.
• A blank cell leaves the product's current value alone, so a file that only carries pieces per box never touches coverage.
• The word clear in a cell removes that value from the product.
• sample_product_handle links the product whose handle you enter as the sample; clear removes the link.
• Dimensions are read in the store's dimension unit and saved with that unit attached.

After an import

The catalog health audit rechecks the imported products as they save, so the issues list is current a few seconds after the import finishes.