Supplier spreadsheet → Shopify product CSV

A complete example: which rows convert, which products need an answer, and where each output value came from.

Prepared demonstration. No customer data. No live Shopify import was performed.

10supplier variant rows

4converted rows / 2 products

6held-back rows / 3 products

A visible difference: price 19,95 becomes 19.95. SKU 000101 remains 000101. Every source row is accounted for: 10 = 4 + 6.

1. The supplier file

Supplier-specific headers, comma-decimal prices, one missing size, a repeated size/colour combination and one missing selling price.

Group	Name	Size	Colour	SKU	Price
TEE	Everyday Tee	S	Navy	000101	19,95
TEE	Everyday Tee	M	Navy	000102	19,95
HOOD	Everyday Hoodie	S	Grey	000201	49,50
HOOD	Everyday Hoodie	M	Grey	000202	49,50
CAP	Canvas Cap	blank	Black	000301	15,00
CAP	Canvas Cap	L	Black	000302	15,00
SOCK	Cotton Socks	M	White	000401	8,00
SOCK	Cotton Socks	M	White	000402	8,00
BAG	Canvas Bag	One size	Natural	000501	blank
BAG	Canvas Bag	One size	Black	000502	25,00

2. The converted import candidate

Explicitly mapped Shopify columns, grouped variants and dot-decimal prices. New products are set to draft. This is the actual engine output.

Title	URL handle	Status	SKU	Option1 name	Option1 value	Option2 name	Option2 value	Price
Everyday Tee	everyday-tee	draft	000101	Size	S	Colour	Navy	19.95
blank	everyday-tee	blank	000102	blank	M	blank	Navy	19.95
Everyday Hoodie	everyday-hoodie	draft	000201	Size	S	Colour	Grey	49.50
blank	everyday-hoodie	blank	000202	blank	M	blank	Grey	49.50

Blank product-level cells on a subsequent variant row are intentional. Repeated handles group the variants of one product.

3. Products held back for a reason

The cap is missing a size. The socks repeat the same option combination. The bag is excluded by operator review because one price is missing. The full product stays out until its source data is resolved.

source_row	product_key	code	details
6	CAP	missing_option_value	The variant has no value for option 'Size'.
7	CAP	product_held_back	Held back with its product because another row of the product has a problem (a product is converted completely or not at all).
8	SOCK	product_held_back	Held back with its product because another row of the product has a problem (a product is converted completely or not at all).
9	SOCK	duplicate_variant	Same option values as source row 8.
10	BAG	excluded_by_operator	Excluded in the mapping by the operator: Operator review: missing selling price on one variant. Hold back the whole product; customer must supply it. No price invented.
11	BAG	excluded_by_operator	Excluded in the mapping by the operator: Operator review: missing selling price on one variant. Hold back the whole product; customer must supply it. No price invented.

The engine initially flags the missing price for review. The operator then excludes BAG explicitly. This is a reviewed service, and missing prices are not all blocked automatically.

4. Inspect the actual files

Supplier input CSV Converted product CSV Exception report Cell-level source record Pre-import QA report Delivery note Full output ZIP

The original file hash is unchanged. Output values were read back and checked. Every filled output cell has a source or an agreed fixed value recorded.

No store export was supplied. Existing handles were not checked against a store. The import setting is no overwrite; Shopify may ignore products whose handles already exist. The output is ready for a controlled import test under the recorded conditions, with no guarantee of platform acceptance or live-store safety.

Have a new-product supplier sheet like this?

$49 for up to 100 variant rows / 3 calendar days.
$99 for up to 500 rows / 4 calendar days.
$149 for up to 2,000 rows / 5 calendar days.

One CSV or XLSX sheet, up to 30 columns, 8 MiB and three options. Delivery starts after funding and complete agreed inputs. One corrected-source rerun with the same mapping is included. Upwork buyer fees and applicable tax are extra.

View packages on Upwork

Your team reviews and imports. New products only. Store access, live import, stock sync, existing-product updates, PDF extraction, image work and joins are outside these packages.