Category: Women > Shirts > Long Sleeve

Women’s Long Sleeve Red Salsa Ombre Tin Haul Collection $49.95 Category: Women’s Long Sleeve Tin Haul Ladies Long Sleeve Western Shirt Btn Front 1 Point. Curved Back Yoke Emb. Logo On Pocket Flap Purple Topstitching & Btn Holes 1 Btn Mitered Edge Cuff Front & Back Darts Long & Lean Body Garment Washed >>> Click here to check current inventory Style Number: 10-050-0062-0730RE Product Number: #6864 We're sorry. This product is currently out of stock. Notify me when you have my size in stock! More in stock: end of September 2012 Brand: View more from Tin Haul update product_parents set vendorinventorywhen = now() where parentid = '6864'checking inventory... Opening connection to Karman, Inc... Automatically checking vendor inventory... Next Delivery: 09/2012 update product_parents set nextdelivery = '20120920' where parentid = '6864' 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 2: m - nodim = 0 2: l - nodim = 0 2: xl - nodim = 0 TIQ 0 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '0' and parentid='6864' update product_parents set vendorinventory = '0', vendorinventorywhen=now() where parentid='6864'

refine 2012-05-11 < 2012-05-18

insert into refine_assignments set parentprodid = '0', parentid = '6864', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '6864', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '6864', refine_attributeid = '23', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '6864', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '6864', refine_attributeid = '21', refine_categoryid = '5'