Find Jobs
Hire Freelancers

Script to update special prices in Opencart database

€15-30 EUR

Terminado
Publicado hace más de 4 años

€15-30 EUR

Pagado a la entrega
Hello, I would like to request support with creating a script in Python or Perl that: 1) Updates special prices in an Opencart 1.5.6.4 database (mySQL), based on a input text file (CSV) 2) Create and sent a html mail report with the updates performed 3) Extra option (parameter) to display all products in the Opencart database using a Special price. 4) Extra option (parameter) to remove all Special prices in the Opencart database The script will be used on a Linux server (CentOS 6) via a scheduled task (cron) Required actions: 1) - Read an import CSV text file that contains: # unique product number, # special price, # start date, # end date - Verify for each record in the CSV text file if a product exists in the Opencart database (table oc_product) by comparing unique product number. ('model' field is used for this) - Use the data from this product/record, and lookup if there is a related record for special price in the oc_product_special / oc_product_special tables - if the record exists: update record with the special price, start date and end date - if the record does not exist: create a new record with the special price, start date and end date - Verify/test if the special price is visible on the website 2) Create and send a mail report with the updates (#1) in special prices performed, using a table that contains: # unique product number # product short description # normal price # special price # start/end date of special price 3) Create a report that contains all products in the database with a Special price assigned, details: # unique product number # product short description # normal price # special price # start/end date of special price 4) - Remove all existing Special prices in the database - Verify/test special prices are removed on the website NB. Experience with Python/Perl, MySQL and Open Cart are required for this project.
ID del proyecto: 20343720

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 5 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
Adjudicado a:
Avatar del usuario
Hello. I can help with the perl script to update the OpenCart database. I'm a senior full-stack developer and have more than 15 years of experience of working with and administering Unix/Linux and its variants. I'm also well versed with Perl, Bash and Python. I have also worked on several projects using WordPress / WooCommerce and OpenCart. I think that I have the necessary expertise to work on your project and will be able to do a good job. Looking forward to hearing from you. Thanks, Ravi
€45 EUR en 2 días
5,0 (12 comentarios)
4,3
4,3
9 freelancers están ofertando un promedio de €132 EUR por este trabajo
Avatar del usuario
I can provide you a Python script that will perform above tasks. It will read input CSV file and update your Opencart MySQL database in the way you need it. After update it will send you a HTML report with details on each operation.
€40 EUR en 1 día
4,9 (443 comentarios)
7,4
7,4
Avatar del usuario
Hello. I can complete it in php. Please let me know if you are interested. Thanks, Vitaliy.
€120 EUR en 7 días
4,8 (63 comentarios)
6,5
6,5
Avatar del usuario
I am good in perl, mysql along with development and automation stuff, please let me know if you are good to award this project to me
€288 EUR en 3 días
4,9 (12 comentarios)
4,3
4,3
Avatar del usuario
Hello, I'm multi-skilled software engineer with 15+ years of experience and would be glad to help you with your project. Additionally I have extensive experience with MySQL and did several projects with OpenCart in the past.
€50 EUR en 1 día
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
I have the technical skills and that attitude to take over the project and deliver it on time. I have more than 20 years of professional experience doing similar projects in large companies and I can reuse the previous experience to deliver something that you can really appreciate and run without a problem. Kind Regards N.
€400 EUR en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NETHERLANDS
Rotterdam, Netherlands
5,0
1
Forma de pago verificada
Miembro desde feb 21, 2016

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.