Men > Caps

Menís Caps
C1 Tin Haul Art Cap - Choc. Brown, Color:

$19.95

Tin Haul BROWN 2nd

Style #10-077-0501-0615BR    Product #4922



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: ppk - nodim = 0

Karmin Importing...

2: ppk - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís Caps
Style #: 10-077-0501-0615BR
Product #: 4922
Short URL:

brand: tin haul   View more from Tin Haul brand.

refine 2014-08-13 < 2014-08-14

insert into refine_assignments set parentprodid = '41225', parentid = '4922', refine_attributeid = '12', refine_categoryid = '3'