\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-02 14:20:47","push_to_top_date":"2024-05-02 14:20:47","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"118062","author_id":"admin","product_sku":"TM-117984","product_hsn":"540710","product_name":"STYLISHTA 6125 TANISHA VOL02 Fancy Casual Wear Block Printed Suit Pant ","cname":" Fancy Casual Wear Block Printed Suit Pant floral print","product_seo_url":"stylishta-6125-tanisha-vol02-fancy-casual-wear-block-printed-suit-pant","product_image":"images\/product\/2024\/05\/stylishta-6125-tanisha-vol02-fancy-casual-wear-block-printed-suit-pant-2024-05-01_13_43_05.jpg","product_qty":"20","catalog_pcs":"8","catelog_set":"","product_price":"699","product_mrp_price":"699","product_sale_price":"5592","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":" Fancy Casual Wear Block Printed Suit Pant floral print","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"STYLISHTA 6125 TANISHA VOL02 Fancy Casual Wear Block Printed Suit Pant 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: - Cotton. \r\nWork: - block print. \r\n dyed. \r\n floral print. \r\nSize:-M (38)\/ L (40), XL (42), XXL (44). \r\nWeight: - 1 kg.<\/p>\r\n\r\n please contact us if you have any queries <\/p>\r\n","single_catalog":"0","product_date":"2024-05-01 13:43:05","push_to_top_date":"2024-05-01 13:43:05","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118044","author_id":"admin","product_sku":"TM-117966","product_hsn":"540710","product_name":"Shri Balaji Emporium 6116 Subhadra Trendy Straight Women Cotton Kurta Pant ","cname":"Women Kurta Pant Cotton Bland Printed ","product_seo_url":"shri-balaji-emporium-6116-subhadra-trendy-straight-women-cotton-kurta-pant","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6116-subhadra-trendy-straight-women-cotton-kurta-pant-2024-05-01_11_20_41.jpg","product_qty":"20","catalog_pcs":"2","catelog_set":"","product_price":"555","product_mrp_price":"555","product_sale_price":"1110","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":"no","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Women Kurta Pant Cotton Bland Printed ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6116 Subhadra Trendy Straight Women Cotton Kurta Pant 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":" Product typ - Women Kurta With Pant<\/p>\r\n\r\n Size - M To XXL<\/p>\r\n\r\n Fabric - Cotton Bland<\/p>\r\n\r\n Pattern - Printed<\/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-01 11:20:41","push_to_top_date":"2024-05-01 11:20:41","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118036","author_id":"admin","product_sku":"TM-117958","product_hsn":"540710 ","product_name":"Shri Balaji Emporium 6104 Latest Designer Wedding Wear Palazzo Sharara Suit ","cname":"pakistani palazzo sharara suit partywear weddig wear ","product_seo_url":"shri-balaji-emporium-6104-latest-designer-wedding-wear-palazzo-sharara-suit","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-6104-latest-designer-wedding-wear-palazzo-sharara-suit-2024-04-30_18_06_47.jpg","product_qty":"20","catalog_pcs":"4","catelog_set":"","product_price":"4199","product_mrp_price":"4199","product_sale_price":"16796","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"10","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":"pakistani palazzo sharara suit partywear weddig wear ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6104 Latest Designer Wedding Wear Palazzo Sharara 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":"\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-04-30 18:06:47","push_to_top_date":"2024-04-30 18:06:47","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117963","author_id":"admin","product_sku":"TM-117885","product_hsn":"540710","product_name":"Shri Balaji Emporium 6081 GUNJAN RAYON EMBROIDERY PAKISTANI SUIT COLLECTION ","cname":" elegance with Lucknowi embroidered suits RAYON EMBROIDERY PAKISTANI SUIT COLLECTION ","product_seo_url":"shri-balaji-emporium-6081-gunjan-rayon-embroidery-pakistani-suit-collection","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-6081-gunjan-rayon-embroidery-pakistani-suit-collection-2024-04-29_11_19_09.jpg","product_qty":"35","catalog_pcs":"6","catelog_set":"","product_price":"1425","product_mrp_price":"1425","product_sale_price":"8550","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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":" elegance with Lucknowi embroidered suits RAYON EMBROIDERY PAKISTANI SUIT COLLECTION ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6081 GUNJAN RAYON EMBROIDERY PAKISTANI SUIT COLLECTION 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":"1ebR4PuAlYr0Onf3X5Nk13lY2oVnnl-Of","other_detail":" Fabric - rayon \r\n m to xxl \r\nBig size -\/- 3xl 4xl 5xl<\/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-04-29 11:19:09","push_to_top_date":"2024-04-29 11:19:09","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117952","author_id":"admin","product_sku":"TM-117874","product_hsn":"540710","product_name":"BANWARI FASHION 6078 Yogita Pure Viscose Chanderi print Anarkali Suit ","cname":" Pure Viscose Chanderi print With Heavy Embroidery Work With Real Mirror Hand Work ","product_seo_url":"banwari-fashion-6078-yogita-pure-viscose-chanderi-print-anarkali-suit","product_image":"images\/product\/2024\/04\/banwari-fashion-6078-yogita-pure-viscose-chanderi-print-anarkali-suit-2024-04-27_15_44_35.jpg","product_qty":"20","catalog_pcs":"1","catelog_set":"","product_price":"800","product_mrp_price":"800","product_sale_price":"800","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"600","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 Viscose Chanderi print With Heavy Embroidery Work With Real Mirror Hand Work.","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"BANWARI FASHION 6078 Yogita Pure Viscose Chanderi print Anarkali 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":"1-ltFTbVoQCCIQmygtw1wP8WQQnvOfhzX","other_detail":" Fabric \r\nTop Fabric : Pure Viscose Chanderi print With Heavy Embroidery Work With Real Mirror Hand Work.<\/p>\r\n\r\n Top Length : 47-48 inch<\/p>\r\n\r\n Pent Fabric : Pure Viscose Chanderi Silk \r\nPent Length :40-41”<\/p>\r\n\r\n Dupatta Fabric: Pure Viscose chanderi print with foil<\/p>\r\n\r\n Size : M, L, XL, XXL.(Fully Stiched)<\/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-04-27 15:44:35","push_to_top_date":"2024-04-27 15:44:35","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117910","author_id":"admin","product_sku":"TM-117832","product_hsn":"540710","product_name":"Shri Balaji Emporium 5818 MAYRA VOL 4 VISCOSE MODAL PURE HAND WORK SUIT","cname":" VISCOSE MODAL PURE HAND WORK PAKISTANI SUIT PARTYWEAR ","product_seo_url":"shri-balaji-emporium-5818-mayra-vol-4-viscose-modal-pure-hand-work-suit","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-5818-mayra-vol-4-viscose-modal-pure-hand-work-suit-2024-04-26_13_50_26.jpg","product_qty":"25","catalog_pcs":"6","catelog_set":"","product_price":"1850","product_mrp_price":"1850","product_sale_price":"11100","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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":" VISCOSE MODAL PURE HAND WORK PAKISTANI SUIT PARTYWEAR ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 5818 MAYRA VOL 4 VISCOSE MODAL PURE HAND WORK 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":" DETAILS<\/p>\r\n\r\n ","single_catalog":"0","product_date":"2024-04-26 13:50:26","push_to_top_date":"2024-04-26 13:50:26","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117908","author_id":"admin","product_sku":"TM-117830","product_hsn":"540710","product_name":"STYLISHTA 5835 TANISHA VOL Cotton Block Print Readymade Kurtis ","cname":"Cotton Block Print Readymade Kurtis partywear casual ","product_seo_url":"stylishta-5835-tanisha-vol-cotton-block-print-readymade-kurtis","product_image":"images\/product\/2024\/04\/stylishta-5835-tanisha-vol-cotton-block-print-readymade-kurtis-2024-04-26_13_36_07.jpg","product_qty":"20","catalog_pcs":"6","catelog_set":"","product_price":"699","product_mrp_price":"699","product_sale_price":"4194","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"no","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Cotton Block Print Readymade Kurtis partywear casual ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"STYLISHTA 5835 TANISHA VOL Cotton Block Print Readymade Kurtis 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: - cotton. \r\nWork: - \r\n1001:-block print. \r\n1002\/1003:- gold print. \r\n1004\/1005\/1006\/1007\/1008:- floral print. \r\nSize:-M(38)\/ L (40), XL (42), XXL (44). \r\nWeight: - 1 kg.<\/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-04-26 13:36:07","push_to_top_date":"2024-04-26 13:36:07","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117868","author_id":"admin","product_sku":"TM-117790","product_hsn":"540710","product_name":"Shri Balaji Emporium 5870 Madhuvan Rayon Weaving Handwork & Embroidery Suits","cname":" Rayon Weaving Handwork & Embroidery Suits","product_seo_url":"shri-balaji-emporium-5870-madhuvan-rayon-weaving-handwork-embroidery-suits","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-5870-madhuvan-rayon-weaving-handwork-embroidery-suits-2024-04-25_16_36_57.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1299","product_mrp_price":"1299","product_sale_price":"5196","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":" Rayon Weaving Handwork & Embroidery Suits","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 5870 Madhuvan Rayon Weaving Handwork & Embroidery Suits 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":" Design : 4 \r\nTop : Rayon Weaving \r\nWork : Handwork & Embroidery \r\nBottom : Cotton Lycra \r\nDupatta : Jequard Viscose <\/p>\r\n\r\n \r\nSize : S(36), M(38), L(40), XL(42), XXL(44), 3XL(46)<\/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-04-25 16:36:57","push_to_top_date":"2024-04-25 16:36:57","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117858","author_id":"admin","product_sku":"TM-117780","product_hsn":"540710","product_name":"Virasat 5872 Pure Musline Jacquard Handwork & Embroidery Kurtis ","cname":"Pure Musline Jacquard Handwork & Embroidery Kurtis ","product_seo_url":"virasat-5872-pure-musline-jacquard-handwork-embroidery-kurtis","product_image":"images\/product\/2024\/04\/virasat-5872-pure-musline-jacquard-handwork-embroidery-kurtis-2024-04-25_15_37_44.jpg","product_qty":"30","catalog_pcs":"4","catelog_set":"","product_price":"1350","product_mrp_price":"1350","product_sale_price":"5400","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":"Pure Musline Jacquard Handwork & Embroidery Kurtis ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 5872 Pure Musline Jacquard Handwork & Embroidery Kurtis 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":" Design : 4 \r\nTop : Pure Musline jacquard \r\nInner : soft cotton \r\nWork : Handwork & Embroidery \r\nBottom : Cotton Lycra \r\nDupatta : Nazmin Chiffon with work <\/p>\r\n\r\n Size : 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-04-25 15:37:44","push_to_top_date":"2024-04-25 15:37:44","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117824","author_id":"admin","product_sku":"TM-117746","product_hsn":"540710","product_name":"Ramsha R-1131 ORGENZA EMBROIDERY INNER PRINT SUIT","cname":"ORGENZA EMBROIDERY WITH INNER PRINT SUIT","product_seo_url":"ramsha-r-1131-orgenza-embroidery-inner-print-suit","product_image":"images\/product\/2024\/04\/ramsha-r-1131-orgenza-embroidery-inner-print-suit-2024-04-24_15_21_46.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1450","product_mrp_price":"1450","product_sale_price":"5800","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":"ORGENZA EMBROIDERY WITH INNER PRINT SUIT ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Ramsha R-1131 ORGENZA EMBROIDERY INNER 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":" TOP-ORGENZA EMBROIDERY WITH INNER PRINT<\/p>\r\n\r\n BOTTOM-SILK STICH<\/p>\r\n\r\n DUPATTA ORGENZA EMBROIDERY<\/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-04-24 15:21:46","push_to_top_date":"2024-04-24 15:21:46","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117812","author_id":"admin","product_sku":"TM-117734","product_hsn":"540710","product_name":"Shri Balaji Emporium 5886 Cotton Slub Beautiful Printed Kurtis","cname":" Cotton Slub Beautiful Printed Kurtis Pant Casual Party Wear","product_seo_url":"shri-balaji-emporium-5886-cotton-slub-beautiful-printed-kurtis","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-5886-cotton-slub-beautiful-printed-kurtis-2024-04-24_12_50_48.jpg","product_qty":"25","catalog_pcs":"6","catelog_set":"","product_price":"560","product_mrp_price":"560","product_sale_price":"3360","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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 Beautiful Printed Kurtis Pant Casual Party Wear","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 5886 Cotton Slub Beautiful Printed Kurtis 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\u25aa:- Cotton Slub \r\n\u25aaTotal Design:- 6 \r\nPick and choose size available \r\n\u25aaSize:- 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-04-24 12:50:48","push_to_top_date":"2024-04-24 12:50: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":"117790","author_id":"admin","product_sku":"TM-117712","product_hsn":"540710","product_name":"JayVijay Aangan PURE COTTON FANCY BORER EMBROIDERY SUIT","cname":"PURE COTTON FANCY BORER EMBROIDERY DIGITAL PRINT WITH EMBROIDERY AND LACE WORK","product_seo_url":"jayvijay-aangan-pure-cotton-fancy-borer-embroidery-suit","product_image":"images\/product\/2024\/04\/jayvijay-aangan-pure-cotton-fancy-borer-embroidery-suit-2024-04-23_18_24_21.jpg","product_qty":"5","catalog_pcs":"7","catelog_set":"","product_price":"1990","product_mrp_price":"1990","product_sale_price":"13930","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"7","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 COTTON FANCY BORER EMBROIDERY DIGITAL PRINT WITH EMBROIDERY AND LACE WORK","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"JayVijay Aangan PURE COTTON FANCY BORER EMBROIDERY 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 ~ PURE COTTON FANCY BORER EMBROIDERY DIGITAL PRINT WITH EMBROIDERY AND LACE WORK INNER~ PURE COTTON (SOLID COLOUR)<\/p>\r\n\r\n BOTTOM PURE COTTON (SOLID COLOUR) WITH EMBROIDERY AND LACE WORK<\/p>\r\n\r\n DUPATTA PURE MAL COTTON FANCY BORER EMBROIDERY DIGITAL PRINT WITH LACE AND HANGINS<\/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-04-23 18:24:21","push_to_top_date":"2024-04-23 18:24:21","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"0"}},{"product":{"product_id":"117757","author_id":"admin","product_sku":"TM-117680","product_hsn":"540710","product_name":"Shri Balaji Emporium 6038 ","cname":"VISCOSE COTTON HEAVY EMBROIDERY WITH MIRROR & BEAUTIFUL LACES SUIT","product_seo_url":"shri-balaji-emporium-6038-viscose-cotton-heavy-embroidery-mirror-suit","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-6038-viscose-cotton-heavy-embroidery-mirror-suit-2024-04-23_12_01_05.jpg","product_qty":"20","catalog_pcs":"6","catelog_set":"","product_price":"1499","product_mrp_price":"1499","product_sale_price":"8994","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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":"VISCOSE COTTON HEAVY EMBROIDERY WITH MIRROR & BEAUTIFUL LACES SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6038 ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" DETAILS<\/p>\r\n\r\n KURTI PANT WITH DIGITAL DUPATTA<\/p>\r\n\r\n FABRIC - VISCOSE COTTON DOBBY<\/p>\r\n\r\n BOTTOM FABRIC - COTTON CAMRIC 60\/60<\/p>\r\n\r\n DUPATTA - DIGITAL PRINT<\/p>\r\n\r\n WORK TYPE - HEAVY EMBROIDERY WITH MIRROR & BEAUTIFUL LACES<\/p>\r\n\r\n SIZE : M(38) L(40) XL(42) XXL(44)<\/p>\r\n\r\n DESIGN - 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-04-23 12:01:05","push_to_top_date":"2024-04-23 12:01:05","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117755","author_id":"admin","product_sku":"TM-117678","product_hsn":"540710","product_name":"Shri Balaji Emporium 6041 Deeptex Roohi Zara Heavy Lawn Poplin Cotton Printed Suit","cname":"Heavy Lawn Poplin Cotton Printed Suit Pant Partywear ","product_seo_url":"shri-balaji-emporium-6041-deeptex-roohi-zara-heavy-lawn-poplin-cotton-printed-suit","product_image":"images\/product\/2024\/04\/shri-balaji-emporium-6041-deeptex-roohi-zara-heavy-lawn-poplin-cotton-printed-suit-2024-04-23_11_43_15.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"460","product_mrp_price":"460","product_sale_price":"3680","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":"Heavy Lawn Poplin Cotton Printed Suit Pant Partywear ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6041 Deeptex Roohi Zara Heavy Lawn Poplin Cotton Printed Suit sarees indian indianwear partywear festivals functions occasions .\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":" Size:- Unstitched \r\nFabric:- Lawn Cotton \r\nOther Details:- \r\nTop:- Heavy Lawn Poplin Cotton | Cut:2.50 Mtrs \r\nBottom:- Heavy Lawn Cotton | Cut:- 2.00 Mtrs \r\nDupatta:- Heavy Cotton Dupatta | Cut:- 2.25 Mtrs<\/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-04-23 11:43:15","push_to_top_date":"2024-04-23 11:43:15","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117753","author_id":"admin","product_sku":"TM-117676","product_hsn":"540710","product_name":"ALIZEH 6042 Murad 10 Hit Colour Latest Designer Georgette Suit ","cname":" Jacket Alizeh Georgette Thread With Zari & Sequins Embroiedery Suit","product_seo_url":"alizeh-6042-murad-10-hit-colour-latest-designer-georgette-suit","product_image":"images\/product\/2024\/04\/alizeh-6042-murad-10-hit-colour-latest-designer-georgette-suit-2024-04-23_11_23_59.jpg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"2345","product_mrp_price":"2345","product_sale_price":"2345","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"1.5","product_stitch":"Semi 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":" Jacket Alizeh Georgette Thread With Zari & Sequins Embroiedery Suit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"ALIZEH 6042 Murad 10 Hit Colour Latest Designer Georgette Suit sarees indian indianwear partywear festivals functions occasions \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- \r\nJacket - Alizeh Georgette \r\nInner & Bottom - Dull Santoon \r\nDupatta - Net<\/p>\r\n\r\n Work - Thread With Zari & Sequins Embroiedery<\/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-04-23 11:23:59","push_to_top_date":"2024-04-23 11:23: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":"117736","author_id":"admin","product_sku":"TM-117659","product_hsn":"540710","product_name":"IBIZA 6016 MUSLIN DIGITAL PRINT HANDWORK SUIT","cname":"PURE BAMBARG MUSLIN DIGITAL PRINT HANDWORK ","product_seo_url":"ibiza-6016-muslin-digital-print-handwork-suit","product_image":"images\/product\/2024\/04\/ibiza-6016-muslin-digital-print-handwork-suit-2024-04-22_16_27_07.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"1795","product_mrp_price":"1795","product_sale_price":"10770","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 BAMBARG MUSLIN DIGITAL PRINT WITH HANDWORK","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"IBIZA 6016 MUSLIN DIGITAL PRINT HANDWORK SUIT sarees indian indianwear partywear festivals functions occasions .\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<\/p>\r\n\r\n Top:-PURE BAMBARG MUSLIN DIGITAL PRINT WITH HANDWORK<\/p>\r\n\r\n DUPATTA:-PURE AEREE SILK DIGITAL PRINT<\/p>\r\n\r\n BOTTOM:-PURE RAYON<\/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-04-22 16:27:07","push_to_top_date":"2024-04-22 16:27:07","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117732","author_id":"admin","product_sku":"TM-117655","product_hsn":"540710","product_name":"PRM TRENDZ 6017 SUNKISSED FENCY HAND WORK PURE LAWN COTTON SUIT ","cname":" PURE LAWN COTTON WITH FENCY HEND WORK WITH DIGITAL PRINT SUIT","product_seo_url":"prm-trendz-6017-sunkissed-fency-hand-work-pure-lawn-cotton-suit","product_image":"images\/product\/2024\/04\/prm-trendz-6017-sunkissed-fency-hand-work-pure-lawn-cotton-suit-2024-04-22_16_01_31.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"1195","product_mrp_price":"1195","product_sale_price":"9560","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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 LAWN COTTON WITH FENCY HEND WORK WITH DIGITAL PRINT SUIT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"PRM TRENDZ 6017 SUNKISSED FENCY HAND WORK PURE LAWN COTTON SUIT sarees indian indianwear partywear festivals functions occasions .\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 LAWN COTTON WITH FENCY HEND WORK WITH DIGITAL PRINT<\/p>\r\n\r\n Bottom: PURE COTTON SOLID *<\/p>\r\n\r\n Dupatta:*PURE BEMBER CHIFFON WITH DIGITAL PRINT *<\/p>\r\n\r\n Designs: 8 * 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-04-22 16:01:31","push_to_top_date":"2024-04-22 16:01:31","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117724","author_id":"admin","product_sku":"TM-117647","product_hsn":"540710","product_name":"YASHIKA TRENDS 6018 KANTHA EXCLUSIVE HEAVY COTTON PRINTED KURTA PANT ","cname":"HEAVY COTTON PRINTED WITH EXCLUSIVE NECK AND DAMAN WORK","product_seo_url":"yashika-trends-6018-kantha-exclusive-heavy-cotton-printed-kurta-pant","product_image":"images\/product\/2024\/04\/yashika-trends-6018-kantha-exclusive-heavy-cotton-printed-kurta-pant-2024-04-22_15_34_50.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"550","product_mrp_price":"550","product_sale_price":"4400","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":"HEAVY COTTON PRINTED WITH EXCLUSIVE NECK AND DAMAN WORK ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"YASHIKA TRENDS 6018 KANTHA EXCLUSIVE HEAVY COTTON PRINTED KURTA PANT sarees indian indianwear partywear festivals functions occasions .\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":"1t9j3Hcn7F9Hui2GCwOo26K8msgadBrhs","other_detail":" HEAVY COTTON \r\n \r\n Fabric Details:-<\/p>\r\n\r\n TOP :- *HEAVY COTTON PRINTED WITH EXCLUSIVE NECK AND DAMAN WORK 2.5MTR<\/p>\r\n\r\n :- HEAVY COTTON 2.5 MTR<\/p>\r\n\r\n :- 2:25( HEAVY COTTON DUPATTA WITH PIGMENTPEINT FANCY DISINE)<\/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-04-22 15:34:50","push_to_top_date":"2024-04-22 15:34:50","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"117711","author_id":"admin","product_sku":"TM-117634","product_hsn":"540710","product_name":"ALIZEH 5967 Alizeh Murad 2015 Yellow Georgette Suit Salwar Pant ","cname":"Alizeh Yellow Georgette Suit Salwar Pant ","product_seo_url":"alizeh-5967-alizeh-murad-2015-yellow-georgette-suit-salwar-pant","product_image":"images\/product\/2024\/04\/alizeh-5967-alizeh-murad-2015-yellow-georgette-suit-salwar-pant-2024-04-22_14_52_20.jpg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"2100","product_mrp_price":"2100","product_sale_price":"2100","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"1","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":"Yellow Georgette Suit Salwar Pant ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"ALIZEH 5967 Alizeh Murad 2015 Yellow Georgette Suit Salwar Pant sarees indian indianwear partywear festivals functions occasions .\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":"1TKvRKQNTpjnUucPGzndMGkWj7EK41lfL","other_detail":" \r\nFabric \r\nTop & Dupatta-Alizeh Georgette \r\nInner & Bottom-Dull Santoon<\/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-04-22 14:52:20","push_to_top_date":"2024-04-22 14:52:20","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='135' and rm.type='subcat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 24, 20"} | | | | | | | | | | | | | | | | |