Please allow extra time for delivery of this product, roughly 5-10 extra business days. If you need it quicker, please call customer service at 832-369-6715.

New Ink Wash
Sits Low On The Waist
Slim Fit Thigh With Slightly Flared Leg
Tonal Decorative "S" Stitching On Back Pkts
Stetson Branded Buttons, Rivets And Zippers
Blasting and Whisker Details

Style #11-054-0816-0080BU    Product #2749

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

Opening connection to Karman, Inc...

Automatically checking vendor inventory....

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

1: OO - S = 7

1: OO - R = 10

1: OO - L = 16

1: OO - XL = 11

1: OO - 2X = 7

1: O - S = 16

1: O - R = 41

1: O - L = 31

1: O - XL = 34

1: O - 2X = 26

1: 2 - S = 21

1: 2 - R = 32

1: 2 - L = 42

1: 2 - XL = 13

1: 2 - 2X = 0

1: 4 - S = 22

1: 4 - R = 53

1: 4 - L = 59

1: 4 - XL = 30

1: 4 - 2X = 2

1: 6 - S = 13

1: 6 - R = 73

1: 6 - L = 77

1: 6 - XL = 16

1: 6 - 2X = 0

1: 8 - S = 21

1: 8 - R = 50

1: 8 - L = 52

1: 8 - XL = 19

1: 8 - 2X = 7

1: 10 - S = 38

1: 10 - R = 51

1: 10 - L = 72

1: 10 - XL = 11

1: 10 - 2X = 0

1: 12 - S = 19

1: 12 - R = 56

1: 12 - L = 60

1: 12 - XL = 17

1: 12 - 2X = 2

1: 14 - S = 13

1: 14 - R = 38

1: 14 - L = 43

1: 14 - XL = 8

1: 14 - 2X = 0

1: 16 - S = 10

1: 16 - R = 22

1: 16 - L = 25

1: 16 - XL = 10

1: 16 - 2X = 0

1: 18 - S = 10

1: 18 - R = 14

1: 18 - L = 17

1: 18 - XL = 2

1: 18 - 2X = 0

Karmin Importing...

2: OO - S = 7

update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '43223'

2: OO - R = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '43427'

2: OO - L = 16

update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '34284'

2: OO - XL = 11

update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '34903'

2: OO - 2X = 7

update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '43224'

2: O - S = 16

update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '67827'

2: O - R = 41

update products set vendorinventory = '41', vendorinventorywhen=now() where prodid = '68419'

2: O - L = 31

update products set vendorinventory = '31', vendorinventorywhen=now() where prodid = '61325'

2: O - XL = 34

update products set vendorinventory = '34', vendorinventorywhen=now() where prodid = '72333'

2: O - 2X = 26

update products set vendorinventory = '26', vendorinventorywhen=now() where prodid = '72334'

2: 2 - S = 21

update products set vendorinventory = '21', vendorinventorywhen=now() where prodid = '34285'

2: 2 - R = 32

update products set vendorinventory = '32', vendorinventorywhen=now() where prodid = '30513'

2: 2 - L = 42

update products set vendorinventory = '42', vendorinventorywhen=now() where prodid = '31075'

2: 2 - XL = 13

update products set vendorinventory = '13', vendorinventorywhen=now() where prodid = '34286'

2: 2 - 2X = 0

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

2: 4 - S = 22

update products set vendorinventory = '22', vendorinventorywhen=now() where prodid = '30514'

2: 4 - R = 53

update products set vendorinventory = '53', vendorinventorywhen=now() where prodid = '31076'

2: 4 - L = 59

update products set vendorinventory = '59', vendorinventorywhen=now() where prodid = '31583'

2: 4 - XL = 30

update products set vendorinventory = '30', vendorinventorywhen=now() where prodid = '36516'

2: 4 - 2X = 2

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

2: 6 - S = 13

update products set vendorinventory = '13', vendorinventorywhen=now() where prodid = '30515'

2: 6 - R = 73

update products set vendorinventory = '73', vendorinventorywhen=now() where prodid = '31077'

2: 6 - L = 77

update products set vendorinventory = '77', vendorinventorywhen=now() where prodid = '31584'

2: 6 - XL = 16

update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '35958'

2: 6 - 2X = 0

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

2: 8 - S = 21

update products set vendorinventory = '21', vendorinventorywhen=now() where prodid = '30516'

2: 8 - R = 50

update products set vendorinventory = '50', vendorinventorywhen=now() where prodid = '31078'

2: 8 - L = 52

update products set vendorinventory = '52', vendorinventorywhen=now() where prodid = '31079'

2: 8 - XL = 19

update products set vendorinventory = '19', vendorinventorywhen=now() where prodid = '31585'

2: 8 - 2X = 7

update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '43227'

2: 10 - S = 38

update products set vendorinventory = '38', vendorinventorywhen=now() where prodid = '30517'

2: 10 - R = 51

update products set vendorinventory = '51', vendorinventorywhen=now() where prodid = '31080'

2: 10 - L = 72

update products set vendorinventory = '72', vendorinventorywhen=now() where prodid = '31586'

2: 10 - XL = 11

update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '34288'

2: 10 - 2X = 0

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

2: 12 - S = 19

update products set vendorinventory = '19', vendorinventorywhen=now() where prodid = '30519'

2: 12 - R = 56

update products set vendorinventory = '56', vendorinventorywhen=now() where prodid = '31081'

2: 12 - L = 60

update products set vendorinventory = '60', vendorinventorywhen=now() where prodid = '31587'

2: 12 - XL = 17

update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '34289'

2: 12 - 2X = 2

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

2: 14 - S = 13

update products set vendorinventory = '13', vendorinventorywhen=now() where prodid = '30520'

2: 14 - R = 38

update products set vendorinventory = '38', vendorinventorywhen=now() where prodid = '31082'

2: 14 - L = 43

update products set vendorinventory = '43', vendorinventorywhen=now() where prodid = '31588'

2: 14 - XL = 8

update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '34290'

2: 14 - 2X = 0

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

2: 16 - S = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '30521'

2: 16 - R = 22

update products set vendorinventory = '22', vendorinventorywhen=now() where prodid = '31083'

2: 16 - L = 25

update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '31589'

2: 16 - XL = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '43230'

2: 16 - 2X = 0

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

2: 18 - S = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '30522'

2: 18 - R = 14

update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '30523'

2: 18 - L = 17

update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '45062'

2: 18 - XL = 2

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

2: 18 - 2X = 0

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

TIQ 1339

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