Metro Cash and Carry India Monthly Wholesale Pricing & Bulk Tier Dataset
A monthly file of Metro Cash and Carry — India's largest wholesale cash-and-carry chain — with 26 columns covering price, MRP, discount, availability, store, pin-code, country of origin and, most usefully, price_quantity_tiers: the full bulk pricing ladder.
This is B2B pricing, not retail. A product does not have one price — it has a price per quantity band. In the supplied sample one item ran ₹159 per piece at 1–2 units, ₹132 at 3–99, and lower again past 100, with the margin percentage on every tier.
The file already exists, because this pipeline runs every month whether you buy it or not. Most vendors start collecting after you order — which is why they quote a lead time. Here the most recent file is in your account within minutes of payment, with an API key issued at the same time.
What you get, in plain terms
Four things. This is a wholesale dataset — if you want retail shelf prices, this is not the file.
Bulk pricing tiers, with margin
price_quantity_tiers carries every quantity band as JSON — min quantity, max quantity, per-piece price and the margin percentage against MRP. Nobody buys one unit here.
Minimum and maximum order quantity
minimum_quantity and maximum_quantity as their own columns. A price you cannot buy at your volume is not a price you can act on.
Store and pin-code on every row
Cash-and-carry pricing is set per branch. store_id and pincode are captured so you compare like with like.
However you want it
Direct download, REST API, Amazon S3, Google Cloud, Snowflake or SFTP. The API key comes with the dataset.
Fields included in this dataset
All 26 columns, in the exact order they appear in the file — taken straight from the sample, not from a brochure. The free sample ships with a data dictionary giving an example value for each one.
Sample rows from the real file
Real rows from the sample file, not an illustration. The free sample is 50 items with all 26 columns.
Coverage
Captured monthly across the stores on your feed. The supplied sample is one Bengaluru branch in depth — 37 brands across 31 search terms.
| Metric | In the supplied sample | What it tells you |
|---|---|---|
| Brands covered | 37 | Breadth of a single branch's assortment |
| Search terms | 31 | How the catalogue was walked |
| Items available | 47 of 50 | Wholesale availability is high — stock-outs are the exception |
| Rows with bulk tiers | 47 of 50 | Tiered pricing is the norm, not a special case |
| Rows with promotions | 15 of 50 | Promotional activity on roughly a third of the assortment |
| Country of origin | India, all 50 | Useful for sourcing and compliance reporting |
One branch is what the sample shows, not what the feed is limited to. Store count is the main thing that drives the price — tell us which branches or cities matter and we will quote it.
Historical data
The last 30 days come with the dataset. Beyond that we hold Metro records from February 2025 onwards for the stores on this feed — enough to see how wholesale tiers moved through a full trading year.
Ask about historical dataNeed more data points?
We can extend this dataset beyond the standard 26 columns — the bulk tiers flattened into named columns is the most requested change, along with more branches, category hierarchy and competitor cash-and-carry chains in the same file.
Request custom fields“We had been benchmarking our trade price against Metro's shelf price, which is the price nobody pays. The tier ladder showed we were twelve percent off at the volumes our customers actually buy.”
What people use this dataset for
FMCG brands and distributors
Benchmark your trade prices against the wholesale ladder at the volumes your customers actually order.
Retailers and kirana buyers
Compare cost of goods across brands and pack sizes before committing a bulk purchase.
Pricing and margin teams
Use the published margin percentage per tier to see where wholesale economics actually sit.
Analysts
Build a B2B price series for a channel that almost no other dataset covers.
About Metro Cash and Carry wholesale data
Metro Cash and Carry operates wholesale branches serving kirana stores, restaurants and institutional buyers across India. It is a B2B channel, which means its pricing behaves nothing like retail — there is no single price per product, and the number on the shelf is the least interesting one in the file.
Why quantity tiers are the whole point
A wholesale buyer's cost depends entirely on how much they take. In the supplied sample one item priced at ₹159 per piece for 1–2 units, ₹132 for 3–99, and lower again beyond 100 — a spread of more than twenty percent on the same product on the same day. price_quantity_tiers carries every band with its own min_qty, max_qty, retail_price_per_pc and margin, so you can price against the volume your customers really buy rather than the headline.
Minimum order quantity changes what a price means
minimum_quantity and maximum_quantity sit as their own columns because a tier you cannot access is not a tier. Some items cap at 99 units, some at 999. If you are modelling landed cost, the cap matters as much as the rate.
Why monthly capture is the right cadence here
Wholesale prices move on contract and promotion cycles, not daily. Monthly capture matches how the channel actually behaves and keeps the file affordable across many branches — which is the dimension that matters, since cash-and-carry pricing is set per branch rather than nationally.
Is collecting this data legal?
Collecting publicly visible product and price information is generally lawful in most jurisdictions. Actowiz collects only public pages, respects robots.txt and platform terms, holds no personal data, and aligns with GDPR and CCPA. We are ISO 9001 and ISO 27001 certified, and this dataset carries documented provenance so your legal team can review the source before you buy.
Frequently asked questions
min_qty, max_qty, retail_price_per_pc and margin — so a single row can tell you the per-piece cost at 1 unit, at 3 units and at 100. It was populated on 47 of the 50 rows in the supplied sample.
Your Data Needs
-
Free Sample in 2 HoursShare your requirement, get 500 rows of real data — no commitment.
-
Plans from $500/monthFlexible pricing for startups, growing brands, and enterprises.
-
US-Based SupportOffices in New York & California. Aligned with your timezone.
-
ISO 9001 & 27001 CertifiedEnterprise-grade security and quality standards.
