Modify Order Data in Magento 1.6 Database

We have an active ecommerce site that uses Magento 1.6 with live customers, orders and has been active for several months.

We recently upgraded from 1.5 to 1.6 using a fresh install and imported customers, orders, products etc to the new install.

Everything imported fine except that the ORDERS have some incorrect values and dates. We'd like to you to assist us with a direct database update of about 250 orders preferably from a CSV file if possible.

* We have all the correct data in the magento 1.5 database and Excel.

We don't want to lose the relationship between orders, customers and invoices so we'll need to update the current table.

Please advise the method you will use and whether your work includes updating the import files or just loading the data into the new database.

To get the correct values into the magento system may require fixing data in a number of different tables e.g. sales flat orders, sale flat invoices etc

PM any questions you have - this should be a relatively easy task for someone with good Magento/mySQL experience.

Skills: Data Processing, Excel, Magento, MySQL, PHP

See more: magento modify order data, magento orders table, magento sales table, magento order table, order processing work, magento mysql table order data, magento import orders, mysql data files, sales order, magento import, magento import customers, magento database, install database, import database, database ecommerce, Data tables, data in, correct csv, php flat file csv, php data table, update mysql using csv, update mysql csv php, magento excel import products, php import excel file mysql, mysql flat file

About the Employer:
( 26 reviews ) Sydney, Australia

Project ID: #1268184

Awarded to:


hi, I can help you on this. Please check Inbox. Thanks!

$50 USD in 1 day
(23 Reviews)

5 freelancers are bidding on average $53 for this job


Hi, I would really be interested in helping you with your problem. I won't get into much detail (if you want more info, feel free to PM me), but it would be to basically update the data directly from your CSV. For such More

$100 USD in 1 day
(10 Reviews)

Ready to start work.

$56 USD in 1 day
(7 Reviews)

Base on your situation, I will compare the data from old Magento 1.5 to Magento 1.6...If necessary, I will correct the date, invoice no. etc.. I have experience using UBS & MYOB software..

$30 USD in 1 day
(0 Reviews)

Hi, I have strong knowledge in PHP/MYSQL for past 4 years and also in Magento. Kindly check your PM for further details. Thanks, Vijay

$30 USD in 1 day
(0 Reviews)