Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Trying to import customers in DataFlow
 
lilicrashes
Jr. Member
 
Total Posts:  30
Joined:  2008-10-23
 

I can upload the csv files with no problem, I am using openOffice. It sees the file and starts running it and I get a
“Skip import row, website “website” field does not exists

I have 1600 people to import. I make pics of the error, the setup in dataflow and a layout of the csv file.. Can someone PLEASE HELP ME!!??

I am also using the field mapping as you can see from the pic.. Obsivioulsy I am doing something wrong and I am not sure what.

Image Attachments
csvFile.jpgDataFlowWindow.jpgdataFlowCustomers.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
Brandlive_br
Guru
 
Avatar
Total Posts:  653
Joined:  2008-05-19
Buenos Aires, Argentina
 

I’m not sure about import customers.
Why you don’t create one Customer into the backend.
After that, export that information, and compare with your csv file.

That’s the way that I used in my firsts imports with the Datalflow.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lilicrashes
Jr. Member
 
Total Posts:  30
Joined:  2008-10-23
 

thanks I figured it out. I did what the 1st reply said, and made a fake user in magento.

then I exported that user to get the csv file. Once I got it I saw what I was doing wrong.. I didn’t map it properly. I was able to import all the firstnames, lastnames, email and md5hash passwords with no problem. Now the new problem I have is getting over the addresses because they were in a totally different table in my database and it doesn’t match up with the users.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lilicrashes
Jr. Member
 
Total Posts:  30
Joined:  2008-10-23
 

In (Zen cart)

to get all the addresses and people together (2 tables to join) use the following code in phpmyadmin and export it out into a csv file:

SELECT *
FROM wccustomers
INNER JOIN wcaddress_book
ON wccustomers.customer.id = wcaddress_book.customer_id

Ok now I got the addresses in the csv file and formatted, but even though I have all my data in the file it still only allows the email, firstname and lastname and password into magento… I filled in the other columns with addresses city and state/zip but that isn’t showing up in magento after the import....

why? I used the same csv file from dataflow when I exported out the dummy account....

 
Magento Community Magento Community
Magento Community
Magento Community
 
BobC
Jr. Member
 
Total Posts:  5
Joined:  2008-11-14
 

Hmm,
I must be missing something obvious. I did export customers from 1.1.7 and tried to import them back. The script says: “Skip import row, required field “website” not defined”

Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
adam hughes
Jr. Member
 
Total Posts:  6
Joined:  2008-12-01
 

I have the exact same issue with 1.1.8 (thread post) , it seems to be an issue with the import profile in 1.1.8 but I haven’t been able to figure it out yet.

http://www.magentocommerce.com/boards/viewthread/24746/

 
Magento Community Magento Community
Magento Community
Magento Community
 
adam hughes
Jr. Member
 
Total Posts:  6
Joined:  2008-12-01
 

Okay I found the issue to be the csv format.
I was taking my format from the export csv option in the customers section and not using the export customers profile.

When I used the export customers profile I found the format to be the following (I’ve included one basic user example as well) :

"website","email","group_id","firstname","lastname","password_hash","prefix","middlename","suffix","taxvat","billing_prefix","billing_firstname","billing_middlename","billing_lastname","billing_suffix","billing_street_full","billing_city","billing_region","billing_country","billing_postcode","billing_telephone","billing_company","billing_fax","shipping_prefix","shipping_firstname","shipping_middlename","shipping_lastname","shipping_suffix","shipping_street_full","shipping_city","shipping_region","shipping_country","shipping_postcode","shipping_telephone","shipping_company","shipping_fax","created_in","is_subscribed"
"base"
,"test2@questtech.co.uk","General","Test2","User2","6ede2082d4b16bbf5c6e53945aa18cc9:lo","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","admin","0"
 
Magento Community Magento Community
Magento Community
Magento Community
 
BobC
Jr. Member
 
Total Posts:  5
Joined:  2008-11-14
 
adam hughes - 01 December 2008 11:52 PM

Okay I found the issue to be the csv format.
I was taking my format from the export csv option in the customers section and not using the export customers profile.

When I used the export customers profile I found the format to be the following (I’ve included one basic user example as well) :

"website","email","group_id","firstname","lastname","password_hash","prefix","middlename","suffix","taxvat","billing_prefix","billing_firstname","billing_middlename","billing_lastname","billing_suffix","billing_street_full","billing_city","billing_region","billing_country","billing_postcode","billing_telephone","billing_company","billing_fax","shipping_prefix","shipping_firstname","shipping_middlename","shipping_lastname","shipping_suffix","shipping_street_full","shipping_city","shipping_region","shipping_country","shipping_postcode","shipping_telephone","shipping_company","shipping_fax","created_in","is_subscribed"
"base"
,"test2@questtech.co.uk","General","Test2","User2","6ede2082d4b16bbf5c6e53945aa18cc9:lo","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","admin","0"

Hello,
did you try to import your exported data back to magento? It doesn’t work for me

 
Magento Community Magento Community
Magento Community
Magento Community
 
saloob
Jr. Member
 
Total Posts:  9
Joined:  2008-11-03
 

Hi (Mosh?)

Can we add a field to also import the registration date?
In the exported format, it has no rego date.
Passwords are a killer - would be great to have an auto password creator and emailer to let them know their new access details and password.

But, for now if anyone has any ideas on the data field - would appreciate muchly..

 
Magento Community Magento Community
Magento Community
Magento Community
 
scarab242
Jr. Member
 
Total Posts:  11
Joined:  2009-01-06
 

Hope somebody’s still reading this thread.
Do you have any experience with importing customers with multiple addresses? How to export the file from the oscommerce in this case? I looked at the field mapping options and there are fields like billing address and shipping address, but in the osc these options are missing, there are only addresses, and the user can choose which one is for shipping and which one for billing.
If somebody has managed to import addresses, please tell me how (s)he was doing this. Thx in advance!

 
Magento Community Magento Community
Magento Community
Magento Community
 
andrew.mart
Jr. Member
 
Total Posts:  4
Joined:  2009-03-19
 

Ok I had an issue importing customer details on 1.1.8

First check data in notepad, text reader etc.
“text”,"text”,"0"
“text”,"text”,"0"
make sure there are “ or errors occur, open office worked ok, excel failed

Second I had a group error you have to have an ID Column that references the data base.
eg. auto number all the rows in spreadsheet convert to csv and upload, don’t map the fields as the “ID” field does not exist in
the map field option!

this ID is not required when uploading products, the id key must be referenced to the sku

hope that works, let me know

 
Magento Community Magento Community
Magento Community
Magento Community
 
chopstik
Jr. Member
 
Avatar
Total Posts:  6
Joined:  2008-08-07
Northland, Aoteoroa
 

Finally found a solution to importing customers from osCommerce into Magento.  Import was working on a test set of 10 records (via the Import/Export Profiles) but address data was erratic and incorrect. The issue turned out to be a blank postcode/zip field from osCommerce.  Magento requires something in this field.  I inserted a ‘-’ (see SQL) when its empty in osCommerce and the import worked fine for 2,600 customer records.

select

    
'base' as website,
    
c.customers_email_address as email,
    
'General' as group_id,
    
NULL as prefix,
    
c.customers_firstname as firstname,
    
NULL as middlename,
    
c.customers_lastname as lastname,
    
NULL as suffix,
    
c.customers_password as password_hash,
    
NULL as billing_prefix,
    
a.entry_firstname as billing_firstname,
    
NULL as billing_middlename,
    
a.entry_lastname as billing_lastname,
    
NULL as billing_suffix,
    
CONCAT_WS(', ',
        
IFNULL(a.entry_street_address,NULL),
        
IFNULL(a.entry_street_address2,NULL),
        
IFNULL(a.entry_suburb,NULL)
    ) as 
billing_street_full,
    
a.entry_city as billing_city,
    
a.entry_state as billing_region,
    
co.countries_name as billing_country,
    IF(
a.entry_postcode '','-',a.entry_postcode) as billing_postcode,
    
c.customers_telephone as billing_telephone,
    
a.entry_company as billing_company,
    
c.customers_fax as billing_fax,
    
NULL as shipping_prefix,
    
aa.entry_firstname as shipping_firstname,
    
NULL as shipping_middlename,
    
aa.entry_lastname as shipping_lastname,
    
NULL as shipping_suffix,
    
CONCAT_WS(', ',
        
IFNULL(aa.entry_street_address,NULL),
        
IFNULL(aa.entry_street_address2,NULL),
        
IFNULL(aa.entry_suburb,NULL)
    ) as 
shipping_street_full,
    
a.entry_city as shipping_city,
    
aa.entry_state as shipping_region,
    
co.countries_name as shipping_country,
    IF(
aa.entry_postcode '','-',a.entry_postcode) as shipping_postcode,
    
c.customers_telephone as shipping_telephone,
    
aa.entry_company as shipping_company,
    
c.customers_fax as shipping_fax,
    
'admin' as created_in,
    IF(
c.customers_newsletter 1,1,0) as is_subscribed,
    
ci.customers_info_date_account_created as created_at
    
from customers 
as c

left join customers_info 
as ci on
    c
.customers_id ci.customers_info_id

left join address_book 
as a on 
    
IF(c.customers_default_billing != 0,c.customers_default_billing,c.customers_default_address_id
        = 
a.address_book_id

left join address_book 
as aa on 
    
IF(c.customers_default_shipping != 0,c.customers_default_shipping,c.customers_default_address_id)
        = 
aa.address_book_id

left join countries 
as co on
    a
.entry_country_id co.countries_id;
 
Magento Community Magento Community
Magento Community
Magento Community
 
stereoscott
Jr. Member
 
Avatar
Total Posts:  17
Joined:  2009-03-18
New York, NY
 

Thanks to all for sharing. I found the query above to be really useful to import customers from zen cart into magento. I had a few differences with my installation of zen (table name prefix, and only one default address for the customer record rather than a default shipping and default billing). Another change is the case statement to convert the full country name to “US” or “CA” (our store only has customers from those two countries, you may have to modify your query accordingly).

Note that this only imports the default address. If customers added additionally addresses they will not be copied.

select

    
'base' as website,
    
c.customers_email_address as email,
    
'General' as group_id,
    
NULL as prefix,
    
c.customers_firstname as firstname,
    
NULL as middlename,
    
c.customers_lastname as lastname,
    
NULL as suffix,
    
c.customers_password as password_hash,
    
NULL as billing_prefix,
    
a.entry_firstname as billing_firstname,
    
NULL as billing_middlename,
    
a.entry_lastname as billing_lastname,
    
NULL as billing_suffix,
    
CONCAT_WS(', ',
        
IFNULL(a.entry_street_address,NULL),
        
IFNULL(a.entry_suburb,NULL)
    ) as 
billing_street_full,
    
a.entry_city as billing_city,
    
a.entry_state as billing_region,
    CASE 
co.countries_name
        WHEN 
'United States' THEN 'US'
        
WHEN 'Canada' THEN 'CA'
        
ELSE co.countries_name
    END 
as billing_country,
    IF(
a.entry_postcode '','-',a.entry_postcode) as billing_postcode,
    
c.customers_telephone as billing_telephone,
    
a.entry_company as billing_company,
    
c.customers_fax as billing_fax,
    
NULL as shipping_prefix,
    
aa.entry_firstname as shipping_firstname,
    
NULL as shipping_middlename,
    
aa.entry_lastname as shipping_lastname,
    
NULL as shipping_suffix,
    
CONCAT_WS(', ',
        
IFNULL(aa.entry_street_address,NULL),
        
IFNULL(aa.entry_suburb,NULL)
    ) as 
shipping_street_full,
    
a.entry_city as shipping_city,
    
aa.entry_state as shipping_region,
    CASE 
co.countries_name
        WHEN 
'United States' THEN 'US'
        
WHEN 'Canada' THEN 'CA'
        
ELSE co.countries_name
    END 
as shipping_country,
    IF(
aa.entry_postcode '','-',a.entry_postcode) as shipping_postcode,
    
c.customers_telephone as shipping_telephone,
    
aa.entry_company as shipping_company,
    
c.customers_fax as shipping_fax,
    
'admin' as created_in,
    IF(
c.customers_newsletter 1,1,0) as is_subscribed,
    
ci.customers_info_date_account_created as created_at
    
from zen_customers 
as c

left join zen_customers_info 
as ci on
    c
.customers_id ci.customers_info_id

left join zen_address_book 
as a on 
    
IF(c.customers_default_address_id!= 0,c.customers_default_address_id,c.customers_default_address_id
        = 
a.address_book_id

left join zen_address_book 
as aa on 
    
IF(c.customers_default_address_id != 0,c.customers_default_address_id,c.customers_default_address_id)
        = 
aa.address_book_id

left join zen_countries 
as co on
    a
.entry_country_id co.countries_id
    
order by c
.customers_id ASC;
 
Magento Community Magento Community
Magento Community
Magento Community
 
jinlopez
Jr. Member
 
Total Posts:  5
Joined:  2010-10-29
 

Good afternoon,

Can someone please assist?  I have read this thread word for word...and have tried every suggestion.  However, I\\\’m still having issues importing my Customer.csv file.  I keep getting the \\\"Skip import row, website \\\"website\\\" field not exists\\\”.  I have put the website column in the beginning with \\\"base\\\" in each field row.  Still doesn\\\’t work.

Help??

 
Magento Community Magento Community
Magento Community
Magento Community
 
happyhour
Member
 
Total Posts:  32
Joined:  2011-05-27
 

How can I import ALL addresses a user has and not only the standard-shipping and standard-billingaddress?

 
Magento Community Magento Community
Magento Community
Magento Community
 
johnlewisdesign
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2012-05-06
 
jinlopez - 06 November 2010 12:02 PM

Good afternoon,

Can someone please assist?  I have read this thread word for word...and have tried every suggestion.  However, I\\\’m still having issues importing my Customer.csv file.  I keep getting the \\\"Skip import row, website \\\"website\\\" field not exists\\\”.  I have put the website column in the beginning with \\\"base\\\" in each field row.  Still doesn\\\’t work.

Help??

Long time to reply sorry lol!

Try exporting again from PHPMyAdmin - I scrolled down after running the query and exported from the bottom. But first, I showed all options, and made sure I checked the ‘labels in first row’ option. Other way didn’t give me the joined table, this way did. Plus if you have the labels in, it knows what to do! Make sure there’s no underscores too like on the export. “website” is good, “_website” is bad.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2