Women > Shirts > Short Sleeve

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

$47.95

Note: This product is in high demand, please allow extra time for delivery.


Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


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



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-12-10 < 2014-12-11

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'


View All Categories


Stay in touch: