Urban Western Wear

My Account | Coupons    

  

cart

buy an UrbanWesternClothing.com gift card Gift Cards Available

Invitations

You have five friend invitations remaning.

Click here

 

Category: Women > Shirts > Long Sleeve

Women’s Long Sleeve
Green 7162 Cross Dye Shimmer Shirt Ladies Stetson Collection- Winter Ii Group
$48.95


brand: stetson


Category: Women’s Long Sleeve
Rich Teal Cotton/Nylon Blend With A Subtle Shimmer
1 Point Curved Yokes & Flaps
4 Snap Cuff
Contrasting Triple Needle Stitching For Added Detail
Tonal Pearl Snaps
Stetson Embroidery On Hemline

Color: Green





Style Number: 11-050-0565-0126GR
Product Number: #2005


We're sorry. This product is currently out of stock.


Notify me when you have my size in stock!


brand: stetson
Brand: View more from Stetson


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

Opening connection to Karman, Inc...

Automatically checking vendor inventory...

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 1x - nodim = 0

2: 2x - nodim = 0

2: 3x - nodim = 0

TIQ 0

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

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

refine 2012-05-13 < 2012-05-14

insert into refine_assignments set parentprodid = '26461', parentid = '2005', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '26461', parentid = '2005', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '26461', parentid = '2005', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '26461', parentid = '2005', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '26461', parentid = '2005', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '26461', parentid = '2005', refine_attributeid = '21', refine_categoryid = '5'

Item Added to Cart

You successfully added an item to your cart.




updated Monday, May 21, 2012
© Copyright 2010-2012, Urban Western Wear. All rights reserved.
Photos, imagery and any other information from this site may not be used without prior written consent.

 

   THANK YOU FOR VISITING OUR SITE!