I have had a look around the modules and can't find one? Does it exist? If so can you give me a pointer to it please.
Thanks
best sellers would be the closest i guess? wouldnt it be good if you could get customers also brought this in the shopping basket.....
the problem with customers also bought is that you have to query all your orders then all the products in them to get the data, and once you start getting lots of orders it always slows down.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
as far as I know no one has written any module like this. I don't really think anyone has even thought to hard about it. It's much better to use some sort of cross sell than an also purchased module.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Hello Xsecrets,
I respectfully disagree with you. To choose products to cross sell each product in a store can be time consuming and involve bias from the shop owner.
If the shop keeps track of products that customers bought alongside this product it would give a much better picture of things that should actually be cross-sold. (as chosen by the customers themselves)
There should be an fallback option, that products from the same category and price or products that have been chosen to be related should be displayed in case there is no data on the above.
I respectfully disagree with you. To choose products to cross sell each product in a store can be time consuming and involve bias from the shop owner.
If the shop keeps track of products that customers bought alongside this product it would give a much better picture of things that should actually be cross-sold. (as chosen by the customers themselves)
There should be an fallback option, that products from the same category and price or products that have been chosen to be related should be displayed in case there is no data on the above.
Add it to the feature requests area and we'll see what we can do about it.
If you do decide to add it I would certainly make it optional as I guarantee it will slow down sites with lots of products, customers, and orders. And before anyone says amazon does it I'm quite sure they do summary tables in a different database on schedules and multiple servers which is not feasible for a project like this.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
I've recently developed this add on, and will make it commercially available in the near future. The module makes two queries to the database and is able to work out which products have been purchased the most and "weight" the items in their favour as those are most likely to be bought again. As long as there is a limit to the products and the queries are smart it doesn't really slow it down all that much imo
well yes it's just two queries, but one is used inside a loop of the results of the other right? and at what point does it start slowing things down on shared hosting? 1000 orders 10,000 orders 100,000 orders? In my experience on other systems somewhere around 30,000 orders things start slowing down alot. remember these queries have to be run anytime anyone looks at any product. I suppose you could cache them which would help, and 30,000 orders may sound like a lot if a store takes off it really doesn't take that long to get there.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
well that would be very interesting to see how it works. I'm all for the function if it can be done efficiently, but I've seen several attempts and they all have caused performance issues on high traffic sites, so I am very leary.JAY6390 wrote:Nope no looping, hence the "smart query" bit
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Not really as simple as that Tom. You could cache each product's items that have been ordered with it, but that would take quite a bit of space up on the file system.
@Xsecrets - It might actually be 3 queries, but either way it doesn't loop through them. There are a number of ways this can be done. Obviously the biggest factor is the orders are going to get bigger as you've said. I'm sure indexes could be added to the relevant tables to get the performance up too
@Xsecrets - It might actually be 3 queries, but either way it doesn't loop through them. There are a number of ways this can be done. Obviously the biggest factor is the orders are going to get bigger as you've said. I'm sure indexes could be added to the relevant tables to get the performance up too
Nope but I intend to make the module auto hidden if it hasn't got any (or at least an option to choose to have it)
To be honest, I'd only need a beta tester for the "larger" stores with the 10,000 plus order, to test load on the database and response times (as mentioned above)
To be honest, I'd only need a beta tester for the "larger" stores with the 10,000 plus order, to test load on the database and response times (as mentioned above)
Hey Ja6390,
Could you share this link? The VQMod Pic in yoru signature goes to github vqmod page.
Could you share this link? The VQMod Pic in yoru signature goes to github vqmod page.
Regards,
Nightwing
Access to my Free Extensions: https://www.opencart.com/index.php?rout ... =nightwing
Who is online
Users browsing this forum: No registered users and 6 guests
