Script to update special prices in Opencart database


I would like to request support with creating a script in Python or Perl that:

1) Updates special prices in an Opencart 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:


- 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


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


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


- 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.

Skills: Python, MySQL, Linux, Software Architecture, Open Cart

See more: php script update database using drop list menu, linux script update database, script update database, macro script update database excel, php script update database hour, php script update database xml, php script update database dump file, perl script update database example, php script update mysql database, script update access database javascript, ssis script update access database, script update access database web form, vbs script update access database, php script update database table, ipn script update database, php script update asterisk mysql database, script update database php

About the Employer:
( 1 review ) Rotterdam, Netherlands

Project ID: #20343720

Awarded to:


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 More

€45 EUR in 2 days
(12 Reviews)

9 freelancers are bidding on average €132 for this job


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 e More

€40 EUR in 1 day
(443 Reviews)

Hi there, I am interested in your project. I worked a similar project that scraped data from [login to view URL] and then put it to Opencart DB. I have 4+ years’ experience at Web scraping. If you'd like to view my previous work More

€120 EUR in 7 days
(94 Reviews)

Hello. I can complete it in php. Please let me know if you are interested. Thanks, Vitaliy.

€120 EUR in 7 days
(63 Reviews)

Hi, i have read the job details carefully and we are sure that we can finish project very well. We are [login to view URL] and team of 25+ members team of india based registered company since 8+ years. We are h More

€44 EUR in 10 days
(107 Reviews)

Greetings, Hope you are fine Sir, I can easily create that importer, In recent past I've create very more complex things then this, so therefore it's a piece of cake for me. I've 5+ years of experience working with More

€80 EUR in 1 day
(9 Reviews)

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 in 3 days
(12 Reviews)

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 t More

€50 EUR in 1 day
(1 Review)

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 previo More

€400 EUR in 7 days
(0 Reviews)