{"status":"ok","count":20,"catalog":[{"product_id":"399067","product_name":"senhora amaira 2096-2099 series designer buttefly net party wear stone work salwar kameez online wholesaler surat ","brand_name_name":"Senhora","cname":"amaira ","product_seo_url":"senhora-amaira-2096-2099-series-designer-buttefly-net-party-wear-stone-work-salwar-kameez-online-wholesaler-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/05\/senhora-amaira-2096-2099-series-designer-buttefly-net-party-wear-stone-work-salwar-kameez-online-wholesaler-surat-2023-05-12_12_03_35.jpg","product_qty":"2","sale_price":"11816","product_price":"2954","product_mrp_price":"3004","catalog_pcs":"4","regular_price":null,"disable_date":"2023-05-17 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"Butterfly Net","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":2,"productview":"374","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th May 2023","salelable":""},{"product_id":"398589","product_name":"blue hills by festival night vol 7 1001-1008 series reyon foil printed nyra cut stich salwar kameez online best price catalogue ","brand_name_name":"Bluehills","cname":"festival night vol 7 ","product_seo_url":"blue-hills-by-festival-night-vol-7-1001-1008-series-reyon-foil-printed-nyra-cut-stich-salwar-kameez-online-best-price-catalogue","product_image":"https:\/\/prathamexports.com\/images\/product\/2023\/04\/blue-hills-by-festival-night-vol-7-1001-1008-series-reyon-foil-printed-nyra-cut-stich-salwar-kameez-online-best-price-catalogue-2023-04-14_20_27_45.jpg","product_qty":"8","sale_price":"5960","product_price":"745","product_mrp_price":"795","catalog_pcs":"8","regular_price":null,"disable_date":"2023-04-17 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"reyon ","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"257","size_name":"M | L | XL | XXL | XXXL | 4XL | 5XL | 6XL","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"14th Apr 2023","salelable":""},{"product_id":"396147","product_name":"twisha 2200 series party wear anarkali salwar kameez wholesale price surat ","brand_name_name":"Twisha","cname":"2200 series","product_seo_url":"twisha-2200-series-party-wear-anarkali-salwar-kameez-wholesale-price-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/12\/twisha-2200-series-party-wear-anarkali-salwar-kameez-wholesale-price-surat-2022-12-16_14_44_22.jpg","product_qty":"2","sale_price":"9975","product_price":"3325","product_mrp_price":"3375","catalog_pcs":"3","regular_price":null,"disable_date":"2022-12-18 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"3Kg","fabric_name123":"Velvet","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":1,"productview":"284","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"16th Dec 2022","salelable":""},{"product_id":"394065","product_name":"blue hills manika mage hithe vol-10 10001-10008 series reyon bigger size ready made anarkali salwar kameez online best price surat india ","brand_name_name":"Bluehills","cname":"manika mage hithe vol-10","product_seo_url":"blue-hills-manika-mage-hithe-vol-10-10001-10008-series-reyon-bigger-size-ready-made-anarkali-salwar-kameez-online-best-price-surat-india","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/09\/blue-hills-manika-mage-hithe-vol-10-10001-10008-series-reyon-bigger-size-ready-made-anarkali-salwar-kameez-online-best-price-surat-india-2022-09-05_12_31_13.jpg","product_qty":"0","sale_price":"6792","product_price":"849","product_mrp_price":"899","catalog_pcs":"8","regular_price":null,"disable_date":"2022-09-07 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"8Kg","fabric_name123":"reyon ","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"316","size_name":"M | L | XL | XXL | XXXL | 4XL | 5XL | 6XL | 7XL | 8XL | 9XL | 10XL","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Sep 2022","salelable":""},{"product_id":"393450","product_name":"shivali tyohaar festive season beautiful upada prints party wear gowns catalogue wholesale price ","brand_name_name":"Shivali S4u","cname":"tyohaar","product_seo_url":"shivali-tyohaar-festive-season-beautiful-upada-prints-party-wear-gowns-catalogue-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/08\/shivali-tyohaar-festive-season-beautiful-upada-prints-party-wear-gowns-catalogue-wholesale-price-2022-08-06_12_18_36.jpg","product_qty":"1","sale_price":"12495","product_price":"2499","product_mrp_price":"2599","catalog_pcs":"5","regular_price":null,"disable_date":"2022-08-09 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"Ready to Ship","per_product_weight":"8Kg","fabric_name123":"Pure Upada","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":4,"productview":"337","size_name":"XXXL","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"6th Aug 2022","salelable":""},{"product_id":"391590","product_name":"gramo rooch colour vol 1 anarkali style salwar kameez online wholesaler pratham fashion surat ","brand_name_name":"Gramo","cname":"rooch colour vol 1 ","product_seo_url":"gramo-rooch-colour-vol-1-anarkali-style-salwar-kameez-online-wholesaler-pratham-fashion-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/04\/gramo-rooch-colour-vol-1-anarkali-style-salwar-kameez-online-wholesaler-pratham-fashion-surat-2022-04-30_13_47_31.jpg","product_qty":"2","sale_price":"8796","product_price":"2199","product_mrp_price":"2249","catalog_pcs":"4","regular_price":null,"disable_date":"2022-05-03 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":2,"productview":"425","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Apr 2022","salelable":""},{"product_id":"391273","product_name":"blue hills by ada vol 4 ready madw designer anarkali salwar kameez wholesaler online surat","brand_name_name":"Bluehills","cname":"ada vol 4","product_seo_url":"blue-hills-by-ada-vol-4-ready-madw-designer-anarkali-salwar-kameez-wholesaler-online-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/04\/blue-hills-by-ada-vol-4-ready-madw-designer-anarkali-salwar-kameez-wholesaler-online-surat-2022-04-15_15_33_32.jpg","product_qty":"7","sale_price":"3745","product_price":"749","product_mrp_price":"799","catalog_pcs":"5","regular_price":null,"disable_date":"2022-04-19 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"5Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":6,"productview":"347","size_name":"M | L | XL | XXL | XXXL | 4XL | 5XL","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"15th Apr 2022","salelable":""},{"product_id":"389062","product_name":"twisha aanaya vol 131 3101-3104 series party wear anarkali suits wholesale price ","brand_name_name":"Twisha","cname":"aanaya vol 131","product_seo_url":"twisha-aanaya-vol-131-3101-3104-series-party-wear-anarkali-suits-wholesale-price","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/01\/twisha-aanaya-vol-131-3101-3104-series-party-wear-anarkali-suits-wholesale-price-2022-01-06_14_51_42.jpg","product_qty":"2","sale_price":"12780","product_price":"3195","product_mrp_price":"3245","catalog_pcs":"4","regular_price":null,"disable_date":"2022-01-08 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Velvet","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":2,"productview":"659","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"6th Jan 2022","salelable":""},{"product_id":"389008","product_name":"alizeh gulbahaar 3006-3009 series function special anarkali suits manufacturer surat","brand_name_name":"Alizeh","cname":"gulbahaar","product_seo_url":"alizeh-gulbahaar-3006-3009-series-function-special-anarkali-suits-manufacturer-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/01\/alizeh-gulbahaar-3006-3009-series-function-special-anarkali-suits-manufacturer-surat-2022-01-03_17_37_44.jpg","product_qty":"2","sale_price":"14360","product_price":"3590","product_mrp_price":"3640","catalog_pcs":"4","regular_price":null,"disable_date":"1970-01-01 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Butterfly Net","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":1,"productview":"798","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"3rd Jan 2022","salelable":""},{"product_id":"388981","product_name":"sayuri designer shaina 136 series party wear suits online supplier surat","brand_name_name":"Sayuri Designer","cname":"shaina","product_seo_url":"sayuri-designer-shaina-136-series-party-wear-suits-online-supplier-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2022\/01\/sayuri-designer-shaina-136-series-party-wear-suits-online-supplier-surat-2022-01-01_12_21_52.jpg","product_qty":"2","sale_price":"11495","product_price":"2299","product_mrp_price":"2349","catalog_pcs":"5","regular_price":null,"disable_date":"2022-01-03 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"5Kg","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":2,"productview":"483","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Jan 2022","salelable":""},{"product_id":"382110","product_name":"Eba Lifestyle Hurma Vol 35 Colour Edition Salwar Kameez Catalogue Surat","brand_name_name":"Eba lifestyle","cname":"hurma vol 35 colour edition","product_seo_url":"eba-lifestyle-hurma-vol-35-colour-edition-salwar-kameez-catalogue-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2021\/09\/382110_1634725857.jpg","product_qty":"2","sale_price":"8396","product_price":"2099","product_mrp_price":"2149","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-20 00:00:00","moq":"0","avail":"ask","size":"not","product_type":"On Booking","per_product_weight":"4Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":2,"productview":"481","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Sep 2021","salelable":""},{"product_id":"323077","product_name":"Aashirwad Peacock 7172-7177 Series Anarkali Party Wear Look Suits Collection Wholesale Price In Surat","brand_name_name":"Aashirwad Creation","cname":"Peacock","product_seo_url":"aashirwad-peacock-7172-7177-series-anarkali-party-wear-look-suits-collection-wholesale-price-in-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2020\/10\/323077_1634746698.jpg","product_qty":"1","sale_price":"17370","product_price":"2895","product_mrp_price":"2895","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-20 00:00:00","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>1<\/span><\/span><\/a>","discount":0,"productview":"721","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"26th Oct 2020","salelable":""},{"product_id":"271967","product_name":"Aashirwad Anarkali 8226-8229 Series Real Georgette Fancy Embroidery Party Wear Dresses Wholesale Rates Surat","brand_name_name":"Aashirwad Creation","cname":"anarkali","product_seo_url":"aashirwad-anarkali-8226-8229-series-real-georgette-fancy-embroidery-party-wear-dresses-wholesale-rates-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/11\/271967_1634827392.jpg","product_qty":"1","sale_price":"9180","product_price":"2295","product_mrp_price":"2295","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-21 14:43:12","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"618","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"29th Nov 2019","salelable":""},{"product_id":"263309","product_name":"Twisha Anaya Vol 96 96001-96004 Series Anarkali Party Wear Salwar Kameez Collection Wholesale Rate Surat","brand_name_name":"Twisha","cname":"aanaya vol 96000","product_seo_url":"twisha-anaya-vol-96-96001-96004-series-anarkali-party-wear-salwar-kameez-collection-wholesale-rate-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/10\/263309_1634829380.jpg","product_qty":"1","sale_price":"7580","product_price":"1895","product_mrp_price":"1895","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-21 15:16:20","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"439","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"11th Oct 2019","salelable":""},{"product_id":"248534","product_name":"Senhora Mirza Catalogue 11001-11004 Series Pure Georgette With Embroidery Work Stone Work With Lace Belt Collection Best Rates","brand_name_name":null,"cname":"MIRZA","product_seo_url":"senhora-mirza-catalogue-11001-11004-series-pure-georgette-with-embroidery-work-stone-work-with-lace-belt-collection-best-rates","product_image":"https:\/\/prathamexports.com\/images\/product\/2019\/08\/248534_1634833089.jpg","product_qty":"1","sale_price":"7996","product_price":"1999","product_mrp_price":"1999","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-21 16:18:09","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"623","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Aug 2019","salelable":""},{"product_id":"163114","product_name":"Kesri Trendz Launch Rangoli Vol 1 Anarkali Heav Embroiderd Party Wear Suits","brand_name_name":"Kesri Trendz","cname":"Rangoli Vol 1","product_seo_url":"kesri-trendz-launch-rangoli-vol-1-anarkali-heav-embroiderd-party-wear-suits","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/10\/163114_1634881018.jpg","product_qty":"1","sale_price":"8975","product_price":"1795","product_mrp_price":"1795","catalog_pcs":"5","regular_price":null,"disable_date":"2021-10-22 05:36:58","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"461","size_name":"Unstitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Oct 2018","salelable":""},{"product_id":"161272","product_name":"Aashirwad Noorjahan 2 8035-8040 Series Festive Party Wear Anarkali Embroidered Suits Collection Surat","brand_name_name":"Aashirwad Creation","cname":"Noorjahan 2","product_seo_url":"aashirwad-noorjahan-2-8035-8040-series-festive-party-wear-anarkali-embroidered-suits-collection-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/09\/161272_1634881441.jpg","product_qty":"1","sale_price":"11970","product_price":"1995","product_mrp_price":"1995","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-22 05:44:01","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"527","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"25th Sep 2018","salelable":""},{"product_id":"147806","product_name":"Ayesha Takiya Amirah Vol 9 Anarkali Salwar Kameez Catalog Wholesale Delear Online Price From Surat","brand_name_name":null,"cname":"Vol 9","product_seo_url":"ayesha-takiya-amirah-vol-9-anarkali-salwar-kameez-catalog-wholesale-delear-online-price-from-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/07\/147806_1634885136.jpg","product_qty":"1","sale_price":"10770","product_price":"1795","product_mrp_price":"1795","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-22 06:45:36","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"880","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"20th Jul 2018","salelable":""},{"product_id":"146184","product_name":"Aanaya 56000 Series Tafeta Silk Anarkali Collection Wholesale Rate Supplier","brand_name_name":"Twisha","cname":"Aanaya 56000 series","product_seo_url":"aanaya-56000-series-tafeta-silk-anarkali-collection-wholesale-rate-supplier","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/07\/146184_1634885588.jpg","product_qty":"1","sale_price":"9980","product_price":"2495","product_mrp_price":"2495","catalog_pcs":"4","regular_price":null,"disable_date":"2021-10-22 06:53:08","moq":"0","avail":"ask","size":"yes","product_type":"Stocked Out","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"404","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"12th Jul 2018","salelable":""},{"product_id":"130500","product_name":"Aashirwad Taj 2001-2006 Series Fancy Anarkali Eid Collection Suit Buy Wholesale Rate From Surat","brand_name_name":"Aashirwad Creation","cname":"Taj","product_seo_url":"aashirwad-taj-2001-2006-series-fancy-anarkali-eid-collection-suit-buy-wholesale-rate-from-surat","product_image":"https:\/\/prathamexports.com\/images\/product\/2018\/04\/130500_1634890037.jpg","product_qty":"1","sale_price":"10770","product_price":"1795","product_mrp_price":"1795","catalog_pcs":"6","regular_price":null,"disable_date":"2021-10-22 08:07:17","moq":"0","avail":"ask","size":"yes","product_type":"On Booking","per_product_weight":"-","fabric_name123":null,"wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","discount":0,"productview":"511","size_name":"Stitched","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"25th Apr 2018","salelable":""}],"oo":"select pm.* from relation_master as rm left join product_master as pm on pm.product_id=rm.product_id where 1=1 and pm.product_price!=0 and rm.type_id='25' and rm.type='subcat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}