Purple Carribean Paisley 9154 Stetson Men's Collection- Summ

$54.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.


Paisley Print On Cotton Poplin
1 Point Curved Back Yoke
Stetson "S" Emb
2 Point Curved Pocket Flaps
Contrast Inside Trim
Snap Front Featuring Logo Snaps

Style #11-002-0425-0430PU    Product #14222



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 1

1: m - nodim = 1

1: l - nodim = 6

1: xl - nodim = 0

1: 2xl - nodim = 0

1: 3xl - nodim = 0

Karmin Importing...

2: s - nodim = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '106850'

2: m - nodim = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '106851'

2: l - nodim = 6

update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '106852'

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

2: 3xl - nodim = 0

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

TIQ 8

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

 

We are currently gathering reviews for this product.


Category:
Color: Purple
Style #: 11-002-0425-0430PU
Product #: 14222
Short URL:

brand: stetson   View more from Stetson brand.




refine 2014-10-23 < 2014-10-24

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '60', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '29', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '14222', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: