app-download-header
Everything under Rs.999
20% Cashback* on Buy 4 items. , Use Code: CB20
20% Cashback* on Buy 4 items.
Use Code: CB20
HR
:
MN
:
SC
ENDS IN

Co-Ords

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Sets 2042 items
Colour
Colour
  1. Beige 105 items
  2. Black 435 items
  3. Blue 205 items
  4. Brown 203 items
  5. Gold 3 items
  6. Green 152 items
  7. Grey 124 items
  8. Maroon 2 items
  9. Multi 83 items
  10. Orange 44 items
  11. Pink 189 items
  12. Purple 45 items
  13. Red 104 items
  14. Silver 14 items
  15. White 291 items
  16. Yellow 64 items
Less
Size
Size
  1. 1XL 12 items
  2. 2XL 130 items
  3. 3XL 32 items
  4. 4XL 19 items
  5. 5XL 9 items
  6. FS 38 items
  7. L 1789 items
  8. M 1796 items
  9. S 1752 items
  10. XL 736 items
  11. XS 65 items
  12. XXL 116 items
  13. XXS 3 items
  14. XXXL 10 items
  15. 0XL 1 item
Less
Price
Price
  1. Rs. 200 - 400 2 items
  2. Rs. 400 - 600 2 items
  3. Rs. 600 - 800 9 items
  4. Rs. 800 - 1000 19 items
  5. Rs. 1000 - 1200 48 items
  6. Rs. 1200 - 1400 100 items
  7. Rs. 1400 - 1600 171 items
  8. Rs. 1600 - 1800 200 items
  9. Rs. 1800 - 2000 175 items
  10. Rs. 2000 - 2500 492 items
  11. Rs. 2500 - 3000 403 items
  12. Rs. 3000 - 3500 252 items
  13. Rs. 3500 - 4000 95 items
  14. Rs. 4000 - 4500 24 items
  15. Rs. 4500 - 5000 11 items
  16. Rs. 5000 - 5500 3 items
  17. Rs. 5500 - 6000 2 items

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=513 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 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `search_tmp_672ac6b694f9b3_76557567` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

2049 styles found
  1. 64% Off
    -64%
    BLACK TWO PIECE RIB-KNIT CO-ORD SET
  2. 60% Off
    -60%
    BROWN TUBE TOP W/ BOLERO SET
  3. 58% Off
    -58%
    BLACK PU TOP AND PENCIL SKIRT SET
  4. 60% Off
    -60%
    COLOURBLOCKED GREY CO-ORD SET
  5. 60% Off
    -60%
    Black Slim Cami & Slanted Skirt Set
  6. 63% Off
    -63%
    Pink Fitted Tube Top & Bolero
  7. 63% Off
    -63%
    White Seamless Tube Top & Shorts
  8. 60% Off
    -60%
    BLACK TIE-DYE TOP & MINI SKIRT SET
  9. 75% Off
    -75%
    BAHAMA MOOD TWO PIECE SET
  10. 63% Off
    -63%
    Printed Purple Two Piece Upper Set
  11. 60% Off
    -60%
    T-SHIRT AND SHORTS CO-ORD SET
  12. 75% Off
    -75%
    GREEN TUBE TOP W/ BOLERO SET
  13. 60% Off
    -60%
    TRANSPARENT BLACK LACE UPPER SET