Data Architecture

June 16, 2014 | Posted in eCommerce | By

Last week, while attending the Internet Retailer Conference in Chicago, someone asked me what the greatest challenge is with ecommerce today.   Not wanting to give a less than thoughtful answer, but also not wanting to get into the vortex of all that is right and wrong in the world of ecommerce, I simply gave a four letter word as my answer.


Inevitably, with clients that I’ve worked with in the past, or my own sites that I’ve led, the root of all issues in ecommerce always seems to come back to that four letter word.  Poor data can be the reason why conversion rates are bad, why bounce rates are bad, or for a less than ideal user experience. Incorrect data can be a reason why otherwise correct code doesn’t work properly, why faceting breaks, or why images don’t display properly. In a nutshell, it can make or break an entire ecommerce business.

I’ve had clients at large, global brands asking why their ecommerce sales are not what they expect.  And then after doing a thorough assessment of their site, you find that they have a mismatched taxonomy, no defining attributes, inaccurate descriptive attributes, and generally terrible product data.  This is not an issue limited to small companies.  In fact, in my experience, it is actually more prevalent at the larger, more established organizations where the existing data long precedes ecommerce, or even the internet itself.  More and more businesses are implementing a D2C model (Direct to Consumer), and these organizations are typically manufacturers by nature.  Manufacturing data is typically created by engineers and not merchandisers, and therefore the data is not thought about in the same manner that a merchandiser or marketing professional would consider it.  A common naming convention in the industry may not make any sense whatsoever to an ordinary customer.

So with that being said, here are a few things to consider when organizing and planning your data architecture.

  1. Group your products in a way that makes sense.  If you have 10 variations of essentially the same product, don’t make them all individual products.  They should be a single product, with 10 varying child SKUs under the product.  The only data that should differ among those products would be whatever makes that SKU unique from the rest of the products.  For example, if you have a bunch of shirts that are identical other than the fact that they are available in red, black, and blue, and each comes in size S, M, L, and XL, then you should set this up as a single product.  It would be 12 unique SKUs under this product (4 for each size in each of the 3 different colors), but the only thing that would differ between those SKUs would be Size and Color.  The name, description, and all descriptive attributes would all be identical, and the defining attributes would be the method in which you select the unique SKU to Add to Cart, by selecting Size and Color.  Too many sites have these broken up into too many product pages, which is a waste of time and energy that goes against ecommerce best practices.
  2. Make sure the data that you do have is accurate and valid.  There is nothing that will kill a conversion more than giving a customer a reason to doubt that the product they are looking at is the product that they need to buy.  It is imperative to make sure that every piece of information that you have is available on the product detail page.  Nobody likes surprises later on in the checkout flow, so if a product it out of stock, has an additional shipping charge, or requires special tools for installation, then you should let the customer know BEFORE they add the item to the cart.  Otherwise, you risk alienating them as a potential customer and cause problems for yourself in having to make the situation right in the future.


Selling on Amazon

December 31, 2013 | Posted in eCommerce | By

I’m working on a step by step guide to selling your products on Amazon, completely outside of your own ecommerce site.  Regardless of what platform you use, you can easily take advantage of Amazon traffic to sell your own products on their site.  There are many pros and cons to doing so, with the biggest pro being the visibility that a site like Amazon can bring to you, with the biggest con being the price pressure of selling on Amazon. Unless you are offering a very unique product or premier brand item, there is a ton of competition when selling products on Amazon.  Very soon I’ll have a more detailed guide on my site walking you through everything you need to know, should you decide to use Amazon as one of your own sales channels.


Defining an eCommerce Org Structure

November 14, 2013 | Posted in eCommerce | By

One of the first things I’m often asked at the beginning of an engagement is “How should our organization be structured?”  Many eCommerce businesses are not set up in a very efficient manner, including many large companies.  Regardless of the size of your eCommerce team, there is a structure that can be used to group functionality and tasks so that the work gets done in the most efficient manner possible.  Every company is different, but inevitably when I work with clients to define an organizational structure for their eCommerce team, I end up with something very similar to the same thing.

If you break down the shopping experience, I find that there are often four different universal areas for businesses to focus for eCommerce.

While some of the specific work tasks tend to cross the lines a bit, the four primary pillars are:

  1. Getting customers to the site
  2. Helping customers find what they are looking for and presenting it in a way that makes them want to transact
  3. Processing customer orders (collecting payment and getting the product to the customer)
  4. Taking care of the customer AFTER the transaction is complete

We can put better names to these divisions of work, which make more sense and give a little more clarity as to the roles and work that is done within each.  Knowing that everyone’s nomenclature is different, we’ll use the term “team” for each of these departments. That is just a personal preference that I have, and it makes it feel more like everyone is working together.  I realize at many places it may not always feel like that.  :)

Marketing Team – This group is responsible for getting traffic to the site.  Any requirement or task that has to do with getting traffic to the site would fall under this category.  Some examples of those tasks would include inbound marketing, pay per click, search engine optimization, social media, homepage design, site look and feel, email marketing, and customer segmentation requirements.  Basically, the job of the marketing department is to get people to the site.  Once the customer reaches the site, the job of the marketing team is done for that visitor.  In essence, the marketing team brings people to the site, and hands them off to the…

Merchandising Team – The merchandising team has the sole job of taking the people who are on the site and turning them into paying customers, also known in eCommerce terminology as, a “conversion”.  If conversion is a familiar term for you, then you would correctly assume that Conversion Rate on an eCommerce site should be completely owned by the head of the merchandising team.   Every task of function needs one specific owner, often with many contributors, and the head of the merchandising team tends to have more tasks than others to own.  In my opinion, and no disrespect to the other areas of an eCommerce organization, but the head of the merchandising team is the most important person in the entire operation.  If you do not have the right person in this role, you will likely fail. If you have the right person in this role, you will likely thrive.

This person needs to be a seasoned eCommerce veteran who truly understands retail, and lives for analytical data such as conversion rates, average cart size, cart abandonment, checkout funnels, and that sort of thing.  As that person is ultimately responsible for those analytics, they also would be the person with final decision making authority over things such as site taxonomy, product detail page look and feel, category structure, and navigational appearance.  They also would own site search and the optimizing of site search results, as well as cross-sells and up-sells, category landing pages, promotions, and ultimately, the entire checkout process.

A good merchandising team will provide a customer with the products they want in a manner in which they expect to find them, and then smoothly complete the checkout and purchase of that product.  A great merchandising team will do the same thing, but also present some higher margin alternatives and perhaps convince the customer to buy a few higher margin accessories or impulse items along the way.   That skill alone is so valuable when you consider the cost of customer acquisition is usually quite high in eCommerce, so selling more to those customers (increasing average cart size) is the difference between a good sale and a great sale, and in essence.. a good year and a great year.  Once the customer has found the products they want to purchase, and have navigated their way through the checkout button, the next hand-off comes when the customer clicks the submit order button on your site.  Clicking that button then passes the baton from the merchandising team to the…

Operations Team – The operations team is responsible for the successful operation of all logistics of completing an order, commonly referred to as ‘Order Processing’.  Order processing begins with the acceptance and processing of the customers payment method, such as a credit card transaction.  This team will own the relationship with any payment processor third parties, banks, merchant accounts, tax collection and submission, and shipping requirements.  Many companies use third party vendors who specialize in these areas, specifically when it comes to tax and shipping, and the operations team is responsible for managing all of those relationships and requirements.  There is a lot of pressure on this area as well, because no matter how great of a job the marketing and merchandising team does, if the operations team drops the ball, then that customer may very well never return to place another order again.  They also have the responsibility of fraud detection, which is a very commonplace activity that is part of eCommerce life nowadays.  Whether your company has a large distribution center or relies entirely on dropshippers, the operations team is responsible for making sure that purchased products are delivered to the door of the paying customer.  This includes the “pickers and packers” who take the item from inventory and prepare it for shipping in an appropriate and cost efficient sized box, as well as overall inventory management to make sure that the numbers of which products are on-hand and which are not, are accurate. Once the package arrives at the customer’s doorstep, then the operations team has done it’s job completely and it is time for the…

Customer Service Team – The customer service team is there to support the post transaction customer experience.  This would include everything from the order confirmation email, order status tracking, and shipment confirmation, through to processing returns if necessary and following up with customers to ensure their satisfaction with surveys or requesting a product rating and review.  This also means staffing a customer service phone number, email, online chat, or even snail mail communication if your organization offers it.  Assuming the customer service team does a great job to complete the sales process, it would then be handed back over to the marketing team to target those previous customers and start the entire cycle over again.

There are definitely many roles and responsibilities under each of these teams, and many tasks have somewhat blurred lines and there is often questions about who owns which aspects of each.  I’ll add a post in the future to talk more about that and best practices for each of these groups, but for now, I hope this helps explain best practices for a high level eCommerce org structure.

Please feel free to use the comments section below to ask any questions or provide your own input as well.
Joe Rozsa


Hosting an IBM WebSphere Commerce Starter Store

February 25, 2013 | Posted in eCommerce | By

As the founder and president of KaLor Technology, one of the most important things that I have done is to become an IBM Business Partner. This gives me access to tons of information that is needed in my day to day world of implementing enterprise eCommerce solutions for our clients.  One of the worst things I do is that I rarely allow myself the time that is needed to go over all of that information that is available to me.

I am in the process of launching a starter store containing the latest and greatest IBM WebSphere Commerce version 7 Feature Pack 5, so that I can demonstrate the power to the world, as well as to provide some training and educational recordings for people while using information for a KaLor starter store.   If anyone has any suggestions for the best way to host this, please let me know.  My team can easily configure, design and install it…  but I am torn with the best way to host the thing right now.


Thanks for reading…

Joe Rozsa