Women > Shirts > Sleeveless

Women’s Sleeveless
White 6793 Cotton Gauze Cami Stetson Ladies Collection- Summer I Group

$55.95

Stetson Pretty Wide Strap Cami In Cream Gauze
Contrasting Binding & Straps
Embroidery On Fronts
Smocked Waistline Creates A Slight Baby Doll Style
Dome Pearl Buttons Down Front

Style #11-052-0565-0416WH    Product #2826



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

Karmin Importing...

2: xs - nodim = 0

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: White
Style #: 11-052-0565-0416WH
Product #: 2826
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-10-13 < 2014-10-16

insert into refine_assignments set parentprodid = '30613', parentid = '2826', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '30613', parentid = '2826', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '30613', parentid = '2826', refine_attributeid = '25', refine_categoryid = '5'



Stay in touch: