Women > Shirts > Long Sleeve

Women’s Long Sleeve
Green 6798 Sunset Plaid 3/4 Slv Shirt Stetson Ladies Collection- Summer Ii Group

$49.95

Stetson Fun To Wear In Stunning Turquoise Plaid Lawn
3/4 Sleeve Shirt
Empire Waist
Open Neck With Ruffle and Tie
Ruffled Cuff
Very Flattering Fit
Bias Details

Style #11-050-0597-0420GR    Product #3562



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Green
Style #: 11-050-0597-0420GR
Product #: 3562
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-10-11 < 2014-10-15

insert into refine_assignments set parentprodid = '32693', parentid = '3562', refine_attributeid = '2', refine_categoryid = '1'



Stay in touch: