Data Import from Old site to Omni : Smart E Touch

Data Import from Old site to Omni Print

Created by: Nishant Pandey

Modified on: Tue, 28 Jan, 2020 at 5:16 PM

use this query to import customer data from old website to this one.

SELECT CONCAT(fname," ",lname)as name,mobile,email,"" as house,addl1,addl2,postcode,"0" as optout FROM `customers` WHERE 1

export as csv and process for xls 2000

similarly from booking database

SELECT name,phone,email,"" as house,addr_1,addr_2,postcode,"0" as optout FROM `booking` WHERE 1

Nishant is the author of this solution article.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk