I have an OSCommerce V2.2 based website. I have a new table in the database that in this table I enter all products information including the category, prices, image files etc. Now I need a php file that will do the below
a) find products currently in the store not listed in this new table and set their status not to be shown. Also update the products_last_modified filed
b) find products that were previously maked not to be shown and are now in this new table to be showen in the store again. Also update the products_last_modified filed
c) update existing products in the store with new information from the new table in the store (like description updates, price updates etc). Also update the products_last_modified filed
d) find products in the new table that don't exist in the store and insert them in the store. Also update the products_date_added
This new table had an id to every products and ther is a corresponding ID in the OSC Products database, so it's easy to find new products etc by just matching the ID's.
12 freelancers are bidding on average $145 for this job