Women > Shirts > Short Sleeve

Women’s Short Sleeve
Blue Steson Script Nailhead Screen Stetson Ladies T-shirts

$29.95

Ladies Cotton Jersey T-Shirt
Crew Neck
Stetson Original Artwork

Style #11-039-0562-0708BU    Product #23



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Short Sleeve
Color: Blue
Style #: 11-039-0562-0708BU
Product #: 23
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-07 < 2014-08-14

insert into refine_assignments set parentprodid = '44387', parentid = '23', refine_attributeid = '17', refine_categoryid = '4'