Category: Men > Shirts > Long Sleeve

Men’s Long Sleeve Blue Circles Foulard Print On Poplin 8104 Stetson Men’s Collection- Fall I $59.95 Category: Men’s Long Sleeve Foulard Print On Cotton Poplin Fancy Front & Back Yokes Featuring Triple Needle Stitching Stetson "S" Emb "Stetson" Emb On Rt. Sleeve Placket Contrast Inside Trim 2 Snap Cuff Classic Snap Front Featuring Logo Snaps Color: Blue >>> Click here to check current inventory Style Number: 11-001-0425-0702BU Product Number: #6473 We're sorry. This product is currently out of stock. Notify me when you have my size in stock! More in stock: end of July 2012 Brand: View more from Stetson update product_parents set vendorinventorywhen = now() where parentid = '6473'checking inventory... Opening connection to Karman, Inc... Automatically checking vendor inventory... Next Delivery: 07/2012 update product_parents set nextdelivery = '20120720' where parentid = '6473' 1: s - nodim = 0 1: m - nodim = 0 1: l - nodim = 0 1: xl - nodim = 0 1: 2xl - nodim = 0 1: 3xl - nodim = 0 Karmin Importing... 2: s - nodim = 0 2: m - nodim = 0 2: l - nodim = 0 2: xl - nodim = 0 2: 2xl - nodim = 0 2: 3xl - nodim = 0 TIQ 0 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '0' and parentid='6473' update product_parents set vendorinventory = '0', vendorinventorywhen=now() where parentid='6473'

refine 2012-05-10 < 2012-05-16

insert into refine_assignments set parentprodid = '0', parentid = '6473', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '0', parentid = '6473', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '0', parentid = '6473', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '6473', refine_attributeid = '29', refine_categoryid = '5'

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