Ecommerce Database Management for Success.

In Marketing and Advertising, Shoppping by Heidi Nyburg on Saturday, September 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 thiers.

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

54 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 Bernhard

September 8, 2008 @ 11:44 am

Occasionally I look here by and read the interesting and well written contributions. Today I would like to leave gladly a greeting from Thuringia in Germany!

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 Diego

September 9, 2008 @ 10:15 am

It´s a quite boring. But i think it´s a marketing strategy!!

Comment by Lea

September 9, 2008 @ 12:19 pm

that is a cute top :)

Comment by britneyvaughan

September 10, 2008 @ 1:35 am

I am impressed by the stuff you have mentioned. Really the power of the web.

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 Stephanie

September 21, 2008 @ 4:44 pm

Glamour, my fav mag

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

RSS feed for comments on this post. TrackBack URI

Leave a comment

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>

 
Close
E-mail It