Sync Shopify Variant Prices from a Pricing Sheet with VLOOKUP
Many teams manage pricing in a dedicated spreadsheet and push final values into Shopify. With eCommix - Google Sheets Sync, this workflow works well for high-volume catalogs because you can centralize logic in Google Sheets and sync updates back to Shopify in bulk.
This guide covers a practical setup where the sync sheet pulls price values from a separate pricing tab using Variant ID or SKU as the lookup key.
Real use case: Formula-driven pricing with a separate pricing table
An operations team maintains a dedicated pricing sheet with Variant ID/SKU and target prices. In the Shopify sync sheet, the Price (Variant) column uses a lookup formula to fetch the right number per row. After review, the team imports updates and syncs prices back to Shopify.
This approach reduces manual copy/paste errors and keeps pricing logic in one place.
- Pricing data is owned in a single source tab
- Sync sheet formulas map prices automatically by key
- Team validates before import to avoid bad updates
Use eCommix - Google Sheets Sync to export Shopify products to Google Sheets, bulk edit safely, validate changes, and import updates back to Shopify.
Install eCommix - Google Sheets Sync on Shopify
Recommended sheet structure
Use two tabs:
- Pricing tab:
Variant ID,SKU,Target Price - Sync tab: eCommix export columns including
Variant ID,SKU (Variant),Price (Variant)
How to use VLOOKUP for price sync
Option 1: Match by Variant ID (recommended)
If your pricing tab has Variant ID in column A and Target Price in column C:
=IFERROR(VLOOKUP(A2, Pricing!A:C, 3, FALSE), "")
This is usually the safest key because Variant ID is unique and stable.
Option 2: Match by SKU
If you must match by SKU, use the SKU column as the lookup key:
=IFERROR(VLOOKUP(B2, Pricing!B:C, 2, FALSE), "")
Use SKU only if you are sure each SKU is unique and normalized.
Best practices for this workflow
- Use
Variant IDas primary key whenever available - Keep one row per variant in the pricing tab (no duplicates)
- Store numeric prices only in
Target Price(no currency symbols) - Add a QA column to flag missing lookups before import
- Lock formula columns to prevent accidental overwrite
- Run imports in small batches first when changing logic
Add a quick QA check before import
Use a helper column to catch rows where lookup failed:
=IF(C2="", "MISSING_PRICE", "OK")
Filter to MISSING_PRICE and resolve every row before validation/import.
Import sequence with eCommix
- Export the target product/variant set to the sync tab.
- Apply lookup formulas in
Price (Variant)(or helper column + paste values). - Run QA filters for blanks, duplicates, and unexpected values.
- Validate in eCommix.
- Import and sync to Shopify.
- Re-export a sample to confirm final prices.
Common mistakes to avoid
- Using SKU lookup when SKU is not unique across variants
- Mixing text-formatted prices with numeric price columns
- Updating formulas without testing on a small sample first
- Skipping validation because formulas "look right"
Final tip
For long-term reliability, treat your pricing tab as the source of truth and your sync tab as a controlled execution layer. This makes recurring price updates fast, auditable, and safer.
Related Shopify Spreadsheet Guides
Continue with these related tutorials to build a complete bulk-edit workflow in Shopify:
- Bulk Edit Product Prices in Shopify
- Manage Shopify International Market Prices
- Validate Shopify Bulk Changes Before Import
Install eCommix - Google Sheets Sync
If you want to manage Shopify data in spreadsheets and import changes back with validation, install eCommix - Google Sheets Sync and start with a small test batch first.