I have an idea to set up a site similar to www.staticice.com.au, (no actual product page, just click direct on the search link to get to the merchant's site) but what I want to know is if I can record the number of clicks a product gets? (among other things)
Since the product table gets wiped out during a feed import I can't just tack on an extra field to the product table. I was thinking of using the product name and the merchant id as a unique key and then store this in another table along with the number of views. Does this seem like a good idea? Searching by strings seems like it would be very slow instead of a number...
The actual code for increasing views I can easily code in but it's just the design part...
Any ideas would be greatly appreciated, thanks.
Peter
Hello Peter,
Yes - that is the best way to do it. In fact, someone asked about this recently and there is some code to do this in the following thread:
http://www.pricetapestry.com/node/1832
Cheers,
David.