Men > Shirts > Long Sleeve

Menís Long Sleeve
Blue Big Paisley Print On Poplin Gmt Wshd Stetson Men’s Collection- Summer I

$64.95

Paisley Print On Cotton Poplin
1 Point. Front And 2 Point. Back Yokes
Stetson "S" Emb
"Stetson" Emb On Rt. Sleeve Placket
3 Snap Cuff
Contrast Inside Trim
Classic Snap. Front Featuring Logo Snaps

Style #11-001-0425-0515BU    Product #2318



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 2xl - nodim = 0

1: 3xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

2: 3xl - nodim = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís Long Sleeve
Color: Blue
Style #: 11-001-0425-0515BU
Product #: 2318
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-21 < 2014-08-25

insert into refine_assignments set parentprodid = '29234', parentid = '2318', refine_attributeid = '60', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '29234', parentid = '2318', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '29234', parentid = '2318', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '29234', parentid = '2318', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29234', parentid = '2318', refine_attributeid = '29', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29234', parentid = '2318', refine_attributeid = '21', refine_categoryid = '5'



Stay in touch: