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 (181671, 176867, 171198, 169203, 175806, 175792, 289595, 288593, 288559, 285415, 281585, 277323, 276764, 272952, 271191, 261572, 251888, 230435, 225683, 218310, 217336, 214780, 214478, 206377)) ORDER BY FIELD(e.entity_id,181671,176867,171198,169203,175806,175792,289595,288593,288559,285415,281585,277323,276764,272952,271191,261572,251888,230435,225683,218310,217336,214780,214478,206377)
Page
Sort by
Items 1-24 of 32
FILTER
Now Shopping by
  1. Occasion
    Wedding
  2. Work
    Sequins
  3. Time to ship
    Within 1 Day
Clear All
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Plunge Neck
  3. Anarkali
  4. Abaya Style
  5. Pakistani
  6. Palazzo Suits
  7. Pant Suits
  8. Printed
  9. Sharara Suits
  10. Angrakha Style
  11. Straight Cut
  12. Suits with Slit
  13. Bollywood
  14. Jacket Style
  15. Heavy Border
  16. Heavy Sleeves
  17. Heavy Yoke
  18. Sherwani
  19. Kurti Style Lehenga
  20. Heavy Blouse
  21. Asymmetric
  22. Classic Style
  23. Dhoti with Sherwani
  24. Contemporary
Occasion
  1. Festive
  2. Bridesmaid Lehenga
  3. Wedding
  4. Reception
  5. Engagement
  6. Mehendi
  7. Sangeet
  8. Bridal
  9. Party
  10. Cocktail
  11. Casual
  12. Groom
  13. Bridesmaid
Fabric
  1. Art Silk
  2. Chiffon
  3. Georgette
  4. Net
  5. Organza
  6. Tussar Silk
  7. Velvet
Work
  1. Chikankari Work
  2. Bandhej
  3. Beads Work
  4. Cut Beads
  5. Digital Print
  6. Dori
  7. Embroidered
  8. Floral Print
  9. Gota Patti
  10. Hand Work
  11. Lace
  12. Mirror Work
  13. Patch Border
  14. Plain
  15. Resham Work
  16. Sequins
  17. Stone Work
  18. Thread
  19. Woven
  20. Zari
Price
Time to ship
  1. Within 1 Day
  2. Within 5 Days
  3. Within 7 Days
  4. Within 10 Days
  5. Within 15 Days
  6. Within 21 Days
  7. Within 25 Days
  8. Within 30 Days
Product Discount
  1. 20%-30%
  2. 40%-50%
Gender
  1. Female
  2. Girls
  3. Male
Readymade Size
  1. 7
  2. 8
  3. 9
  4. 10
  5. 11
  6. 12
  7. 13
  8. 32
  9. 34
  10. 36
  11. 38
  12. 40
  13. 42
  14. 44
  15. 46
  16. 48
  17. 50
  18. 52
Customizable Size
  1. 32
  2. 34
  3. 36
  4. 38
  5. 40
  6. 42
  7. 44
Tailoring Options
  1. Readymade
  2. Semi Stitched
  3. Customizable/Fabric
FILTER
Now Shopping by
  1. Occasion
    Wedding
  2. Work
    Sequins
  3. Time to ship
    Within 1 Day
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Plunge Neck
  3. Anarkali
  4. Abaya Style
  5. Pakistani
  6. Palazzo Suits
  7. Pant Suits
  8. Printed
  9. Sharara Suits
  10. Angrakha Style
  11. Straight Cut
  12. Suits with Slit
  13. Bollywood
  14. Jacket Style
  15. Heavy Border
  16. Heavy Sleeves
  17. Heavy Yoke
  18. Sherwani
  19. Kurti Style Lehenga
  20. Heavy Blouse
  21. Asymmetric
  22. Classic Style
  23. Dhoti with Sherwani
  24. Contemporary
Occasion
  1. Festive
  2. Bridesmaid Lehenga
  3. Wedding
  4. Reception
  5. Engagement
  6. Mehendi
  7. Sangeet
  8. Bridal
  9. Party
  10. Cocktail
  11. Casual
  12. Groom
  13. Bridesmaid
Fabric
  1. Art Silk
  2. Chiffon
  3. Georgette
  4. Net
  5. Organza
  6. Tussar Silk
  7. Velvet
Work
  1. Chikankari Work
  2. Bandhej
  3. Beads Work
  4. Cut Beads
  5. Digital Print
  6. Dori
  7. Embroidered
  8. Floral Print
  9. Gota Patti
  10. Hand Work
  11. Lace
  12. Mirror Work
  13. Patch Border
  14. Plain
  15. Resham Work
  16. Sequins
  17. Stone Work
  18. Thread
  19. Woven
  20. Zari
Price
Time to ship
  1. Within 1 Day
  2. Within 5 Days
  3. Within 7 Days
  4. Within 10 Days
  5. Within 15 Days
  6. Within 21 Days
  7. Within 25 Days
  8. Within 30 Days
Product Discount
  1. 20%-30%
  2. 40%-50%
Gender
  1. Female
  2. Girls
  3. Male
Readymade Size
  1. 7
  2. 8
  3. 9
  4. 10
  5. 11
  6. 12
  7. 13
  8. 32
  9. 34
  10. 36
  11. 38
  12. 40
  13. 42
  14. 44
  15. 46
  16. 48
  17. 50
  18. 52
Customizable Size
  1. 32
  2. 34
  3. 36
  4. 38
  5. 40
  6. 42
  7. 44
Tailoring Options
  1. Readymade
  2. Semi Stitched
  3. Customizable/Fabric
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.