Women > Shirts > Long Sleeve

Women’s Long Sleeve
Black 7159 Overprinted Plaid Shirt Stetson Ladies Collection- Winter I Group

$55.95

Stetson Cool New Overprinted Plaid Fabric
Classic Western Yokes & Pockets Jazzed Up With Contrast Stitching
4 Snap Cuff
Velvet Trim On Side Seams, Inside Front Placket & Inside Collarband For Added Detail
Logo Embroidery Inside Cuff

Style #11-050-0597-0101BL    Product #2000



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Black
Style #: 11-050-0597-0101BL
Product #: 2000
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-29 < 2014-09-14

insert into refine_assignments set parentprodid = '26456', parentid = '2000', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '26456', parentid = '2000', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '26456', parentid = '2000', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '26456', parentid = '2000', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '26456', parentid = '2000', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '26456', parentid = '2000', refine_attributeid = '21', refine_categoryid = '5'



Stay in touch: