Product analysis and data modelling

Product range analysis.

An important consideration for all online store owners is the ability to effectively categorise your product range, as this streamlines the time taken for a customer to find their desired product.

We did this recently for an NHS supply chain company. We rationalised their range of 5,000 plus products into 16 main product categories, each with its product sub-category. You can see how this improved the ease of finding products at  https://www.spentex.co.uk/.

The added advantage of this approach also allows an opportunity to display related products, assisting customers to view related products at the foot of the product listing, which is almost identical to Amazon’s approach. This helps to maximise customer engagement, allowing customers to make more informed product choices. Lastly, products are not only linked by stock code to a printed product catalogue, but they can also be searched using a partial description.

Have any questions?

Simply call us on 01943 864688 or 07403 321862 or contact us by email

Complex data modelling.

What if your product is complex, bespoke dog food for example? At face value this appears to be relatively straight forward, however, it’s far more difficult than a cursory glance might reveal.

There are a huge range of options to consider:

  • Is the dog an adult or a puppy?
  • Does the dog have any food allergies eg: Chicken, beef, liver etc?
  • What’s the weight and age of the dog?
  • How active is the dog - lazy, moderate, active, or highly active?

In this case the underlying formula used only produced the daily energy requirements for an average dog. Our approach to this issue yielded an algorithmic solution encompassing the above, which ultimately lead to the creation of 2 look-up tables, 1 for puppies and 1 for dogs. The solution caters for 95% of all dogs, irrespective of age, weight, activity level and medical condition.

The result allowed customers to answer a few simple questions, without any knowledge of the background calculation. Dog owners are shown their dog’s daily energy requirement in kilograms of food, the total amount required for either a 2, 3- or 4-week delivery cycle, all seamlessly pulled together, including payment by subscription.

This was a complete end-to-end solution, derived entirely from the customer’s research, together with our analytical skills.