Sync Master
← Features

Sync engines

Metafield Sync

Push variant metafields from spreadsheet columns — with normalization built in.

Metafield Sync maps spreadsheet columns to Shopify variant metafields and updates them in bulk. Values are normalized on the fly so the data lands in Shopify in the exact shape you want.

How it works

Step by step.

  1. STEP 1

    Map columns

    For each metafield, choose the column in the sheet that feeds it.

  2. STEP 2

    Pick a normalization preset

    Trim whitespace, lowercase, uppercase, DD/MM/YYYY or MM/DD/YYYY to ISO date, or custom replace rules — applied per column.

  3. STEP 3

    Add custom replace rules

    Map your own values, like Y → true / N → false, before they reach Shopify.

  4. STEP 4

    Decide on empty cells

    Choose whether empty cells clear the metafield (clearOnEmpty) or are skipped.

  5. STEP 5

    Test and sync

    The connection test shows sample values after normalization (✓ transformed, ⚠ mismatch) before you run the sync.

Spec highlights

At a glance.

Plan
Basic · Pro
Normalization
trim · lower · upper · date (DMY/MDY → ISO) · replace
Empty cell mode
clearOnEmpty | skip
Match key
barcode | sku
Logs
Per-variant success / error

Use cases

Where it earns its keep.

Spec-sheet sync

Engineering keeps tech specs in Sheets; ship them to Shopify metafields without manual entry.

Compliance flags

Track per-variant compliance (Y/N) in Sheets, automatically map to true/false metafields.

Localized labels

Pull translated short descriptions from a Sheet column straight into the matching metafield.

Stop pasting stock numbers by hand.

Install Sync Master on Shopify, connect the spreadsheet you already use, and start syncing stock with ease.