Hello David
We have a problem with the admin counter. When we import feeds, the click counter reset.
We need a click counter with date range which doesn't reset to each import,is it possible in PT ?
Thank you of your help
Jordanus
Ok thank you David
For the resetting at import, I'm going to verify my system, it's strange...
Hi Jordanus,
The script as it stands in the distribution should not be resetting clicks whenever you update / import a script; but you mentioned date range which implies that this might be a custom modification and possibly recording clicks in the products table.
If clicks are being recorded in the products table they will be reset at import as the first stage of importing any feed is to DELETE all product records for that feed and then let them become recreated as the feed is imported (this is by far the most efficient way to make sure the database is up to date with the feed.
One option would be to check whether a product exists in the database (for the feed being imported) at import time and if so update; otherwise insert - this needs to be combined of course with a "deleteme" flag so that expired products can be removed.
To that end, it may be worth considering moving your click tracking to a separate table where you insert / update based on the product name and then that table can exist with all records indefinitely; however if you'd like to look at the above let me know and I'll pull together the relevant info...
Cheers,
David.
--
PriceTapestry.com