Category: Men > Shirts > Long Sleeve

Men’s Long Sleeve 6511 Pullover Sweater - Green Stetson Men’s Collection-fall Ii $74.95 Category: Men’s Long Sleeve Pull-Over Sweater W/Zipper At The Neck One Pocket & Flap With Mitered Edges Front Placket & Pocket Made Of Washed Twill In Coordinating Color "Stetson" Embroidery On Collar Band 100% Cotton Great Layering Piece Color: Green >>> Click here to check current inventory Style Number: 11-014-0120-0653GR Product Number: #788 We're sorry. This product is currently out of stock. Notify me when you have my size in stock! Brand: View more from Stetson update product_parents set vendorinventorywhen = now() where parentid = '788'checking inventory... Opening connection to Karman, Inc... Automatically checking vendor inventory... 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 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '13458' 2: m - nodim = 0 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '15225' 2: l - nodim = 0 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '15226' 2: xl - nodim = 0 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '15227' 2: 2xl - nodim = 0 update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '15228' 2: 3xl - nodim = 0 TIQ 0 update products set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where prodid = '13458' and parentid='788' update product_parents set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where parentid='788'

refine 2012-05-10 < 2012-05-14

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '14', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '19', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '13458', parentid = '788', refine_attributeid = '20', refine_categoryid = '5'