Forum Moderators: coopster
I have searched on this topic and not really come up with anything either on the net or here.
The only topic I found was this:
[webmasterworld.com...]
where the linked artice (via another topic) is now a 404 page.
So back on track.
I am looking to implement this into a large shopping site where there are a large (not amazon size but 1000+) number of products available.
I would like some suggestions on database tables, important coding considerations and any tutorials or script that are already available.
At present all orders go via (secure) email and are recorded on a different system from where the site and it's database are, so this can be started from scratch recording orders and products etc.
Thank you.
[zend.com...]
a little bit of alteration can be used to make the code more accurate.
Another way to do this is to record lists of transactions in one table. For example colon seperated product id's for each transaction: :100:101:102:534:890:130:
then every night run a script that flies through all that days/weeks transactions, works out which products sell most with another product and then stick the top few (5/10/15) products that sell with another product into the actual product info table. Again seperate them with colons and this time order them so that first is the most affiliated product.
The second way means only a simple call is needed for each page. Most of the work is done at night by the main script which totals and then writes to database.
The second way also allows a better system for manipulating the data. If a product is on offer you may want it at the top of the list!
When I start writing the code I will come back and add to this thread.
