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 (296353, 252542, 250733, 250730, 250726, 250711, 250700, 250677, 247968, 247555, 241932, 240727, 240698, 240256, 240220, 240189, 240172, 240128, 240109, 240107, 240099, 240091, 240089, 233727)) ORDER BY FIELD(e.entity_id,296353,252542,250733,250730,250726,250711,250700,250677,247968,247555,241932,240727,240698,240256,240220,240189,240172,240128,240109,240107,240099,240091,240089,233727)
Page
Sort by
Items 1-24 of 44
FILTER
Now Shopping by
  1. Style
    Asymmetric
  2. Work
    Zari
  3. Readymade Size
    34
  4. Tailoring Options
    Readymade
Clear All
Category
Style
  1. Bandhgala Jodhpuri
  2. Kurta Pajama with Nehru Jacket
  3. Kurta Sets
  4. Men's Kurta
  5. Plunge Neck
  6. Sherwani with Anarkali Kurta
  7. Skirt Set
  8. Anarkali
  9. Abaya Style
  10. Pakistani
  11. Palazzo Suits
  12. Pant Suits
  13. Printed
  14. Punjabi Suits
  15. Sharara Suits
  16. Angrakha Style
  17. Straight Cut
  18. Suits with Slit
  19. A Line
  20. Twin Layered
  21. Kurta Pajama
  22. Jacket Style
  23. Heavy Border
  24. Heavy Sleeves
  25. Heavy Yoke
  26. Sherwani
  27. Indo Western Sherwani
  28. Nehru Jacket
  29. Heavy Blouse
  30. Asymmetric
  31. Classic Style
  32. Dhoti with Sherwani
  33. Designer
  34. Contemporary
  35. Dhoti with Kurta
  36. Gowns
  37. Kaftan
  38. Kurtis
  39. Long Kurta
  40. Gharara
Occasion
  1. Festive
  2. Wedding
  3. Reception
  4. Engagement
  5. Mehendi
  6. Party
  7. Groom
Fabric
  1. Art Silk
  2. Banarasi Silk
  3. Dupion Silk
  4. Georgette
  5. Jacquard
  6. Silk
Work
  1. Chikankari Work
  2. Abstract Print
  3. Applique
  4. Bandhej
  5. Beads Work
  6. Block Print
  7. Cut Beads
  8. Digital Print
  9. Dori
  10. Embroidered
  11. Floral Print
  12. Gota Patti
  13. Hand Work
  14. Kundan Work
  15. Lace
  16. Mirror Work
  17. Patch Work
  18. Plain
  19. Printed
  20. Resham Work
  21. Sequins
  22. Stone Work
  23. Thread
  24. Tie-Dye Print
  25. Woven
  26. Zardosi Work
  27. Zari
Price
Time to ship
  1. Within 1 Day
  2. Within 10 Days
  3. Within 15 Days
  4. Within 21 Days
  5. 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. 28
  13. 30
  14. 32
  15. 34
  16. 36
  17. 38
  18. 40
  19. 42
  20. 44
  21. 46
  22. 48
  23. 50
  24. 52
  25. 54
  26. 56
  27. 58
  28. 60
  29. 62
  30. 64
  31. 66
Tailoring Options
  1. Readymade
FILTER
Now Shopping by
  1. Style
    Asymmetric
  2. Work
    Zari
  3. Readymade Size
    34
  4. Tailoring Options
    Readymade
Category
Style
  1. Bandhgala Jodhpuri
  2. Kurta Pajama with Nehru Jacket
  3. Kurta Sets
  4. Men's Kurta
  5. Plunge Neck
  6. Sherwani with Anarkali Kurta
  7. Skirt Set
  8. Anarkali
  9. Abaya Style
  10. Pakistani
  11. Palazzo Suits
  12. Pant Suits
  13. Printed
  14. Punjabi Suits
  15. Sharara Suits
  16. Angrakha Style
  17. Straight Cut
  18. Suits with Slit
  19. A Line
  20. Twin Layered
  21. Kurta Pajama
  22. Jacket Style
  23. Heavy Border
  24. Heavy Sleeves
  25. Heavy Yoke
  26. Sherwani
  27. Indo Western Sherwani
  28. Nehru Jacket
  29. Heavy Blouse
  30. Asymmetric
  31. Classic Style
  32. Dhoti with Sherwani
  33. Designer
  34. Contemporary
  35. Dhoti with Kurta
  36. Gowns
  37. Kaftan
  38. Kurtis
  39. Long Kurta
  40. Gharara
Occasion
  1. Festive
  2. Wedding
  3. Reception
  4. Engagement
  5. Mehendi
  6. Party
  7. Groom
Fabric
  1. Art Silk
  2. Banarasi Silk
  3. Dupion Silk
  4. Georgette
  5. Jacquard
  6. Silk
Work
  1. Chikankari Work
  2. Abstract Print
  3. Applique
  4. Bandhej
  5. Beads Work
  6. Block Print
  7. Cut Beads
  8. Digital Print
  9. Dori
  10. Embroidered
  11. Floral Print
  12. Gota Patti
  13. Hand Work
  14. Kundan Work
  15. Lace
  16. Mirror Work
  17. Patch Work
  18. Plain
  19. Printed
  20. Resham Work
  21. Sequins
  22. Stone Work
  23. Thread
  24. Tie-Dye Print
  25. Woven
  26. Zardosi Work
  27. Zari
Price
Time to ship
  1. Within 1 Day
  2. Within 10 Days
  3. Within 15 Days
  4. Within 21 Days
  5. 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. 28
  13. 30
  14. 32
  15. 34
  16. 36
  17. 38
  18. 40
  19. 42
  20. 44
  21. 46
  22. 48
  23. 50
  24. 52
  25. 54
  26. 56
  27. 58
  28. 60
  29. 62
  30. 64
  31. 66
Tailoring Options
  1. Readymade
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.