═══════════════════════════════════════════════════════════════════ Vendor Management — Manual Test Data Pack For copy/paste during testing. Realistic, varied, India-shaped data. ═══════════════════════════════════════════════════════════════════ Login: Hub → Harish (PIN 0000) or Pramod (PIN 0000) → Vendor tile Open this file via: cat /var/www/360lm/cic-prompts/vendors_test_data_samples.txt ═══════════════════════════════════════════════════════════════════ PART 1 — 10 SAMPLE VENDORS TO ADD ═══════════════════════════════════════════════════════════════════ Covers every category, edge cases (long names, single-word, special chars), every field combination, both filled-out and minimal entries. ──────────────────────────────────────────────────────────── Sample #1 — Standard catering vendor (fully filled) ──────────────────────────────────────────────────────────── Name : Spice Garden Caterers Type : Vendor Proprietor : Rajesh Kumar UPI receipt name : RAJESH KUMAR Phone : 9876510001 Email : contact@spicegarden.in GST No. : 29ABCDE1234F1Z5 PAN : ABCDE1234F Contact Person : Rajesh Address : 12, Linking Road, Bandra West, Mumbai 400050 Aliases : Spice Garden, SG Caterers, Rajesh Garden ──────────────────────────────────────────────────────────── Sample #2 — Print vendor (proprietorship with brand name) ──────────────────────────────────────────────────────────── Name : Sunrise Printers Type : Vendor Proprietor : Sunita Devi UPI receipt name : SUNRISE PRINTERS PVT Phone : 9810023456 Email : hello@sunriseprint.co.in GST No. : 07AAACS9999B1Z2 PAN : AAACS9999B Contact Person : Vikash (manager) Address : Plot 47, Okhla Industrial Area Phase II, New Delhi 110020 Aliases : Sunrise, Sunrise Print, SR Printers ──────────────────────────────────────────────────────────── Sample #3 — Logistics vendor (multi-state, fleet) ──────────────────────────────────────────────────────────── Name : Delhi-Mumbai Cargo Movers Type : Vendor Proprietor : Mohan Singh UPI receipt name : DMCM TRANSPORT Phone : 9999123456 Email : ops@dmcargo.in GST No. : 27AABCD1234E5F6 PAN : AABCD1234E Contact Person : Mohan Address : Truck Plaza, Sanjay Gandhi Transport Nagar, Delhi 110042 Aliases : DM Cargo, Delhi Mumbai Movers, DMCM ──────────────────────────────────────────────────────────── Sample #4 — Small vendor (minimal info; tests optional fields) ──────────────────────────────────────────────────────────── Name : Ramesh Tea Stall Type : Vendor Phone : 9123456789 (leave all other fields blank) Aliases : Ramesh, Tea Stall, Chai Wala ──────────────────────────────────────────────────────────── Sample #5 — Stalls / decoration vendor (event supplier) ──────────────────────────────────────────────────────────── Name : Mehta Decorators & Stalls Type : Vendor Proprietor : Amar Mehta UPI receipt name : AMAR MEHTA Phone : 9892334455 Email : amar@mehtadecor.com GST No. : 24BBCCD5678E1Z7 PAN : BBCCD5678E Contact Person : Amar Address : Shop 8, Subhash Marg, Ahmedabad 380015 Aliases : Mehta Decor, MD Stalls ──────────────────────────────────────────────────────────── Sample #6 — Manpower / labour contractor ──────────────────────────────────────────────────────────── Name : Reliable Workforce Solutions Type : Vendor Proprietor : Suresh Yadav UPI receipt name : SURESH YADAV Phone : 9818776655 GST No. : 09CCDDE9876F1Z3 Contact Person : Suresh / Pinky (HR) Address : Sector 18, Noida 201301 Aliases : Reliable, RWS, Suresh Workforce ──────────────────────────────────────────────────────────── Sample #7 — Outdoor / hoarding vendor ──────────────────────────────────────────────────────────── Name : Sky-High Outdoor Media Type : Vendor Proprietor : Karan Malhotra Phone : 9876543299 Email : bookings@skyhigh.in GST No. : 06DDEEF1234G1Z9 PAN : DDEEF1234G Aliases : Sky-High, SHOM ──────────────────────────────────────────────────────────── Sample #8 — Family / personal payee (type = Family) ──────────────────────────────────────────────────────────── Name : Kalpana Lal (Harish's wife) Type : Family Phone : 9911223344 Address : Pune Aliases : Kalpana, Wife, Kal ──────────────────────────────────────────────────────────── Sample #9 — Internal entity (other category) ──────────────────────────────────────────────────────────── Name : Imprest Cash – Field Ops Type : Other Contact Person : Shambhu (custodian) Aliases : Field Imprest, FO Cash ──────────────────────────────────────────────────────────── Sample #10 — Long name + special chars (UI stress test) ──────────────────────────────────────────────────────────── Name : M/s. Shri Krishna Enterprises (Prop. K. Krishnamurthy) — Branch I Type : Vendor Proprietor : K. Krishnamurthy UPI receipt name : SHRI KRISHNA ENT Phone : 7890123456 Email : admin@shrikrishna.co.in GST No. : 33EEFFG1111H1Z4 PAN : EEFFG1111H Contact Person : K.K. / Murali Address : No. 24/3, Anna Salai, T. Nagar, Chennai 600017 Aliases : Shri Krishna, SKE, KK Enterprises, KrishnaMurthy ═══════════════════════════════════════════════════════════════════ PART 2 — RATE CARD SAMPLES ═══════════════════════════════════════════════════════════════════ Multiple rate cards per vendor — tests current/expired/future validity badges + tiered pricing (multiple active cards same product). ──────────────────────────────────────────────────────────── Rate Card #11 — CURRENT (active) ──────────────────────────────────────────────────────────── Vendor : Mehta Decorators & Stalls Product : Octonum Stall (search "octonum" in modal) Agreed price : 1400 Unit : nos Valid from : 2026-01-01 Valid to : 2026-12-31 Contract Ref : Contract-2026-Q1 Notes : Tier-1 negotiated rate; freight included up to 5km ──────────────────────────────────────────────────────────── Rate Card #12 — EXPIRED (last year, kept for history) ──────────────────────────────────────────────────────────── Vendor : Mehta Decorators & Stalls Product : Octonum Stall Agreed price : 1200 Unit : nos Valid from : 2025-01-01 Valid to : 2025-12-31 Contract Ref : Contract-2025-Annual Notes : Historical rate (FY 2025-26) ──────────────────────────────────────────────────────────── Rate Card #13 — FUTURE (kicks in next year) ──────────────────────────────────────────────────────────── Vendor : Mehta Decorators & Stalls Product : Octonum Stall Agreed price : 1500 Unit : nos Valid from : 2027-01-01 Valid to : (leave empty for open-ended) Contract Ref : Contract-2027-Renewal Notes : Renewal rate; tier-1 retained for 3+ orders/month ──────────────────────────────────────────────────────────── Rate Card #14 — TIER-2 pricing (same product, lower price, bulk) ──────────────────────────────────────────────────────────── Vendor : Mehta Decorators & Stalls Product : Octonum Stall Agreed price : 1250 Unit : nos Valid from : 2026-06-01 Contract Ref : Contract-2026-Bulk Notes : Tier-2 / bulk (≥10 units per order) ──────────────────────────────────────────────────────────── Rate Card #15 — Print vendor card (different product) ──────────────────────────────────────────────────────────── Vendor : Sunrise Printers Product : Standee (search "standee") Agreed price : 450 Unit : nos Valid from : 2026-04-01 Valid to : 2027-03-31 Contract Ref : PO-SR-2026 Notes : 6x2 ft, 6 colour, including delivery in Delhi-NCR ──────────────────────────────────────────────────────────── Rate Card #16 — Catering bulk rate ──────────────────────────────────────────────────────────── Vendor : Spice Garden Caterers Product : Lunch Pack — Veg (or any food item from catalog) Agreed price : 180 Unit : pack Valid from : 2026-01-01 Contract Ref : AMC-Catering-2026 ═══════════════════════════════════════════════════════════════════ PART 3 — LINE-ITEM SAMPLES (for Custodian Transfers) ═══════════════════════════════════════════════════════════════════ Use these in Custodian PWA → Transfer → Party + recipient → fill amount → add line items. The "supplies" + "prices" tabs in Vendor PWA will reflect them. ──────────────────────────────────────────────────────────── Transfer set #17 — Single product, multiple qty (exact-match test) ──────────────────────────────────────────────────────────── Recipient : Mehta Decorators & Stalls Amount : ₹7,000 Mode : UPI · Ref TESTREF-017 Lines : Line 1: search "octonum", pick Octonum Stall Qty 5 · Unit nos · Unit ₹ 1400 · Total ₹ 7,000 Expected : Sum matches ✓. Vendor's Prices tab shows ₹1400 actual vs ₹1400 active rate card → 0% delta (match badge). ──────────────────────────────────────────────────────────── Transfer set #18 — Two products, sum matches ──────────────────────────────────────────────────────────── Recipient : Mehta Decorators & Stalls Amount : ₹4,200 Mode : Cash Lines : Line 1: Octonum Stall · Qty 2 · ₹ 1400 · Total ₹ 2,800 Line 2: Stall Chair & Tables · Qty 1 · ₹ 1400 · Total ₹ 1,400 Expected : Sum = ₹4200 ✓ ──────────────────────────────────────────────────────────── Transfer set #19 — Sum mismatch (warning, not blocked) ──────────────────────────────────────────────────────────── Recipient : Sunrise Printers Amount : ₹5,000 Mode : NEFT · Ref TESTREF-019 Lines : Line 1: Standee · Qty 10 · ₹ 450 · Total ₹ 4,500 Expected : "diff ₹500 (amount higher)" warning in red. Submit still succeeds — Phase 3b is warning-only. ──────────────────────────────────────────────────────────── Transfer set #20 — Price OVER rate card (red delta) ──────────────────────────────────────────────────────────── Recipient : Mehta Decorators & Stalls Amount : ₹1,600 Mode : UPI · Ref TESTREF-020 Lines : Line 1: Octonum Stall · Qty 1 · ₹ 1600 · Total ₹ 1,600 Expected : After save, Vendor PWA → Prices tab → Octonum row shows red delta "vs rate card ₹1400 → +₹200 (+14.29%)" ──────────────────────────────────────────────────────────── Transfer set #21 — Price UNDER rate card (green delta) ──────────────────────────────────────────────────────────── Recipient : Mehta Decorators & Stalls Amount : ₹1,250 Mode : Cash Lines : Line 1: Octonum Stall · Qty 1 · ₹ 1250 · Total ₹ 1,250 Expected : Prices tab now shows "Latest = ₹1250" (overrides ₹1600 from #20 because it's newer). Delta = -₹150 (-10.71%) in green. ──────────────────────────────────────────────────────────── Transfer set #22 — Inline quick-add new catalog item ──────────────────────────────────────────────────────────── Recipient : Sunrise Printers Amount : ₹2,500 Lines : In product field, type: "Backlit Glow Sign" No matches in catalog. Dropdown shows: "+ Add 'Backlit Glow Sign' to catalog" link. Tap it. New catalog item created with category Misc, unit nos. Set qty 1 · ₹ 2500 · Total ₹ 2500. Expected : Catalog item created in sales.catalog AND auto-linked to Sunrise Printers. Visible later in Sales PWA catalog and the vendor's Catalog tab. ──────────────────────────────────────────────────────────── Transfer set #23 — No line items (backward compatibility) ──────────────────────────────────────────────────────────── Recipient : Delhi-Mumbai Cargo Movers Amount : ₹3,500 Mode : IMPS · Ref TESTREF-023 Lines : (none) Expected : Submit works. Vendor's Account Ledger shows the transfer. Supplies tab still empty for this vendor (lines tab only). ──────────────────────────────────────────────────────────── Transfer set #24 — Free-text description without catalog link ──────────────────────────────────────────────────────────── Recipient : Ramesh Tea Stall Amount : ₹500 Mode : Cash Lines : Line 1: In product field, type "Tea (40 cups @ ₹10)" WITHOUT picking from dropdown. Leave qty/price blank. Just set Total ₹ 400. Line 2: Same as above: "Biscuits (1 dozen)" with Total ₹ 100. Expected : Both lines saved with description only. catalog_id is NULL. Supplies tab shows them but they don't appear in Prices tab (no unit_price recorded). ═══════════════════════════════════════════════════════════════════ PART 4 — SEARCH STRESS-TEST QUERIES ═══════════════════════════════════════════════════════════════════ Run each in the LIST search box AFTER Part 1 vendors are added. Expected number of matches noted. Query Expected matches ───────────────── ──────────────── spice 1 (Spice Garden Caterers) rajesh 1 (proprietor match) 9876510001 1 (phone match) 29ABCDE1234F1Z5 1 (GST exact) 29ABCDE 1 (GST partial) ABCDE1234F 1 (PAN exact) ABCDE ≥1 (PAN partial; may match GST too) SG Caterers 1 (alias match) contact@spicegarden 1 (email match) sunrise 1 printer 1+ (Sunrise Printers and any others) ok 0 (specifically tests no-match) bandra 1 (address partial) delhi ≥1 9876 ≥2 (multiple phones start 9876) mehta 1 reliable 1 workforce 1 RWS 1 (alias) sky-high 1 outdoor 1+ family 0+ (Kalpana Lal is type=family but won't match name "family") kal ≥1 (Kalpana + alias "Kal") Krishna 1 KK ≥1 (alias) long search query that wont match → 0 ═══════════════════════════════════════════════════════════════════ PART 5 — TYPE FILTER CHIP MATRIX ═══════════════════════════════════════════════════════════════════ After Part 1 vendors are added, tap each type chip: All → count = N (where N includes all existing seed payees too) Vendors → count includes 8 of the new ones + any existing vendors (Sample 1, 2, 3, 4, 5, 6, 7, 10 = 8 vendors) Family → count includes Sample 8 (Kalpana Lal) + any existing Employees → existing seed employees only (Mukesh, Sachin, etc.) Other → count includes Sample 9 + any existing (typically rare) ═══════════════════════════════════════════════════════════════════ PART 6 — CLEAN-UP (moved to a separate file) ═══════════════════════════════════════════════════════════════════ After manual testing, run the cleanup script to wipe the test data and restore wallets / catalog to their pre-test state: cat /var/www/360lm/cic-prompts/vendors_test_data_cleanup.txt That file has: • A transactional safe-wipe (rolls back on error) • Wallet refund step • Soft-delete (reversible) • Verification queries • Optional hard-purge instructions • Optional catalog-inline-add cleanup Keep this test-data file untouched — it's pure input. Cleanup logic lives in the companion file so the two don't get accidentally merged. ═══════════════════════════════════════════════════════════════════ END OF TEST DATA PACK ═══════════════════════════════════════════════════════════════════