Find Jobs
Hire Freelancers

PHP/MySQL Developer(s) Required for Database Manipulation Scripts

$100-300 USD

Cerrado
Publicado hace más de 18 años

$100-300 USD

Pagado a la entrega
We are interested in hiring a PHP developer/team on a long-term contract basis who is can create PHP scripts to amnipulate database data. Database used is MySQL database (see attachment). Background We have created web crawlers to crawl various sites for data. This data is being populated into various tables in the database. We need to ensure the data is up-to-date and accurate, as well as "scrubbed". We have the need for the following scripts/functions: 1. Keyword Matching Script – Script to ensure that duplicate records are not being created for the same information. Code must gauge the proximity of the match, based on an algorithm which matches key words. This script will be utilized to match keywords in various tables and thus should be fairly flexible. 2. Deletion Script – Script which deletes repetitive or expired listings (based on expiration date field) from tables and inserts them into the table of purged records ([purged_record]). 3. Record Matching Script – Code which attempts to match nearly identical records found during the execution of the on-demand crawlers to existing records in various tables based on matching criteria. Algorithm will be explained. 4. Local Retailers Store Number Script – Given stores with a brick and mortar presence in the database, will search the brick and mortar stores’ websites to retrieve the store information, specifically the store number (e.g., “BestBuy #48” matching an actual physical location) and any other missing store information not already recorded in the store table. 5. Product Picture Script – Given a product, be able to capture and store the picture of the product in a picture table in the database. Avoid duplication of pictures. 6. UPC Code Matching Algorithm – Match a product based on various attributes (namely Brand and Model and/or Key Words) to a product in an existing UPC database to retrieve the product’s UPC Code, which will be stored in the product table. You may use the Keyword Matching Script to achieve this. 7. Other scripts, as you deem necessary to achieve the scripts above. NOTES: 1. The scripts should enable another PHP page to execute it as needed (i.e., initiated when required) and the data parsed into the appropriate tables, without duplication of records. 2. Contractor will agree to and sign the Service Agreement contract. 3. Quote provided on a bundled basis. Payment will be contingent upon meeting milestones throughout the project (i.e., delivering working code). The final payment will be made before the end of the entire project dependent on meeting all requirements and conclusion of testing. 4. Contractor must participate in bi-weekly meetings and provide daily status updates. Once a project starts, you must provide daily updates and must be available on an ad-hoc basis for conference calls via Skype. Conferencing will be conducted on GotoMeeting (already paid for). 5. Scripts must be periodically backed up, uploaded and tested on our servers. Final acceptance of a script is contingent on testing and approval by management. 6. Contractor will provide project timeline, noting milestones of when various scripts and web crawlers will be delivered, unless agreed upon in the Service Agreement. If the contractor anticipates that it will miss the deadline, management must be notified. Any delays in the project timeline must be agreed by both parties. 7. Contractor will work closely with PeerShopper™ team members in testing and integrating scripts into existing code. 8. Contractor will provided evidence of previous work using PHP. 9. You must include 1 month of assistance and upgrades, as deemed necessary upon successful completion of the project.
ID del proyecto: 43792

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 18 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de UNITED STATES
Wilmington, United States
5,0
5
Miembro desde nov 9, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.