huggettm

Related PRoducts

Recommended Posts

Not sure what you mean by manually setting related products in bulk but have you seen the plugin from @Noodleman https://www.cubecart.com/extensions/plugins/related-products-manual-automated-recommendations - we have clients using this and it works well and is already integrated with our Retail Therapy skin which we are discussing in another thread

Ian

Share this post


Link to post
Share on other sites

Hi Noodleman, thank you. by bulk i mean all products at once - ie by csv upload.

we have over 4000 skus so manually adding to each one is not an option.

does your plugin work by adding the related products to the existing product db field or a seperate table?

Share this post


Link to post
Share on other sites

my module does not have an interface to allow import of a file, however you could import data directly into the database table where manual related products are stored.

The table is called "CubeCart_related_prods" and you simply need to add the product ID of the parent item, then the ID's of the related items. you can define an sort order as well.

You can use an application such as Navicat to quickly import data into the DB from a file

 

 

 

Edited by Noodleman

Share this post


Link to post
Share on other sites

this can be done if you wish.. entirely possible within your store theme to setup. the copy/paste code samples are considered to be a generic starting point which can be modified as required to suit your own requirements.

Share this post


Link to post
Share on other sites

there could be a requirement to add some indexes to the database tables the module uses which will boost performance. This shouldn't be impacted by cache and is likely a database level performance issue.

If you are willing, I can look directly at the issue for you, review the SQL queries and tune the tables via indexes as required to check if performance improves. Alternatively, I can provide some SQL queries to run, and if you share the results with me I can recommend indexes to add on specific tables.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now