Yes - Polyester - Pashmina - Cotton Net - Chambray Jacquard - Unstitched Fabric
Filters
(14 Items)
Display
Filters
Applied Filters
Filters- New Arrivals Yes Remove This Item
- New Arrivals No Remove This Item
- Dupatta Fabric Polyester Remove This Item
- Dupatta Fabric Pashmina Remove This Item
- Dupatta Fabric Cotton Net Remove This Item
- Dupatta Fabric Chambray Jacquard Remove This Item
Category
Biggest Discount
New Arrivals
Price
Product Type
Color
Shirt Fabric
Dupatta Fabric
Trouser Fabric
Best Selling
Sort
Sort By
Best Selling
New Arrivals
Price - Low to High
Price - High to Low
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price_cg0_ws3` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '3' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 3 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (618104, 523490)) ORDER BY FIELD(e.entity_id,618104,523490)
Page
- Page Previous
- Page 1
- You're currently reading page 2