Women > Shirts > Long Sleeve

Women’s Long Sleeve
Blue 7983 Fruit Paisley Printed Chiffon Stetson Ladies Collection- Summer Ii

$64.95

Stetson Soft Paisley Print On Crinkled Chiffon
Off Center Curved 1 Point Front Yokes & 2 Point Back Yoke
5 Snap Cuffs
Front And Back Darts
Pearl Logo Buttons

Style #11-050-0590-0430BU    Product #5951



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 1x - nodim = 0

1: 2x - nodim = 0

1: 3x - nodim = 0

Karmin Importing...

2: xs - nodim = 0

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 1x - nodim = 0

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

2: 2x - nodim = 0

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

2: 3x - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Blue
Style #: 11-050-0590-0430BU
Product #: 5951
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-09-11 < 2014-09-13

insert into refine_assignments set parentprodid = '46353', parentid = '5951', refine_attributeid = '60', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '46353', parentid = '5951', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '46353', parentid = '5951', refine_attributeid = '21', refine_categoryid = '5'



Stay in touch: