Write OpenCart (V1.5.1.3) Stored Procedure in MySQL V5.1

A zipped XML file is received weekly from my supplier direct to a Public FTP account on my web server. I download this file (22Mb), open it in Excel and delete all but the Stock_id, Retail & Cost price columns and then save as a CSV file. (This is because Navicat Lite cannot properly interpret the layout of the XML file due to cost and retail prices being nested).

I then run a couple of queries to Drop and Create the following additional tables in the OpenCart database:-



I then Import the XML file into FullSTK using Navicat and also import the Cost & Listprice CSV into Cost_and_retail_prices.

I then run the following update queries:-

1) Update FullSTK with Cost and Retail prices

2) Update FullSTK to change the PublishedDate format – changes date to YYYY-MM-DD

My server runs MySQL V5.1.

Whilst this is not the most important area, it would be good to unzip and load the XML file into the temporary tables on the server - please provide quote.


I then create a second temporary table called oc_temp which is populated from FullSTK and provides all the data to update oc_product and oc_product_description. I’ve written some procedures to insert/update oc_product and oc_product_description from oc_temp, which I’m not happy with. The join between oc_temp and oc_product can be sku, but this doesn’t exist on oc_product_description, which causes me the problem. I assume oc_product and oc_product_description can be joined on product_id and the update from oc_temp, based on sku, can update both tables – this is really what I need a quote for.

Kemahiran: AJAX, MySQL, PHP, Reka Bentuk Laman Web

Lihat lagi: opencart mysql, website design procedures, website design procedure, web layout for retail, web layout design download, web design lite, unzip ftp, procedure to design website, navicat xml, m format in excel, layout web design download, ftp unzip, download php 5.3, delete quote, database design prices, opencart xml import, mysql 5.1, download mysql, xml supplier, v5, stored, stored procedures, procedure of create website, php opencart, opencart

Tentang Majikan:
( 79 ulasan ) Shrewsbury, United Kingdom

ID Projek: #1573987

15 pekerja bebas membida secara purata $513 untuk pekerjaan ini


********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and get Lagi

$1000 USD dalam 8 hari
(119 Ulasan)

I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, Lagi

$888 USD dalam 7 hari
(66 Ulasan)

Hello, Please check PMB for the details. Regards Sneha

$550 USD dalam 3 hari
(17 Ulasan)

hi there Maximum opencart reviews Please check inbox Regards Shambhal

$300 USD dalam 5 hari
(126 Ulasan)

Hi, XML, PHP, MySQL expert here. Please view PM. Thanks Harish.

$301 USD dalam 5 hari
(68 Ulasan)

hi, i can help this project for you. thank.

$350 USD dalam 10 hari
(74 Ulasan)

Opencart expert [login to view URL] check ur PMB.

$750 USD dalam 20 hari
(36 Ulasan)

You will find an elegant and outstanding design with all thefeatures as required by you. Seeportfolio and samples attached.

$400 USD dalam 18 hari
(19 Ulasan)

Hi, I have PHP/Mysql experience and worked on CSV report generation, xml parsing related projects. I can work on this and ready to get started. Thanks

$500 USD dalam 15 hari
(6 Ulasan)

Hello, I would like to say something on PM. Have read and understood the requirements fully. Thanks. Atanu.

$650 USD dalam 18 hari
(4 Ulasan)

Hello from Europe. We're new in freelancer.com system, but we have extensive experience in developing web-based business solutions. For details see your private message box.

$450 USD dalam 10 hari
(2 Ulasan)

No problem. My server probably munches 20 meg of xml every 3 or 4 minutes. .

$250 USD dalam sehari
(1 Ulasan)

Pls check PMB.

$750 USD dalam sehari
(0 Ulasan)

please check pmb

$300 USD dalam 5 hari
(0 Ulasan)

Hi, I know OpenCart (V1.5.1.3), I am very good in PHP and MySql. Thanks!

$250 USD dalam 15 hari
(0 Ulasan)