SGS EcommerceSGS Ecommerce
← ALL TOOLS

Inventory Forecast ALL PLATFORMS

Amazon + Flipkart + Meesho pooled into one shipped-units forecast, with units and revenue Pareto.

Step 1 — Download these files from the marketplace

FILE 01 · OPTIONAL

Amazon MTR B2C and B2B (.csv) — optional, multiple files/accounts allowed

Seller Central → Reports → Manage Taxes → GST Monthly Reports → Download Report → Merchant Tax Report (MTR) → B2C / B2B → select the month → Download Report. Put BOTH B2C and B2B in this one box (and every account you run) — they are pooled into a single Amazon column.

FILE 02 · OPTIONAL

Flipkart Sales Report (.xlsx) — optional, multiple accounts allowed

Seller Hub → Reports → Reports Center → Request New Report → Tax Reports → Sales Report → REQUEST REPORT → select the date range → Submit → Download.

FILE 03 · OPTIONAL

Meesho Orders (.csv) — optional, multiple accounts allowed

Meesho Supplier Panel → Orders → Download Orders Data → select the date range → Export / Download.

Step 2 — Upload & generate

Log in to generate this report. New sellers get 3 free reports a month.

What this report does

Pools Amazon (B2C + B2B), Flipkart and Meesho — any number of accounts — into one master SKU list
Measures true depletion, so returns don't distort what you reorder
Per SKU: daily average, 30-day forward stock, safety stock, lead-time buffer, total stock to maintain and reorder point
HIGH / MEDIUM / LOW reorder priority so the buying list writes itself
Dual 80/20 Pareto — by units and by revenue (a SKU can be vital on one and not the other)
Returned units, returned revenue and return rate % per SKU, split by marketplace
Upload only the platforms you sell on — the rest are dropped from the sheet, not left blank
Summary dashboard with charts + full Inventory Forecast data sheet

Use case

Monthly reorder planning: what to reorder and how urgently, which SKUs are the vital few by units and by revenue, and where cash is stuck — pooled across every marketplace and account you sell on, measured on units actually shipped.