Table of Contents

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.

Learn more on ecommix.io

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)

[SCREENSHOT PLACEHOLDER]
image.png: pricing table tab and sync tab side by side

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 ID as 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.

[SCREENSHOT PLACEHOLDER]
rows flagged as MISSING_PRICE before 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:

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.

Install eCommix – Google Sheets Sync