Quick-commerce catalog workflow
CSV Converter for Quick Commerce
Turn a supplier price list, Shopify export or Excel master into a validated catalog for 10-minute delivery. CSV Pilot maps products, SKUs, pack sizes, MRP, prices, stock and images into a clean CSV — including the Hyperzod import format when your storefront runs on Hyperzod.
No signup. You review every row before export. CSV Pilot does not publish to a marketplace or dark store for you.
Why a quick-commerce catalog is not a normal product export
A standard e-commerce export describes a product page. A quick-commerce (q-commerce) upload feeds a dark-store picking, replenishment and expiry system, and the assortment is hyperlocal by design. The same product can exist in several pack sizes, each with its own barcode, MRP and stock position. If a pack size, barcode or shelf life is wrong, the file may pass a visual review and still fail at inwarding — or reach a picker as the wrong item.
| Standard catalog | Quick-commerce catalog |
|---|---|
| One row per product | One row per sellable pack / SKU |
| Marketing title is enough | Title must include brand, variant and net quantity |
| Stock is a rough number | Stock is per SKU and often per dark store |
| Barcode optional | Barcode is needed for inwarding and scanning |
| Shelf life rarely shown | Shelf life and batch rules decide what can be shipped |
How the converter works
- 1. Upload what you already have. Supported Shopify product exports, DeliverLogic RDS files, Yelo product templates, Ordering.co Multi Importer files, StoreHippo exports, or a plain CSV/XLSX converted to CSV. A supplier price list works too if it has one row per pack.
- 2. Normalize the catalog. CSV Pilot groups variant rows, deduplicates SKUs, strips HTML from descriptions, normalizes prices and inventory, quotes commas correctly, and flags values it cannot map. Inferred fields stay visible so you can correct them.
- 3. Validate before export. Required names, categories, selling prices and cost prices are checked. Duplicate SKUs, compare-price errors and missing fields are listed per row. Warnings cover known conversion losses such as variant SKU loss or dropped barcode columns.
- 4. Export the file you need. Download a Hyperzod-ready import CSV, or use the cleaned master CSV to fill a marketplace portal template. You review the preview grid before download, so what you export is what you saw.
Quick-commerce field mapping
The right-hand column shows the Hyperzod CSV field CSV Pilot writes. Fields with no dedicated Hyperzod column stay in your master sheet and must be added in the destination portal template. Do not invent a header just to make a file look complete — validation and the importer both reject unknown structures more often than they accept them.
| Quick-commerce field | What to supply | CSV Pilot / Hyperzod output |
|---|---|---|
| SKU / product code | One unique code per sellable pack; must match your inventory system | PRODUCT.SKU |
| Product title | Brand + product + variant + pack size, e.g. "Tata Salt 1 kg" | PRODUCT.NAME |
| Category | The category tree used by the destination portal | PRODUCT.CATEGORY |
| Pack size / net quantity | 500 g, 1 L, 6 x 100 ml — put it in the title and description | Title + PRODUCT.DESCRIPTION |
| MRP | The printed maximum retail price, not an inflated number | PRODUCT.PRICE.COMPARE |
| Selling price | The price the customer pays today | PRODUCT.PRICE.SELLING |
| Cost price | Landed or purchase cost for margin checks | PRODUCT.PRICE.COST |
| Stock | A non-negative whole-number snapshot per SKU | PRODUCT.INVENTORY |
| Barcode / EAN / UPC | One scannable GS1 barcode per pack | No dedicated Hyperzod column — keep in master + portal template |
| Shelf life / batch | Manufacture and expiry rules required for food | No dedicated column — description, tags or master sheet |
| Image URL | Public HTTPS image, ideally square and white-background | PRODUCT.IMAGES |
| Tax / GST | The tax percentage that applies to the product | PRODUCT.TAX_PERCENT |
| Status | Whether the SKU is sellable right now | PRODUCT.STATUS |
| Variants | Pack sizes, flavours or colours that share a base product | OPTION*.NAME / VARIANTS |
| Labels and tags | veg / non-veg, storage, allergen or internal labels | PRODUCT.LABELS / PRODUCT.TAGS |
Quick-commerce catalog checklist
Example: a grocery row, before and after
A supplier sheet might contain one line for a 1 kg salt pack. A quick-commerce catalog needs that line to carry the pack size, barcode, MRP, selling price and stock in a structure the destination can read.
Source row
- Item
- Tata Salt
- Pack
- 1 kg
- MRP
- ₹30
- Selling
- ₹28
- Stock
- 48
Exported fields
- PRODUCT.NAME
- Tata Salt 1 kg
- PRODUCT.SKU
- TATA-SALT-1KG
- PRODUCT.CATEGORY
- Salt & Sugar
- PRODUCT.PRICE.COMPARE
- 30.00
- PRODUCT.PRICE.SELLING
- 28.00
- PRODUCT.INVENTORY
- 48
The barcode, shelf life and batch number stay in the master sheet because the Hyperzod CSV schema has no dedicated columns for them. Add those values in the portal template where the platform asks for them.
Common quick-commerce CSV errors
| Problem | Why it fails | Fix |
|---|---|---|
| Duplicate SKU | Two packs share a code, so stock and orders hit the wrong item | Make SKU unique ignoring case; check variant rows before export |
| Missing category | The portal cannot place the product in a category tree | Assign a category to every row; use one naming convention |
| MRP below selling price | Discount maths and portal validation fail | Set compare price above selling price, or leave it blank |
| Pack size only in the description | Pickers and search results cannot tell 500 g from 1 kg | Put the pack size in the product title as well |
| Leading zeros in barcodes | The barcode no longer scans after a spreadsheet round-trip | Format the barcode column as text before exporting |
| Broken image URL | The listing is rejected or shows a placeholder | Open every URL; use public HTTPS assets you control |
| Formula-like text | Spreadsheet opens the value as a formula | Prefix with an apostrophe on export; review the output |
| Wrong tax rate | Invoices and margins are wrong from day one | Confirm GST/HSN with your accountant and apply per row |
Platform reality check
Blinkit, Zepto and Swiggy Instamart list products through their own seller portals, and each platform allocates stock and assortment by dark store rather than by national catalog. Their listing templates and attribute rules are not a public CSV standard, and they change. CSV Pilot does not log in to those portals, submit listings, sync stock or guarantee that a portal will accept a file. What it does is remove the spreadsheet work before that step: one clean row per SKU, consistent pack sizes, validated prices and a catalog structure you can map into the template you have been given.
If your own storefront or delivery backend runs on Hyperzod, the export is already in the Hyperzod import format. If it does not, use the cleaned CSV as the master and fill the destination template from it. That distinction matters: a converter can normalize your data, but it cannot invent a private platform schema or replace the platform's approval process.
Frequently asked questions
What is a CSV converter for quick commerce?
It is a workflow that turns a supplier price list, marketplace export or spreadsheet into a clean, validated product catalog for a quick-commerce operation. A quick-commerce catalog needs one row per sellable SKU with a scannable barcode, pack size, MRP, selling price, tax, stock and a public image URL — not one row per marketing product.
Does CSV Pilot upload directly to Blinkit, Zepto or Swiggy Instamart?
No. Those platforms use their own seller portals and private listing templates, and CSV Pilot does not log in to them or submit files on your behalf. CSV Pilot prepares and validates the master catalog CSV. You then map that master into the portal template, or import it into your own storefront or backend when it runs on Hyperzod.
Which columns does a quick-commerce catalog need?
At minimum: a unique SKU, product title with pack size, category, MRP, selling price, tax rate, stock quantity, status and a public HTTPS image URL. Barcode/EAN, shelf life, batch details, FSSAI and HSN information are also commonly required, but the exact schema is defined by the platform or your own commerce backend, not by CSV alone.
Can I convert a Shopify export for quick commerce?
Yes. CSV Pilot recognizes supported Shopify product exports, groups variant rows by handle, rebuilds option groups and converts prices into Hyperzod's base-price plus delta model. Review variant SKU loss, zero-stock choices and extra gallery images before you rely on the result.
Does the converter handle barcodes and EAN codes?
The current Hyperzod CSV schema has no dedicated barcode column. CSV Pilot can preserve barcode values in your source and report where they cannot be mapped. Keep a barcode column in your master sheet, verify one GS1 barcode per SKU, and add it in the destination portal template where that field exists.
Can I manage store-level or dark-store inventory?
The exported CSV carries a stock snapshot per product row. It does not sync live inventory, and it does not split one row into per-dark-store quantities. For hyperlocal stock you need a backend or inventory system that maintains stock by location; use the CSV for the catalog structure and the initial snapshot.
Is the quick-commerce CSV converter free?
Yes. Creating, editing, converting and validating a catalog in the CSV Pilot workspace is free and requires no signup. You review the preview and validation results before downloading the file.
How do I validate a catalog before uploading it?
Check required names, categories, SKUs and prices; confirm price-compare values are above selling prices; look for duplicate SKUs; open every image URL; confirm pack size and net quantity; verify tax rates; and run a small test upload before replacing a live catalog. The validation panel lists field-level errors before export.
Convert your first quick-commerce CSV
Upload a supplier sheet or a supported platform export, review the mapped rows, fix validation errors and download a clean catalog. Free, no signup, no columns to memorize.
Open the CSV workspace