File and feed columns¶

Column names read from a feed or an uploaded CSV or Excel file. Matching ignores case, treats spaces as underscores and drops prefixes such as g:. The first match wins.

What we need	Names we accept
id	`id`, `sku`, `variant_sku`, `handle`. With no id, the link is used.
title	`title`, `name`
description	`description`, `body_(html)`
link	`link`, `url`, `product_url`
brand	`brand`, `vendor`
type	`product_type`, `type`, `google_product_category`
tags	`tags`, comma-separated
price	`price`, `variant_price`, `regular_price`
sale price	`sale_price`
in stock	`availability`, `stock_status`
currency	`currency`, `price_currency`
quantity	`quantity`, `variant_inventory_qty`, `stock_quantity`
image	`image_link`, `image`, `image_src`
more images	`additional_image_link`, `additional_image_links`, comma-separated
variant group	`item_group_id`
size	`size`
colour	`color`, `colour`

Rules¶

Required: title and link. Rows missing either are skipped.
Stock: availability decides; without it, a quantity of 0 is out of stock; with neither, in stock.
Price: a lower sale_price replaces price. Within an item_group_id, the regular price shows struck through.
Variants: rows sharing an item_group_id become one product with a variant per row. Other rows are separate products.