Women > Shirts > Sleeveless

Women’s Sleeveless
Green 6797 Dillon Paisley S/l Shirt Stetson Ladies Collection- Summer Ii Group

$44.95

Stetson New Details On This Sleeveless Western Shirt
New Front & Back Pieced Yokes W/Detail Stitch
Open Rounded Pockets W/Darted Bottom
Classic Pearl Snaps
Logo Embroidery On Front Placket

Style #11-052-0590-0421GR    Product #1005



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: Green
Style #: 11-052-0590-0421GR
Product #: 1005
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-09-16 < 2014-09-24

insert into refine_assignments set parentprodid = '15631', parentid = '1005', refine_attributeid = '60', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '15631', parentid = '1005', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '15631', parentid = '1005', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '15631', parentid = '1005', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '15631', parentid = '1005', refine_attributeid = '21', refine_categoryid = '5'



Stay in touch: