Update instead of Delete

Submitted by ukresident on Sat, 2008-10-11 17:14 in Price Tapestry

Hi all,

just wondering if the following is possible:

currently when a feed is refreshed, it deletes all items in the old feed and refereshes the database with items in the updated feed.

Is it possible to have it so that when refreshing the feed, it doesn't delete the old items in the dataabse but isntead updates them (if there are new items in refeshed feed)?

Not sure if that makes sense.

Thanks for your help

Anton

Hello Anton, It is possible,

Submitted by support on Mon, 2008-10-13 08:03

Hello Anton,

It is possible, but has performance implications during import as every products needs a sequence of SQL calls rather than a single, fast INSERT query. More importantly however, is how you deal with "old" products. Do you need them to be marked in some way so that the links are no longer provided through to the merchants? This is similar to what another user has asked for recently...

http://www.pricetapestry.com/node/2333

Cheers,
David.

Thanks David, The link you

Submitted by ukresident on Mon, 2008-10-13 10:19

Thanks David,

The link you prvided doesn't provide the modified code, is this available?

Also, old links do not need to be marked in any way, I would like them to still point to the merchant.

Many thanks

Anton

Hello Anton, I haven't put

Submitted by support on Mon, 2008-10-13 10:23

Hello Anton,