Bulk edit cost per item on Shopify

Cost per item is easy to ignore because customers never see it. Then a supplier raises prices by 8%, nobody updates the field, and every profit report for the next quarter is quietly wrong.

Because cost sits on the variant, updating it in bulk is the same shape of job as repricing — filter, apply a rule, check the example, run it.

Cost operations

• Change to — set a flat cost for a filtered group.
• Adjust by amount or percentage — apply a supplier increase across one vendor.
• Adjust based on price — derive cost from the retail price when you work to a target margin.
• Set cost per item to blank (NULL) — clear the field where it does not apply.
• Round to — keep costs to two decimals rather than whatever the percentage produced.

Scoping a cost update

• By vendor — the usual scope, because increases arrive supplier by supplier.
• By product type — when a materials cost moves for a category.
• By SKU — contains or equals, for supplier code prefixes.
• Where cost is empty — find products that never had cost filled in.
• By update date — catch anything not touched since the last review.

A worked example: an 8% supplier increase, passed through

1. Filter: vendor is equal to “Northwind”.
2. Editor: cost per item → increase by 8%, round to 2 decimals.
3. Editor: price → adjust based on cost per item, increase by 120%, round to .95.
4. Preview the calculation example — the app shows the old and new value for both fields.
5. Run it, then check the log to see every SKU that moved.

Margins as a maintenance job

Once cost is accurate, price-from-cost rules become dependable: a single task can hold your whole pricing policy — target margin, rounding, exclusions — and be re-run whenever costs change.

On paid plans the same task can be scheduled to repeat, so a quarterly cost review runs itself and you only read the log.

Related guides