Closed

: PHP/MYSQL coding to allow editing to MYSQL site & remain after datafeed refresh

This project received 6 bids from talented freelancers with an average bid price of $63 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $90 USD
Total Bids
6
Project Description

The website in question is a MYSQL price comparison website, which is updated via XML datafeeds. We have pricetapestry PHP/MYSQL 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 a simple 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). **Please see deliverables for more thorough explanation and find document attached for more details (which also forms part of the deliverables)**

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.


2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
The website in question is a MYSQL price comparison website, which is updated via XML datafeeds. We have pricetapestry PHP/MYSQL 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 a simple 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, and a page showing all categories. See point 8 on page 7. - Merge feature: 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 find the attached document for further explanation. The work should probably take less than five-seven hours, and you will be given access to the entire site including the database. Please do ask if you have any questions.
* * *This broadcast message was sent to all bidders on Sunday Feb 25, 2007 9:26:56 AM:



Hello,

Unfortunately I am having to cancel this bid request due to persistent problems with Rentacoder & Paypal, which I was only informed of once I tried to select a coder!

The project has however been posted on another well known freelance site, who do take paypal. Gaf.

## Platform

- Linux server - Apache - PHP - MYSQL

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online