The current setup:
The website in question is a MYSQL price comparison website, which is updated via XML datafeeds.
We have pricetapestry software in place, which allows datafeeds to be uploaded, automatically populating the product database. Currently, when a datafeed is re-imported/updated for a particular shop, a full data refresh takes place – i.e. the current datatable is deleted, and replaced fully with all the products from the new datafeed.
The problem is, we want to edit, delete and categorise individual products, but when the datafeed is re-imported, obviously our changes are erased.
Therefore, the bid request is to produce an admin interface that will not only edit the current product in the database, but add a record to a new table/database with the product’s new title and SKU (the unique product identifier each merchant has for all products).
Then, when the product feed is re-imported, your script should check to see if modifications have been made to a product, and if they have, make the modifications as part of the datafeed re-import (well, just after it anyway).
Similarly, it should also allow certain products to be hidden (not entirely deleted though). This would probably be done by adding a column to the existing database, and adding a record to the table of changes.
Products should also be able to have up to three categories assigned to them. As with the above features, the category data must remain after the feed is re-imported. You’ll also need to create a table for categories, which can be edited by the admin, and a page showing all categories. See point 8 on page 7.
Finally, a “merge” feature is needed. This will pretty much use your existing code above, but mean a button next to related products (related products module already exists) to change their title to the current product being viewed. See page 5 for details.
PLEASE SEE THE FOLLOWING FILE FOR A FULL EXPLANATION: [url removed, login to view]