Category: Men > Shirts > Short Sleeve

Men’s Short Sleeve Roper 6754 Red Check Plaid Amarillo Collection- Red Valley Group $36.95 Category: Men’s Short Sleeve Men’s Short Sleeve Shirt Btn Dn Collar 1 Point Back Yoke W/Pleat & Locker Loop 2 One Point Pkts And Flaps Roper "R" Embroidery One Open Pkt Style Has Straight Back Yoke New Amarillo Fit Color: Red >>> Click here to check current inventory Style Number: 03-002-0378-0458RE Product Number: #2971 We're sorry. This product is currently out of stock. Notify me when you have my size in stock! Brand: View more from Roper update product_parents set vendorinventorywhen = now() where parentid = '2971'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 = '31758' 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() , vendorpermoos = 'y' where prodid = '31758' and parentid='2971' update product_parents set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where parentid='2971'

refine 2012-05-13 < 2012-05-17

insert into refine_assignments set parentprodid = '31758', parentid = '2971', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '31758', parentid = '2971', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '31758', parentid = '2971', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '31758', parentid = '2971', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '31758', parentid = '2971', refine_attributeid = '21', refine_categoryid = '5'