Import fit data from a spreadsheet

Open a finder, go to the Sources tab and use Import CSV. Pick the file, the source it goes into and what the file does, then Import. Every row is checked first: you see how many rows are ready and which have errors, and nothing reaches shoppers until you open Review changes and activate the change.

Download a sample gives you a small file with this finder's columns to start from.

The columns#

The first row names the columns. Their order doesn't matter.

• Shorter rows fit more. Leave the last levels empty to fit everything under them: HP,OfficeJet,,HP-67-BLK fits every OfficeJet model. A gap (an empty level followed by a filled one) is an error.

• A row without a product adds the configuration to the finder without saying what fits it.

• A SKU on a product with one variant fits the product. A SKU on one of several variants fits only that variant. A SKU that more than one variant uses is an error: give the variant_id instead.

• Several products in one row: separate SKUs (or handles, product ids, variant ids) with |.

• To write a | inside an alias, type \|; to write a backslash, type \\.

Years#

Years go from 1900 to 2100. A config_id names one configuration, so it can't go on a row with a range or a list.

What the file does#

• Add and update: the rows are added to the source. Its other rows stay.

• Replace this source: the file becomes the source's whole content. Rows that aren't in the file are removed.

• Remove these rows: the rows are removed from the source. A row without a product removes that configuration from the source.

A source only ever changes its own rows: other sources and your catalog data stay as they are.

Rows with errors#

A row is never guessed. An unknown SKU or handle, a SKU on two variants, products that don't match, a year that isn't a year: each is an error, with the column to fix. Download errors gives you those rows with error_column and error_message. Fix them and import that file again.

With Add and update or Remove these rows you can also tick Skip the rows with errors on the review page and activate the rest. A Replace with errors can't be skipped, because a row it couldn't read would remove what that row replaced: fix the file and upload it again.

Export#

Export on a source downloads its content in the same format: the configurations first (with their ids and aliases), then one row per fit. Edit it and import it back with Replace this source. If nothing changed, there's nothing to review.

A cell that starts with =, +, -, @ or ' gets one extra ' in front, so spreadsheet apps don't run it as a formula. On import, one leading ' is always removed, so '=SUM(A1) comes back as =SUM(A1).

Export all sources adds a source column. It's for reading and backups: to import it, split it by source first.

Limits#

• One CSV: up to 100 MB and 1,000,000 rows. Larger: split it into parts of up to 100 MB each and upload them together as one .zip (up to 5 GB, 5,000,000 rows), read as one file. A large export downloads the same way.

• One source: up to 500,000 fit rows.

• The file is UTF-8 CSV (Excel: CSV UTF-8), with ,, ; or tab between columns.