Template · Stock and products · Opening soon

Sell-through rate for every product

See how much of the stock you received each product has sold, what is left and which lines are slow, from your Shopify or stock system. It updates with every sale.

Book a demo

You bring

Stock received12 rows

ProductUnits received

Sales193 rows

Sold productUnits sold

Mammoth does the work

You get

One table13 rows

Each product's units received, units sold, what is left and its sell-through rate.

ProductUnits receivedUnits soldLeftSell-through %Pace

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Sell-through rate: the resultSample data13 rows

Product	Units received	Units sold	Left	Sell-through %	Pace
Linen shirt	150	140	10	93.3	Selling through
Canvas tote	200	184	16	92	Selling through
Leather belt	80	69	11	86.3	Selling through
Denim jacket	150	123	27	82	Selling through
Wool scarf	150	109	41	72.7	On track
Puffer vest	80	52	28	65	On track
Tee 3-pack	80	43	37	53.8	On track
Rain coat	60	31	29	51.7	On track

13 rows in the result · made from Stock received (12 rows) and Sales (193 rows) · first 8 shown. Sample data: illustrative figures, not business results.

How is sell-through rate calculated?

Sell-through rate is units sold divided by units received, as a percent. Selling 80 of 100 units received is an 80% sell-through: a strong line. A low rate late in a season is the cue to mark down or stop reordering.

How it works

How to use the sell-through rate template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Stock received and units sold, by product (2 tables)

Stock received

Product
Units received

Sales

Sold product
Units sold

The steps it runs

1Match columns: Stock received
2Match columns: Sales
3Units sold by product
4Units received by product
5Line up received and sold
6Sell-through rate

Every step is an ordinary Mammoth step you can open and change.

Sell-through rate: questions

Over what period?

Over whatever the two tables cover. Keep both to one season or one delivery to read a season's sell-through.

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.