Men > Shirts > T-Shirts

Menís T-Shirts
Grey Steson Western Goods Screen Print Stetson Men's T-shirt Collecti

$29.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.


Comfort T-Shirt
Stetson Western Goods Screen Printed Design

Style #11-076-0562-0733GY    Product #12245



update product_parents set vendorinventorywhen = now() where parentid = '12245'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís T-Shirts
Color: Grey
Style #: 11-076-0562-0733GY
Product #: 12245
Short URL:

brand: stetson   View more from Stetson brand.





refine 2015-01-16 < 2015-01-24

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


View All Categories


Stay in touch: