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 (287061, 287058, 287021, 287011, 265739, 259957, 254504, 254501, 254481, 254438, 254236, 252700, 252695, 242028, 241988, 241983, 241869, 241822, 241805, 239954, 233738, 233698, 233696, 233675)) ORDER BY FIELD(e.entity_id,287061,287058,287021,287011,265739,259957,254504,254501,254481,254438,254236,252700,252695,242028,241988,241983,241869,241822,241805,239954,233738,233698,233696,233675)
Page
Sort by
Items 1-24 of 36
FILTER
Now Shopping by
  1. Work
    Mirror Work
  2. Time to ship
    Within 30 Days
  3. Readymade Size
    46
  4. Tailoring Options
    Readymade
Clear All
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Kurta Sets
  3. Pathani Suit
  4. Anarkali
  5. Pakistani
  6. Palazzo Suits
  7. Pant Suits
  8. Printed
  9. Sharara Suits
  10. Straight Cut
  11. Twin Layered
  12. Kurta Pajama
  13. Jacket Style
  14. Heavy Yoke
  15. Nehru Jacket
  16. Heavy Blouse
  17. Asymmetric
  18. Designer
  19. Contemporary
  20. Jumpsuit
  21. Kaftan
Occasion
  1. Festive
  2. Groomsmen
  3. Bridesmaid Lehenga
  4. Wedding
  5. Reception
  6. Engagement
  7. Mehendi
  8. Sangeet
  9. Party
  10. Cocktail
  11. Casual
  12. Groom
Fabric
  1. Art Silk
  2. Chiffon
  3. Cotton
  4. Crape
  5. Georgette
  6. Organza
  7. Satin
  8. Silk
Work
  1. Chikankari Work
  2. Cutbeads
  3. Abstract Print
  4. Bandhej
  5. Beads Work
  6. Cut Beads
  7. Dori
  8. Embroidered
  9. Floral Print
  10. Foil Print
  11. Gota Patti
  12. Hand Work
  13. Lace
  14. Leheria
  15. Mirror Work
  16. Patch Work
  17. Plain
  18. Polka Dot Print
  19. Printed
  20. Resham Work
  21. Sequins
  22. Stone Work
  23. Thread
  24. Tie-Dye Print
  25. Zardosi Work
  26. Zari
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. 34
  2. 36
  3. 38
  4. 40
  5. 42
  6. 44
  7. 46
  8. 48
  9. 50
  10. 52
Customizable Size
  1. 34
  2. 36
  3. 38
  4. 40
  5. 42
  6. 44
Tailoring Options
  1. Readymade
FILTER
Now Shopping by
  1. Work
    Mirror Work
  2. Time to ship
    Within 30 Days
  3. Readymade Size
    46
  4. Tailoring Options
    Readymade
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Kurta Sets
  3. Pathani Suit
  4. Anarkali
  5. Pakistani
  6. Palazzo Suits
  7. Pant Suits
  8. Printed
  9. Sharara Suits
  10. Straight Cut
  11. Twin Layered
  12. Kurta Pajama
  13. Jacket Style
  14. Heavy Yoke
  15. Nehru Jacket
  16. Heavy Blouse
  17. Asymmetric
  18. Designer
  19. Contemporary
  20. Jumpsuit
  21. Kaftan
Occasion
  1. Festive
  2. Groomsmen
  3. Bridesmaid Lehenga
  4. Wedding
  5. Reception
  6. Engagement
  7. Mehendi
  8. Sangeet
  9. Party
  10. Cocktail
  11. Casual
  12. Groom
Fabric
  1. Art Silk
  2. Chiffon
  3. Cotton
  4. Crape
  5. Georgette
  6. Organza
  7. Satin
  8. Silk
Work
  1. Chikankari Work
  2. Cutbeads
  3. Abstract Print
  4. Bandhej
  5. Beads Work
  6. Cut Beads
  7. Dori
  8. Embroidered
  9. Floral Print
  10. Foil Print
  11. Gota Patti
  12. Hand Work
  13. Lace
  14. Leheria
  15. Mirror Work
  16. Patch Work
  17. Plain
  18. Polka Dot Print
  19. Printed
  20. Resham Work
  21. Sequins
  22. Stone Work
  23. Thread
  24. Tie-Dye Print
  25. Zardosi Work
  26. Zari
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. 34
  2. 36
  3. 38
  4. 40
  5. 42
  6. 44
  7. 46
  8. 48
  9. 50
  10. 52
Customizable Size
  1. 34
  2. 36
  3. 38
  4. 40
  5. 42
  6. 44
Tailoring Options
  1. Readymade
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.