Women > Boots

Women’s Boots
Yellow Hand Tinted Lemon Vamp/shaft, Snip Toe Stetson Ladies Boots

$229.95

Stetson HAND TINTED LEMON VAMP/SHAFT, SNIP TOE
BLACK LOW STACKED HEEL & OUTSOLE

Style #12-021-6104-0581YE    Product #1565



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: 5 - B = 0

1: 5.5 - B = 0

1: 6 - B = 0

1: 6.5 - B = 0

1: 7 - B = 0

1: 7.5 - B = 0

1: 8 - B = 0

1: 8.5 - B = 0

1: 9 - B = 0

1: 9.5 - B = 0

1: 10 - B = 0

1: 10.5 - B = 0

1: 11 - B = 0

Karmin Importing...

2: 5 - B = 0

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

2: 5.5 - B = 0

2: 6 - B = 0

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

2: 6.5 - B = 0

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

2: 7 - B = 0

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

2: 7.5 - B = 0

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

2: 8 - B = 0

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

2: 8.5 - B = 0

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

2: 9 - B = 0

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

2: 9.5 - B = 0

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

2: 10 - B = 0

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

2: 10.5 - B = 0

2: 11 - B = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Boots
Color: Yellow
Style #: 12-021-6104-0581YE
Product #: 1565
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-10 < 2014-08-15

insert into refine_assignments set parentprodid = '23743', parentid = '1565', refine_attributeid = '7', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '23743', parentid = '1565', refine_attributeid = '41', refine_categoryid = '5'



Stay in touch: