---
title: "Supplier price sync"
id: "1114"
type: "page"
slug: "shopify-supplier-price-sync"
published_at: "2026-11-15T03:05:27+00:00"
modified_at: "2026-11-15T03:05:27+00:00"
url: "https://flexsync.app/formulas/shopify-supplier-price-sync/"
markdown_url: "https://flexsync.app/formulas/shopify-supplier-price-sync.md"
---

Formula recipe# Pull supplier prices straight into Shopify

`=IMPORTRANGE(supplier_url,"Sheet1!B2")`Link your supplier's Google Sheet. Their price lands on your Shopify product. No downloads, no CSV imports.

[Start for Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-supplier-price-sync)
[See how it works](#how)

[#](#)

Formula**IMPORTRANGE**

Shopify field**Price**

Tested result**Price set to 12,999**

4.9/5 on Shopify App Store

Built for Shopify

20 formula cells free

How it works## Your supplier's sheet, your store's prices

IMPORTRANGE reads a cell from any Google Sheet you can open. Put it in the Price column and FlexSync sends the supplier's price to Shopify.

- Works with any Sheet you have access to
- Add your markup in the same cell
- Match rows by SKU or variant ID with VLOOKUP

Supplier feed · FlexSync**Synced**

fx`=IMPORTRANGE(supplier_url,"Sheet1!B2")`

| 1 | Product | Variant ID | Price |
| --- | --- | --- | --- |
| 2 | Hooded Wetsuit | ...716807 | 12,999 |
| 3 | Fullsuit 2XS | ...781191 | 11,999 |
| 4 | Soft Surfboard 5'7 | ...228743 | 13,999 |

Shopify admin

### Hooded Wetsuit

Price**12,999.00 *Updated***

Copy and paste## Ready-to-use variations

Native Google Sheets formulas. Paste one in the yellow column and fill down.

`=IMPORTRANGE(url,"Sheet1!B2")`### One cell, one price

Read a single supplier price.

`=IMPORTRANGE(url,"Sheet1!B2")*1.4`### Supplier price plus markup

Add 40% on top of the supplier's price.

`=VLOOKUP(B2,IMPORTRANGE(url,"Sheet1!A2:B500"),2,0)`### Match by variant ID

Find each product's row in the supplier sheet.

Good to know## Tips before you start

### Connect the sheets first

Run IMPORTRANGE once in a spare tab and click **Allow access**. Then delete the tab and use the formula in Price.

### When the supplier changes a price

Fill the Price formula down again. FlexSync sends the new prices to Shopify.

### Use a stable key

Match on variant ID or SKU, not row position, so new supplier rows don't shift prices.

Setup## Up and running in three steps

1### Turn on formulas

In FlexSync, open Settings, then Advance Settings, and switch on Allow Sheet Formula.

2### Paste the formula

Add it to the first row of the yellow column you want to change.

3### Fill down

Drag it down the column. FlexSync sends each result to Shopify.

[Read the formula guide](/docs/how-to-enable-and-use-flexsync-shopify-formula-feature/)

More recipes## More formulas that change your store

[Auto-draft sold-out products =IF(On_hand=0,"DRAFT","ACTIVE") Explore →](/formulas/shopify-auto-draft-out-of-stock/)
[Sitewide sale pricing =Compare_at*0.85 Explore →](/formulas/shopify-sale-pricing-formula/)
[Cost-plus pricing =VLOOKUP(SKU,Costs,3,0)*1.6 Explore →](/formulas/shopify-cost-plus-pricing/)
[Auto-tag low stock =IF(Available<10,"low-stock","") Explore →](/formulas/shopify-low-stock-tags/)
[Clean up product titles =PROPER(raw_title) Explore →](/formulas/shopify-clean-product-titles/)
[Generate SKUs ="FB-"&RIGHT(Variant_id,6) Explore →](/formulas/shopify-auto-generate-skus/)

Questions## Frequently asked questions

Still have questions? Our support team is available 24/7 at [support@flexsync.app](mailto:support@flexsync.app)
.

### Does my supplier need FlexSync?

    No. They only need to share their Google Sheet with you.

### Why connect in a spare tab first?

    Before access is granted, IMPORTRANGE shows an error. FlexSync won't send an error to Shopify, so connect the sheets first.

### Can I pull costs instead of prices?

    Yes. Pull the cost and multiply by your markup in the same cell.

## Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.

[Install FlexSync Free](https://apps.shopify.com/flex-stock-sync/install?utm_source=flexsync.app&utm_medium=formula-page&utm_campaign=shopify-supplier-price-sync)
[See pricing](/pricing)

×
