Automated Cin7 ABC Inventory Analysis
On the first Monday of each month, WebRun opens Cin7, reads 90 days of sales revenue by SKU, ranks them by contribution, assigns each to the A (top 80 percent of revenue), B (next 15 percent), or C (bottom 5 percent) tier, and writes the classified list to a Google Sheet for your buyers and planners.
How do I automatically run an ABC inventory analysis using Cin7 sales data each month?
WebRun opens Cin7 on the first Monday of each month, reads 90 days of sales revenue by SKU, and classifies every item into A, B, or C tiers using the standard 80-15-5 revenue split. The ranked, tier-labeled catalog is written to Google Sheets so buyers can concentrate purchasing effort on the SKUs that drive the most revenue.
- Every SKU classified into A, B, or C tier monthly with zero spreadsheet work
- Buyers focus safety stock and service levels on the SKUs that drive 80 percent of revenue
- Tier shifts caught month to month so purchasing strategy stays aligned with actual sales
Built for inventory planners · purchasing managers · supply chain analysts · wholesale distributors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.cin7.comin a real browser with your saved login - no setup, no API keys. -
1
Cin7 - read 90-day sales revenue by SKU
cin7.com
WebRun opens Cin7 to read 90-day sales revenue by SKU. - Open Cin7 and pull sales order lines for the past 90 days
- Calculate total revenue per SKU for the period
- Sort SKUs by revenue descending and compute cumulative revenue percentage
- Assign tier A to SKUs that together make up the first 80 percent of cumulative revenue
- Assign tier B to the next group reaching 95 percent, and tier C to the remainder
Done when Every active SKU is assigned an A, B, or C tier based on 90-day revenue contribution.
-
2
Google Sheets - write ABC classification report
google.com
WebRun opens Google Sheets to write ABC classification report. - Open the ABC analysis Google Sheet
- Replace last month's classifications with this month's results
- Write SKU, product name, 90-day revenue, revenue share percent, cumulative percent, and tier for each item
- Add a summary tab showing item count and total revenue per tier
Done when The ABC sheet is refreshed with this month's tier classifications and the summary tab is updated.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it change reorder settings in Cin7 based on the ABC tier?
No. WebRun writes the tier classification to Google Sheets for your planning team to use. Updating safety stock or reorder levels in Cin7 is a human step so your team validates tier assignments before changing settings.
Can I change the A, B, C revenue thresholds?
Yes. The default is 80-15-5 percent. Tell WebRun your preferred split during setup and it will apply those thresholds instead.
How often should ABC analysis run?
Monthly is the recommended default, which balances freshness with stability. For fast-moving catalogs, WebRun can run it weekly. Change the trigger during setup to match your planning cycle.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.