Women > Shorts

Womenís Shorts
Blue Boyfriend Fit With Frayed Hem Stetson Ladies Collection- Summer I

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


A Short Fit For Everyone
Boyfriend Fit With Raw Edge Hem
Aztec Embroidery Down Side Seams Give A Slim Look
1 Point Back Pockets
Stetson "S" Embroidery On Back Pockets
Logo Buttons
Hand Sanding

Style #11-055-0202-0474BU    Product #12729



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: O - nodim = 6

1: 2 - nodim = 2

1: 4 - nodim = 0

1: 6 - nodim = 2

1: 8 - nodim = 0

1: 10 - nodim = 2

1: 12 - nodim = 0

1: 14 - nodim = 0

1: 16 - nodim = 1

1: 18 - nodim = 3

Karmin Importing...

2: O - nodim = 6

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

2: 2 - nodim = 2

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

2: 4 - nodim = 0

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

2: 6 - nodim = 2

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

2: 8 - nodim = 0

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

2: 10 - nodim = 2

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

2: 12 - nodim = 0

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

2: 14 - nodim = 0

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

2: 16 - nodim = 1

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

2: 18 - nodim = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '107424'

TIQ 16

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

 

We are currently gathering reviews for this product.


Category: Womenís Shorts
Color: Blue
Style #: 11-055-0202-0474BU
Product #: 12729
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-09-13 < 2014-09-16

insert into refine_assignments set parentprodid = '0', parentid = '12729', refine_attributeid = '25', refine_categoryid = '5'

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

insert into refine_assignments set parentprodid = '0', parentid = '12729', refine_attributeid = '37', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '12729', refine_attributeid = '43', refine_categoryid = '6'



Stay in touch: