SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`amstcred_amount`, `e`.`amstcred_allow_open_amount`, `e`.`amstcred_open_amount_min`, `e`.`amstcred_open_amount_max`, `e`.`amstcred_price_type`, `e`.`amstcred_price_type_value`, `e`.`amstcred_price_percent`, `e`.`occasion`, `e`.`style`, `e`.`fabric`, `e`.`size`, `e`.`size_value`, `e`.`time_to_ship`, `e`.`time_to_ship_value`, `e`.`time_to_ship_display`, `e`.`work`, `e`.`customizable_size`, `e`.`blouse_neck_style`, `e`.`blouse_sleeves`, `e`.`readymadesize`, `e`.`amxnotif_hide_alert`, `e`.`productcategory`, `e`.`productcategory_value`, `e`.`tailoringoptions`, `e`.`tailoringoptions_value`, `e`.`swatch_image`, `e`.`aw_arp_override_native`, `e`.`featured`, `e`.`amstore_credit_prices`, `e`.`amstore_credit_open_amount`, `e`.`amstore_credit_open_amount_min`, `e`.`amstore_credit_open_amount_max`, `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_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (293335, 293331, 293294, 293288, 289881, 288303, 288240, 288221, 287694, 285075, 284321, 284296, 284269, 284012, 283982, 283975, 283973, 283923, 283920, 282607, 282063, 282061, 282016, 279859)) ORDER BY FIELD(e.entity_id,293335,293331,293294,293288,289881,288303,288240,288221,287694,285075,284321,284296,284269,284012,283982,283975,283973,283923,283920,282607,282063,282061,282016,279859)
Sort by
24 Items found
FILTER
Now Shopping by
  1. Occasion
    Haldi
  2. Time to ship
    Within 15 Days
  3. Readymade Size
    50
Clear All
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Anarkali
  3. Printed
  4. Kurta Pajama
  5. Sherwani
  6. Indo Western Sherwani
  7. Dhoti with Sherwani
Occasion
  1. Festive
  2. Groomsmen
  3. Wedding
  4. Reception
  5. Engagement
  6. Mehendi
  7. Haldi
  8. Sangeet
  9. Party
  10. Cocktail
  11. Casual
  12. Groom
Fabric
  1. Art Silk
  2. Cotton
  3. Rayon
  4. Silk
Work
  1. Digital Print
  2. Embroidered
  3. Floral Print
  4. Plain
  5. Print
  6. Printed
  7. Sequins
  8. Thread
  9. Woven
Price
Time to ship
  1. Within 10 Days
  2. Within 15 Days
  3. Within 21 Days
  4. Within 30 Days
Gender
  1. Female
  2. Male
Readymade Size
  1. 3
  2. 4
  3. 5
  4. 6
  5. 7
  6. 8
  7. 9
  8. 10
  9. 11
  10. 12
  11. 13
  12. 34
  13. 36
  14. 38
  15. 40
  16. 42
  17. 44
  18. 46
  19. 48
  20. 50
  21. 52
  22. 54
  23. 56
  24. 58
  25. 60
  26. 62
  27. 64
  28. 66
  29. 68
  30. 70
FILTER
Now Shopping by
  1. Occasion
    Haldi
  2. Time to ship
    Within 15 Days
  3. Readymade Size
    50
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Anarkali
  3. Printed
  4. Kurta Pajama
  5. Sherwani
  6. Indo Western Sherwani
  7. Dhoti with Sherwani
Occasion
  1. Festive
  2. Groomsmen
  3. Wedding
  4. Reception
  5. Engagement
  6. Mehendi
  7. Haldi
  8. Sangeet
  9. Party
  10. Cocktail
  11. Casual
  12. Groom
Fabric
  1. Art Silk
  2. Cotton
  3. Rayon
  4. Silk
Work
  1. Digital Print
  2. Embroidered
  3. Floral Print
  4. Plain
  5. Print
  6. Printed
  7. Sequins
  8. Thread
  9. Woven
Price
Time to ship
  1. Within 10 Days
  2. Within 15 Days
  3. Within 21 Days
  4. Within 30 Days
Gender
  1. Female
  2. Male
Readymade Size
  1. 3
  2. 4
  3. 5
  4. 6
  5. 7
  6. 8
  7. 9
  8. 10
  9. 11
  10. 12
  11. 13
  12. 34
  13. 36
  14. 38
  15. 40
  16. 42
  17. 44
  18. 46
  19. 48
  20. 50
  21. 52
  22. 54
  23. 56
  24. 58
  25. 60
  26. 62
  27. 64
  28. 66
  29. 68
  30. 70
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.