Creating your first pricing formula

Prerequisites

Formula pricing requires your products to have cost per item set in Shopify. Go to Shopify admin → Products → [product] → Cost per item to add costs. BulkOps reads this field via the Shopify API.

Formula pricing is available on the Starter plan and above.

Step 1 — Open Formula Pricing

In BulkOps, click Pricing → Formula Pricing in the left sidebar. Click New Formula.

Step 2 — Name your formula

Give the formula a descriptive name, e.g. "2.5x markup" or "40% margin target". This name appears in your campaign history.

Step 3 — Write the expression

In the Formula field, type your pricing expression. Examples:

GoalExpression |------|-----------| 2.5x markupcost * 2.5 40% gross margincost / (1 - 0.40) 50% markup on costcost * 1.5

The cost variable maps to the cost per item field in Shopify.

Step 4 — Set rounding (optional)

Choose how prices should be rounded after the formula runs:

Step 5 — Filter products

Use the product filter to select which products this formula applies to. You can filter by collection, product type, vendor, tag, or price range.

Step 6 — Preview

Click Preview. BulkOps calculates the new price for every filtered product and shows a comparison table. Review the results carefully.

Step 7 — Apply or Schedule

Troubleshooting

"Cost data missing for X products" — Some products don't have cost per item set. BulkOps skips these and shows a warning. Add costs in Shopify admin to include them.

Formula returns 0 — Check that the variable name is cost (lowercase). BulkOps does not support Cost or COST.