Workflow · Stock and products · Opening soon

Gross margin by product

See gross margin for each product from Shopify exports. You get net sales, unit cost, units sold, gross margin, and margin percent.

Book a demo

Someone typed

“gross margin per product: net sales minus unit cost times units, and margin percent”

The agent read it as

Work out gross margin per product from Shopify orders and Shopify products: net sales minus unit cost times units, and margin percent.

What the agent built

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

File

Shopify products

CSV export · 8 rows

File

Shopify orders

CSV export · 24 rows

Step

Make product SKU key

Step 1

Step

Make order SKU key

Step 2

Step

Total sales by product

Step 3

Join

Bring in product sales

8 of 8 paired

Step

Calculate gross margin

Step 5

Result

Product Gross Margins

8 rows

Schedule

Runs when you say

Proposed

File
Shopify products
CSV export · 8 rows
File
Shopify orders
CSV export · 24 rows
Step
Make product SKU key
Step 1
Step
Make order SKU key
Step 2
Step
Total sales by product
Step 3
Join
Bring in product sales
8 of 8 paired
Step
Calculate gross margin
Step 5
Result
Product Gross Margins
8 rows
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.

Download Shopify products sample (8 rows)Shopify admin: Products > Export > Current page of products (CSV)
Download Shopify orders sample (24 rows)Shopify admin: Orders > Export > All orders (CSV)

What you get back

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

Product Gross MarginsSample data8 rows

Product name	Gross margin	Margin percent	Net sales	Units sold	Unit cost	Cost of units
Eco Ceramic Mug	83	66.40	125	7	6	42
Softcover Notebook	51.80	72.96	71	6	3.20	19.20
Canvas Tote	37	39.36	94	6	9.50	57
Oak Desk Lamp	121	55.76	217	4	24	96
Steel Water Bottle	75	64.10	117	6	7	42
Soy Candle	58.50	60.31	97	7	5.50	38.50
Cedar Desk Shelf	-10	-9.80	102	4	28	112
Weekly Planner	82	63.08	130	6	8	48

8 rows in the result. Sample data: illustrative figures, not business results.

How do you work out gross margin by product?

Export your Shopify orders and Shopify products files, then upload them. Mammoth matches products by SKU, totals sales by product, brings in unit cost, and calculates gross margin and margin percent.

How it works

How to use the Product Gross Margins workflow

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.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Product Gross Margins: questions

Which export files should you use?

Use the orders export for sales, and the products export for SKU and unit cost. If your files use different column names, map them to the matching fields when you upload them.

What happens to rows that do not match?

Rows that do not find a match stay out of the final product totals unless you choose to review them. You can use them to spot missing SKUs, blank values, or products that were not in both files.

How do you change the rules?

Edit the workflow steps in words, then rerun it. You can change how SKUs are built, which columns are summed, and the formula used for gross margin and margin percent.