Importing Your Inventory From Shopify (Including Variant Pricing)

 The one thing to understand first

In Syncrostore, each variant is its own row in the spreadsheet. Rows that belong to the same product are tied together by a shared value in the Group Key column (Shopify calls this the Handle).

So a shirt that comes in 4 color/size combinations is 4 rows, all sharing the same Group Key, and each row has its own price in the Variant Price column.

That's the whole trick to "4 variants, 4 prices." You're not looking for one item with four price boxes — you're making four rows.

Here's exactly what that looks like (this is the sample built into our import template):

Same Group Key on all four rows = one product with four variants. Notice the last variant is priced 26.99 while the others are 24.99 — that's per-variant pricing. You can set every variant to a different price this way.

Tip: You only need to fill in the product name, brand, category, etc. on the first row of each group. The other rows just need the Group Key, the variant fields, and the option columns. Syncrostore fills the rest in from the first row.

Two ways to do it — pick one

Option A (easiest): Use the Syncrostore template

1. On the Import Inventory page, click Download import template.
2. Open it in Excel or Google Sheets. There's a sample on it and a "How to Use" tab.
3. Copy your products in, one row per variant, using the columns shown above. Different price per variant goes in Variant Price.
4. Save as .xlsx or .csv and upload it.

This is the most reliable path because the column names already match exactly, so nothing needs to be mapped by hand.

Why not just upload the raw Shopify export?

It's tempting to upload the file you exported straight from Shopify, but it won't bring your variants in correctly — and it's worth knowing why so you don't waste time on it:

• Shopify only lists each product's option labels once. For a product with variants, it writes "Color" and "Size" on the first line only and leaves those labels blank on every variant line below. When another system reads the file back, the variants after the first lose their Color/Size and pile up together instead of landing in their own spots. That's the "variants in the wrong place" problem.
• A Shopify export has 100+ columns (SEO fields, Google Shopping fields, metafields, and so on) that don't have a home in Syncrostore, so there's no reliable way to line them up automatically.

The template avoids both problems: it asks for just the handful of fields we need, one row per variant, with the option label spelled out on every row.

Copying from Shopify into the template: you only need these columns —

The key step is filling the option name down every row (Shopify leaves it blank; the template needs it on each line).

You don't need a Vendor column. On your import, every item is automatically assigned to your own vendor account.

Step-by-step in the import wizard

1. Step 1 — Upload a file. Choose your filled-in template (.xlsx). The first row is the column headers (already set up in the template).
2. Step 2 — Map your columns. With the template, everything matches automatically. Description (Title) is the one required field.
3. Step 3 — Preview & edit. Check a few rows. Click any cell to fix it. Flip a row's toggle off to skip it.
4. Step 4 — Validation & duplicate handling. Fix anything flagged. Choose what happens if an item already exists (match on SKU or UPC, then Skip or Update). Click Run Import.
5. Step 5 — Done. You'll see how many items were added, with their variants.

Quick checklist

• One row per variant.
• Same Group Key on every row of the same product.
• Each variant's price in Variant Price (these can all be different).
• Color/Size go in Option1 / Option2 Name & Value columns.
• If using the raw Shopify file, map Variant Inventory Qty → Variant Quantity on the mapping step.
• Product name/brand/category only need to be on the first row of each group.