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.

FormulaIMPORTRANGE
Shopify fieldPrice
Tested resultPrice 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
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.

Questions

Frequently asked questions

Still have questions? Our support team is available 24/7 at support@flexsync.app.

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

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

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.