Hi,
Doing a bit of an interesting project - would like to monitor prices for particular products, for one merchant, over time.
The merchant has ~600 products, so updating it every day would mean 219000 entries in the database, which seems a bit unnecessary as prices are changed relatively rarely.
I think Price inspector does a similar thing (you can sign up for alerts); was just wondering where the best place to start with this would be.
Thanks :)
Hi David,
Cheers for that, exactly what I'm looking for.
When I do an import though, it imports as usual but without affecting the new "pricehistory" table - it just remains empty. Any ideas?
Thanks :)
Hi Harvey,
It may be a database error to do with the modification. Try using the debug version of database.php. Click here to download, unzip and upload to /includes/ after making a back-up of the original version.
Then import again, and if it is a database error the error message should be displayed and should indicate what the problem is...
Cheers,
David.
Hi,
Strangely when I implement the given code, the admin page is blank. Have put it just between:
if (database_queryModify($sql,$insertId))
{
$admin_importProductCount++;
}
and
if ($admin_importCallback)
{
if (!($admin_importProductCount % 100))
{
$admin_importCallback($admin_importProductCount);
}
}
Cheers
Hi again,
Hmm, the new admin.php seems to be making my admin page disappear - maybe it's not in the right place?
It's between:
if (database_queryModify($sql,$insertId))
{
$admin_importProductCount++;
}
and
if ($admin_importCallback)
{
if (!($admin_importProductCount % 100))
{
$admin_importCallback($admin_importProductCount);
}
}
so starting on line 288.
Hi Harvey,
Have a look at the following thread which should help get you started...!
http://www.pricetapestry.com/node/3001
Cheers,
David.