📄
Click to select or drag & drop purchase orders here
PDF (Blinkit, Swiggy, Zepto, More Retail, FirstCry) · Excel (Bigbasket)
Vendor / Buyer Reference
| Buyer Entity | Platform | PO Number Format | Tax Type | Place of Supply | Zoho GSTIN | Item Code Field (PO) | SKU Master Sheet | Key Extracted Fields | Zoho SO Mapping Notes |
|---|---|---|---|---|---|---|---|---|---|
| BLINK COMMERCE PRIVATE LIMITED | Blinkit | Numeric RO Number 2549710016558 |
IGST or CGST+SGST
Auto-detected from table header |
HR (Haryana) | 06AAFCG9846E1ZF | Item Code → SKU Master Blinkit sheet | Blinkit |
RO Number · Date · RO Type · Seller No · Currency · RO Expiry · Item Code · HSN · UPC · Description · Tax% · Landing Rate · Qty · MRP · Total · Basic Cost (Master) Awenest SKU Code (Master) Pack Size (Master) Item Tax (Master) Item Tax % (Master) |
Called "Recommended Quantity Order (R.O.)". Items can span multiple pages — page 2+ has no repeated header row. Zoho: Customer = BLINK COMMERCE PRIVATE LIMITED · Place of Supply = HR · Tax lookup: IGST → Inter State, CGST+SGST → Intra State. |
| CLOUDKART VENTURES PRIVATE LIMITED | Swiggy | CHMPO284218 (CHMPO) | IGST | TS (Telangana) | 36AAKCC0275A1Z2 | Item Code → SKU Master Swiggy sheet | Swiggy |
PO No · PO Date · Release Date · Payment Terms · Delivery Date · Expiry Date · Item Code · HSN · Qty · MRP · Base Cost · Taxable Value · CGST Rate & Amt · SGST Rate & Amt · IGST Rate & Amt · CESS · Total · Basic Cost (Master) Awenest SKU Code (Master) Pack Size (Master) Item Tax (Master) Item Tax % (Master) |
All Swiggy entities use identical PO template. Buyer name auto-extracted from billing address. IGST for inter-state; CGST+SGST for intra-state. Zoho: Fallback row on continuation pages captured via regex. Buyer GSTIN and Place of Supply differ per entity — see this table. |
| CLOUDSTORE RETAIL PRIVATE LIMITED | Swiggy | CIMPO99250 (CIMPO) | CGST+SGST | MH (Maharashtra) | 27AAKCC0172C1Z1 | ||||
| PJTJ TECHNOLOGIES PRIVATE LIMITED | Swiggy | ETPPO46823 (ETPPO) | IGST | HR (Haryana) | 06AAJCP6431C1ZN | ||||
| JUPITER KART PRIVATE LIMITED | Swiggy | JN2PO83146 (JN2PO) | IGST | TN (Tamil Nadu) | 33AAFCJ5481L1Z9 | ||||
| ZEPTO LIMITED (formerly Kiranakart / Zepto Pvt Ltd) |
Zepto | P3981396 (P + 7 digits) | IGST |
Derived from PO buyer GSTIN MH KA TN TS HR UP WB RJ GJ PB |
Read live from PO — varies by warehouse: 27AAICK4821A1ZV MH (Maharashtra) 29AAICK4821A1ZR KA (Karnataka) 33AAICK4821A1Z2 TN (Tamil Nadu) 36AAICK4821A1ZW TS (Telangana) 06AAICK4821A1ZZ HR (Haryana) 09AAICK4821A1ZT UP (Uttar Pradesh) 19AAICK4821A1ZS WB (West Bengal) 08AAICK4821A1ZV RJ (Rajasthan) 24AAICK4821A1Z1 GJ (Gujarat) 03AAICK4821A1Z5 PB (Punjab) |
Material Code → SKU Master Zepto sheet | Zepto |
PO No · PO Date · Release Date · Payment Terms · Delivery Date · Expiry Date · Material Code · SKU Code (UUID) · HSN · EAN · Qty · MRP · Base Cost · Taxable Value · CGST · SGST · IGST · CESS · Total · Basic Cost (Master) Awenest SKU Code (Master) Pack Size (Master) Item Tax (Master) Item Tax % (Master) |
SKU Code is an internal UUID. Wide 24-column table with spacer columns — mapped by fixed position. Zoho: GSTIN and Place of Supply read directly from PO buyer GSTIN (identified by AAICK PAN prefix). Derived state code used as Place of Supply. Item Code matched via Material Code. |
| MORE RETAIL PRIVATE LIMITED | More Retail | 14119445 (8-digit numeric) | IGST | KA (Karnataka) | 29AAACP2678Q1ZM | Primary Vendor SKU → SKU Master More sheet | More |
PO No · PO Date · Delivery Date · Expiry Date · Payment Terms · Tax Amount · Grand Total · HSN · Vendor SKU · Description · Barcode (EAN-13) · MRP · Cost Price · UOM · Qty · Tax Type · Tax% · Tax Value · Total · Basic Cost (Master) Awenest SKU Code (Master) Pack Size (Master) Item Tax (Master) Item Tax % (Master) |
No structured table — all item data crammed into one cell per row. Parsed via regex on raw text; descriptions reconstructed from surrounding lines. Zoho: Item Code matched via Primary Vendor SKU field. |
| INNOVATIVE RETAIL CONCEPTS PRIVATE LIMITED | Bigbasket | IRA-prefixed IRA36528205 |
IGST or CGST+SGST
Auto-detected from IGST%/CGST% columns |
Derived from GSTIN state code (varies per warehouse) | From PO (varies per warehouse — e.g. 27AACCI2053A1Z7 MH, 36AACCI2053A1Z8 TS) | SKU Code → SKU Master BB sheet | BB |
PO Number · PO Date · Buyer GSTIN · HSN Code · SKU Code · Description · EAN/UPC Code · Case Quantity · Quantity · Basic Cost · SGST% · CGST% · IGST% · GST% · MRP · Basic Cost (Master) Awenest SKU Code (Master) Pack Size (Master) Item Tax (Master) Item Tax % (Master) |
Input is .xlsx (AUTO-PO format), not PDF. Fixed row structure — GSTIN on row 10, PO info on row 15, items from row 16. GSTIN and Place of Supply always taken from the PO (varies per BB warehouse/state). |
| Varies per franchise (Min2Max, Vignesh Enterprise, GRS Enterprises, Rajmudra, etc.) |
FirstCry | pin-prefixed pin101260407ekz75fb |
IGST or CGST+SGST
Auto-detected: buyer state ≠ 27 (MH) → IGST, buyer state = 27 → CGST+SGST |
Derived from GSTIN state code (varies per franchise location) | From PO (varies per franchise — e.g. 33AAVFM4325P1ZN TN, 19AATFV6329E1ZL WB, 27AGRPP5403H1Z4 MH) | FCID → SKU Master FirstCry sheet | FirstCry |
PO Number (PONO) · PO Date · Buyer GSTIN · FCID · HSN Code · Style Code · Product Name · MRP · Base Cost · Tax% · Landing Rate · Billed Qty · Total Qty · Total Amount · Basic Cost (Master) Awenest SKU Code (Master) Pack Size (Master) Item Tax (Master) Item Tax % (Master) |
Customer Name taken directly from the franchise buyer entity in the PO (not a fixed name — varies per order). Supplier GSTIN (AALCR2997M) is filtered out; buyer GSTIN used for Place of Supply. |
|
Zoho SO — Fixed Mappings (all vendors) Status draft Template Name Standard Template Currency Code INR GST Treatment business_gst Exchange Rate 1 Discount Type item_level Is Discount Before Tax TRUE Entity Discount % 0 Warehouse Name Bangalore WH (Warehouse) Is Inclusive Tax FALSE Discount 0 Item Tax Type IGST → ItemAmount CGST+SGST → Tax Group Item Type goods Supply Type Taxable Order Date = Expected Shipment Date = PO Date SalesOrder Number entered by user at upload time Item Tax / Item Tax % from Item.csv (Intra/Inter State based on CGST vs IGST) |
|||||||||