Women > Shirts > Short Sleeve

Women’s Short Sleeve
Grey Tin Haul Heart And Arrows Print Tin Haul Ladies T-shirts

$26.95

Soft Comfy Crew Neck T-shirt
Tin Haul Aztec Heart Screen Print

Style #10-039-0501-0201GY    Product #13193

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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Short Sleeve
Color: Grey
Style #: 10-039-0501-0201GY
Product #: 13193
Short URL:

brand: tin haul   View more from Tin Haul brand.





refine 2016-04-27 < 2016-04-28

insert into refine_assignments set parentprodid = '0', parentid = '13193', refine_attributeid = '22', refine_categoryid = '5'


View Homepage


Stay in touch: