Skip to content
Workflow · Stock and products · Opening soon

GMROI by category

Export your Shopify sales and inventory data, then load both files. Mammoth matches rows by category, calculates gross margin dollars divided by average inventory at cost, and shows GMROI for each category.

Early access opens shortly. Check back soon.

Someone typed

“match the shopify category sales to the inventory at cost, calculate gmroi from gross margin dollars over average inventory cost, and show each category with gmroi and status: Agrees at 2 or more, Low return below 2”

The agent read it as

Match the Shopify sales with cost by category to the Shopify inventory at cost by category, calculate gmroi from gross margin dollars over average inventory cost, and show each category with gmroi and status: Agrees at 2 or more, Low return below 2

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Shopify sales with cost by category
    CSV export · 8 rows
  2. File
    Shopify inventory at cost by category
    CSV export · 8 rows
  3. Step
    Make sales category key
    Step 2
  4. Step
    Make inventory category key
    Step 1
  5. Join
    Match inventory by category
    8 of 8 paired
  6. Step
    Calculate category GMROI
    Step 4
  7. Result
    Category GMROI
    8 rows · 6 flagged
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 8 of 8 rows.

What you get back

The result of that run, the rows to look at first.

Category GMROISample data8 rows
2 agrees6 low return
CategoryGMROIStatusGross margin dollarsAverage inventory cost
Apparel1.50Low return75,30050,050
Electronics-0.28Low return-12,70044,800
Home Decor1.64Low return61,45037,450
Outdoor0.99Low return41,25041,850
Pantry1.51Low return35,20023,350
Pet1.67Low return42,90025,700
Accessories2.36Agrees55,40023,450
Beauty2.84Agrees85,20029,950
8 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Category GMROI workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Category GMROI: questions

How do you calculate GMROI by category?
Export your Shopify sales and inventory data, then load both files. Mammoth matches rows by category, calculates gross margin dollars divided by average inventory at cost, and shows GMROI for each category.
What export should I use?
Use a Shopify sales export and a Shopify inventory export that include the category fields you want to compare. The file needs enough detail to group sales and inventory by the same category key.
What happens if a row does not match?
Rows that do not match the category key are left out of the matched result. You can review them and decide whether to fix the category names or add a rule so they match.
How do I change the matching rules?
Edit the rules in words, then run the workflow again. You can change how the category key is made, how rows are matched, and how GMROI status is labeled.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.