Men > Shirts > T-Shirts

Menís T-Shirts
Navy Stetson Allover Logo Screen Print

$29.95

Stetson BLUE 2nd

Style #11-076-0562-0713BU    Product #8947



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 2xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís T-Shirts
Color: Navy
Style #: 11-076-0562-0713BU
Product #: 8947
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-11-30 < 2014-12-14

insert into refine_assignments set parentprodid = '0', parentid = '8947', refine_attributeid = '9', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '8947', refine_attributeid = '22', refine_categoryid = '5'


View All Categories


Stay in touch: