Women > Shirts > Long Sleeve

Women’s Long Sleeve
White 7544 Solid Lawn Shirt Stetson Ladies Collection- Fall I

$69.95

Stetson Tonal Embroidery Dresses Up This Classic White Western Shirt
1 Point Frt Yoke
Deep 1 Point Back Yoke
1 Point Pkts/Flaps
Tonal Crewel Embroidery On Yokes & Cuffs
Logo Pearl Snaps
Single Needle Topstitching For A Clean Look

Style #11-050-0565-0617WH    Product #3525



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Style #: 11-050-0565-0617WH
Product #: 3525
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-06 < 2014-08-13

insert into refine_assignments set parentprodid = '32656', parentid = '3525', refine_attributeid = '1', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '32656', parentid = '3525', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '32656', parentid = '3525', refine_attributeid = '8', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '32656', parentid = '3525', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '32656', parentid = '3525', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '32656', parentid = '3525', refine_attributeid = '21', refine_categoryid = '5'