Women > Shirts > Short Sleeve

Women’s Short Sleeve
Orange Barrel Racer Screen Print Stetson Ladies Collection

$29.95

Add to Cart

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


Stetson Barrel Racer Screen Print
Cotton/Poly Burnout Short Sleeve T-Shirt
Garment Dyed And Washed For A Super Soft Hand
Rib Collar And Reinforced Shoulders For Durability

Style #11-039-0562-0074OR    Product #3324



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Short Sleeve
Color: Orange
Style #: 11-039-0562-0074OR
Product #: 3324
Short URL:

brand: stetson   View more from Stetson brand.





refine 2015-02-25 < 2015-02-26

insert into refine_assignments set parentprodid = '32326', parentid = '3324', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '32326', parentid = '3324', refine_attributeid = '22', refine_categoryid = '5'


View All Categories


Stay in touch: