Sedang Disiapkan

Script to update special prices in Opencart database

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.

Kemahiran: Python, MySQL, Linux, Kejuruteraan Perisian, Kart Terbuka

Lihat lagi: 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

Tentang Majikan:
( 1 ulasan ) Rotterdam, Netherlands

ID Projek: #20343720

Dianugerahkan kepada:

rdmrla

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 Lagi

€45 EUR dalam 2 hari
(8 Ulasan)
3.3

10 pekerja bebas membida secara purata €123 untuk pekerjaan ini

gangabass

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 Lagi

€40 EUR dalam sehari
(407 Ulasan)
7.3
etuannv

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 Lagi

€120 EUR dalam 7 hari
(74 Ulasan)
6.5
oscworker

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

€120 EUR dalam 7 hari
(63 Ulasan)
6.5
kodecubeinfosys

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 Lagi

€44 EUR dalam 10 hari
(98 Ulasan)
6.1
phantom1222

Hello. I have read your job description carefully and I am very interested. I am Web expert with rich experience of 10+ years and so I have professional skills for your project. My communication is very good in Englis Lagi

€40 EUR dalam 7 hari
(12 Ulasan)
4.5
ashpreet

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 Lagi

€80 EUR dalam sehari
(6 Ulasan)
4.1
goodwork20k

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 dalam 3 hari
(5 Ulasan)
3.0
msmith2201

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 Lagi

€50 EUR dalam sehari
(1 Ulasan)
0.6
alexannick

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 Lagi

€400 EUR dalam 7 hari
(0 Ulasan)
0.0