I try to import my existing customers to the new site which is prepared using prestashop. I prepared the cvs file as in the samples.I have over 17000 existing customer records. When I tried to import whole file I managed to insert around 5000 records. I thought that maybe this number is too high for prestashop it causes some memory problems. Later I divided original file into smaller files which have 5000 records at most than I could import around 1500 records :) Later I tried file with 1000 records result was even smaller.
In the end I tried file with 200 records at most and I could import around 87 using cvsimport. This is meaningless. Everytime I clear the table before cvsimport... I don't get an error. It looks like import finishes correctly but when I check the # of records I see the bad result....
Is this a known issue? How can I solve this ?
I also inserted the customers usind sql script. I utilized excel to prepare the sql scripts. First I divided my data to 17 different tabs later I prepared sql for 1000 records at most. Even if I enter data with sql script I had problem with data bigger than 1000 records.
This is a sample sql
INSERT INTO
ps_customer
(active
,id_gender
,email
,passwd
,lastname
,firstname
,newsletter
,optin
) VALUES (1,9, "[email protected]", MD5(CONCAT('cookiekeycookiekeycookiekey','password')),"surname","name",1,1);Later you should run the script below otherwise you can not login
INSERT INTO
ps_customer_group
(id_customer,id_group) SELECT id_customer,3 FROM ps_customer WHERE id_customer NOT IN (SELECT id_customer FROMps_customer_group
)In my existing data I had the address in the same table but in prestashop adres is stored in another table. I prepared the sql below to use the customerid s in address table.
INSERT INTO
ps_address
(id_customer
,id_country
,id_state
,alias
,company
,lastname
,firstname
,address1
,postcode
,city
,phone
,phone_mobile
,vat_number
) VALUES(( SELECT
id_customer
FROMps_customer
WHEREemail
= "[email protected]" ), 211 , 0 , " Adres1 "," "," Surname "," Name ","Adress details "," 10000 "," İstanbul "," tel1 "," mobile tel "," "));That all ...
Ferda