PHP/MYSQL coding on datafeed/database site

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:

The problem is, we want to edit, delete and categorise individual products, but when the datafeed is re-imported, obviously our changes are erased.

The overview:

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.


Beceriler: PHP, XML

Daha fazlasını gör: pricetapestry, problem categories, php create table, create website coding, create table php, coding we, code coding, check point software, comparison site mysql, php mysql comparison table, mysql coding creator, coding record already exists php mysql, datafeed database, mysql mean, want a price to produce software, uk database, sku, price comparison script, php script create table, php co

İşveren Hakkında:
( 13 değerlendirme ) Brighton, United Kingdom

Proje NO: #127973



Hi friend, I just downloaded [login to view URL] and anatomized some technical details, I basically agreed your proposal, one table should be added to reserve the modification and deletion, the related data will be manua Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 60%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(79 Değerlendirme)

Bu iş için 2 freelancer ortalamada $80 teklif veriyor


Professional work from professionals!

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(220 Değerlendirme)