Women > Shirts > Sleeveless

Women’s Sleeveless
Brown 7988 Cocoa Heather Jersey Sun Dress Stetson Ladies Collection- Summer I

$69.95

Stetson Delightful Knit Sundress Is Easy To Wear For Summer Fun
Subtle Cocoa Heather Jersey
Colorful Crewel Embroidery On Bodice And Skirt
Elastic Smocking On Bodice And Waist
Adjustable Straps
Flowing Skirt

Style #11-057-0513-0404BR    Product #6053

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 = '6053'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 1x - nodim = 0

1: 2x - nodim = 0

1: 3x - nodim = 0

Karmin Importing...

2: xs - nodim = 0

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 1x - nodim = 0

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

2: 2x - nodim = 0

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

2: 3x - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: Brown
Style #: 11-057-0513-0404BR
Product #: 6053
Short URL:

brand: stetson   View more from Stetson brand.





refine 2015-04-17 < 2015-04-19

insert into refine_assignments set parentprodid = '0', parentid = '6053', refine_attributeid = '25', refine_categoryid = '5'


View All Categories


Stay in touch: