Ecommerce Database Management for Success.

In Shoppping by Heidi Nyburg on Tuesday, May 6, 2008

Yeah, I know the header for this post is not really very layercake-ish but after the online shopping experience I just had, it seemed appropriate. While flipping through the pages of a back issue of Glamour:

I saw this adorable blouse, let’s call it Exhibit A:

Cute, huh? So according to the article I can find this retro little gem of a blouse at an online store called Unique Vintage. And we’re off like a prom dress. After a few clicks we find our way around the store—more on the UI later—we find the blouse. How exciting is that? The magazine is at least a month or two old and the blouse is still in the store. Don’t get too excited, this is where the database management (or lack thereof) rears its ugly head. Look at this:

Do you see what I see? It’s sold out. Huh? I can’t even type Huh? enough times on this page to capture the lameness of this retail experience. This is a signature Macy’s.com move, but at least Macys.com doesn’t let you add the item to your cart and complete your purchase of said non-existent item that will never be produced again.  Feel free to purchase it but just be aware that it will arrive in an invisible box and that it is constructed using only the finest quality organic air. And it comes with a refund to your credit card because it doesn’t exist.  So today’s Database Management tip of the day is: Remove products that no longer exist from your active database. And if you feel you must leave the item on the site maybe because it’s so pretty and it got a lot of press, how ’bout flagging it as unsaleable so we don’t have any of those pesky credits to process.

UPDATE: I received a really nice comment from Katie, the owner of Unique Vintage clothing. She has removed the really cute unavailable blouse from the site. And even though my heart’s true desire was for Unique Vintage to wave its sparkly fashion wand and produce a few dozen more of that coveted blouse, I guess I’ll just have to walk away with a lesson learned. If you love something, go after it with passion and determination. Ah so true on so many levels.  Like I mentioned in the post I totally understand leaving the item up for people to see, good press is hard to come by and it’s something to be proud of. Making it unsalable by not allowing it to be added to the cart just makes it easier for everyone and maybe putting it on the press page like some other stores do, instead of mixing it in with available inventory. The great thing about blogging, in my experience is that it opens lines of communication. Now let’s all get over to Unique Vintage and get our fashion on. If only Nordstrom was as responsive as Katie and could fix this website debacle of theirs.

If you’re in Southern California, you can visit the Unique Vintage flagship store at 2013. W Magnolia Blvd
Burbank, CA 915062013. Grand opening September 6th 2008!

  • No Related Post

58 Comments »

Comment by Catherine

September 6, 2008 @ 5:43 pm

preach on sister, preach on!

Comment by Katie

September 6, 2008 @ 7:06 pm

Hello there,

In defense of myself (I am the owner of http://www.unique-vintage.com) I have only kept this item online because Glamour asked me to do so. If you browse my site you will see that we do not show any other unavailable items. Since the issue is a couple of months old, I will take the unavailable blouse offline now, but thought I should at least explain myself. When a super powerhouse like Glamour is nice enough to mention your site, leaving a product online with a full explanation of the fact that it is no longer available, seems reasonable. These things happen, we are a small business and trying to do our very best.

Sincerely,

Katie

Comment by UptakeInOH

September 6, 2008 @ 8:24 pm

I think that in their marketing minds, if they’ve gotten you to their site, they are happy. To them, why take the time to remove or flag items if they have the potential to bring you to their online store, where you might find a replacement for the out-of-stock item.

To me–I just find it annoying and leave, but I bet that many stay and shop.

Comment by Alex

September 9, 2008 @ 8:55 am

Ahh yes the power of the web. I like how you posted a critique of said store and then the store owner took the time to write you a candid letter. Awesome!

Comment by Lea

September 9, 2008 @ 12:19 pm

that is a cute top :)

Comment by jmchua

September 10, 2008 @ 11:46 am

Nice blouse, sigh.. better luck next time.

Comment by Roshni

September 10, 2008 @ 11:54 am

I really think that the white top is cute.. :)

Comment by Claire

September 10, 2008 @ 11:36 pm

Katie,

I can understand where you are coming from, and for something that big to put you in thier magazine is fantastic. I suppose in addition to what they have asked you to do, but i probably for your sake, got some links on there to similar items that are available. This would then not annoy the customer as much and give them an alternative to continue shopping there.

Claire
Civil Engineer and Web Designer

Comment by MOin

September 11, 2008 @ 1:21 pm

i entered this post thinking about something of my department lol and that top in the cover is beautiful but the second one old skool looking blouse is really eye catching.

Comment by LAX

September 13, 2008 @ 8:53 pm

Wow, word gets around the web. Nice on the owner and yourself to giving it another plug :)

Comment by Sinead

September 15, 2008 @ 2:48 am

I feel your pain. I know what it’s like to find something you completely adore, then to see it’s out of stock. Still I agree with the owner in the first comment. If Glamour asked me to do the same, I would too!

Comment by Gustav

September 15, 2008 @ 3:26 am

You have a very interesting and nice blog by the way… keep the great job.

Now to the topic, it seems that they consider this Database technique a MARKETING strategy.. have you ever seen those magazines with houses which are marked as SOLD? why put them in the magazine if they are sold? duh

Gustav

Comment by bucko

September 15, 2008 @ 7:09 pm

Nice Blouse, bad database.

Comment by Jenna

September 17, 2008 @ 7:14 am

That is a cute top — too bad it was sold out! I hate when I really want something (in store or online) and it’s unavailable.

Comment by Kayla

September 18, 2008 @ 10:13 pm

Nice article, well written and Interesting. I am glad to see such a lovely post after a long time. love the top as well. Thanks for the online store link will buy it from there. :)

Comment by christine

September 20, 2008 @ 1:52 pm

I love that you actually got someone’s attention and got something done! Well, sort of.

Comment by Josh

September 21, 2008 @ 11:38 am

True, it’s a little confusing that the blouse was left up even though they’re sold out. I can definitely see your point there. But consider how much more confusing it’d be if you were to show up and find no mention of the blouse at all! (Did you go to the right website? Was the Glamour article wrong? etc.)

Still, leaving the “add to cart” option there is a little strange. Maybe better than that would be a “You may also like,” like Amazon has.

For a small business getting media attention from a bigwig like Glamour, you’ve got to do whatever you can to make sure that new visitors know they’re in the right place.

-Josh

Comment by RicardoV

September 23, 2008 @ 7:57 am

I appreciate that the owner of the site wanted to keep the item up there for all to see. But this is typical of bad UI design. It would have been so easy to simply hide the Add to Cart button and show a lovely message when something is out of stock, but instead her website designers have been lazy.

Comment by fatfoogoo

September 25, 2008 @ 2:22 am

Hmm…hard call on this one, but I think I might do the same. I guess the only thing I might change is remove the ‘add to cart’ option. I think she made it perfectly clear that the item was no longer available, but this is also a missed opportunity to cash in a a massive traffic influx. Instead of just saying ‘we will have to refund your credit card’, why not use this prime real estate to say something along the lines of ‘Hello Glamour readers. Sorry to say that this amazing blouse is gone with the wind and will no longer be produced. But since you’re already here, why not nose around the shop a bit more, there’s bound to be something else to suit your fancy.’

Comment by Johnny T.

September 27, 2008 @ 11:05 am

Your use of the phrase “vintage” brings to mind an eBay campaign I once used selling Rock tee shirts. They were new shirts but by putting the word vintage in the title I sold out.

Comment by Mia

September 28, 2008 @ 4:55 pm

As a webmaster of my own ecommerce site I would of left the product and page up as many will be coing to that page. Like you suggested I would have made the product unsaleable and I would pull similar products from the database and displayed them below. You still may end up with a sale.

Comment by Rika

October 1, 2008 @ 1:14 am

I live in a small town in South Africa, so shopping on the net is a great option. But the disappointment can also be huge. Pity you couldn’t get that blouse. It sure looks dreamy. Hope you have better luck next time.

Comment by Sam

October 1, 2008 @ 9:56 pm

Nice article well written.Nice marketing statergy.Thanks for sharing it.

Comment by Renita

October 1, 2008 @ 10:54 pm

I can totally feel your frustration…I too was duped by “creative marketing”. I was on a very popular site, I will refrain from mentioning names, and found the perfect bistro table with chairs that I had been feverishly looking after viewing 7 or 8 pages. Excited, I checked the item to add to my cart and when it was time to place my order…Out of Stock! Oh well, a few months later I found an even better table for less…Justice!

Comment by Mulder

October 3, 2008 @ 5:40 am

There are several shopping web sites that I’ve encountered the same problem with. Alloy and Frederick’s of Hollywood are two examples of online shops that will allow you to add the item, even if it isn’t in stock. It’s very frustrating. I’m surprised that these types of stores wouldn’t respond to consumer demand by increasing their inventory.

Comment by Alex

October 5, 2008 @ 9:03 am

website glitches happen all the time…however, it should not be seen in an ecommerce site… well, at least they respond to you nicely. ;-)

Comment by Laura White

October 7, 2008 @ 4:24 am

I think this is kind of lame and one of the downsides of an off the shelf oscommerce solution – when you mark as 0 items in stock; customers can still buy it.

Comment by Vanessa

October 10, 2008 @ 9:21 pm

Cute blouse, but I agree with you that it’s a terrible experience to purchase something and then have it be sold out.

Perhaps they did just get overwhelmed, and didn’t really have policies in place to do an “emergency removal of something no longer available”.

Hugs,
Vanessa

Comment by Kaufman

October 12, 2008 @ 11:36 pm

I have had that happen to me before. I was buying a remote control car for my son and it was for Christmas. I bought it online and got confirmation that my order had been placed and would ship out shortly. Three weeks later I find out that the model was discontinued. It’s very frustrating.

Comment by Cathy

October 13, 2008 @ 5:38 am

I guess that happens when you have a bug business. But its good to hear they try to improve the situation. Nice top btw.

Comment by Meg@ Belts

October 13, 2008 @ 2:54 pm

You are mostly right but many of my customers ask us to leave the product online to add to their wish list in case it will come back in stock in the next 30 days.
I do agree that getting you to the site is 95% of the effort and that if the product is 100% discontinued that it would be removed or to stop people’s frustration from searching for it to have a note that it is not available.

Comment by Rahsia

October 13, 2008 @ 3:42 pm

Yeah…I am agree with vanessa

Comment by Renae

October 14, 2008 @ 10:10 am

I love the blouse. Love your posts as well

Renae

Comment by Kana

October 15, 2008 @ 4:00 am

Hmm sorry you experienced this, but glad Katie was able to sort it out. I suppose good customer service shines through at the end of the day.

Comment by tyas

October 15, 2008 @ 5:34 am

very cute vintage blouse.. i like it..!

Comment by Roger Hamilton

October 17, 2008 @ 7:15 am

Better luck next time! Hope you can find that blouse somewhere on the internet.

Comment by robin

October 18, 2008 @ 5:28 am

You can understand sites leaving products on when they are out of stock because they will have been indexed by the search engines, and therefore there’s a chance customers may buy something else after their initial disappointment. I’m guessing on most shopping cart applications it’s just a mere click of a button that will stop customers checking out.

Comment by Daisy

October 18, 2008 @ 8:54 am

Well the owner wass decent enough to explain herself. And what would you if Glamour asked you to keep the item on your site. On the other hand, as a customer I would be bummed!
The blouse looks great!

Comment by Connie937

October 18, 2008 @ 2:23 pm

Very cute top and I hate when things are out of stock. Feel like I’ve wasted my time looking in their website.

Comment by Jennifer

October 19, 2008 @ 1:52 am

I had this happen to me with ASOS, only problem was they didn’t tell me it was out of stock until the following day when they had to refund my card,

I loved that coat, and it will never be mine!

Comment by Andrew Green

October 19, 2008 @ 9:21 am

I agree with the owner in the first comment. If Glamour asked me to do the same, I would too!

Comment by Grumble

October 22, 2008 @ 5:50 am

It’s so true! I hate things like that happening when I’m shopping online… a sure way of making sure I don’t ever shop there again!

Comment by Brad

October 22, 2008 @ 7:30 am

Katie

It’s great to see the owner of the store in question come in and post an explanation as well as participate in the forum. That speaks volumes about your character and integrity. Many companies, whether privately owned or a large conglomerate, wouldn’t take the time to communicate at this level. Kudos to you.

Comment by Scott

October 22, 2008 @ 12:37 pm

I think that in their marketing minds, if they’ve gotten you to their site, they are happy.

Comment by Cathy

October 22, 2008 @ 10:49 pm

Yes must agree I live out in the middle of Australia and usually buy everything online. It also takes an age to have it delivered.

Makes it even harder for me when you make the effort to find something you like online then only to discover it is out of stock or discontinued. Especially as i have only very limited internet time.

Comment by Vicky Adams

October 26, 2008 @ 4:58 pm

Reading to Kathy comments, I guess she made good action. Although I can understand that you maybe still feel disappointed, but at least she tried to respond and explain the matter. Success to your business, Kathy

Comment by Maneet Puri

October 27, 2008 @ 2:08 am

This is perhaps the most common problem with e-commerce websites. Website owners should realize that such small bits of inconvenience robs a major portion out of user experience.

Comment by lauracj

October 29, 2008 @ 7:50 am

Hilarious! I totally agree that I am going to Boycot Americas Next Top Model, unless they have a sudden script change! Tyra has to be my worst!

Comment by catylincairo

October 29, 2008 @ 9:02 pm

I think that in their marketing minds, if they’ve gotten you to their site, they are happy. To them, why take the time to remove or flag items if they have the potential to bring you to their online store, where you might find a replacement for the out-of-stock item.

Comment by Monty J

October 30, 2008 @ 6:12 am

Nice top but ya…there are many several online shopping web sites that I have as well encountered same problem with.

Comment by MonaVie

October 30, 2008 @ 10:16 am

Wow Katie was fast to respond (she seems to be the first comment on here). I agree with both sides. Leaving a product up that was mentioned by Glamour is probably a good idea, but it shouldn’t have said “sold out” just No Longer Available, or Past Products. That was nice of her to email you back without getting defensive. I totally agree about the Macy’s thing though, I’ve had that happen to some friends and its annoying.

Comment by Penny Bright

October 30, 2008 @ 7:58 pm

That’s one thing I hate about online shopping. It’s true that with online shopping we don’t have to go anywhere to buy our need. But we must accept the risk of out stock and long delivery time.

Comment by Bryan Alwright

November 12, 2008 @ 6:45 pm

That was the same experience with me at my last shopping online. I was going to buy a present for my wife birthday. Too bad the stuff didn’t come after I submit my order without notification.

Comment by Zara

November 17, 2008 @ 5:13 pm

It is sooo true! I think most of the sites don’t remove the items that are not available anymore! It’s just a waste of time for the buyer!

Comment by Isuzu Npr

November 17, 2008 @ 6:46 pm

The article was impressive, but more impressive is the store owners response. I can’t help but to give my business to a small family run business, or an owner like Katie. Keeping an eye on your online PR is always beneficial. Bravo to Katie for catching the article.

Comment by MichaelC

November 28, 2008 @ 5:17 pm

Having reviewed many websites and shopping carts I think there should be some effort put into making a cart that meets many sales-oriented and being found requirements like:
* usability including clean navigation and user friendly (not hostile) info
* standards compliant – no errors for HTML or CSS – makes for ease of search engine indexing
* smart content – uses product names and codes in important page areas so the product page can be found in the search engines.

Just my $0.02.

Comment by Anna

January 11, 2009 @ 10:15 am

Well at least the owner was nice enough to contact you and remove the item. I too, get frustrated when I finally find a product I really want to buy, only to find out that it’s been discontinued.

Comment by Lori Dell

May 20, 2009 @ 8:10 am

Shopping online like most everything else has its ups and downs… Its pluses and minuses, so to speak. The good = Items that may not be available in stores around where you actually live. The minus… Well it just may not fit that great. These are just the facts of life…
Until the online boutiques make it possible for you to try your blouse and/or bikini on at home via virtual manikin one will just have to read the measurements very carefully and of course understand their own measurements to the best of their abilities.What is a shame about some of the online retailers is shared with a comment above… To be able to go through the check-out THEN finding out your item is not in stock is just plain wrong and bad for customer relations. It is understandable sometimes that the item can still be searched for even though that it is out of stock… The item should not be able to be entered into the shopping cart…
JMHO –
Lori…

RSS feed for comments on this post.

Leave a comment

Note that we no longer collect or publish URLs .. too many spammers.

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>