Market basket analysis for Shopify stores: increase sales with advanced merchandising data

A number of people have been asking about how to tell which products are bought together. e.g. does this shirt get bought with these pants or these shorts?

This is called a market basket analysis or an affinity analysis in more general statistics.

The market basket analysis process can be simple or complex depending on how many products you have and how many orders you're analyzing. If you want to start with a simpler version, just analyze the last 12 months of orders and only look at products (ignore variants for now).

Some product analysis Shopify apps can help with this if the data crunching is too complex. Just be cautious of over-hyped "AI" systems that can't explain how their analysis runs. There are well-known, supported-by-research algorithms that can work for 99% of stores.

Once you find out which products are related, you have a quite a few options to improve your marketing and merchandising:

One thing to be ready for is finding unexpected matches. These are products that are frequently bought together that you had no idea about.

As with any analysis, you'll want to refresh your data on a regular basis as the customer behavior changes. For a busy store with a lot of products and orders, this might be every month. For a small store that only introduces new products once a year, this might be every six months.

Performing a market basket analysis may seem daunting, but with the right tools and approach, you can gain valuable product insights to help grow your Shopify store.

While Repeat Customer Insights has a product analysis, it is focused on which products create better customers, not which products are bought together. Product affinity might be an area I expand to later.

Eric Davis

Retain the best customers and leave the worst for your competitors to steal

If you're having problems with customers not coming back or defecting to competitors, Repeat Customer Insights might help uncover why that's happening.
Using its analyses you can figure out how to better target the good customers and let the bad ones go elsewhere.

Learn more

Topics: Product analysis Product bundles Cross sell Product pages

Would you like a daily tip about Shopify?

Each tip includes a way to improve your store: customer analysis, analytics, customer acquisition, CRO... plus plenty of puns and amazing alliterations.