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):

Group Key	Variant SKU	Variant Price	Variant Quantity	Option1 Name	Option1 Value	Option2 Name	Option2 Value
TSHIRT-PRO-001	TSHIRT-PRO-001-RED-S	24.99	12	Color	Red	Size	Small
TSHIRT-PRO-001	TSHIRT-PRO-001-RED-M	24.99	18	Color	Red	Size	Medium
TSHIRT-PRO-001	TSHIRT-PRO-001-BLU-S	24.99	9	Color	Blue	Size	Small
TSHIRT-PRO-001	TSHIRT-PRO-001-BLU-M	26.99	14	Color	Blue	Size	Medium

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.

Option B: Upload your Shopify export directly

You can upload the file you exported from Shopify without rebuilding it. Most columns line up automatically. Here's how Shopify's columns match ours:

Shopify column	Maps to Syncrostore field	Auto-matches?
Handle	Group Key	✅ Yes
Title	Description (Title)	✅ Yes
Body (HTML)	Long Description	✅ Yes
Tags	Tags	✅ Yes
Option1 Name / Value	Option1 Name / Value	✅ Yes
Option2 Name / Value	Option2 Name / Value	✅ Yes
Option3 Name / Value	Option3 Name / Value	✅ Yes
Variant SKU	Variant SKU	✅ Yes
Variant Price	Variant Price	✅ Yes
Variant Inventory Qty	Variant Quantity	⚠️ Map this one by hand

The only column you have to set yourself is the quantity. On the Map your columns step, find the row for Variant Inventory Qty and, in its "Maps to" dropdown, choose Variant Quantity. Everything else should already be filled in.

You don't need to map 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 .csv/.xlsx. (First row must be column headers — both Shopify exports and our template already are.)
2. Step 2 — Map your columns. Confirm the matches above. Set Variant Inventory Qty → Variant Quantity if you used the Shopify file. 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