Copy / Migrate cells from MySql data base for ecommerce store

In Progress Posted 7 years ago Paid on delivery
In Progress Paid on delivery

We have a Prestashop based ecommerce store that we want to manually copy the content (customers, address, orders) from and insert into new prestashop based shop

Instructions =

On old prestashop database, select these tables

ps_address

ps_cart

ps_cart_product

ps_connections

ps_connections_source

ps_customer

ps_customer_group

ps_customer_message

ps_customer_thread

ps_guest

ps_message

ps_orders

ps_order_carrier

ps_order_detail

ps_order_detail_tax

ps_order_history

ps_order_invoice

ps_order_invoice_payment

ps_order_payment

ps_order_state

ps_order_state_lang

After that, you select "export" and save that file.

Then, you go to your new prestashop database and you delete those tables mentioned above (ONLY THOSE ONES, MAKE SURE YOU ARE INDEED SELECTING THE RIGHT ONES).

Now you have to import the file you exported from your old prestashop (not the entire backup, obviously... only the file that you exported with those tables selected)!

After import the tables, you will now have to recreate come columns. Now this is a VERY important step, and if you don't do it correctly, your store will NEVER work! (if you don't know how to do this, ask a professional to do it for you or simply buy a module to export and import your stuff)

- Add column "mobile_theme" to "ps_cart" as tinyint(1) and 0 as default

- Add column "id_lang" to "ps_customer" as int(10) and NULL as default

- Add column "date_upd" to "ps_customer_message" as datetime

- Add column "mobile_theme" to "ps_guest" as tinyint(1) and 0 as default

- Add column "mobile_theme" to "ps_orders" as tinyint(1) and 0 as defau

Database Programming MySQL

Project ID: #10658822

About the project

3 proposals Remote project Active 7 years ago

Awarded to:

awantech

I am a mysql expert and have complete understanding of prestashop table structure. I can provide you this work without lost of any data.

$70 NZD in 1 day
(6 Reviews)
3.5

3 freelancers are bidding on average $62 for this job

mindprogram

Hi there, I am an expert in MySQL and can do this for you perfectly according to the instructions. Would like discuss more with you. Thanks.

$60 NZD in 1 day
(38 Reviews)
6.3
intellisoft5

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c More

$155 NZD in 3 days
(0 Reviews)
0.0