Hi all
I run a nightly script which takes affiliate feed XML data and inserts it into my database. It is a REPLACE INTO query.
Now, I have hundreds of thousands of records as it is a price comparison website.
In a nutshell, my client needs to be able to edit some or all of the product data on the website via my CMS however this leaves me with a problem in that I replace the whole record when I import the affiliate data which will overwrite the clients changes. The client has asked if it would be possible to be able to detect if they have made a change to a field in a record and not update that field, but to update the other fields of the same record that have not changed.
Now, on first thought, this would seem an impossible task to achieve based on the high volume of data within the database but I thought I would ask if anyone out there has any thoughts on if this could be done and if so, what would be the best method of doing it!
Many thanks for reading
kbc
