---
title: "Cost-plus pricing"
id: "1115"
type: "page"
slug: "shopify-cost-plus-pricing"
published_at: "2026-11-15T03:05:28+00:00"
modified_at: "2026-11-15T03:05:28+00:00"
url: "https://flexsync.app/formulas/shopify-cost-plus-pricing/"
markdown_url: "https://flexsync.app/formulas/shopify-cost-plus-pricing.md"
---

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.

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

[#](#)

Formula**VLOOKUP**

Shopify field**Price**

Tested result**Cost 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

Pricing rules · FlexSync**Synced**

fx`=VLOOKUP(B2,Costs!A:C,3,0)*1.6`

| 1 | Product | Cost | Markup | Price |
| --- | --- | --- | --- | --- |
| 2 | Fullsuit 2XS | 7,000 | x1.6 | 11,200 |
| 3 | Hooded Wetsuit | 8,000 | x1.6 | 12,800 |
| 4 | Soft Surfboard 5'7 | 9,000 | x1.6 | 14,400 |

Shopify admin

### Fullsuit 2XS

Price**11,200.00 *Updated***

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.

[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/)
[Supplier price sync =IMPORTRANGE(supplier_url,"Sheet1!B2") Explore →](/formulas/shopify-supplier-price-sync/)
[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)
.

### My products have no SKUs. Can I still use this?

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

### Can I keep a different markup per category?

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

### Does this change cost per item in Shopify?

    No. This formula sets the Price only.

## 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-cost-plus-pricing)
[See pricing](/pricing)

×
