Skip to content

E-commerce product information management. Not cool.

Woman wearing smart business suit in front of a laptop looking bored

Share This Post

Why read this? : We explore e-Commerce product information management systems. Learn how to use them to get the right information in front of shoppers. We share examples of how Amazon, Google and WooCommerce do it. Read this to learn how to optimise product information management systems. 

From the outside, e-Commerce looks and sounds cool, right? It starts with that “e-”. Surely that means it’s cool?

Hey, it’s new and online. And online’s cool. It’s “e-”. It’s not the same old, same old.

You still hear people talk like that, right? Usually, it’s senior leaders wanting to sound like they’re “in touch” with market trends. Or start-up gurus and sharp-suited consultants trying to justify their large fees. 

Person holding a mobile phone with an e-Commerce page on screen and a credit card in the other hand

Then, you stick “commerce” after the “e-“. Oooh. Get you. 

Not “sales”. Because sales doesn’t sound cool, does it? Sales sounds like hard work. The sales rep driving to call on their customers. The call centre worker busting a gut to hit their sales target every day. Sales is also the guy stacking the shelf in the supermarket and the woman on the make-up counter at the department store. On their feet all day keeping customers happy.

No, working in “sales” isn’t a fun gig at all. It’s definitely uncool. It’s tough. It’s thankless. And it’s a grind and a hustle every day. 

But damn, it’s important, isn’t it? Because without sales, you have no business.

But surely, e-Commerce gets you away from all that stuff, right?  Um, no. 

E-Commerce - jobs to grind out

When you do e-Commerce, you soon realise the tough and unglamorous part of “sales” is still there.

The only thing that’s noticeably different is you get to sit down while you do all the hard bits. But there’s still a lot of grinding to do. 

Like working with e-Commerce product information management systems.

Because most of the people who talk about e-Commerce aren’t the ones doing it.

Woman wearing smart business suit in front of a laptop looking bored

They’re the ones getting excited about the “big” numbers around e-Commerce. For example, the recent report showing e-Commerce sales growth in Australia running at 50%+ year on year.

There are not many traditional businesses growing at 50% year on year. But break it down. Those “big” numbers are always an accumulation of “small” individual customer orders.

And you have to work to gain every single order. They don’t just happen. Someone has to make sure every product goes into e-Commerce product information management systems, so it can be “sold”. You need that information to populate the product page on the online store

Getting products onto these systems is the e-Commerce equivalent of shelf stacking. It’s hard work, usually done by the low-paid and rarely recognised. But without it, there’d be no online sales. 

It’s a hard job because most e-Commerce product information management systems run on complex spreadsheets. Or annoyingly finicky software platforms which demand a Rainman level of attention to detail, and the patience of a saint to complete. 

Even the big guys like Amazon and Google haven’t yet found a way to make e-Commerce product information management systems easy. As we’re about to show you. 

Amazon Item Template

For example, when selling via Amazon is part of your online retailer strategy, you’ve probably already shown some of the detail / patience levels needed to work in e-Commerce. Because they don’t make it easy to work with them.

Their negotiating stance starts with “We’re big and successful, accept our terms or f*ck off”. We’re simplifying and paraphrasing. Obviously. But, they’re well-known for being tough negotiators

Amazon Item Template screengrab

And then you get their Amazon Item Template. For every product you want to list on Amazon, you have to complete this beast of a spreadsheet in a way they’re happy with. It has 37 different elements on it.

37.

For every single SKU you want to sell, here’s just some of the information you have to supply :-  

Vendor codes, brand names, category, GST status, barcodes, weights, packaging details, product descriptions, price breakdowns, features, shelf-life, temperature status, country of origin, ingredients, dimensions and fragile or dangerous transportation warnings. 

Pretty full on, right?

The headlines about Amazon may sound “cool”. But the reality is some poor schmuck has to fill in this damn spreadsheet line by line, just to get stuff to appear on their site.

Not cool

Google Merchandise Sheet

Ah well, maybe Amazon is just a one-off?  

Surely, someone like Google does it better? Their search engine interface is the world’s simplest and best-designed user interface. Surely, they can come up with an e-Commerce product information management system that’s better?

Well, yes, kind of. But also, no. 

Google Merchant Centre - Spreadsheet with multiple columns and rows to complete to list items with Google

Though Google aren’t strictly an e-Commerce store, they do “sell” products by letting you advertise on Google Shopping. And to do that, you set yourself up on Google Merchant Centre.

To be fair, when you first visit the site, there’s a fairly easy-to-use interface to link your online store to Google Shopping Ads. And to track how your ads perform.

But then, you go to list your products and wait a minute, what’s this?

A spreadsheet on Google Docs which feeds information into your Google Merchant Centre account. And this one has 44 fields to fill in for every item you want to sell.

44.

Bugger.

Your SKU ID, product name, product description, links to the product listing in your store and the product image, condition of the product (new, used, refurbished), price, availability, barcodes, brand name, category, packaging details, age group, gender, size, colour, material, pattern, tax, delivery charges, dimensions, price and a few more.

So, to list your product on a Google Ad, you need to fill out these details. One line for every product you sell.

Not cool.

What if you run your own online store?

So, what if you manage your own online store?

Surely, there’s an easier way to manage product information if you do it yourself?

After all, one of the benefits of running your own store is the control it gives you compared to selling through an online retailer. 

WooCommerce product page example - shows Game Player - Red Control - Men's Hoodie Pullover and the product description used in WooCommerce

The good news is you don’t have to use spreadsheets when you use a Shopify, Magento or WooCommerce option to run your own online store. 

But actually, you might want to. Because you still have to upload a lot of information to make each e-Commerce product “ready” for sale. Only this time, without using spreadsheets.  

We run WooCommerce on our shop because we like the integration between WordPress CMS and WooCommerce. And because when you “list” a product in your online store, you’re basically “publishing” a page about that specific product.

You have all the options you have when you publish a page. You can SEO optimise it with titles, metadata, categories and tags. Want to write your own product descriptions with links to relevant content? Easy.

You choose the images, the layouts, the copy, the links, and the pricing. It’s all under your control.  

But to do that for every product you want to sell. That’s a lot of work. 

And when you’ve listed your first 10, 20, 100 products, that’s when you realise e-Commerce is definitely not cool. It’s hard work to get every product listed so it’s available for customers to buy.

WooCommerce product page - SEO section

Is there a better way?

Well, there are businesses we’ve worked with like SkuVantage and GS1 / Smart Media who partly help.

They help standardise your e-Commerce product management information systems so you have one master copy sheet, which all the retailers can pull from.

You still have to do the hard work the first time. But if you then change something with your product, you only change it in one place. The master sheet information automatically flows through to all your retailers. That reduces the amount of work when you make changes.

But that still leaves someone with the very uncool job of setting it all up in the first place. And keeping track of the master data

We’ve had to do that job many times. It’s definitely not cool. Whoever does that for you, make sure you keep them happy and thank them. Because they’re making sure your products are available to buy. They’re helping customers make decisions by having the right information available. 

Conclusion - product information management systems

You can’t sell online if customers can’t access information about your products. Product information management systems help you manage this. You use them to make sure your products appear on store websites with the right information attached. Customers need this information to make decisions and know which products are right for them. 

You must supply full and accurate product information when you sell online. It’s not optional. No information or not enough information means no sale. So make sure you have a plan to manage this part of your e-Commerce operations properly.

Check out our basic product pages and high-ticket product pages articles for more on this. Or email us if you’ve any questions about product information management systems.

Photo credit 

Bored in front of computer : Photo by Magnet.me on Unsplash

Online shopping with phone and credit card : Photo by PhotoMIX Company from Pexels

Share this content

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest blog posts

Subscribe to get Three-Brains updates