SIGN IN
If you are not registered with Darveys.com, a Member’s Exclusive Website, become a lifetime Darveys Member with a onetime fee of ₹2000.
GET NOTIFIED
We will notify you once this item comes back in stock.
THANK YOU
We will notify you once this item comes back in stock.
But Wait Before You Leave!
We have some amazing items waiting for you at Upto 60% Off on your favorite Designer.
Please enter your VIP Code for early access.
Tory Burch Flats
Buy Tory Burch Flats Online in India
SELECT `e`.`entity_id`,
matrix_cron.sort_order as custom_sort,
`e`.`type_id`,
`e`.`is_kids_product`,
`e`.`name`,
`e`.`sku`,
`e`.`price`,
`e`.`special_price`,
`e`.`special_from_date`,
`e`.`special_to_date`,
`e`.`manufacturer_value`,
`e`.`small_image`,
`e`.`news_from_date`,
`e`.`news_to_date`,
`e`.`url_path`,
`e`.`default_sort_value`,
`e`.`luxe`,
`e`.`luxe_value`,
`e`.`stock_status`,
`e`.`discount_percent`
FROM `darveyscatalog_product_flat_1` AS `e`
INNER JOIN `darveyscatalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id
INNER JOIN `darveyscatalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id INNER JOIN `darveysvss_matrix_cron_test` AS `matrix_cron` ON matrix_cron.product_id=e.entity_id INNER JOIN `darveyscatalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id) AND (at_category_id.category_id IN(375)) WHERE 1
AND cat_index.store_id=1
AND cat_index.visibility IN(2,4)
AND cat_index.category_id = '375'
AND price_index.website_id = '1'
AND price_index.customer_group_id = '1'
AND matrix_cron.attribute_set_id = 10 AND e.visibility = '4' AND e.manufacturer_value = 'TORY BURCH' group by e.entity_id ORDER BY custom_sort ASC limit 48
Buy Tory Burch Flats Online in India
