Formula recipe

Price every product from its real cost

=VLOOKUP(SKU,Costs,3,0)*1.6

Keep costs in one sheet. VLOOKUP finds each product's cost, your markup sets the price, and Shopify follows.

FormulaVLOOKUP
Shopify fieldPrice
Tested resultCost 7,000 became 11,200
4.9/5 on Shopify App Store
Built for Shopify
20 formula cells free
How it works

Costs in one place, prices everywhere

Your cost list can live in another tab or another file. VLOOKUP pulls the right cost for each row and your markup does the rest.

  • Look up by SKU or variant ID
  • Pull costs from another file with IMPORTRANGE
  • Change the markup, reprice a category
Copy and paste

Ready-to-use variations

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

=VLOOKUP(X2,Costs!A:C,3,0)*1.6

Markup on cost

Cost times 1.6.

=ROUND(VLOOKUP(X2,Costs!A:C,3,0)/(1-0.35),0)

Target margin

Price for a 35% margin, rounded.

=VLOOKUP(B2,IMPORTRANGE(url,"Sheet1!A2:D500"),3,0)*1.6

Costs in another file

Tested: cost 7,000 became 11,200.

Good to know

Tips before you start

Exact match

Keep the last argument at 0 so VLOOKUP only returns an exact SKU match.

Missing SKUs

If a SKU isn't in the cost list, VLOOKUP returns an error and FlexSync resets that cell. Wrap it in IFERROR to fall back to the current price.

Refresh after cost changes

Fill the Price formula down again after updating costs.

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.

Yes. Look up by Variant ID instead. It's already in the Sheet.

Yes. Add a markup column to your cost sheet and multiply by it.

No. This formula sets the Price only.

Let your formulas run your store

Free plan includes 500 SKUs and 20 formula cells.