Em Andamento

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.

PLEASE SEE THE FOLLOWING FILE FOR A FULL EXPLANATION: [url removed, login to view]

Habilidades: PHP, XML

Ver mais: 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, mysql admin, import mysql, import database, edit php, database admin

Acerca do Empregador:
( 13 comentários ) Brighton, United Kingdom

ID do Projeto: #127973

Premiar a:

wincent

Hi friend, I just downloaded [url removed, login to view] 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 Mais

$60 USD em 3 dias
(79 Avaliações)
6.0

2 freelancers estão ofertando em média $80 para este trabalho

pentium10

Professional work from professionals!

$100 USD in 5 dias
(220 Comentários)
6.9