Build a Shopify SKU revenue concentration stack with CSV data

When a store has hundreds or thousands of SKUs, a ranked sales list is a start, not a stock plan. It shows which products sold most in a chosen period. A Pareto analysis adds the cumulative share: how much of total revenue comes from the leading items, and where the contribution begins to thin out.

That distinction matters. A business whose sales are concentrated in a small group of products faces a different exposure from one with a long, even tail. The curve will not tell an ecommerce manager how many units to buy. It can show where a stockout, supplier delay or forecast error deserves attention first.

1. Choose the unit and sales window

Start in Shopify with a product-sales report or an order-line export that includes the sales period you want to examine. Report names, available fields and export options can vary. The important thing is that the data identifies the product or variant and provides a consistent revenue measure. If the report is at product level but replenishment happens by variant, find a source with variant-level detail instead.

Set the period before exporting. A recent month may reflect a promotion or a seasonal peak; a longer period smooths some short-term swings but can hide a change in demand. For a first pass, use a period that matches how the team reviews purchasing, then repeat the analysis for a comparable prior period if you need context.

2. Prepare a two-column CSV

Build a compact file with one row per reorderable SKU and two fields: a label, such as SKU or variant name, and the selected revenue value. If the export has multiple rows for a SKU, aggregate them before analysis. A spreadsheet can do that with a pivot table or a grouped sum. Check that each SKU appears once and that the total still matches the source report.

Be consistent about what “revenue” means. Use the same treatment of discounts, refunds and returns across every row. If the source offers gross and net sales, choose the measure that fits the question and record that choice. Avoid mixing currencies, time periods or tax and shipping amounts into the product values. Resolve blank or duplicated SKU identifiers; otherwise, the ranking may combine distinct items or split one item into several rows.

3. Run the concentration analysis

Upload the CSV to ParetoScope, paste the two columns from a spreadsheet, or enter the data manually. Its calculations return a ranked list, individual and cumulative percentages, concentration, and a vital-few cut-off. Free calculations run locally in the browser and do not require an account.

Read the cumulative share beside the ranked SKUs, not as a universal 80% rule. If the first handful of products account for a large share, the catalog is concentrated by revenue. If the curve rises gradually, sales are spread more broadly. The cut-off is a way to locate a leading group in this dataset; it is not a claim that every store should prioritize exactly 20% of its catalog. For context on why a fixed threshold can mislead, see how static 80/20 cutoffs can misallocate resources.

4. Turn the list into a replenishment review

Take the highest-contributing SKUs from the analysis into the inventory review. Compare them with on-hand stock, open purchase orders, supplier lead times, minimum order quantities and recent unit sales. Use those operational facts to decide what to reorder and when. Revenue rank alone cannot supply a reorder quantity: a high-price item may generate substantial revenue with few units, while a lower-priced item may move quickly and still contribute less revenue.

Use the list to assign attention, not to automate a purchase decision. A leading SKU with healthy cover may need no immediate order. A lower-ranked item may still be essential because it completes a bundle, supports a key customer or has a long replenishment lead time. ParetoScope derives insights and recommended actions from the numbers entered; inventory constraints and commercial judgment remain part of the decision.

Know what the curve leaves out

A revenue-based ecommerce 80/20 product analysis measures sales concentration, not margin, unit demand, stockout risk or supplier reliability. Promotions can pull revenue forward. Returns can change the picture depending on the report and the period. New products may look unimportant simply because they have had less time to sell. Repeat the analysis on comparable windows, and keep the metric and SKU definition stable when comparing results.

The practical stack is deliberately small: Shopify provides the sales data, a spreadsheet can aggregate rows to the replenishment unit, and ParetoScope calculates the ranking and cumulative concentration from the CSV. That is enough to reveal whether a few SKUs dominate revenue. It is not a substitute for a demand forecast or an inventory policy, but it gives the team a defensible place to start its next stock review.