Find Jobs
Hire Freelancers

Script to update special prices in Opencart database

€15-30 EUR

Teljesítve
Kiadva ekkor: több mint 4 évvel ezelőtt

€15-30 EUR

Teljesítéskor fizetve
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.
Projektazonosító: 20343720

A projektről

9 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
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 2 napon belül
5,0 (12 értékelés)
4,3
4,3
9 szabadúszó adott átlagosan €132 EUR összegű árajánlatot erre a munkára
Felhasználó avatár
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 1 napon belül
4,9 (443 értékelés)
7,4
7,4
Felhasználó avatár
Hello. I can complete it in php. Please let me know if you are interested. Thanks, Vitaliy.
€120 EUR 7 napon belül
4,8 (63 értékelés)
6,5
6,5
Felhasználó avatár
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 3 napon belül
4,9 (12 értékelés)
4,3
4,3
Felhasználó avatár
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 1 napon belül
5,0 (1 értékelés)
1,0
1,0
Felhasználó avatár
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 7 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

NETHERLANDS zászlója
Rotterdam, Netherlands
5,0
1
Fizetési mód hitelesítve
Tagság kezdete: febr. 21, 2016

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.