You are here:  » Product import query

Support Forum



Product import query

Submitted by FirstByte on Wed, 2008-10-08 05:05 in

Hi David,

Have a question about the import feature, When using the @MODIFIED command for importing feeds, will the command delete products that are no longer on the latest feeds?

If so, I'd like to be able to still display those "sold out/delete" products more from a SEO point of view.

Is this something that's possible?

regards
Rod

Submitted by support on Wed, 2008-10-08 09:44

Hello Rod,

Yes, @MODIFIED (or any method of importing any feed) always starts by deleting every record for that merchant before importing. This is simply to make sure that the database is always "up to date" and in sync with the feed that has just been imported.

Persisting existing records should be possible (and with not much more work marking them as "Sold Out" so that you don't confuse users). Bear with me and i'll look at the implications of this for you and try and post some code - there's shouldn't be much change needed...

Cheers,
David.

Submitted by paul30 on Mon, 2008-10-13 09:44

Just to follow up, I am also VERY interested in this... Also it would be great if the "sold out" products would be marked with "current time" as soon as they became "sold out" (on the feed import I assume) and the "time" field would erase on the next import if the product become available (lets say after a few weeks)...

This way we could track the sold out products, and delete them when ever we want simply issuing something like "DELETE FROM products WHERE time > (what ever time you want here)"

Thanks a lot!

Pasha

Submitted by paul30 on Mon, 2008-10-20 05:05

hello, just wondering if we have any progress with that, or if we should expect it at all...

Thank you very much!
Pasha

Submitted by support on Mon, 2008-10-20 09:48

Hello Pasha,

Sorry for the delay, it's not such a straight forward mod this one. Could you perhaps drop me an email with your existing includes/admin.php and i'll take a look for you...

Cheers,
David.