AP Preselection

Also Purchased using pre-selection via scheduled php job

Most will be aware that the normal osc also purchased schema is somewhat limited as it only counts products as also purchased when they are purchased in the same order as the one you are looking at. If that product was also purchased by a customer which purchased this one but did that in a separate order, the product will not be selected.

Ofcourse there is a very good performance reason for this.

So now with this scheme of taking that query off-line in a scheduled job and putting the result in the ap_preselection table for fast online access we can engage in actually determining the real also purchased information.

So I have changed the ap_preselection job to do just that.
It selects products which customers also purchased regardless of whether that purchase was done in the same order as long as it was done by the same customer.

Normal stock OSC scenario :

customer A purchased product 1 and product 2 in order X
customer A purchased product 3 and product 4 in order Y

look at product 1 -> product 2 is AP
look at product 2 -> product 1 is AP
look at product 3 -> product 4 is AP
look at product 4 -> product 3 is AP

Real AP scenario :

customer A purchased product 1 and product 2 in order X
customer A purchased product 3 and product 4 in order Y
look at product 1 -> product 2, 3 and 4 is AP
look at product 2 -> product 1, 3 and 4 is AP
look at product 3 -> product 1, 2 and 4 is AP
look at product 4 -> product 1, 2 and 3 is AP

v1.1

10/01/2009 by homewetbar

UPDATES:
- Added the order cutoff (preset to 1 year) so only products purchased in the last year will be shown credit Chemo
- Updated includes/modules/also_purchased.php query to randomly display the also purchased products
- Added list of indexes to add to database (greatly speeds up cron query) credit Chemo

AP Preselection

01/04/2007 by mijman2

Same as below except 2 bug fixes:
1) dont need reference to configuration_cache_read.php
2) added p.products_id - prior version did not work correctly because the product_id field was being left blank and therefore linked to an error page.

Not a bad contribution!

AP Preselection

06/24/2005 by amanda

Also Purchased using pre-selection via scheduled php job

Most will be aware that the normal osc also purchased schema is somewhat limited as it only counts products as also purchased when they are purchased in the same order as the one you are looking at. If that product was also purchased by a customer which purchased this one but did that in a separate order, the product will not be selected.

Ofcourse there is a very good performance reason for this.

So now with this scheme of taking that query off-line in a scheduled job and putting the result in the ap_preselection table for fast online access we can engage in actually determining the real also purchased information.

So I have changed the ap_preselection job to do just that.
It selects products which customers also purchased regardless of whether that purchase was done in the same order as long as it was done by the same customer.

Normal stock OSC scenario :

customer A purchased product 1 and product 2 in order X
customer A purchased product 3 and product 4 in order Y

look at product 1 -> product 2 is AP
look at product 2 -> product 1 is AP
look at product 3 -> product 4 is AP
look at product 4 -> product 3 is AP

Real AP scenario :

customer A purchased product 1 and product 2 in order X
customer A purchased product 3 and product 4 in order Y
look at product 1 -> product 2, 3 and 4 is AP
look at product 2 -> product 1, 3 and 4 is AP
look at product 3 -> product 1, 2 and 4 is AP
look at product 4 -> product 1, 2 and 3 is AP