Women > Shirts > Long Sleeve

Women’s Long Sleeve
Blue 6990 Navy Jersey L/s Knit Stetson Ladies Collection- Fall I Group

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


Stetson A Basic T-Shirt Is Dressed Up With Lavish Crewel Embroidery
3/4 Sleeve
Pretty Scoop Neck
1 Point Back Yoke
Scroll And Floral Crewel Embroidery Surrounds The Front & Back Neckline

Style #11-038-0513-0603BU    Product #1868

View more: Western Shirts



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Blue
Style #: 11-038-0513-0603BU
Product #: 1868
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-12-09 < 2014-12-11

insert into refine_assignments set parentprodid = '25858', parentid = '1868', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '25858', parentid = '1868', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: