Copy / Migrate cells from MySql data base for ecommerce store
$30-250 NZD
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
Project ID: #10658822
About the project
Awarded to:
I am a mysql expert and have complete understanding of prestashop table structure. I can provide you this work without lost of any data.
3 freelancers are bidding on average $62 for this job
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.
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