Women > Shirts > Short Sleeve

Women’s Short Sleeve
Tin Haul White Aa1593

$24.95

Note: This product is in high demand, please allow extra time for delivery.


Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


Tin Haul WHITE 2nd

Style #10-039-0501-0110WH    Product #400



update product_parents set vendorinventorywhen = now() where parentid = '400'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 2

1: m - nodim = 2

1: l - nodim = 5

1: xl - nodim = 4

Karmin Importing...

2: s - nodim = 2

update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '13038'

2: m - nodim = 2

update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '13742'

2: l - nodim = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '13743'

2: xl - nodim = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '13744'

TIQ 13

update product_parents set vendorinventorywhen=now(), vendorpermoos = '' where parentid='400'

 

We are currently gathering reviews for this product.


Category: Women’s Short Sleeve
Style #: 10-039-0501-0110WH
Product #: 400
Short URL:

brand: tin haul   View more from Tin Haul brand.

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

insert into refine_assignments set parentprodid = '13038', parentid = '400', refine_attributeid = '8', refine_categoryid = '3'