Hello David
Would it be possible to have a way of showing new items when importing.
I thinking about copying the list of the current products into the database as part of the import, then comparing it with the list of products after the import.
Could also do the opposite and show items which have been dropped.
Any adivce would be greatfully received.
Thanks Mally
Hi Mally,
The difficulty here is that rather than add to the table, the first stage of importing a merchant's feed is to delete all existing products. This is by far the easiest way to ensure that the database is always up to date with the latest version of the feed.
However, as you're running a niche site; it should be straight forward to basically do what you say and create a "snapshot" of the database before import and then run some comparison scripts after import to indicate additions / removals. Bear with me and I'll have a go at this on my test server...
Cheers,
David.