Theoretically yes, but it's complex and has performance issues (the easiest way to keep everything up-to-date with the merchant's feeds is just to DELETE and INSERT again).
Do your XML feeds have a product ID available that you could use instead of relying on the database ID? If that's an option, have a look at the following thread for instructions on adding a new field to your site which could then be used to hold the ID...
Hi Mick,
Theoretically yes, but it's complex and has performance issues (the easiest way to keep everything up-to-date with the merchant's feeds is just to DELETE and INSERT again).
Do your XML feeds have a product ID available that you could use instead of relying on the database ID? If that's an option, have a look at the following thread for instructions on adding a new field to your site which could then be used to hold the ID...
http://www.pricetapestry.com/node/313
Cheers,
David.