Loading...

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.

    • Wrong Email or Password.

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.

THEORY

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_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = 1 AND manufacturer_idx.value in (3130) WHERE 1 AND cat_index.store_id=1 AND cat_index.visibility IN(2,4) AND cat_index.category_id = '530' AND price_index.website_id = '1' AND price_index.customer_group_id = '1' AND matrix_cron.is_collection = '0' And matrix_cron.category_id = 530 AND `e`.`stock_status`=1 group by e.entity_id ORDER BY custom_sort ASC limit 48
SORT BY
  1. 1
  2. 2

Theory Navy Rib Neck Silk Top

Theory

Navy Rib Neck Silk Top

Regular Price: 31,500

Special Price 19,950

(37% OFF)
0
Theory Black Striped Sleeveless Top

Theory

Black Striped Sleeveless Top

Regular Price: 22,000

Special Price 12,950

(42% OFF)
0
Theory Black One-Shoulder Sweater

Theory

Black One-Shoulder Sweater

Regular Price: 38,500

Special Price 24,950

(36% OFF)
0
Theory Grey Ribbed Tiny T-Shirt

Theory

Grey Ribbed Tiny T-Shirt

Regular Price: 25,500

Special Price 12,950

(50% OFF)
0
Theory White Vest Silk Shirt

Theory

White Vest Silk Shirt

Regular Price: 29,500

Special Price 13,950

(53% OFF)
0
Theory Light Pink Classic Straight Blouse

Theory

Light Pink Classic Straight Blouse

Regular Price: 31,500

Special Price 17,950

(44% OFF)
0
Theory Black Mockneck Silk Shell

Theory

Black Mockneck Silk Shell

Regular Price: 30,000

Special Price 18,950

(37% OFF)
0
Theory Black Folded Drape Silk Top

Theory

Black Folded Drape Silk Top

Regular Price: 30,000

Special Price 18,950

(37% OFF)
0
Theory Pink Ruffle Stretch-Silk Shell

Theory

Pink Ruffle Stretch-Silk Shell

Regular Price: 26,500

Special Price 19,950

(25% OFF)
0
Theory Blue Mouline Ribbed Knit Long Sleeve Top

Theory

Blue Mouline Ribbed Knit Long Sleeve Top

Regular Price: 30,500

Special Price 22,950

(25% OFF)
0
Theory Beige Drawstring Hoodie

Theory

Beige Drawstring Hoodie

Regular Price: 27,000

Special Price 18,950

Flash Sale
0
Theory Blue Straight Leg Ruched Rolled Sleeve Jumpsuit

Theory

Blue Straight Leg Ruched Rolled Sleeve Jumpsuit

Regular Price: 45,500

Special Price 22,950

(50% OFF)
0
Theory Brown Belted Cargo Jumpsuit

Theory

Brown Belted Cargo Jumpsuit

Regular Price: 43,500

Special Price 28,950

(34% OFF)
0
Theory Pink Classic Straight Blouse

Theory

Pink Classic Straight Blouse

Regular Price: 29,500

Special Price 17,950

(40% OFF)
0
Theory White Cropped Button Down Blouse

Theory

White Cropped Button Down Blouse

Regular Price: 28,500

Special Price 17,950

(38% OFF)
0
Theory White Trapeze Shirt

Theory

White Trapeze Shirt

Regular Price: 28,500

Special Price 19,950

(30% OFF)
0
Theory Black Silk Abstract-Print Shirt

Theory

Black Silk Abstract-Print Shirt

Regular Price: 32,000

Special Price 22,950

(29% OFF)
0
Theory Brown Pull On Ankle Pants

Theory

Brown Pull On Ankle Pants

Regular Price: 17,500

Special Price 9,950

(44% OFF)
0
Theory Blue Silk Wide Leg Pants

Theory

Blue Silk Wide Leg Pants

Regular Price: 42,500

Special Price 24,950

(42% OFF)
0
Theory Black Boatneck Ribbed Sweater

Theory

Black Boatneck Ribbed Sweater

Regular Price: 43,500

Special Price 28,950

(34% OFF)
0
Theory Olive Ladder Trim Pullover

Theory

Olive Ladder Trim Pullover

Regular Price: 24,000

Special Price 16,950

(30% OFF)
0
Theory Off White Chunky Knit Pullover

Theory

Off White Chunky Knit Pullover

Regular Price: 32,000

Special Price 24,950

Runway
0
Theory White Overlay Mesh Pullover

Theory

White Overlay Mesh Pullover

Regular Price: 28,000

Special Price 22,950

In Spotlight
0
Theory Light Grey Wool Sweater

Theory

Light Grey Wool Sweater

Regular Price: 24,500

Special Price 18,950

In Spotlight
0
Theory Navy Blue Cashmere Sweater

Theory

Navy Blue Cashmere Sweater

Regular Price: 34,000

Special Price 25,950

Editor's Pick
0
Theory Light Blue V-Neck Pullover

Theory

Light Blue V-Neck Pullover

Regular Price: 36,000

Special Price 26,950

(26% OFF)
0
Theory Red Long-Sleeve T-Shirt

Theory

Red Long-Sleeve T-Shirt

Regular Price: 43,500

Special Price 28,950

(34% OFF)
0
Theory Red Space Dye Rib Cardigan

Theory

Red Space Dye Rib Cardigan

Regular Price: 43,500

Special Price 28,950

(34% OFF)
0
Theory Olive Irving Button-Front Shirt

Theory

Olive Irving Button-Front Shirt

Regular Price: 30,000

Special Price 18,950

(37% OFF)
0
Theory Navy Blue Standard-Fit Short-Sleeve Shirt

Theory

Navy Blue Standard-Fit Short-Sleeve Shirt

Regular Price: 25,000

Special Price 16,950

(33% OFF)
0
Theory Navy Blue Striped Polo Midi-Dress

Theory

Navy Blue Striped Polo Midi-Dress

Regular Price: 38,000

Special Price 29,950

Editor's Pick
0
Theory Black Cosmos Essential Jersey T-Shirt

Theory

Black Cosmos Essential Jersey T-Shirt

Regular Price: 23,500

Special Price 15,950

(33% OFF)
0
Theory Blue Striped A-Line Shirtdress

Theory

Blue Striped A-Line Shirtdress

Regular Price: 37,500

Special Price 26,950

(29% OFF)
0
Theory White Short Sleeve Trapeze Dress

Theory

White Short Sleeve Trapeze Dress

Regular Price: 39,500

Special Price 26,950

(32% OFF)
0
Theory White Striped Ribbed Midi Dress

Theory

White Striped Ribbed Midi Dress

Regular Price: 26,500

Special Price 19,950

(25% OFF)
0
Theory Beige Cashmere Pullover

Theory

Beige Cashmere Pullover

Regular Price: 32,500

Special Price 21,950

(33% OFF)
0
Theory Black Slim Tweed Moto Jacket

Theory

Black Slim Tweed Moto Jacket

Regular Price: 59,500

Special Price 42,950

(28% OFF)
0
Theory Black Open-Front Jacket

Theory

Black Open-Front Jacket

Regular Price: 64,000

Special Price 52,950

In Spotlight
0

Filter By

Gender

Designer

Type

Clothing Type

Size

Clothing Size

Discount

Color

Price

methods:
    • Contact Us
    Contact us 1800-212-0085
    Email: assistance@darveys.com
    copyright @ 2019 darveys.com

    Darveys.com is best experienced in the portrait mode.

    Please Rotate your screen.