Skip to content

Case price to unit cost: what to check before updating Shopify

The price did not change. The cost did.

Imagine a fictional supplier list showing a $36 case of six items. The unit cost is $6. In the next list, the case still costs $36 but contains four items. The unit cost is now $9: a 50% increase even though the case-price cell stayed the same.

Comparing only the price column misses the change. You also need to compare the quantity inside the priced package and the unit your Shopify variant represents.

Keep three quantities separate

MeaningFictional exampleWhat it tells you
Units in the priced case6 individual glassesDivide the case cost by 6 if the store sells one glass
Order multiple12 glassesOrders must be in multiples of 12; it is not the case size
Supplier availabilityLimitedIt says nothing about how many glasses your own store holds

If your store sells the whole case, do not divide its cost as though the variant were a single glass. Confirm the actual sellable unit first. Hold a row for review when the pack size is missing, zero or ambiguous.

Check the basis before comparing

Use like-for-like currency, tax treatment and units. Confirm whether a number is your wholesale cost or a recommended retail price. Don't treat a suggested selling price as a purchase cost, and don't assume recoverable tax, freight, discounts or duties have already been accounted for.

For the simple example below, both editions use tax-exclusive USD and the store sells one glass. This calculation is a reference-cost comparison, not a landed-cost or accounting valuation method.

EditionCase priceUnits per caseReference unit cost
First$36.006$6.00
Revised$39.006$6.50

Review margin without confusing it with markup

Simple product margin is (selling price − unit cost) / selling price. To target 55% on a $6.50 unit cost, the unrounded price would be 6.50 / (1 − 0.55) = 14.444…. A price of $14.45 clears that threshold in this simplified example.

Adding a 55% markup gives a different result. Neither formula tells you your final business profit. Check your actual costs, tax basis and pricing commitments before deciding what to charge.

Make the next revision easier to review

In unkrypt Amend, confirm what the supplier columns mean and which variants they describe, then review the next edition using that saved setup. Correct unclear rows beside the original. Approve the intended cost and base selling-price updates separately, and check the results.

The walkthrough uses fictional price lists with exactly this $36-to-$39 case change. It is an edited demonstration, not a claim about customer time savings. See the 30-day trial and processing limits.

Written by unkrypt, the developer of Amend. English UI; initial availability excludes EEA and UK businesses. External OCR is optional and limited to price lists confirmed free of personal data with the required sending rights. Inventory quantities are not changed.

TRY THE FICTIONAL EXAMPLE

What does one item cost?

Assumes your store sells one item, with all prices in tax-exclusive USD. Calculates in your browser; nothing is sent or written to Shopify.

Reference unit cost: $6.50

Simple product margin: 53.57%

Excludes shipping, duties, discounts, payment fees and other expenses. This is a learning example, not landed-cost or inventory accounting.