Urban Western Wear

My Account | Coupons    

  

cart


buy an UrbanWesternClothing.com gift card Gift Cards Available

Invitations

You have five friend invitations remaning.

Click here

 

Category: Women > Shirts > Long Sleeve


Women’s Long Sleeve
Roper Red 8052 Floral Burnout Jersey Dress Studio West- Hidden Garden

$64.95


brand: roper


Category: Women’s Long Sleeve
Roper Feminine Empire Waist Dress In A Pretty Floral Burnout Jersey
Flattering Scoop Neckline With Shirred Bodice
Sleeves Are Embellished With Sparkly Rhinestud Swirls
36" Length From Shoulder
Body Of Dress Is Lined
Sleeves Are Sheer





Style Number: 03-057-0513-0529RE
Product Number: #5956


We're sorry. This product is currently out of stock.


Notify me when you have my size in stock!


brand: roper
Brand: View more from Roper


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

Opening connection to Karman, Inc...


Automatically checking vendor inventory...

1: xs - nodim = 32

1: s - nodim = 57

1: m - nodim = 75

1: l - nodim = 78

1: xl - nodim = 42

Karmin Importing...

2: xs - nodim = 32

insert into products set internalid='xs1337903667', size = 'xs', int_size2 = 'xs', altsize='', int_altsize='', vendorinventory = '32', vendorinventorywhen=now(), parentid = '5956', autocreated = 'y', color='red', singlepriceamt = '64.95'

2: s - nodim = 57

update products set vendorinventory = '57', vendorinventorywhen=now() where prodid = '46358'

2: m - nodim = 75

insert into products set internalid='m1337903667', size = 'm', int_size2 = 'm', altsize='', int_altsize='', vendorinventory = '75', vendorinventorywhen=now(), parentid = '5956', autocreated = 'y', color='red', singlepriceamt = '64.95'

2: l - nodim = 78

insert into products set internalid='l1337903667', size = 'l', int_size2 = 'l', altsize='', int_altsize='', vendorinventory = '78', vendorinventorywhen=now(), parentid = '5956', autocreated = 'y', color='red', singlepriceamt = '64.95'

2: xl - nodim = 42

insert into products set internalid='xl1337903667', size = 'xl', int_size2 = 'xl', altsize='', int_altsize='', vendorinventory = '42', vendorinventorywhen=now(), parentid = '5956', autocreated = 'y', color='red', singlepriceamt = '64.95'

TIQ 284

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

refine 2012-05-16 < 2012-05-17

insert into refine_assignments set parentprodid = '46358', parentid = '5956', refine_attributeid = '6', refine_categoryid = '3'

Item Added to Cart

You successfully added an item to your cart.





updated Thursday, May 24, 2012
© Copyright 2010-2012, Urban Western Wear. All rights reserved.
Photos, imagery and any other information from this site may not be used without prior written consent.

 

   THANK YOU FOR VISITING OUR SITE!