Shopify's built-in ABC analysis by product grades items over a fixed 28-day window on the Shopify plan or above. The premade ABC Analysis report in Data Export gives you grades at the variant level with the date range you choose, based on units sold. Both are good starting points. The real work starts when you want to grade on a different metric, cover a longer window, or pair the grades with a stock check. A custom report is how you get there.

What does a custom ABC report give you that the native one does not?

Shopify's native ABC analysis by product report puts items into three grades based on revenue in the last 28 days. A-grade covers roughly 80 percent of revenue, B-grade 15 percent, and C-grade 5 percent. It is a clean summary with three limits for everyday inventory decisions:

  • The 28-day window does not move with your buying cycle. If you reorder on a 60-day lead time or sell a seasonal catalog, 28 days can misread a product.

  • You cannot change the metric. Revenue is the only lens.

  • The report lives beside your stock data, not inside it. You still have to cross-check what is on hand before you act.

A custom report in Data Export fixes all three. You pick the window, you pick the metric, and you combine the grades with the stock or cost fields you need for the decision at hand.

Which metric should you grade on: units, revenue, or margin?

Pick the metric that matches the decision you are trying to make. Each one answers a different question:

  • Units sold. Best when you want to understand picking, packing, and handling load. The premade ABC Analysis report in Data Export grades on this by default.

  • Revenue. Best when you want to protect sales. A-grade items here are the ones a stockout will hurt most.

  • Gross margin. Best when you want to protect profit. A high-revenue item with thin margin may matter less than a mid-revenue item with a strong margin.

Many merchants run two versions, one by units and one by revenue, and pay extra attention to items that grade high on both.

What fields do you need in a useful ABC report?

Build the report at the variant level, since grades can differ between variants of the same product. These fields cover the common decisions:

Identity

  • Product title

  • Variant title and SKU

  • Vendor

  • Product type or collection

Grading inputs

  • Units sold in the chosen window

  • Gross or net sales, if you want to grade on revenue

  • Cost per item, if you want to grade on margin

Rank and grade

  • Cumulative share of the chosen metric

  • ABC grade based on your thresholds

Supporting context

  • Current inventory on hand, pulled from a separate inventory report and matched by SKU or Variant ID

  • Days of cover, using average daily units

The premade ABC Analysis report gives you the identity, units, cumulative ranking, and grade fields out of the box. The stock and cost fields come from a separate inventory report, or from a custom report built to combine them.

How do you pick the right date range?

Match the window to the decision, not to the calendar. A few rules of thumb:

  • For replenishment of fast-moving staples, use a window about twice your supplier lead time. For a 30-day lead time, a 60-day window smooths out short gaps.

  • For seasonal catalogs, use the same months from the prior year rather than the most recent weeks. A C-grade in August can still be an A-grade in November.

  • For new products, exclude items with less than a full window of sales data, or review them separately. A short history can pull a promising item into C for the wrong reason.

  • For post-promo review, use the exact promo window. This tells you which items the promo moved and which did not.

Set the date range once in the report, then save it. Next month you only change the dates.

How do you pair ABC grades with current stock?

Grades on their own do not tell you what to do today. The action comes from putting the grade next to how much stock you have right now. A simple matrix:

  • A-grade, low stock: reorder urgently. These are the items a stockout will hurt most.

  • A-grade, healthy stock: protect the buffer. Do not let safety stock drift down.

  • B-grade, low stock: reorder in the normal cycle. Watch sell-through for upgrades to A.

  • B-grade, healthy stock: test a promo or bundle to lift them toward A.

  • C-grade, low stock: let it run down before reordering. Confirm the item still earns its shelf space.

  • C-grade, high stock: candidates for clearance, bundling, or discontinuation.

Two ways to bring the data together in Data Export:

  • Run the premade ABC Analysis report and a separate inventory report, and match by SKU or Variant ID in your export.

  • Build a custom report that pulls the grading fields and the stock fields into the same row, so the file you open is already decision-ready.

How do you build this report in Data Export?

Two paths. Pick the one that fits how you work.

Option 1: Start from the premade report.

Open the premade ABC Analysis report in your Shopify admin. Confirm the calculation settings and grade thresholds. Set your date range. Save a copy with your preferred window. For stock, run a separate inventory report and match by SKU.

Option 2: Build it in Report Builder.

Create a new custom report at the variant grain. Add the identity, grading, and context fields from the list above. Set the ranking and the grade thresholds you want: the common split is 80, 15, 5 for revenue, but a 70, 20, 10 split works for catalogs with a longer tail. Preview, then save.

Either way, you can export to Excel, CSV, TXT, JSON, or PDF, or send the report to email, Google Sheets, Google Drive, FTP, or SFTP on an hourly, daily, weekly, or monthly schedule. Rebuilding the file by hand each month is the step a saved, scheduled report removes.

If a field or formula you need is not obvious, the Data Export support team can set up the report with you. Custom report setup is free.

How often should you refresh the report?

For most stores, monthly is enough. Buying patterns shift slowly, and a monthly rhythm matches most reorder cycles. Run it weekly if you sell perishables or run frequent promotions, and quarterly if your catalog is small and stable. Schedule it so the fresh file lands in your inbox or Google Drive the morning you plan to act on it.

What to watch out for

A few quiet failure modes worth checking before you trust the grades:

  • A new product with two weeks of data can land in C, not because it is weak but because its history is short. Review items with partial history separately.

  • Returns still affect grading if you use gross sales. Grade on net if returns are material for you.

  • Variants of the same product can sit in different grades. A product-level view hides this. Keep the grain at variant for inventory decisions.

  • A single large order can push a slow item into B or A for the window. Spot-check the top of the list before acting.

  • Grade thresholds are a setting, not a law. Check the template's calculation settings before sharing a priority list with the buying team.

Turn ABC into a repeatable workflow

The point of a custom ABC report is not a sharper summary. It is a weekly or monthly list you can act on without rebuilding. Once the fields, date logic, and schedule are set, the report shows up, you work the A items first, you decide on the B items, and you run down the C tail. That is the loop most merchants are missing when they look at the native report and are not sure what to do next.

Data Export is built for this. A clear starting point with the premade ABC Analysis report, custom reports when you need to change the metric or the fields, fast generation, and live human help when you need it. Free trial on the Shopify App Store.

Frequently Asked Questions

Can I run ABC analysis over a longer period than 28 days in Shopify?

Not with the native Shopify report, which is fixed at 28 days. The premade ABC Analysis report in Data Export lets you pick any date range, and a custom report lets you set rolling windows, prior-year ranges, or specific promo periods.

Should I grade products by units, revenue, or margin?

Grade by units if you want to understand picking and handling load. Grade by revenue if you want to protect sales. Grade by gross margin if you want to protect profit. The premade ABC Analysis report grades by units sold, and you can build a custom report for the other two.

What grade thresholds should a custom ABC report use?

A common convention is 80, 15, 5 for A, B, and C by revenue share. For catalogs with a long tail of small sellers, a 70, 20, 10 split often fits better. Confirm the thresholds in the template's calculation settings before publishing a priority list, and keep them steady so trends stay comparable.

Should ABC grading be at the product level or the variant level?

Grade at the variant level for inventory decisions. Variants of the same product often sell at very different rates, and a product-level grade hides that. Group back to product for a merchandising view if you need one.

How do I treat brand-new products in ABC analysis?

Exclude variants with less than a full window of sales history, or review them separately. Letting a two-week history drop a new item into C can push you to kill a product before it has had a fair chance.

Does the ABC Analysis report include current stock levels?

The premade ABC Analysis report does not include stock quantities. Run a separate inventory report and match by SKU or Variant ID, or build a custom report that pulls grades and stock fields into the same row.

Can I schedule a custom ABC report?

Yes. Save the report in Data Export and set the schedule. Delivery supports email, Google Sheets, Google Drive, FTP, and SFTP, in Excel, CSV, TXT, JSON, or PDF, on an hourly, daily, weekly, or monthly cadence.

Try Data Export free for 15 days

Custom reports, 100+ prebuilt reports and scheduled delivery on every plan, from $12 per month.

Share this article