AP Preselection

for osCommerce Online Merchant v2.2

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

Files