\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 13:38:02","push_to_top_date":"2024-05-07 13:38:02","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118290","author_id":"admin","product_sku":"TM-118212","product_hsn":"540710","product_name":"shri balaji emporium 5478 AADHIRA Vol-9 designer alia cut sharara shuit","cname":" wedding wear Designer Embroidered Sleeves paired with Designer Plazo And Dupatta alia cut sharara shuit","product_seo_url":"shri-balaji-emporium-5478-aadhira-vol-9-designer-alia-cut-sharara-shuit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5478-aadhira-vol-9-designer-alia-cut-sharara-shuit-2024-05-07_13_01_48.png","product_qty":"30","catalog_pcs":"5","catelog_set":"","product_price":"1375","product_mrp_price":"1375","product_sale_price":"6875","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"5","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":" wedding wear Designer Embroidered Sleeves paired with Designer Plazo And Dupatta alia cut sharara shuit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5478 AADHIRA Vol-9 designer alia cut sharara shuit","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" We are Introducing our NAYRA STYLE WEAR COLLECTION To Make You Unique and Classy..<\/p>\r\n\r\n With Supirier Quality and Affordable Price<\/p>\r\n\r\n Catalogue:- AADHIRA Vol-9 \r\nDescription \r\n Designer Embroidered Sleeves paired with Designer Plazo And Dupatta<\/p>\r\n\r\n Details \r\nTop:- PURE REYON VISCOS FABRIC WITH HEAVY LAKHNAWI EMBROIDERY<\/p>\r\n\r\n Bottom :- Pure Reyon Viscos fabrics With Hevy Lakhnavi Work<\/p>\r\n\r\n DUPTTA Nazmin 4side border GPU less \r\n Size Chart \r\n Top:- S-36,M-38,L-40,XL-42,XXL-44,3XL-46<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 13:01:48","push_to_top_date":"2024-05-07 13:01:48","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118288","author_id":"admin","product_sku":"TM-118210","product_hsn":"540710","product_name":"shri balaji emporium 5477 Aarzoo Ladies Flavour Aarzoo Heavy Chanderi Silk Readymade Suits ","cname":"daily wear casual wear designer chanderi silk ready to wear shuit","product_seo_url":"shri-balaji-emporium-5477-aarzoo-ladies-flavour-aarzoo-heavy-chanderi-silk-readymade-suits","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5477-aarzoo-ladies-flavour-aarzoo-heavy-chanderi-silk-readymade-suits-2024-05-07_12_36_23.png","product_qty":"20","catalog_pcs":"4","catelog_set":"","product_price":"1225","product_mrp_price":"1225","product_sale_price":"4900","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"daily wear casual wear designer chanderi silk ready to wear shuit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5477 Aarzoo Ladies Flavour Aarzoo Heavy Chanderi Silk Readymade Suits","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Premium Festival Collection + Dupptta Catlouge<\/p>\r\n\r\n Catalog: Aarzoo<\/p>\r\n\r\n Design: 4<\/p>\r\n\r\n Fabric:- \r\nTop:- Heavy Chanderi Silk With Embroidery With Hand Work With inner<\/p>\r\n\r\n Note :- Top with Cup & Zip Finishing<\/p>\r\n\r\n Bottom:- Heavy Chanderi Silk<\/p>\r\n\r\n Dupptta :Chinon Chiffon With Gota Lace (2.30 cut & 36 Panna)<\/p>\r\n\r\n Size : M(38),L(40),XL(42), 2XL(44)<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 12:36:23","push_to_top_date":"2024-05-07 12:36:23","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118279","author_id":"admin","product_sku":"TM-118201","product_hsn":"540710","product_name":"Shri Balaji Emporium 6225 Pure Cotton Aline Shape kurti with plazzo","cname":"Exclusive New Pure Cotton Aline Shape kurti with plazzo with Beautiful three Colors","product_seo_url":"shri-balaji-emporium-6225-pure-cotton-aline-shape-kurti-with-plazzo","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6225-pure-cotton-aline-shape-kurti-with-plazzo-2024-05-07_12_06_24.jpg","product_qty":"20","catalog_pcs":"3","catelog_set":"","product_price":"849","product_mrp_price":"849","product_sale_price":"2547","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Exclusive New Pure Cotton Aline Shape kurti with plazzo with Beautiful three Colors","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6225 Pure Cotton Aline Shape kurti with plazzo","product_meta_keyword":"Shri Balaji Emporium 6225 Pure Cotton Aline Shape kurti with plazzo indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, red black lewndar purple","product_meta_description":"Exclusive New Pure Cotton Aline Shape kurti with plazzo with Beautiful three Colors","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Aline Shape kurti with plazzo<\/p>\r\n\r\n Both side pocket<\/p>\r\n\r\n Material cotton \r\nKurti length 44 \r\nPlazzo 38<\/p>\r\n\r\n Red Sizes: 38 40 42 44 46 \r\nPurple size:38 40,42,44 \r\nBlack Size: 38 40,42,44,46<\/p>\r\n\r\n Please contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 12:06:24","push_to_top_date":"2024-05-07 12:06:24","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118269","author_id":"admin","product_sku":"TM-118191","product_hsn":"540710","product_name":"SHUBHVASTRA 6179 FEMELLA VOL-13 New Exclusive Stitched Western Co-Ords Set Collection ","cname":" New Exclusive Stitched Western Co-Ords Set Collection ","product_seo_url":"shubhvastra-6179-femella-vol-13-new-exclusive-stitched-western-co-ords-set-collection","product_image":"images\/product\/2024\/05\/shubhvastra-6179-femella-vol-13-new-exclusive-stitched-western-co-ords-set-collection-2024-05-07_12_00_20.jpg","product_qty":"25","catalog_pcs":"3","catelog_set":"","product_price":"600","product_mrp_price":"600","product_sale_price":"1800","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"2","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":" New Exclusive Stitched Western Co-Ords Set Collection ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"SHUBHVASTRA 6179 FEMELLA VOL-13 New Exclusive Stitched Western Co-Ords Set Collection ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Weight: 0.5 KG. \r\nType: Full Stitched (Top & Bottom) S-36 • M-38 • L-40 • XL-42 • XXL-44<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 11:19:55","push_to_top_date":"2024-05-07 11:19:55","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118253","author_id":"admin","product_sku":"TM-118175","product_hsn":"540710","product_name":"shri balaji emporium 5471 Afgani Alia Vol-2\ufe0f\u20e3 party wear designer alia cut shuit","cname":"wedding wear party wear casual wear designer fancy afgani alia shuit","product_seo_url":"shri-balaji-emporium-5471-afgani-alia-vol-2-party-wear-designer-alia-cut-shuit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5471-afgani-alia-vol-2-party-wear-designer-alia-cut-shuit-2024-05-06_14_56_20.png","product_qty":"30","catalog_pcs":"3","catelog_set":"","product_price":"1150","product_mrp_price":"1150","product_sale_price":"3450","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"wedding wear party wear casual wear designer fancy afgani alia shuit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5471 Afgani Alia Vol-2\ufe0f\u20e3 party wear designer alia cut shuit","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1xq-Ui0t0HvbnvW2_3kHHX08dEAsTkR11","other_detail":" \r\n <\/p>\r\n\r\n
Afgani Alia Vol-2\ufe0f\u20e3 \r\n \r\n Detail - \r\n","single_catalog":"0","product_date":"2024-05-06 14:56:20","push_to_top_date":"2024-05-06 14:56:20","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118245","author_id":"admin","product_sku":"TM-118167","product_hsn":"540710","product_name":"shri balaji emporium 5467 AFGANI ALIA VOL - 1 casual wear designer aliya kat shuit","cname":"daily wear casual wear designer aliya kat shuit","product_seo_url":"shri-balaji-emporium-5467-afgani-alia-vol-1-casual-wear-designer-aliya-kat-shuit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5467-afgani-alia-vol-1-casual-wear-designer-aliya-kat-shuit-2024-05-06_13_40_01.png","product_qty":"30","catalog_pcs":"4","catelog_set":"","product_price":"1149","product_mrp_price":"1149","product_sale_price":"4596","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"daily wear casual wear designer aliya kat shuit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5467 AFGANI ALIA VOL - 1 casual wear designer aliya kat shuit","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1SideFt6qMjoJEHdhUKmYW38QXkyPgNTV","other_detail":" AFGANI ALIA VOL - 1<\/p>\r\n\r\n 2225 TO 2228 SERIES<\/p>\r\n\r\n Size- S-36 M-38 L-40 XL-42 XXL-44 3XL-46<\/p>\r\n\r\n Detail<\/p>\r\n\r\n Top —Premium Rayon Export Quality Handwork Full stitched<\/p>\r\n\r\n Pant -Premium Riyon Export Quality With Two Pocket<\/p>\r\n\r\n Dupatta -Heavy Najmin with Four Side Printed Lace<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-06 13:40:01","push_to_top_date":"2024-05-06 13:40:01","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118234","author_id":"admin","product_sku":"TM-118156","product_hsn":"540710","product_name":"TWISHA 6178 AANAYA VOL-187 Trendy Chinon Silk Anarkali Daily Wear kurtis ","cname":"Chinon Silk inner- SANTOOL daily wear co-ord set ","product_seo_url":"twisha-6178-aanaya-vol-187-trendy-chinon-silk-anarkali-daily-wear-kurtis","product_image":"images\/product\/2024\/05\/twisha-6178-aanaya-vol-187-trendy-chinon-silk-anarkali-daily-wear-kurtis-2024-05-06_15_25_05.jpg","product_qty":"35","catalog_pcs":"3","catelog_set":"","product_price":"1745","product_mrp_price":"1745","product_sale_price":"5235","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"3","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Trendy Chinon Silk Anarkali Daily Wear kurtis ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"TWISHA 6178 AANAYA VOL-187 Trendy Chinon Silk Anarkali Daily Wear kurtis indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"1","product_type":"Ready to Ship","video_link":"","other_detail":" Top. – Chinon Silk \r\ninner- SANTOOL \r\nNOTE:- This Product Can Stitch Up To 50" \r\nDupatta – Chinon Silk<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-06 12:13:59","push_to_top_date":"2024-05-06 12:13:59","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118232","author_id":"admin","product_sku":"TM-118154","product_hsn":"540710","product_name":"MAHOTSAV 6177 BERLIN Muslin Pakistani Suit Salwar Party Wear ","cname":"Muslin Embroidered Pakistani Suit Salwar Party Wear ","product_seo_url":"mahotsav-6177-berlin-muslin-pakistani-suit-salwar-party-wear","product_image":"images\/product\/2024\/05\/mahotsav-6177-berlin-muslin-pakistani-suit-salwar-party-wear-2024-05-06_12_00_32.jpg","product_qty":"20","catalog_pcs":"3","catelog_set":"","product_price":"725","product_mrp_price":"725","product_sale_price":"2175","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Muslin Embroidered Pakistani Suit Salwar Party Wear ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"MAHOTSAV 6177 BERLIN Muslin Pakistani Suit Salwar Party Wear ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Kurta fabric : Muslin \r\nBottom Fabric : Poly Muslin \r\nSize : M(38), L(40). XL(42),XXL(44) \r\nwork : Embroidered<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-06 12:00:32","push_to_top_date":"2024-05-06 12:00:32","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118214","author_id":"admin","product_sku":"TM-118136","product_hsn":"540710","product_name":"Shri Balaji Emporium 5630B 100% Pure Cotton Hand Block Printed Kaftan","cname":"New Summer Collection 100% Pure Cotton Hand Block Printed Kaftan with Beautiful Colors","product_seo_url":"shri-balaji-emporium-5630b-100-pure-cotton-hand-block-printed-kaftan","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5630b-100-pure-cotton-hand-block-printed-kaftan-2024-05-04_17_40_52.jpg","product_qty":"25","catalog_pcs":"13","catelog_set":"","product_price":"899","product_mrp_price":"899","product_sale_price":"11687","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"13","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"New Summer Collection 100% Pure Cotton Hand Block Printed Kaftan with Beautiful Colors","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 5630B 100% Pure Cotton Hand Block Printed Kaftan","product_meta_keyword":"Shri Balaji Emporium 5630B 100% Pure Cotton Hand Block Printed Kaftan pink red yellow purple wine green blue black white indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, ","product_meta_description":"New Summer Collection 100% Pure Cotton Hand Block Printed Kaftan with Beautiful Colors","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Exclusive NEW DESIGNS of kaftan \r\n *Block printed KAFTAN \r\n Authentic PRINT \r\nNatural Colours. \r\n100% Pure cotton \r\nFree Size up 36 to 52 .. \r\n Length : 52 inch<\/p>\r\n\r\n Please feel free to contact us if you need Singles. In some catalogues, we can give single on additional cost if available in stock.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-04 17:40:52","push_to_top_date":"2024-05-04 17:40:52","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118213","author_id":"admin","product_sku":"TM-118135","product_hsn":"540710","product_name":"Shri Balaji Emporium 5630A 100% Pure Cotton Hand Block Printed Kaftan","cname":"New Summer Collection 100% Pure Cotton Hand Block Printed Kaftan with Beautiful Colors","product_seo_url":"shri-balaji-emporium-5630a-100-pure-cotton-hand-block-printed-kaftan","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5630a-100-pure-cotton-hand-block-printed-kaftan-2024-05-04_17_39_29.jpg","product_qty":"25","catalog_pcs":"12","catelog_set":"","product_price":"899","product_mrp_price":"899","product_sale_price":"10788","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"12","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"New Summer Collection 100% Pure Cotton Hand Block Printed Kaftan with Beautiful Colors","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 5630A 100% Pure Cotton Hand Block Printed Kaftan","product_meta_keyword":"Shri Balaji Emporium 5630A 100% Pure Cotton Hand Block Printed Kaftan pink red yellow purple wine green blue black white indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, ","product_meta_description":"New Summer Collection 100% Pure Cotton Hand Block Printed Kaftan with Beautiful Colors","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Exclusive NEW DESIGNS of kaftan \r\n *Block printed KAFTAN \r\n Authentic PRINT \r\nNatural Colours. \r\n100% Pure cotton \r\nFree Size up 36 to 52 .. \r\n Length : 52 inch<\/p>\r\n\r\n Please feel free to contact us if you need Singles. In some catalogues, we can give single on additional cost if available in stock.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-04 17:39:29","push_to_top_date":"2024-05-04 17:39:29","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118211","author_id":"admin","product_sku":"TM-118133","product_hsn":"540710","product_name":"Shri Balaji Emporium 6162 ISHQ - E -IBADAT PURE COTTON STRAIGHT PAKISTANI SALWAR SUIT ","cname":"Pure Cotton Fully stiched Kurtis & pant & Duppta","product_seo_url":"shri-balaji-emporium-6162-ishq-e-ibadat-pure-cotton-straight-pakistani-salwar-suit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6162-ishq-e-ibadat-pure-cotton-straight-pakistani-salwar-suit-2024-05-04_17_31_18.jpg","product_qty":"25","catalog_pcs":"6","catelog_set":"","product_price":"1650","product_mrp_price":"1650","product_sale_price":"9900","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Pure Cotton Fully stiched Kurtis & pant & Duppta","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6162 ISHQ - E -IBADAT PURE COTTON STRAIGHT PAKISTANI SALWAR SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" TOP- \r\nFabric: PURE COTTON BY COTTON + WEAVING SELF PATTERN COTTON \r\n - Designer style \r\n TOP:- \r\nWORK:- \r\nDESGINER FANCY THERD mirrors work + Hand work + Accessory WoRK<\/p>\r\n\r\n BOTTOM PANT : - PURE COTTON + laces WITH WORK<\/p>\r\n\r\n Pant:- FANCY BOTTM cotton<\/p>\r\n\r\n DUPPTA :- PURE COTTON WITH FANCY DIGITAL PRINTS WITH WEAVINGZARI BORDERS<\/p>\r\n\r\n Fully stiched Kurtis & pant & Duppta<\/p>\r\n\r\n 3psc<\/p>\r\n\r\n Size:- M-38 L-40 XL-42 XXL-44 3XL-46<\/p>\r\n\r\n Designs:- 6<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-04 17:31:18","push_to_top_date":"2024-05-04 17:31:18","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118209","author_id":"admin","product_sku":"TM-118131","product_hsn":"540710","product_name":"Shri Balaji Emporium 6161 MARIAB PAKISTANI DESIGNER COLLECTION EMBROIDERY WORK ","cname":"Pure Organza Heavy Embroidery work with Moti work","product_seo_url":"shri-balaji-emporium-6161-mariab-pakistani-designer-collection-embroidery-work","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6161-mariab-pakistani-designer-collection-embroidery-work-2024-05-04_17_22_49.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"850","product_mrp_price":"850","product_sale_price":"3400","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Pure Organza Heavy Embroidery work with Moti work ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6161 MARIAB PAKISTANI DESIGNER COLLECTION EMBROIDERY WORK sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"1zxyN93nEtbQmE2YeMp3T4_1DjEpa7e29","other_detail":" TOP :- Pure Organza \r\nINNER :- Dull santoon (2mtr) \r\nBOTTOM :- Dull Santoon (2mtr) \r\nDUPATTA :- Pure soft organza with Embroidery Work \r\nWORK :- Heavy Embroidery work with Moti work \r\nDesign : 4 Color<\/p>\r\n\r\n Weight - 600gm<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-04 17:22:49","push_to_top_date":"2024-05-04 17:22:49","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118208","author_id":"admin","product_sku":"TM-118130","product_hsn":"540710","product_name":"TANISHK FASHION 6160 SANIYA VOL 1 Designer Summer Collection Cotton Salwar Suit","cname":"COTTON SLUB PRINT WITH EMBROIDERY SIKVANS WORK ","product_seo_url":"tanishk-fashion-6160-saniya-vol-1-designer-summer-collection-cotton-salwar-suit","product_image":"images\/product\/2024\/05\/tanishk-fashion-6160-saniya-vol-1-designer-summer-collection-cotton-salwar-suit-2024-05-04_17_11_59.jpg","product_qty":"25","catalog_pcs":"7","catelog_set":"","product_price":"455","product_mrp_price":"455","product_sale_price":"3185","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"7","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"COTTON SLUB PRINT WITH EMBROIDERY SIKVANS WORK ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"TANISHK FASHION 6160 SANIYA VOL 1 Designer Summer Collection Cotton Salwar Suit sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" WITH EMBROIDERY SIKVANS WORK \r\nTOP:COTTON SLUB PRINT \r\nBOTTOM:COTTON SLUB PRINT PENT \r\nDUPATTA:MIX COTTON DUPATTA \r\nSIZE:M,L,XL,2XL,3XL<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-04 17:11:59","push_to_top_date":"2024-05-04 17:11:59","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118207","author_id":"admin","product_sku":"TM-118129","product_hsn":"540710","product_name":"KILORY TRENDZ 6159 Silk Of Bandhej 3 PURE VISCOSE MUSLINE DIGITAL & FOIL PRINT SUIT","cname":"PURE VISCOSE MUSLINE DIGITAL & FOIL PRINT WITH FANCY EMBROIDERY WORK ","product_seo_url":"kilory-trendz-6159-silk-of-bandhej-3-pure-viscose-musline-digital-foil-print-suit","product_image":"images\/product\/2024\/05\/kilory-trendz-6159-silk-of-bandhej-3-pure-viscose-musline-digital-foil-print-suit-2024-05-04_17_03_55.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"1195","product_mrp_price":"1195","product_sale_price":"7170","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"PURE VISCOSE MUSLINE DIGITAL & FOIL PRINT WITH FANCY EMBROIDERY WORK SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"KILORY TRENDZ 6159 Silk Of Bandhej 3 PURE VISCOSE MUSLINE DIGITAL & FOIL PRINT SUIT sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t\t","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Fabric Details \r\n \r\nTop:*PURE VISCOSE MUSLINE DIGITAL & FOIL PRINT WITH FANCY EMBROIDERY WORK<\/p>\r\n\r\n Bottom:*PURE VISCOSE MUSLINE WITH EMBROIDERY WORK<\/p>\r\n\r\n *Dupatta:*PURE VISCOSE MUSLINE WITH EMBROIDERY WORK *<\/p>\r\n\r\n Designs: 6* PCS<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-04 17:03:55","push_to_top_date":"2024-05-04 17:03:55","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118195","author_id":"admin","product_sku":"TM-118117","product_hsn":"540710","product_name":"VINAY 5443 CHAKORI STRAIGHT THREAD EMBROIDERED ORGANZA SALWAR SHUIT","cname":"PARTY WEDDING WEAR LONG DESIGNER SALWAR SHUIT","product_seo_url":"vinay-5443-chakori-straight-thread-embroidered-organza-salwar-shuit","product_image":"images\/product\/2024\/05\/vinay-5443-chakori-straight-thread-embroidered-organza-salwar-shuit-2024-05-04_12_10_29.png","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"1695","product_mrp_price":"1695","product_sale_price":"10170","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"PARTY WEDDING WEAR LONG DESIGNER SALWAR SHUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"VINAY 5443 CHAKORI STRAIGHT THREAD EMBROIDERED ORGANZA SALWAR SHUIT","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" KULEESH - CHAKORI<\/p>\r\n\r\n 67381 SERIES<\/p>\r\n\r\n DRESS MATERIALS : \r\nFABRIC DETAILS : THREAD EMBROIDERED ORGANZA<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-04 12:10:29","push_to_top_date":"2024-05-04 12:10:29","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118194","author_id":"admin","product_sku":"TM-118116","product_hsn":"540710","product_name":"VINAY 5442 SHALINI INDIAN WOMEN PARTY WEAR DESIGNER SHARARA SHUIT","cname":"PARTY WEDDING WEAR LONG DESIGNER SHARARA SHUIT","product_seo_url":"vinay-5442-shalini-indian-women-party-wear-designer-sharara-shuit","product_image":"images\/product\/2024\/05\/vinay-5442-shalini-indian-women-party-wear-designer-sharara-shuit-2024-05-04_11_56_34.png","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"2300","product_mrp_price":"2300","product_sale_price":"13800","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"9","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"PARTY WEDDING WEAR LONG DESIGNER SHARARA SHUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"VINAY 5442 SHALINI INDIAN WOMEN PARTY WEAR DESIGNER SHARARA SHUIT","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" KULEESH - SHALINI<\/p>\r\n\r\n 67831 SERIES<\/p>\r\n\r\n DRESS MATERIALS \r\nFABRIC DETAILS : EMBROIDERED CHINNON TOP WITH SHARARA AND DIGITAL PRINTED EMBROIDERED CHINON DUPATTA<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-04 11:56:34","push_to_top_date":"2024-05-04 11:56:34","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118193","author_id":"admin","product_sku":"TM-118115","product_hsn":"540710","product_name":"VINAY 5441 SURBHI HITLIST PARTY WEAR SILK GEORGETTE SALWAR SHUIT ","cname":"PARTY WEAR CASUAL WEAR STRAIGHT SALWAR SHUIT","product_seo_url":"vinay-5441-surbhi-hitlist-party-wear-silk-georgette-salwar-shuit","product_image":"images\/product\/2024\/05\/vinay-5441-surbhi-hitlist-party-wear-silk-georgette-salwar-shuit-2024-05-04_11_32_25.png","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1595","product_mrp_price":"1595","product_sale_price":"6380","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"PARTY WEAR CASUAL WEAR STRAIGHT SALWAR SHUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"VINAY 5441 SURBHI HITLIST PARTY WEAR SILK GEORGETTE SALWAR SHUIT","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" KULEESH - SURBHI HITLIST<\/p>\r\n\r\n 66661 SERIES<\/p>\r\n\r\n DRESS MATERIALS \r\nDIGITAL PRINTED SILK GEORGETTE WITH EMBROIDERY WORK AND EMBROIDERED SILK GEORGETTE DUPATTA<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-04 11:32:25","push_to_top_date":"2024-05-04 11:32:25","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}}],"ggg":"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='6' and rm.type='cat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 24, 20"} | | | | | | | |