Workflow · Stock and products · Opening soon
Weeks of cover by store
See weeks of cover by store and product from your stock and sales exports. Use average weekly sales across all dates in the sales table.
Someone typed
“calculate weeks of cover for each product at each store from stock and average weekly sales”
The agent read it as
Calculate weeks of cover for each product at each Lightspeed stores from Lightspeed inventory by location and Lightspeed sales line items, with average weekly sales covering all dates in the Lightspeed sales line items.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Lightspeed inventory by location
CSV export · 24 rows
File
Lightspeed sales line items
CSV export · 44 rows
File
Lightspeed stores
CSV export · 3 rows
Step
Calculate weekly sales by store and product
Step 1
Join
Bring in weekly sales
22 of 24 paired
Join
Add store name
24 of 24 paired
Step
Calculate weeks of cover
Step 4
Result
Store Product Weeks Cover
24 rows
Schedule
Runs when you say
Proposed
- FileLightspeed inventory by locationCSV export · 24 rows
- FileLightspeed sales line itemsCSV export · 44 rows
- FileLightspeed storesCSV export · 3 rows
- StepCalculate weekly sales by store and productStep 1
- JoinBring in weekly sales22 of 24 paired
- JoinAdd store name24 of 24 paired
- StepCalculate weeks of coverStep 4
- ResultStore Product Weeks Cover24 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out, and the join paired 22 of 24 rows; the join paired 24 of 24 rows.
- Download Lightspeed inventory by location sample (24 rows)Lightspeed: Inventory > Stock on Hand > Export
- Download Lightspeed sales line items sample (44 rows)Lightspeed: Sales > Sales history > Export line items
- Download Lightspeed stores sample (3 rows)Lightspeed: Settings > Locations > Export
What you get back
The result of that run, the rows to look at first.
Store Product Weeks CoverSample data24 rows
| Product | Store name | Weeks of cover | Average weekly sales | Stock on hand |
|---|---|---|---|---|
| Aster Water Bottle 500ml | Downtown Flagship | 22 | 1.91 | 42 |
| Boreal Tote Bag | Downtown Flagship | 28.29 | 0.64 | 18 |
| Cedar Notebook A5 | Downtown Flagship | 25.14 | 2.55 | 64 |
| Drift Hoodie | Downtown Flagship | 17.68 | 0.51 | 9 |
| Ember Candle 8oz | Downtown Flagship | 51.86 | 0.64 | 33 |
| Fjord Travel Mug | Downtown Flagship | 21.33 | 2.67 | 57 |
| Harbor Pen Set | Downtown Flagship | 58.93 | 1.27 | 75 |
| Aster Water Bottle 500ml | Riverside Pop-Up | 23.57 | 0.89 | 21 |
| Boreal Tote Bag | Riverside Pop-Up | 204.29 | 0.13 | 26 |
| Cedar Notebook A5 | Riverside Pop-Up | 20.20 | 0.89 | 18 |
| Drift Hoodie | Riverside Pop-Up | 110.00 | 0.13 | 14 |
| Ember Candle 8oz | Riverside Pop-Up | 18.33 | 0.38 | 7 |
How do you calculate weeks of cover for each product at each store?
Export your stock and sales files from Lightspeed, then upload them. The workflow calculates weekly sales by store and product, adds the store name, and works out weeks of cover from stock and average weekly sales.
How it works
How to use the Store Product Weeks Cover 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.
Store Product Weeks Cover: questions
What export should I use?
Use the stock export and the sales export from Lightspeed. The workflow reads the rows in those files and uses the fields needed for product, store, stock, and sales.
What happens to rows that do not match?
Rows that do not match the expected product or store details are not included in the matched result. You can review the file and fix the source data, then run it again.
How do I change the rules?
Change the rules in words by editing the workflow steps, for example, which columns count as stock, sales, product, or store. You can also change how average weekly sales is calculated across the dates in the sales table.
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.
Workflows like this
Find the few products that make most of your sales, what sells together, and the stock that sits too long.
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Market basket analysisEvery pair of products bought together, with support, confidence and liftSee the workflow Template
- Inventory turnover and days on handEach product's turnover and days of stock on hand, month by monthSee the workflow Template
- Demand forecast by SKUForecast next month’s demand for each SKU from your Shopify order line export using recent monthly averages and trend.See the workflow Built by the agent
- Economic order quantityCalculate economic order quantity for each item from a NetSuite item cost and demand export.See the workflow Built by the agent