Đang Thực Hiện

Copy / Migrate cells from MySql data base for ecommerce store

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

Kĩ năng: Lập trình cơ sở dữ liệu, MySQL

Xem nhiều hơn: mysql database buy, buy recreate, full website build, copy exitsing website build site, drag drop website build bracelet, teacher rating website build, bid website build, common questions freelance website build, website build bid, poker website build

Về Bên Thuê:
( 17 nhận xét ) Auckland, New Zealand

ID dự án: #10658822

Được trao cho:

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 trong 1 ngày
(6 Đánh Giá)
3.5

3 freelancer đang chào giá trung bình $62 cho công việc này

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 trong 1 ngày
(38 Nhận xét)
6.3
$100 NZD trong 3 ngày
(1 Nhận xét)
0.8
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 Thêm

$155 NZD trong 3 ngày
(0 Nhận xét)
0.0
PawanKumarIND

I am pawan Kumar. I am a Software Developer and website developer. I have 5 years of experience of Web development. I am expert in Asp.net, PHP, Html, CSS, html5, ajax, javascript and some of CMS like WordPress, Joomla Thêm

$56 NZD trong 3 ngày
(0 Nhận xét)
0.0