Hey guys, are there any merchants here who are getting useful insights out of Shopify’s Online Store Cart Analysis report? Looks like it only gives you data of items added to the cart in the last 30 days.
To me it seems more useful to get products that are frequently sold together from all historical orders instead, to help identify the most impactful baskets to optimise pricing, bundling, funnels etc. As this may be more accurate than what customers have been adding to their carts but are not necessarily buying.
1 Like
@xantable how did you solve it and what did you use the info for?
@Gabe maybe you could help out – As a merchant I would like to know: What is my most frequent cart combination in the last 12 months?
I would like to see a rank list:
rank product1 product2 product3 …
#1: oil pepper vinegar
#2: oil oil
#3: salt pepper
Then it would be great to filter the combinations i.e. carts with 3 products or carts with oil and vinegar in it.
With that information at hand, I can optimize the dimensions of my standard shipping box to fit the top 3 carts.
best chris
1 Like
Hey @chris214 ,
I ended up solving this for a friend by building something custom that went through their order history to extract the top N most frequently sold combinations (pretty much what you described). The Cart Analysis tool wasn’t all that helpful since it only does the last 30 days and only items added to the cart, which may not be an accurate indicator of what people are actually buying.
The info was just to help them identify what items to focus on for promotions to get the greatest sales uplift and to increase basket size.
I was considering improving this and creating a Shopify plugin for it if there are enough people that needed something like this. But looks like its a pretty niche issue.
Were you looking to get this kind of info as a one off or ongoing every year?
Hey Xantable,
I’ve given SuperU a try, and it’s been fantastic for analyzing Shopify data. It’s incredibly user-friendly. They even offer a 30-day free trial. I highly recommend checking it out for a better solution. I can share my experience and discuss with you. Here’s the website link of superU.