Closed

MySQL - Add new products from one database to another

This project received 18 bids from talented freelancers with an average bid price of $130 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
18
Project Description

The old database is still active for a live site. We are building a new site but has an old version of the database, since then it has got new orders, customers and products. We need to add this data to the sandbox site regularly as we develop.

We need a script that we can run that will append to our new database (oscmax 2.3.5) specific information from an old but still active database (oscommerce 2.2) starting from the common point of them both. You do not need to necessarily know oscommerce at all to make us what we are asking.

This is not a full port since we already did that. Repeat, we are not porting a full database, just taking new additions on specifically listed (below) tables from the old database and "appending" to the new. Since the new (oscmax) database has some minor differences, all rows that are new will have a null value. Below is tables we need appended with the column differences between databases.

customers - 6 vs 10
customers_info - 12 vs 22

orders - 45 vs 51
orders_products - 11 vs 13
orders_products_attributes : 7 vs 10
orders_products_download : same
orders_status : 3 vs 5
orders_status_history : same
orders_total : same

products - 15 vs 24
product_attributes - 7 vs 11
products_description - 9 vs 16
products_to_categories - same

This can be a bash script that compares two sql files and creates an output for import or any type of runnable code we can hit a button on and make work.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online