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 > Sleeveless

Women’s Sleeveless
Roper 6071 Festive Red Lurex Plaid Five Star- Summer Festival
$36.95


brand: roper


Category: Women’s Sleeveless
Roper Cool Retro Style Sleeveless Shirt In A Lightweight Lurex Plaid
1 Point Yokes Have Unfinished Edges And Overlapping Crewel Embroidery
Frayed Armholes
Pearl Snaps
Flap Pockets

Color: Red





Style Number: 03-052-0565-0424RE
Product Number: #1040


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

Opening connection to Karman, Inc...

Automatically checking vendor inventory...

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 1x - nodim = 0

1: 2x - nodim = 0

1: 3x - nodim = 0

Karmin Importing...

2: xs - nodim = 0

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 1x - nodim = 0

2: 2x - nodim = 0

2: 3x - nodim = 0

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

TIQ 0

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

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

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

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '15666', parentid = '1040', refine_attributeid = '21', refine_categoryid = '5'

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!