Relevant Store Products on Threads & Search
 

This hack will use data from your online store database (or whatever data source you want) and determine which are the most relevant products to show at the top of a thread. It will also show relevant products related to search queries.

It accomplishes this task by some clever javascript that gets the most common occurrences of words / phrases in your posts, and does some clever mysql logic to figure out what is most relevant.

This hack comes with an option for users with over 50 posts to turn OFF seeing these products.
You need to make 2 template modifications, add some CSS and Javascript, and drop in the PHP files. Also add 1 field to the user table (sql statement included) Then edit the relevantProducts.php file to match whatever data you have. Its setup right now for a Volusion API export.

Files:
relevantProducts.php
relevantProductsAjax.php
RP-plugins.txt
RP-search template changes.txt
RP-box template.txt
RP-css.css
RP-debugging.php
RP-hide/show template changes.txt
RP-jQuery Plugin.js
RP-jQuery Plugin Usage.js
RP-sql.sql

https://vborg.vbsupport.ru/external/2011/07/32.png
https://vborg.vbsupport.ru/external/2011/07/33.png


To make this better for later, your store might also give you product popularity, something our store does not. Factoring that in would increase the relevance of the products.

If you like this hack please donate to paypal@mp3car.com
Thanks!

Hooo great!!! Thanks

Do you think if functionally with Mercado livre? www.mercadolivre.com.br

Yea it shouldn't be a problem. You will just need to match the correct database fields in relevantProducts.php.

If you know a little PHP you can swap out the correct database fields and table names.

This works with any online store software? Or just Volusion?

The current files work with Volusion, but you just need an XML output of products from any store and it will work.

The script takes a little bit of "making it work for you" because store databases are so different. But its well commented and should be easy to see where things need to go. Volusion was easy because they have an XML output of orders from their API