Women > Shirts > Sleeveless

Women’s Sleeveless
7333 Solid Purple Jersey Cap Slv Dress Stetson Ladies Collection- Summer Ii

$89.95

Stetson Stunning Dress In Rich Purple Jersey
Sexy Deep V-Neck
Lavish Crewel Embroidery On Front & Back
Cap Sleeve
Smocking On Back Waist
Front & Back Princess Seams For A Flattering Fit

Style #11-057-0513-0436PU    Product #2834



We're sorry. This product is currently out of stock.

Notify me when you have my size in stock!

update product_parents set vendorinventorywhen = now() where parentid = '2834'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

update product_parents set nextdelivery = '' where parentid = '2834'

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

Karmin Importing...

2: xs - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '52456'

2: s - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '30621'

2: m - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '41210'

2: l - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '41211'

2: xl - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '41212'

TIQ 0

update products set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where prodid = '30621' and parentid='2834'

update product_parents set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where parentid='2834'

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Style #: 11-057-0513-0436PU
Product #: 2834
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-11 < 2014-08-13

insert into refine_assignments set parentprodid = '30621', parentid = '2834', refine_attributeid = '1', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '30621', parentid = '2834', refine_attributeid = '25', refine_categoryid = '5'