{"status":"ok","count":20,"catalog":[{"product_id":"4153294","product_name":"Amoha Trends C 704 Shrug Style Partywear 3 Piece Sets","brand_name_name":"Amoha Trends","cname":"C-704","product_seo_url":"amoha-trends-c-704-shrug-style-partywear-3-piece-sets","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/amoha-trends-c-704-shrug-style-partywear-3-piece-sets-2025-02-05_13_46_32.jpg","product_qty":"10","sale_price":"2275","product_price":"2275","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-15","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Crepe","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"35","size_name":"M","category_name":"Indo Western,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Feb 2025","salelable":""},{"product_id":"4153276","product_name":"Netra Vrisa Firozi Exclusive Jacquard Suit Single Dress Wholesale","brand_name_name":"Netra Exclusive","cname":"Vrisa Firozi","product_seo_url":"netra-vrisa-firozi-exclusive-jacquard-suit-single-dress-wholesale","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/netra-vrisa-firozi-exclusive-jacquard-suit-single-dress-wholesale-2025-02-05_11_28_34.jpg","product_qty":"5","sale_price":"1661","product_price":"1661","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-15","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Maslin Jacquard","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"18","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Feb 2025","salelable":""},{"product_id":"4153275","product_name":"Netra Vrisa Rust Muslin Jacquard Dress Festive Collection","brand_name_name":"Netra Exclusive","cname":"Vrisa Rust","product_seo_url":"netra-vrisa-rust-muslin-jacquard-dress-festive-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/netra-vrisa-rust-muslin-jacquard-dress-festive-collection-2025-02-05_11_25_11.jpg","product_qty":"5","sale_price":"1661","product_price":"1661","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-15","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Maslin Jacquard","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"17","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"5th Feb 2025","salelable":""},{"product_id":"4150791","product_name":"Kimora Raas 361 TO 371 Festive Wear Style Dola Silk Saree Wholesalers","brand_name_name":"Kimora Saree","cname":"Raas","product_seo_url":"kimora-raas-361-to-371-festive-wear-style-dola-silk-saree-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/kimora-raas-361-to-371-festive-wear-style-dola-silk-saree-wholesalers-2025-02-01_19_57_38.jpeg","product_qty":"5","sale_price":"32725","product_price":"2975","catalog_pcs":"11","regular_price":null,"disable_date":"2024-12-09","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"10Kg","fabric_name123":"Dola Silk","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"130","size_name":"","category_name":"Saree Single,Saree","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Feb 2025","salelable":""},{"product_id":"4153164","product_name":"Ganga Fashion Chesah 2854 Fancy Linen Cotton Ganga Fashion Suit","brand_name_name":"Ganga Fashion","cname":"Chesah 2854","product_seo_url":"ganga-fashion-chesah-2854-fancy-linen-cotton-ganga-fashion-suit","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/ganga-fashion-chesah-2854-fancy-linen-cotton-ganga-fashion-suit-2025-02-01_17_38_55.jpeg","product_qty":"3","sale_price":"1440","product_price":"1440","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-12","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"125","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Feb 2025","salelable":""},{"product_id":"4153163","product_name":"Ganga Fashion Bernila 2853 Printed Fancy Cotton Ladies Suit Design","brand_name_name":"Ganga Fashion","cname":"Bernila 2853","product_seo_url":"ganga-fashion-bernila-2853-printed-fancy-cotton-ladies-suit-design","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/ganga-fashion-bernila-2853-printed-fancy-cotton-ladies-suit-design-2025-02-01_17_34_44.jpeg","product_qty":"5","sale_price":"1440","product_price":"1440","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-12","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"92","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Feb 2025","salelable":""},{"product_id":"4153162","product_name":"Ganga Fashion Analyn 2852 Fancy Cotton Linen Salwar Suit Suppliers","brand_name_name":"Ganga Fashion","cname":"Analyn 2852","product_seo_url":"ganga-fashion-analyn-2852-fancy-cotton-linen-salwar-suit-suppliers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/ganga-fashion-analyn-2852-fancy-cotton-linen-salwar-suit-suppliers-2025-02-01_17_31_28.jpeg","product_qty":"5","sale_price":"1440","product_price":"1440","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-12","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"59","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Feb 2025","salelable":""},{"product_id":"4153161","product_name":"Ganga Fashion Katherine 2850 Exclusive Cotton Suit Wholesalers","brand_name_name":"Ganga Fashion","cname":"Katherine 2850","product_seo_url":"ganga-fashion-katherine-2850-exclusive-cotton-suit-wholesalers","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/02\/ganga-fashion-katherine-2850-exclusive-cotton-suit-wholesalers-2025-02-01_17_26_15.jpeg","product_qty":"5","sale_price":"1440","product_price":"1440","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-12","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Cotton","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"71","size_name":"","category_name":"Salwar Kameez","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"1st Feb 2025","salelable":""},{"product_id":"4153091","product_name":"Zarqash Z 179 Pakistani Readymade 3 Piece Concept","brand_name_name":"Zarqash","cname":"Z-179","product_seo_url":"zarqash-z-179-pakistani-readymade-3-piece-concept","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/zarqash-z-179-pakistani-readymade-3-piece-concept-2025-01-31_15_59_55.jpeg","product_qty":"20","sale_price":"950","product_price":"950","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-11","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"48","size_name":"XL | XXL","category_name":"Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"31st Jan 2025","salelable":""},{"product_id":"4153053","product_name":"Amoha Trends C 2077 Colors Partywear Crop Tops 3 Piece Collection","brand_name_name":"Amoha Trends","cname":"C-2077 Colors","product_seo_url":"amoha-trends-c-2077-colors-partywear-crop-tops-3-piece-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/amoha-trends-c-2077-colors-partywear-crop-tops-3-piece-collection-2025-01-30_17_30_10.jpg","product_qty":"10","sale_price":"5390","product_price":"2695","catalog_pcs":"2","regular_price":null,"disable_date":"2025-02-10","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"2Kg","fabric_name123":"Chinon","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"90","size_name":"M","category_name":"Indo Western,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"30th Jan 2025","salelable":""},{"product_id":"4152815","product_name":"Amoha Trends T 307 Colors Designer Ready To Wear Partywear Saree","brand_name_name":"Amoha Trends","cname":"T-307 Colors","product_seo_url":"amoha-trends-t-307-colors-designer-ready-to-wear-partywear-saree","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/amoha-trends-t-307-colors-designer-ready-to-wear-partywear-saree-2025-01-25_15_32_38.jpeg","product_qty":"10","sale_price":"5450","product_price":"2725","catalog_pcs":"2","regular_price":null,"disable_date":"2025-02-05","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"2Kg","fabric_name123":"Imported Fabric","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"113","size_name":"M","category_name":"Saree,Saree Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"25th Jan 2025","salelable":""},{"product_id":"4152704","product_name":"Naqsh 15014 Formal Wear Pakistani Suit Readymade Collection","brand_name_name":"Kapdavilla","cname":"15014","product_seo_url":"naqsh-15014-formal-wear-pakistani-suit-readymade-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/naqsh-15014-formal-wear-pakistani-suit-readymade-collection-2025-01-23_16_09_08.jpeg","product_qty":"20","sale_price":"1399","product_price":"1399","catalog_pcs":"1","regular_price":null,"disable_date":"2025-02-03","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Georgette","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"114","size_name":"XL | XXL","category_name":"Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"23rd Jan 2025","salelable":""},{"product_id":"4152519","product_name":"Netra Vrisa Mehrun Designer Jacquard Silk Dress Collection","brand_name_name":"Netra Exclusive","cname":"Vrisa Mehrun","product_seo_url":"netra-vrisa-mehrun-designer-jacquard-silk-dress-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/netra-vrisa-mehrun-designer-jacquard-silk-dress-collection-2025-01-20_12_32_11.jpg","product_qty":"5","sale_price":"1661","product_price":"1661","catalog_pcs":"1","regular_price":null,"disable_date":"2025-01-30","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Maslin Jacquard","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"109","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"20th Jan 2025","salelable":""},{"product_id":"4152421","product_name":"Amoha Trends C 2085 Colors Fancy Palazzo Top Set Catalog Dealer","brand_name_name":"Amoha Trends","cname":"C-2085 Colors","product_seo_url":"amoha-trends-c-2085-colors-fancy-palazzo-top-set-catalog-dealer","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/amoha-trends-c-2085-colors-fancy-palazzo-top-set-catalog-dealer-2025-01-17_15_02_21.jpeg","product_qty":"10","sale_price":"6375","product_price":"2125","catalog_pcs":"3","regular_price":null,"disable_date":"2025-01-27","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"3Kg","fabric_name123":"Fancy fabrics","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"110","size_name":"M","category_name":"Indo Western,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Jan 2025","salelable":""},{"product_id":"4152414","product_name":"Amoha Trends C 423 Designer 3 Piece Shrug Suit Collection","brand_name_name":"Amoha Trends","cname":"C-423","product_seo_url":"amoha-trends-c-423-designer-3-piece-shrug-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/amoha-trends-c-423-designer-3-piece-shrug-suit-collection-2025-01-17_14_02_35.jpg","product_qty":"20","sale_price":"2525","product_price":"2525","catalog_pcs":"1","regular_price":null,"disable_date":"2025-01-27","moq":"0","avail":"ask","size":"yes","product_type":"","per_product_weight":"1Kg","fabric_name123":"Fancy fabrics","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"112","size_name":"L | XL","category_name":"Indo Western,Readymade","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"17th Jan 2025","salelable":""},{"product_id":"4152334","product_name":"Fepic C 1917 C Exclusive Heavy Designer Style Organza Salwar Kameez Ensemble","brand_name_name":"Fepic","cname":"C 1917 C","product_seo_url":"fepic-c-1917-c-exclusive-heavy-designer-style-organza-salwar-kameez-ensemble","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/fepic-c-1917-c-exclusive-heavy-designer-style-organza-salwar-kameez-ensemble-2025-01-13_17_53_50.jpeg","product_qty":"5","sale_price":"1510","product_price":"1510","catalog_pcs":"1","regular_price":null,"disable_date":"2025-01-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"107","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Jan 2025","salelable":""},{"product_id":"4152333","product_name":"Fepic C 1917 B Heavy Designer Style Pakistani Festive Wear Suit Supplier","brand_name_name":"Fepic","cname":"C 1917 B","product_seo_url":"fepic-c-1917-b-heavy-designer-style-pakistani-festive-wear-suit-supplier","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/fepic-c-1917-b-heavy-designer-style-pakistani-festive-wear-suit-supplier-2025-01-13_17_53_49.jpeg","product_qty":"5","sale_price":"1510","product_price":"1510","catalog_pcs":"1","regular_price":null,"disable_date":"2025-01-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"118","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Jan 2025","salelable":""},{"product_id":"4152332","product_name":"Fepic C 1917 A Pakistani Style Designer Organza Embroidered Suit Exporter","brand_name_name":"Fepic","cname":"C 1917 A","product_seo_url":"fepic-c-1917-a-pakistani-style-designer-organza-embroidered-suit-exporter","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/fepic-c-1917-a-pakistani-style-designer-organza-embroidered-suit-exporter-2025-01-13_17_53_49.jpeg","product_qty":"5","sale_price":"1510","product_price":"1510","catalog_pcs":"1","regular_price":null,"disable_date":"2025-01-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"126","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Jan 2025","salelable":""},{"product_id":"4152331","product_name":"Fepic C 1917 Colors Festive Wear Style Heavy Designer Pakistani Suit Collection","brand_name_name":"Fepic","cname":"C 1917 Colors","product_seo_url":"fepic-c-1917-colors-festive-wear-style-heavy-designer-pakistani-suit-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/fepic-c-1917-colors-festive-wear-style-heavy-designer-pakistani-suit-collection-2025-01-13_17_49_12.jpeg","product_qty":"5","sale_price":"4197","product_price":"1399","catalog_pcs":"3","regular_price":null,"disable_date":"2025-01-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"3Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"141","size_name":"","category_name":"Salwar Kameez,Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Jan 2025","salelable":""},{"product_id":"4152328","product_name":"Shree Fabs K 5061 B Festive Wear Style Designer Heavy Salwar Kameez Collection","brand_name_name":"Shree Fabs NC","cname":"K 5061 B","product_seo_url":"shree-fabs-k-5061-b-festive-wear-style-designer-heavy-salwar-kameez-collection","product_image":"https:\/\/kapdavilla.com\/images\/product\/2025\/01\/shree-fabs-k-5061-b-festive-wear-style-designer-heavy-salwar-kameez-collection-2025-01-13_17_36_12.jpeg","product_qty":"5","sale_price":"1350","product_price":"1350","catalog_pcs":"1","regular_price":null,"disable_date":"2025-01-13","moq":"0","avail":"ask","size":"not","product_type":"","per_product_weight":"1Kg","fabric_name123":"Organza","wish":"<\/i><\/a>\n\t\t\t\n\t\t\t<\/i>0<\/span><\/span><\/a>","productview":"117","size_name":"","category_name":"Salwar Kameez Single","single_catalog":"0","numsing":0,"subcategory_seo_url":null,"product_date":"13th Jan 2025","salelable":""}],"s":"select pm.* from product_master pm where pm.type IN (1,2) and pm.product_price!=0 group by pm.product_id order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}