Return to forum

ghmanhit · May 21, 2022 at 7:45 PM

lovelocal.in | LoveLocal: INDIA DATABASE

description Currently, LoveLocal delivers to over 35 cities and over 1300 zip codes in India. Over 100,000 local retailers have registered on the platform. More than 1,000,000 local buyers ...

Domain: lovelocal.in
Country: India
Date breached: 2021 & 2022

Headers :

{"lovelocal_order":{"aliases":{},"mappings":{"properties":{"at_risk":{"type":"boolean"},"changed_by":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"comment":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"coupon":{"properties":{"bill_amount":{"type":"float"},"campaign":{"properties":{"discount":{"type":"float"},"funded_by":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"id":{"type":"long"},"max_discount":{"type":"float"},"min_spend_amount":{"type":"float"},"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"payment_mode":{"properties":{"code":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"code":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"discount_amount":{"type":"float"},"from_admin":{"type":"boolean"},"is_public":{"type":"boolean"},"valid_from":{"type":"date"},"valid_till":{"type":"date"}}},"created_at":{"type":"date"},"customer":{"properties":{"contact":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"email":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"first_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"last_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"delivery_address":{"properties":{"buildingName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"flatNumber":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"googleAddress":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"label":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"landmark":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"localityName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"location":{"properties":{"lat":{"type":"float"},"latitude":{"type":"float"},"lng":{"type":"float"},"longitude":{"type":"float"}}},"pinCode":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"status":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"streetName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"uid":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"delivery_status":{"properties":{"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"description":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"fulfillment_status":{"properties":{"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"id":{"type":"long"},"is_delivered_by_partner":{"type":"boolean"},"is_first_order":{"type":"boolean"},"modified_at":{"type":"date"},"order_manager":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"payment":{"properties":{"amount_paid":{"type":"float"},"amount_payable":{"type":"float"},"amount_refunded":{"type":"float"},"bill_total":{"type":"float"},"delivery_charge":{"type":"float"},"delivery_radius_penalty":{"type":"float"},"discount":{"type":"float"},"id":{"type":"long"},"minimum_order_value_penalty":{"type":"float"},"mode":{"properties":{"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"refund_amount_in_process":{"type":"float"},"special_offer_amount":{"type":"float"},"status":{"properties":{"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}}}},"pickup_from_store":{"type":"boolean"},"products":{"properties":{"barcode":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"brand":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"category":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"cost_price":{"type":"float"},"description":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"fulfilable":{"type":"long"},"image_url":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"is_fulfillable":{"type":"boolean"},"is_prescription_required":{"type":"boolean"},"is_retailer_product":{"type":"long"},"kind":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"measurement_unit":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"measurement_value":{"type":"float"},"mrp":{"type":"float"},"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"price_adjustment":{"type":"float"},"product_tag":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"quantity":{"type":"long"},"retailer_product_id":{"type":"long"},"selling_price":{"type":"float"},"sku_code":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"status":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"uom":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"whole_sale_min_quantity":{"type":"long"},"whole_sale_price":{"type":"float"}}},"retailer":{"properties":{"contact":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"email":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"first_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"id":{"type":"long"},"is_known_retailer":{"type":"boolean"},"last_name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"sla_tag_breached":{"type":"boolean"},"source":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"status":{"properties":{"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}}}},"store":{"properties":{"alternate_contact":{"type":"long"},"contact":{"type":"long"},"email":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"logo":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"web_url_suffix":{"type":"text","fields":{"keyword":{"type":"keyword","ignore_above":256}}},"whatsapp_contact":{"type":"long"}}}}},"settings":{"index":{"routing":{"allocation":{"include":{"_tier_preference":"data_content"}}},"number_of_shards":"1","provided_name":"lovelocal_order","creation_date":"1650613925126","number_of_replicas":"1","uuid":"QfYcNyKlQbuV8UOgT91ihg","version":{"created":"7170399"}}}}}

Sample:

"index": {"_type": "_doc", "_id": "10005736"}}
{"id":10005736,"created_at":"2021-09-08T13:26:49.936113","modified_at":"2021-09-09T02:35:55.065682","store":{"id":"236683","web_url_suffix":"gwalior_grofers","name":"S S Mega Mart","type":null,"email":"","logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Grocery-Shop+(1).png","store_type":null,"contact":9200000354,"alternate_contact":9200007775,"whatsapp_contact":9200000354},"retailer":{"id":77113,"first_name":"yogesh","last_name":"singh","email":"","contact":"9200000354","is_known_retailer":true},"customer":{"id":"60cc60bd93094a0c9aab67a4d4c4698c","first_name":"Amar","last_name":"Bais","email":null,"contact":"7000636089"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"delivery_address":{"flatNumber":"Na ","status":"ACTIVE","googleAddress":"234, Narayan Vihar, Gwalior, Madhya Pradesh 474002, India","uid":"181151","pinCode":"474010","label":"Home","location":{"lat":26.25648116849853,"lng":78.2001898996532},"localityName":"gwalior","landmark":"","streetName":"p. H. E. colony","buildingName":"motijheel"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":false,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":794496,"created_at":null,"modified_at":null,"bill_total":"1308.0000","discount":"0.0000","amount_payable":"1308.0000","amount_paid":1308.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":42757774,"name":"Everest Chole Masala","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"GMs","mrp":"63.00","selling_price":"41.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/1355091_0822202112532127813821308RFKVLB3.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":9098203,"name":"Mix Dal","kind":null,"description":"","category":null,"barcode":"108","manufacturer":null,"brand":null,"uom":null,"mrp":"134.00","selling_price":"121.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"236683_101220200156883777","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmp_mEbbp.jpg","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"KGs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":9098462,"name":"Moong Dal","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"130.00","selling_price":"117.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"236683_101220200157810027","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmp6mIiTV.jpeg","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"KGs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":9096547,"name":"Sunrich Refined Sunflower Oil","kind":null,"description":"","category":null,"barcode":"8906032010616","manufacturer":null,"brand":"Sunrich","uom":null,"mrp":"1100.00","selling_price":"1045.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"236683_101220200151090150","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/177205_082120200834509278981763RF0RXND.jpg","is_retailer_product":0,"measurement_value":5.0,"measurement_unit":"L","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006038"}}
{"id":10006038,"created_at":"2021-10-13T11:52:50.991749","modified_at":"2021-10-15T07:35:14.440031","store":{"id":"428028","web_url_suffix":"pragati-super-mart-locality-not-set","name":"Pragati Super Mart","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Grocery-Shop+(1).png","store_type":null,"contact":9920810493,"alternate_contact":9920810493,"whatsapp_contact":null},"retailer":{"id":30409,"first_name":"Jinesh","last_name":"Gala","email":"","contact":"9920810493","is_known_retailer":true},"customer":{"id":"bdd653457c46417393b076ea2330aac9","first_name":"J","last_name":"Shah","email":null,"contact":"9819704670"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":1004919,"created_at":null,"modified_at":null,"bill_total":"622.0000","discount":"0.0000","amount_payable":"622.0000","amount_paid":622.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":47437123,"name":"Sugar (Small)","kind":"428028","description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"KGs","mrp":"42.00","selling_price":"22.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/1538120_0910202113282492474123370RF7Y0SA.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":true,"is_fulfillable":true},{"quantity":4,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":13519792,"name":"Silver Coin Aata","kind":null,"description":"","category":"All Products","barcode":"8906009820040","manufacturer":null,"brand":null,"uom":null,"mrp":"220.00","selling_price":"150.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"409d4369-f07f-4c49-bcaa-4667f42eb303","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006079"}}
{"id":10006079,"created_at":"2021-09-15T12:12:43.943459","modified_at":"2021-09-15T12:13:17.499526","store":{"id":"769223","web_url_suffix":"vishal_rice_769223","name":"Vishal Rice","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/store-groceries.png","store_type":null,"contact":7065854514,"alternate_contact":null,"whatsapp_contact":9675907231},"retailer":{"id":110314,"first_name":"","last_name":"","email":"","contact":"7065854514","is_known_retailer":false},"customer":{"id":"ad3f5b0efa4441f38b319868f60b8608","first_name":"Raghaw","last_name":"Raj","email":null,"contact":"8750854473"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":837478,"created_at":null,"modified_at":null,"bill_total":"900.0000","discount":"0.0000","amount_payable":"900.0000","amount_paid":900.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43380067,"name":"Dhampure White Crystal Sugar","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"KGs","mrp":"65.00","selling_price":"45.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/1622934_0909202100150728954123370RF9N8X4.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":41840061,"name":"Kettle Studio Potato Chips Mature Cheddar & Red Onions","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"99.00","selling_price":"94.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"769223_310820211825345675","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.ap-south-1.amazonaws.com/868381_1130202003491811819929448RF3N06G.jpg","is_retailer_product":0,"measurement_value":125.0,"measurement_unit":"GMs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":41840063,"name":"Dhara Filter Groundnut Oil","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"240.00","selling_price":"228.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"769223_310820211825516358","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/606240_0815202112185675083211789RFGXUV8.jpg","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"L","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":41840067,"name":"Dynamix Cow's Ghee","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"286.00","selling_price":"257.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"769223_310820211825847704","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/606246_0815202122421769200731286RFDB0GE.jpg","is_retailer_product":0,"measurement_value":500.0,"measurement_unit":"ML","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":41840077,"name":"Everest White Pepper Powder","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"95.00","selling_price":"86.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"769223_310820211826659090","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/606256_0815202122422620646331470RF2YRUB.jpg","is_retailer_product":0,"measurement_value":50.0,"measurement_unit":"GMs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":41877826,"name":"Sugar (1kg) + Lipton Honey & Lemon Green Tea (100g)","kind":null,"description":"Sugar (1kg) + Lipton Honey & Lemon Green Tea (100g)","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"Units","mrp":"196.00","selling_price":"190.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":1,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006231"}}
{"id":10006231,"created_at":"2021-07-06T15:48:54.794610","modified_at":"2021-07-06T16:49:53.331626","store":{"id":"28805","web_url_suffix":"pushpak_kirana","name":"Pushpak Kirana Store","type":null,"email":"[email protected]","logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Grocery-Shop+(1).png","store_type":null,"contact":9294634788,"alternate_contact":null,"whatsapp_contact":9294634788},"retailer":{"id":92910,"first_name":"","last_name":"","email":"","contact":"9294634788","is_known_retailer":true},"customer":{"id":"d87bf24524e740ad8ebd9bf19c51c312","first_name":"Divya","last_name":"","email":null,"contact":"9669744688"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"delivery_address":{"flatNumber":"bbj ","status":"ACTIVE","googleAddress":"Vidur Nagar, Indore, Madhya Pradesh, India","uid":"474207","pinCode":"452009","label":"Home","location":{"lat":22.680854579654074,"lng":75.81664552912116},"localityName":"vidhur nagar","landmark":"","streetName":"om hight","buildingName":"b344"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":false,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":507409,"created_at":null,"modified_at":null,"bill_total":"681.0000","discount":"0.0000","amount_payable":"681.0000","amount_paid":681.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":34810488,"name":"Lay's Potato Chips, Spanish Tomato Tango (90g) + Lay's American Style Cream & Onion Flavour Chips (90g)","kind":null,"description":"Lay's Potato Chips, Spanish Tomato Tango (90g) + Lay's American Style Cream & Onion Flavour Chips (90g)","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"Units","mrp":"70.00","selling_price":"33.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":1,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":3,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":30374847,"name":"Sugar (5kg) + Sugar Midium Size Good Quality (1kg)","kind":null,"description":"Sugar (5kg) + Sugar Midium Size Good Quality (1kg)","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"Units","mrp":"285.50","selling_price":"216.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":1,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006410"}}
{"id":10006410,"created_at":"2021-10-03T10:26:11.701129","modified_at":"2021-10-03T11:36:16.322140","store":{"id":"668140","web_url_suffix":"raj_kirana_store_668140","name":"Raj Kirana Store","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/store-groceries.png","store_type":null,"contact":8076527859,"alternate_contact":null,"whatsapp_contact":8076527859},"retailer":{"id":89780,"first_name":"","last_name":"","email":"","contact":"8076527859","is_known_retailer":false},"customer":{"id":"3ace5af783ba4bc7a6f5a162ea5bbb98","first_name":"jeetu","last_name":"","email":null,"contact":"8505846855"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":946062,"created_at":null,"modified_at":null,"bill_total":"661.0000","discount":"0.0000","amount_payable":"661.0000","amount_paid":661.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":31445177,"name":"Brooke Bond Red Label Natural Care Tea","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"650.00","selling_price":"618.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"668140_020620211202210540","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/11262019234314","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"KGs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":31445268,"name":"Brooke Bond Red Label Tea","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"45.00","selling_price":"43.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"668140_020620211206551513","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmpqOTzu0.jpg","is_retailer_product":0,"measurement_value":100.0,"measurement_unit":"GMs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006575"}}
{"id":10006575,"created_at":"2021-03-18T16:59:41.900625","modified_at":"2021-03-18T17:21:24.000020","store":{"id":"49756","web_url_suffix":"new_tokary_super_market","name":"New Tokary Super Market","type":null,"email":null,"logo":null,"store_type":null,"contact":6360401813,"alternate_contact":null,"whatsapp_contact":6360401813},"retailer":{"id":83828,"first_name":"","last_name":"","email":"","contact":"6360401813","is_known_retailer":false},"customer":{"id":"5c6050359ddb46cd912175e02fae4952","first_name":"Shashi ","last_name":"","email":null,"contact":"8884025138"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"delivery_address":{},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":276302,"created_at":null,"modified_at":null,"bill_total":"575.0000","discount":"0.0000","amount_payable":"575.0000","amount_paid":575.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":21749170,"name":"Amul Pure Ghee (Tin)","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"500.00","selling_price":"475.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/1242071_030120211832216472031057RF885MR.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":10943459,"name":"Amul Kesar Peda","kind":null,"description":"","category":null,"barcode":null,"manufacturer":null,"brand":null,"uom":null,"mrp":"105.00","selling_price":"100.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"49756_101220200416309614","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/868708_113020200401180417257113RFU91UH.jpg","is_retailer_product":0,"measurement_value":200.0,"measurement_unit":"GMs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006660"}}
{"id":10006660,"created_at":"2021-09-29T07:35:21.522709","modified_at":"2021-10-04T14:58:29.201099","store":{"id":"114501","web_url_suffix":"atharva_provison_and_genral_store","name":"Atharva Provision And General Store","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Grocery-Shop+(1).png","store_type":null,"contact":7317211059,"alternate_contact":null,"whatsapp_contact":7317211059},"retailer":{"id":93345,"first_name":"","last_name":"","email":"","contact":"7317211059","is_known_retailer":true},"customer":{"id":"60af410ad3914b069946444c0ea73f15","first_name":"sonal","last_name":"","email":null,"contact":"7640931148"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":true,"is_delivered_by_partner":false,"payment":{"id":921722,"created_at":null,"modified_at":null,"bill_total":"579.0000","discount":"50.0000","amount_payable":"529.0000","amount_paid":529.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"coupon":{"discount_amount":50.0,"bill_amount":579.0,"code":"RFDHG4W","valid_from":"2021-09-24T00:32:02.162149","valid_till":"2022-02-21T00:32:02.162149","from_admin":false,"is_public":true,"campaign":{"id":49,"type":"app_referer_campaign","name":"REFER AND EARN","discount":50.0,"funded_by":"mpaani","min_spend_amount":350.0,"max_discount":50.0,"payment_mode":[{"code":"CASH","name":"Cash on Delivery"},{"code":"DIGITAL","name":"Online Payment"}]}},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":37980131,"name":"Kaju","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"500.00","selling_price":"475.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/11262019232804","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":37980279,"name":"Dettol Antiseptic Liquid","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"116.00","selling_price":"104.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmpR_E58J.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006663"}}
{"id":10006663,"created_at":"2021-10-08T08:09:20.557336","modified_at":"2021-10-08T10:07:06.565844","store":{"id":"894406","web_url_suffix":"hashmukh_supar_markey","name":"Hashmukh Super Market","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/store-groceries.png","store_type":null,"contact":7057713680,"alternate_contact":null,"whatsapp_contact":7057713680},"retailer":{"id":113371,"first_name":"","last_name":"","email":"","contact":"7057713680","is_known_retailer":false},"customer":{"id":"0352b06f675b48b6b46aa8533803b169","first_name":"ramdular","last_name":"","email":null,"contact":"8550989763"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":972994,"created_at":null,"modified_at":null,"bill_total":"496.0000","discount":"50.0000","amount_payable":"446.0000","amount_paid":446.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"coupon":{"discount_amount":50.0,"bill_amount":496.0,"code":"RWDMG3VN","valid_from":"2021-10-07T09:45:15.337113","valid_till":"2021-11-06T09:45:15.337113","from_admin":false,"is_public":true,"campaign":{"id":50,"type":"app_referer_reward_campaign","name":"REFER REWARD","discount":50.0,"funded_by":"mpaani","min_spend_amount":350.0,"max_discount":50.0,"payment_mode":[{"code":"CASH","name":"Cash on Delivery"},{"code":"DIGITAL","name":"Online Payment"}]}},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43420717,"name":"Rava","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"GMs","mrp":"14.00","selling_price":"13.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/605882_0914202122241193661723370RFHAWTW.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43420853,"name":"Jaggery","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"GMs","mrp":"53.00","selling_price":"53.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/605599_0915202104414504796423370RFFK6FU.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43420897,"name":"Sugar Free Gold Sachet","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"Units","mrp":"44.00","selling_price":"44.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/605990_0914202119514390393523370RF76SK9.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43420975,"name":"Lavang (Cloves)","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"20.00","selling_price":"18.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"894406_160920211253364591","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/605674_0914202121023670797523370RFG2BRW.jpg","is_retailer_product":0,"measurement_value":10.0,"measurement_unit":"GMs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43420980,"name":"Lavang (Cloves)","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"40.00","selling_price":"36.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"894406_160920211253691567","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/605675_0915202107225475181023370RFBMTS2.jpg","is_retailer_product":0,"measurement_value":20.0,"measurement_unit":"GMs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43420991,"name":"Jawar (Sorghum) Solapur","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"79.00","selling_price":"71.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"894406_160920211254534731","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/1221530_0914202120521768323023370RF00L8N.jpg","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"KGs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":43421009,"name":"24 Mantra Organic Kabuli Chana","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"290.00","selling_price":"261.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"894406_160920211256037040","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/1221544_0914202123540298313423370RFAB899.jpg","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"KGs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006709"}}
{"id":10006709,"created_at":"2021-09-21T14:54:56.273873","modified_at":"2021-09-21T17:47:59.638303","store":{"id":"824003","web_url_suffix":"ajay_store_824003","name":"Ajay Store","type":null,"email":null,"logo":"https://lovelocal-store-front.s3.ap-south-1.amazonaws.com/grocery_shop1_1.png","store_type":null,"contact":9958576349,"alternate_contact":null,"whatsapp_contact":9958576349},"retailer":{"id":94353,"first_name":"","last_name":"","email":"","contact":"9958576349","is_known_retailer":true},"customer":{"id":"cd4f4a54f018493cae421d7441558503","first_name":"Shailendra","last_name":"","email":null,"contact":"9315594407"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":876033,"created_at":null,"modified_at":null,"bill_total":"525.0000","discount":"0.0000","amount_payable":"525.0000","amount_paid":525.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":44263186,"name":"Tata Salt Lite","kind":"824003","description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"KGs","mrp":"40.00","selling_price":"19.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/1520494_0908202123231840561623370RF4MF2H.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":true,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":36599429,"name":"Amul Cheese Slice","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"375.00","selling_price":"356.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmpBSxryv.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":36599432,"name":"Britannia Classic Cheese Cubes","kind":null,"description":"","category":null,"barcode":"8901063401082","manufacturer":null,"brand":null,"uom":null,"mrp":"150.00","selling_price":"150.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmpJSLNw0.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006796"}}
{"id":10006796,"created_at":"2019-10-24T08:18:49.263200","modified_at":"2020-03-04T11:17:21.584033","store":{"id":"923114","web_url_suffix":"fresh-n-fresh-andheri-west","name":"Fresh N Fresh (Andheri West)","type":null,"email":"","logo":null,"store_type":null,"contact":8097366488,"alternate_contact":8097366488,"whatsapp_contact":null},"retailer":{"id":70936,"first_name":"Vijay","last_name":"Kotian","email":"","contact":"8097366488","is_known_retailer":false},"customer":{"id":"e2daa7d8d19b49bf8e86e6a53d8bf733","first_name":"Ruksar","last_name":"Sayyed","email":"[email protected]","contact":"8291020386"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"delivery_address":{"flatNumber":"test","googleAddress":"Azad Nagar, Azad Nagar, Andheri West, Mumbai, Maharashtra 400047, India","uid":"201","label":"Home","location":{"lat":19.1292449502927,"lng":72.836038749665},"localityName":"test","landmark":"test","streetName":"test","buildingName":"test"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"UNAVAILABLE","comment":"","description":"","pickup_from_store":false,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":16358,"created_at":null,"modified_at":null,"bill_total":"365.0000","discount":"0.0000","amount_payable":"365.0000","amount_paid":365.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":52451,"name":"McCain French Fries (1.25 kg)","kind":null,"description":"","category":"db.Category.None","barcode":"8906000610770","manufacturer":null,"brand":null,"uom":null,"mrp":"260.00","selling_price":"260.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"91234c3a-55d1-463f-bc24-0aa9c9100fa1","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":52469,"name":"Mc Cain Masala Fries (375 g)","kind":null,"description":"","category":"db.Category.None","barcode":"8906000610725","manufacturer":null,"brand":null,"uom":null,"mrp":"105.00","selling_price":"105.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"55727723-7975-42c7-81c4-0e4504e13eb1","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10006924"}}
{"id":10006924,"created_at":"2021-02-04T14:25:07.300768","modified_at":"2021-02-05T05:26:03.040087","store":{"id":"187779","web_url_suffix":"ms_mukund_kumar_laljibhai_nayak","name":"M/S Mukund Kumar Laljibhai Nayak","type":null,"email":null,"logo":"https://apianalytics.mpaani.com/d89f010920200930-094354.jpg","store_type":null,"contact":9173114814,"alternate_contact":9173114814,"whatsapp_contact":9173114814},"retailer":{"id":83127,"first_name":"","last_name":"","email":"","contact":"9173114814","is_known_retailer":false},"customer":{"id":"9a23760c1c4a461281a78aea8ae3a6b4","first_name":null,"last_name":"","email":null,"contact":"9687076979"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"delivery_address":null,"at_risk":false,"sla_tag_breached":false,"source":"WEB","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":204070,"created_at":null,"modified_at":null,"bill_total":"260.0000","discount":"0.0000","amount_payable":"260.0000","amount_paid":260.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":17838086,"name":"Sugar","kind":null,"description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"40.00","selling_price":"10.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/785971_1119202018305338226411095RFMEMM9.png","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":14246200,"name":"Daawat Biryani Basmati Rice - 1.0KGs + Daawat Biryani Basmati Rice - 1.0KGs","kind":null,"description":"Daawat Biryani Basmati Rice - 1.0KGs + Daawat Biryani Basmati Rice - 1.0KGs","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"Units","mrp":"500.00","selling_price":"250.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/tmpymGxzc.jpeg","is_retailer_product":1,"measurement_value":0.0,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10007006"}}
{"id":10007006,"created_at":"2021-04-23T12:00:01.840454","modified_at":"2021-10-04T14:58:29.229813","store":{"id":"423746","web_url_suffix":"oven_magick","name":"Oven Magick","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Bakeries.png","store_type":null,"contact":9146097706,"alternate_contact":null,"whatsapp_contact":null},"retailer":{"id":91299,"first_name":"","last_name":"","email":"","contact":"9146097706","is_known_retailer":false},"customer":{"id":"079c7c846e7e4c0fb6a6e6ec29885c35","first_name":"Shakti singh","last_name":"","email":null,"contact":"7310099142"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"CANCELLED"},"delivery_address":{},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"OM2","changed_by":"Backend ; reason Order pending for > 7 days","comment":"CANCELLED VIA BACKEND ON REQUEST: BY Backend ; reason Order pending for > 7 days","description":"","pickup_from_store":true,"is_first_order":true,"is_delivered_by_partner":false,"payment":{"id":343511,"created_at":null,"modified_at":null,"bill_total":"700.0000","discount":"0.0000","amount_payable":"600.0000","amount_paid":0.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PENDING"},"mode":{"name":"DIGITAL"},"special_offer_amount":"-1.0000"},"coupon":{"discount_amount":100.0,"bill_amount":700.0,"code":"BIG","valid_from":"2021-03-12T04:30:00","valid_till":"2021-12-31T06:29:00","from_admin":false,"is_public":true,"campaign":{"id":166886,"type":"single","name":"Save Rs. 50 on your 1st order from your local shops.","discount":50.0,"funded_by":"mpaani","min_spend_amount":500.0,"max_discount":50.0,"payment_mode":[{"code":"CASH","name":"Cash on Delivery"},{"code":"DIGITAL","name":"Online Payment"}]}},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":24177008,"name":"Truffle Cake","kind":null,"description":"","category":"Cakes","barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"700.00","selling_price":"700.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"423746_20210416165340231047","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://5.imimg.com/data5/HJ/CF/GLADMIN-41906480/chocolate-truffle-cake-500x500.png","is_retailer_product":0,"measurement_value":1.0,"measurement_unit":"KGs","product_tag":null,"is_prescription_required":false,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10007047"}}
{"id":10007047,"created_at":"2021-10-04T10:27:43.045228","modified_at":"2021-10-12T04:00:05.257912","store":{"id":"428028","web_url_suffix":"pragati-super-mart-locality-not-set","name":"Pragati Super Mart","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Grocery-Shop+(1).png","store_type":null,"contact":9920810493,"alternate_contact":9920810493,"whatsapp_contact":null},"retailer":{"id":30409,"first_name":"Jinesh","last_name":"Gala","email":"","contact":"9920810493","is_known_retailer":true},"customer":{"id":"c0566e86fc17499f8fc2d49ff374b09d","first_name":"rita","last_name":"","email":"[email protected]","contact":"9969920672"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"CANCELLED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"Backend ; reason Order pending for > 7 days","comment":"CANCELLED VIA BACKEND ON REQUEST","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":951323,"created_at":null,"modified_at":null,"bill_total":"550.0000","discount":"0.0000","amount_payable":"550.0000","amount_paid":0.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PENDING"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":13094692,"name":"Gits Rabdi Mix 100 Gm","kind":null,"description":"","category":"Mithai","barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"70.00","selling_price":"69.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"428028_20210108210938698578","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":0,"measurement_value":null,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":13094701,"name":"Haldiram Royal Desire 1.84Kg","kind":null,"description":"","category":"Mithai","barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"485.00","selling_price":"460.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":"428028_20210108210939806762","hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"","is_retailer_product":0,"measurement_value":null,"measurement_unit":"","product_tag":null,"is_prescription_required":false,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":46264850,"name":"Cadbury Dairy Milk Chocolate","kind":"428028","description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":"GMs","mrp":"40.00","selling_price":"21.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://lovelocal-product-image.s3.amazonaws.com/1622828_0909202110124094646623370RFRXTKS.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":true,"is_fulfillable":true}]}
{"index": {"_type": "_doc", "_id": "10007163"}}
{"id":10007163,"created_at":"2021-09-03T13:05:30.670214","modified_at":"2021-09-05T11:47:23.833404","store":{"id":"428028","web_url_suffix":"pragati-super-mart-locality-not-set","name":"Pragati Super Mart","type":null,"email":null,"logo":"https://storetypeimages.s3.ap-south-1.amazonaws.com/Grocery-Shop+(1).png","store_type":null,"contact":9920810493,"alternate_contact":9920810493,"whatsapp_contact":null},"retailer":{"id":30409,"first_name":"Jinesh","last_name":"Gala","email":"","contact":"9920810493","is_known_retailer":true},"customer":{"id":"d3c5809ddc784f82ab39fffbfe4be25c","first_name":"ja","last_name":"","email":null,"contact":"7208480260"},"status":{"name":"CREATED"},"fulfillment_status":{"name":"UNADDRESSED"},"delivery_status":{"name":"DELIVERED"},"at_risk":false,"sla_tag_breached":false,"source":"APP","order_manager":"","changed_by":"RETAILER","comment":"","description":"","pickup_from_store":true,"is_first_order":false,"is_delivered_by_partner":false,"payment":{"id":764636,"created_at":null,"modified_at":null,"bill_total":"771.0000","discount":"0.0000","amount_payable":"771.0000","amount_paid":771.0,"amount_refunded":0.0,"refund_amount_in_process":0.0,"delivery_charge":"0.0000","minimum_order_value_penalty":"0.0000","delivery_radius_penalty":"0.0000","status":{"name":"PAID"},"mode":{"name":"CASH"},"special_offer_amount":"-1.0000"},"products":[{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":42150340,"name":"Cadbury Dairy Milk Chocolate","kind":"428028","description":"","category":null,"barcode":"","manufacturer":null,"brand":null,"uom":null,"mrp":"40.00","selling_price":"21.00","cost_price":"0.00","whole_sale_price":"0.00","whole_sale_min_quantity":1,"sku_code":null,"hsn_code":null,"tax_class":null,"cess_rate":null,"cgst":null,"sgst":null,"igst":null,"image_url":"https://home-delivery-product.s3.ap-south-1.amazonaws.com/1622828_0824202118130199104110830RFUEC29.jpg","is_retailer_product":0,"measurement_value":0.0,"measurement_unit":"","product_tag":"LOVELOCAL_APP_EX_PRODUCT_EXPIRED","is_prescription_required":true,"is_fulfillable":true},{"quantity":1,"status":"UNALTERED","price_adjustment":0.0,"retailer_product_id":13095291,"name":"Toor Dal Oily

Hidden Content

You must register or login to view this content.

vintincha · May 22, 2022 at 7:55 AM

This seems interesting, could you please elaborate on how many records are there in total.

hackzies · May 22, 2022 at 9:51 AM

Thanks for sharing but it's not the full db i guess, because it has only 3784 uniq emails :(

nagu143 · June 30, 2022 at 1:31 PM

i love this thank you

raidflacs · August 15, 2022 at 6:10 PM

The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.