also purchased query question

[ryanf]

Hello, I have a question on how the also purchased gets it's results. Does it just grab the first four products that where bought with the particular product it?

If so, how would I change it to grab the most popular items that were also purchased with the particular item. Is that possible?

Thanks

[Ajeh]

There isn't an override for this but you could customize the define for:

DEFINE('SQL_ALSO_PURCHASED', "select p.products_id, p.products_image
                     from " . TABLE_ORDERS_PRODUCTS . " opa, " . TABLE_ORDERS_PRODUCTS . " opb, "
                            . TABLE_ORDERS . " o, " . TABLE_PRODUCTS . " p
                     where opa.products_id = '%s'
                     and opa.orders_id = opb.orders_id
                     and opb.products_id != '%s'
                     and opb.products_id = p.products_id
                     and opb.orders_id = o.orders_id
                     and p.products_status = 1
                     group by p.products_id
                     order by o.date_purchased desc
                     limit " . MAX_DISPLAY_ALSO_PURCHASED); 

This is located in the:
/includes/classes/db/mysql/define_queries.php

You would need to reconstruct how that query is done and your criteria that you want to use ...

[ryanf]

Yeah I saw that, I was hoping someone knew the sql to enter.

[Ajeh]

It grabs however many you set in the Maximum settings based on the date:

                     order by o.date_purchased desc
                     limit " . MAX_DISPLAY_ALSO_PURCHASED); 

You could try to work in the field products_ordered and see if that gives you a better selection than by date ...

NOTE: advantage of date is that when products come and go you are looking at more recent products based on recent orders ...

[vivaraquel]

I have a question in regards to the display images in the also purchased box.

I have it set so they display horizontally, 4 per row. But they are coming up vertically in a sigle column.

I set it in Configuration > Product Info > Also Purchased Products Columns per Row > 4.

Is there somewhere else that I need to set it?

[erwin208]

is there a way to reset "Also Purchased" to 0.

By making some test orders I have some strange combinations...

[CraigW]

I'm assuming you have done the test orders before you have made the site live.

I just go into Tools - Store Managerand click on Reset ALL Products Ordered to fix problems like that before making the site live.

On a new site, I also disable "Also Purchased Products" until I get enough orders in for it to be useful. Disabled by Configuration - Product Info & set "Also Purchased Products Columns per Row" = 0

[spbennett]

is there a way to reset "Also Purchased" to 0.

By making some test orders I have some strange combinations...

Delete your test orders and they won't affect the module any longer.

[lextechs]

I have a question for some reason my Also Purchased Products are not showing under the tab any ideas why see example here.

http://www.lextechs.com/index.php?ma...ducts_id=14017


Thanks in advance

[Ajeh]

What value do you have on the Configuration ... Maximum Values ...

Also Purchased Products
Number of products to display in the 'This Customer Also Purchased' box

In your tpl_products_info_display.php file do you have:

<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->

Also check in the Configuration ... Product Info ...

Also Purchased Products Columns per Row
Also Purchased Products Columns per Row
0= off or set the sort order