Women > Shirts > Sleeveless

Women’s Sleeveless
Blue 7239 Indigo Chambray Slvless Dress Stetson Ladies Collection- Spring Iii

$78.95

Stetson Sweet Chambray Shirt Dress Looks Great Alone, With Skinny Jeans Or Leggings
Stand Collar
Pintucks And Inset Embroidered Panels At Front
Slight Shirt Tail Hem
Self Tie In Back
Self-Covered Buttons In Groups Of 3

Style #11-057-0565-0256BU    Product #2820



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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 = '36507'

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: Blue
Style #: 11-057-0565-0256BU
Product #: 2820
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-10-07 < 2014-10-16

insert into refine_assignments set parentprodid = '30607', parentid = '2820', refine_attributeid = '6', refine_categoryid = '3'



Stay in touch: