Add Product EAN Code and Itam Name Across all Categories
Product Master JSON –Shared Product Summary
--------------------
"data": [
"productId": "PROD_001",
"productName": "Ray-Ban Aviator Classic",
"productCode": "RB-3025-001",
"productDescription": "Gold frame with green classic G-15 lenses",
"category": "Sunglasses",
"subCategory": "Aviator",
"brand": "Ray-Ban",
"productType": "Premium",
"variant": "Gold/Green", item type, business type, gender, size
"barcode": "8053672000000",
"hsnCode": "90041010",
"unitPrice": 8500.00,
"mrp": 12990.00,
"taxPercentage": 18.00,
"uom": "PCS",
"isActive": true
},
"productId": "PROD_002",
"productName": "Oakley Holbrook",
"productCode": "OO-9102-01",
"productDescription": "Matte black frame with grey lenses",
"category": "Sunglasses",
"subCategory": "Square",
"brand": "Oakley",
"productType": "Sports",
"variant": "Black/Grey",
"barcode": "8053672000001",
"hsnCode": "90041010",
"unitPrice": 9500.00,
"mrp": 14990.00,
"taxPercentage": 18.00,
"uom": "PCS",
"isActive": true
Payment API Partial payment method to be incorporated
------------
"data": [
"paymentId": "PAY_20251119_001",
"invoiceId": "POP_01/952111",
"customer": "CUST_001",
"customerName": "John Doe"
"paymentDate": "2025-11-19",
"paymentAmount": 11800.00,
"paymentMode": "UPI",
"paymentStatus": "Success",
"transactionId": "TXN20251119123456",
"paymentGateway": "PhonePe"
},
"paymentId": "PAY_20251119_002",
"invoice": "POP_01/952112",
"customer": "CUST_002",
"customerName": "Sara"
"paymentDate": "2025-11-19",
"paymentAmount": 17700.00,
"paymentMode": "Card",
"paymentStatus": "Success",
"transactionId": "TXN20251119123457",
"paymentGateway": "HDFC POS"
"data": [
"customerId": "CUST_001",
"customerName": "Rajesh Kumar",
"phoneNumber": "9876543210",
"alternatePhoneNumber": "9876543211",
"email": "[Link]@[Link]",
"alternateEmail": "[Link]@[Link]",
"dateOfBirth": "1985-03-15",
"anniversaryDate": "2010-12-25",
"gender": "Male",
"address": "No. 45, MG Road, Anna Nagar",
"state": "Tamil Nadu",
"district": "Chennai",
"pincode": "600040",
"country": "India",
"customerSource": "Walk-in",
"customerStatus": "Active",
"membershipTier": "Gold",
"lastTierUpdateDate": "2025-06-15",
"lastRedeemedDate": "2025-11-10",
"lastPurchaseDate": "2025-11-19",
"preferredCategory": ["Sunglasses", "Contact Lenses", "Reading Glasses"],
"sellerwareCustomerCode": "SW_CUST_001",
"loyaltyPoints": 1250.00
},
"customerId": "CUST_002",
"customerName": "Priya Sharma",
"phoneNumber": "9876543220",
"alternatePhoneNumber": null,
"email": "[Link]@[Link]",
"alternateEmail": null,
"dateOfBirth": "1990-07-22",
"anniversaryDate": "2015-02-14",
"gender": "Female",
"address": "Flat 302, Green Park Apartments, T Nagar",
"state": "Tamil Nadu",
"district": "Chennai",
"pincode": "600017",
"country": "India",
"customerSource": "Online",
"customerStatus": "Active",
"membershipTier": "Silver",
"lastTierUpdateDate": "2025-08-20",
"lastRedeemedDate": "2025-11-19",
"lastPurchaseDate": "2025-11-19",
"preferredCategory": ["Designer Frames", "Sunglasses"],
"budgetRange": "5000-10000",
"sellerwareCustomerCode": "SW_CUST_002",
"loyaltyPoints": 450.00
Invoice JSON
--------------
"Records": [
"INVOICEID": "INV_20251119_001",
"CUSTOMERId": "CUST_001",
"STORE": "STORE_001",
"GST_NUMBER": "29ABCDE1234F1Z5",
"ORDER_DATE": "20251119",
"ORDER_ID": "ORD_2025_001",
"BILL_TYPE": "B2C",
"BILL_NUM": "POP_01/952111",
"INVOICE_BASIC_VALUE": 10000.00,
"TAX_AMOUNT": 1800.00,
"INVOICE_NET_AMOUNT": 11800.00,
"SALES_PERSON": "Ramesh Kumar",
"STATUS": "Completed",
"ItemDetail": [
"PRODUCTID": "PROD_001",
"INVOICEITEMID": "INVLTM_ID_20251119",
"INVOICEID": "INV_20251119_001",
"HSN_CODE": "90041010",
"QUANTITY": 1.0000,
"DESCRIPTION": "Ray-Ban Aviator Classic - Gold/Green",
"UNIT_AMOUNT": 8500.0000,
"SGST": 765.0000,
"CGST": 765.0000,
"ORDER_AMOUNT": 10030.0000,
"PROMOTION_AMOUNT": 0.0000,
"LOYALTY_AMOUNT": 0.0000,
"DISCOUNT": 0.0000,
"UOM": "PCS"
},
"PRODUCT": "PROD_003",
"INVOICEITEMID": "INVLTM_ID_20251119",
"INVOICE": "INV_20251119_001",
"HSN_CODE": "34029090",
"QUANTITY": 2.0000,
"DESCRIPTION": "Lens Cleaning Solution 100ml",
"UNIT_AMOUNT": 250.0000,
"SGST": 45.0000,
"CGST": 45.0000,
"ORDER_AMOUNT": 590.0000,
"PROMOTION_AMOUNT": 50.0000,
"LOYALTY_AMOUNT": 0.0000,
"DISCOUNT": 0.0000,
"UOM": "PCS"
},
"PRODUCT": "PROD_004",
"INVOICEITEMID": "INVLTM_ID_20251119",
"INVOICE": "INV_20251119_001",
"HSN_CODE": "42023100",
"QUANTITY": 1.0000,
"DESCRIPTION": "Premium Leather Eyeglass Case",
"UNIT_AMOUNT": 1200.0000,
"SGST": 90.0000,
"CGST": 90.0000,
"ORDER_AMOUNT": 1180.0000,
"PROMOTION_AMOUNT": 0.0000,
"LOYALTY_AMOUNT": 100.0000,
"DISCOUNT": 100.0000,
"UOM": "PCS"
}
]
Return JSON Unique Order ID/Number Required
------------
"Records": [
"CUSTOMER": "CUST_025",
"STORE": "STORE_001",
"GST_NUMBER": "29ABCDE1234F1Z5",
"ORDER_DATE": "20251119",
"BILL_TYPE": "Return",
"BILL_NUM": "POP_01/RET_001",
"RETURN_BASIC_VALUE": 8500.00,
"TAX_AMOUNT": 1530.00,
"RETURN_NET_AMOUNT": 10030.00,
"STATUS": "Completed",
"ItemDetail": [
"PRODUCT": "PROD_001",
"INVOICE": "INV_20251115_045",
"HSN_CODE": "90041010",
"QUANTITY": 1.0000,
"DESCRIPTION": "Ray-Ban Aviator Classic - Gold/Green",
"UNIT_AMOUNT": 8500.0000,
"SGST": 765.0000,
"CGST": 765.0000,
"ORDER_AMOUNT": 10030.0000,
"UOM": "PCS",
"ORDER": "ORD_2025_045",
"REASON_FOR_RETURN": "Scratched lens - manufacturing defect"
},
"PRODUCT": "PROD_003",
"INVOICE": "INV_20251115_045",
"HSN_CODE": "34029090",
"QUANTITY": 1.0000,
"DESCRIPTION": "Lens Cleaning Solution 100ml",
"UNIT_AMOUNT": 250.0000,
"SGST": 22.5000,
"CGST": 22.5000,
"ORDER_AMOUNT": 295.0000,
"UOM": "PCS",
"ORDER": "ORD_2025_045",
"REASON_FOR_RETURN": "Customer changed mind"
},
"CUSTOMER": "CUST_030",
"STORE": "STORE_001",
"GST_NUMBER": "29ABCDE1234F1Z5",
"ORDER_DATE": "20251119",
"BILL_TYPE": "Return",
"BILL_NUM": "POP_01/RET_002",
"RETURN_BASIC_VALUE": 5000.00,
"TAX_AMOUNT": 900.00,
"RETURN_NET_AMOUNT": 5900.00,
"STATUS": "Pending",
"ItemDetail": [
"PRODUCT": "PROD_005",
"INVOICE": "INV_20251116_082",
"HSN_CODE": "90041010",
"QUANTITY": 1.0000,
"DESCRIPTION": "Oakley Frogskins - Matte Black",
"UNIT_AMOUNT": 5000.0000,
"SGST": 450.0000,
"CGST": 450.0000,
"ORDER_AMOUNT": 5900.0000,
"UOM": "PCS",
"ORDER": "ORD_2025_082",
"REASON_FOR_RETURN": "Doesn't suit face shape"
},
"CUSTOMER": "CUST_012",
"STORE": "STORE_002",
"GST_NUMBER": "29ABCDE1234F1Z5",
"ORDER_DATE": "20251118",
"BILL_TYPE": "Return",
"BILL_NUM": "POP_02/RET_015",
"RETURN_BASIC_VALUE": 12000.00,
"TAX_AMOUNT": 2160.00,
"RETURN_NET_AMOUNT": 14160.00,
"STATUS": "Completed",
"ItemDetail": [
"PRODUCT": "PROD_008",
"INVOICE": "INV_20251110_120",
"HSN_CODE": "90041010",
"QUANTITY": 2.0000,
"DESCRIPTION": "Progressive Lens Glasses",
"UNIT_AMOUNT": 6000.0000,
"SGST": 1080.0000,
"CGST": 1080.0000,
"ORDER_AMOUNT": 14160.0000,
"UOM": "PCS",
"ORDER": "ORD_2025_120",
"REASON_FOR_RETURN": "Wrong prescription"
},
"CUSTOMER": "CUST_045",
"STORE": "STORE_003",
"GST_NUMBER": "29ABCDE1234F1Z5",
"ORDER_DATE": "20251117",
"BILL_TYPE": "Return",
"BILL_NUM": "POP_03/RET_008",
"RETURN_BASIC_VALUE": 3500.00,
"TAX_AMOUNT": 630.00,
"RETURN_NET_AMOUNT": 4130.00,
"STATUS": "Completed",
"ItemDetail": [
"PRODUCT": "PROD_020",
"INVOICE": "INV_20251105_210",
"HSN_CODE": "90041010",
"QUANTITY": 1.0000,
"DESCRIPTION": "Kids Eyewear - Blue Frame",
"UNIT_AMOUNT": 2000.0000,
"SGST": 180.0000,
"CGST": 180.0000,
"ORDER_AMOUNT": 2360.0000,
"UOM": "PCS",
"ORDER": "ORD_2025_210",
"REASON_FOR_RETURN": "Size too small"
},
"PRODUCT": "PROD_004",
"INVOICE": "INV_20251105_210",
"HSN_CODE": "42023100",
"QUANTITY": 1.0000,
"DESCRIPTION": "Premium Leather Eyeglass Case",
"UNIT_AMOUNT": 1500.0000,
"SGST": 135.0000,
"CGST": 135.0000,
"ORDER_AMOUNT": 1770.0000,
"UOM": "PCS",
"ORDER": "ORD_2025_210",
"REASON_FOR_RETURN": "Damaged during shipping"
],
"total": 4,
"per_page": 10,
"current_page": 1,
"last_page": 1,
"next_page_url": null,
"prev_page_url": null,
"from": 1,
"to": 4,
"StatusId": 200,
"StatusMessage": "success"
Stock JSON SKU, STYLE, BARCODE/EAN, SIZE, COLOUR, MRP
-----------
"Records": [
"STOCK_ID": "STK_001",
"PRODUCTID": "PROD_001",
"STOREID": "STORE_001",
"UNIQUE_KEY": "RB-3025-001_POP_01",
"AVAILABLE_QUANTITY": 25.0000,
"LAST_STOCK_UPDATE_DATE": "20251119",
"UOM": "PCS",
"BASE_PRICE": 8500.00
},
"STOCK_ID": "STK_002",
"PRODUCT": "PROD_001",
"STORE": "STORE_002",
"UNIQUE_KEY": "RB-3025-001_POP_02",
"AVAILABLE_QUANTITY": 15.0000,
"LAST_STOCK_UPDATE_DATE": "20251119",
"UOM": "PCS",
"BASE_PRICE": 8500.00
Loyalty Points JSON
---------------------
"Records": [
"TRANSACTION_ID": "LYL_20251119_001",
"CUSTOMER_ID": "CUST_001",
"DATE": "20251119",
"BILL_VALUE": 11800.00,
"POINTS_EARNED": 118.00,
"POINTS_REDEEMED": 0.00,
"NET_POINTS": 118.00,
"TYPE": "Redeemed",
},
"TRANSACTION_ID": "LYL_20251119_002",
"CUSTOMER_ID": "CUST_002",
"PURCHASE_DATE": "20251119",
"BILL_VALUE": 17700.00,
"POINTS_EARNED": 0.00,
"POINTS_REDEEMED": 100.00,
"NET_POINTS": -100.00,
"SLAB_RECALCULATED": "No",
"TYPE": "Redeemed",