Women > Shirts > Short Sleeve

Women’s Short Sleeve
Blue 6701 Glass Ombre Plaid S/s Shirt Stetson Ladies Collection- Spring I Group

$47.95

Stetson Pretty New Short Sleeve Plaid Shirt
Slight Puff Sleeve Has Binding & Button Opening
Bias Body For A Slim Look
Pearl Dome Buttons In Groups Of 2
Open Neck With Stitched-Down Facing
Inset Waistband For Definition

Style #11-051-0597-0210BU    Product #3333



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: s - nodim = 0

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

2: m - nodim = 0

2: l - nodim = 0

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

2: xl - nodim = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Short Sleeve
Color: Blue
Style #: 11-051-0597-0210BU
Product #: 3333
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-09-14 < 2014-09-25

insert into refine_assignments set parentprodid = '32335', parentid = '3333', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '32335', parentid = '3333', refine_attributeid = '43', refine_categoryid = '6'



Stay in touch: