Magento Forum

   
Customer import: Skip import row, is not valid value “” for field “group_id”
 
davy
Jr. Member
 
Total Posts:  20
Joined:  2008-01-21
 

I am trying to import customers with a csv file with field mappings including group (group_id is not available from mapping choice).
Running the profile generates the following error for every line: Skip import row, is not valid value “” for field “group_id”

I’ve set the column “group” to the customer group name.
When using the export functionality, the same data is put in a column “group_id”

Is this a bug or can I adapt a setting somewhere?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
BIll M
Jr. Member
 
Total Posts:  10
Joined:  2008-07-10
Mansfield OH
 

I am badly in need of an answer to this question, also.  I get the same problem - group is offered as a field name, but group_id is required by the script, internally, and group_id is the field in the customer_entity table.

What to do?

PS:  This is updated to version 1.1.4 as of today,

It would also be VERY helpful to know in advance which fields are REQUIRED - like website - to be included in the csv file.

Thank You!

 
Magento Community Magento Community
Magento Community
Magento Community
 
davy
Jr. Member
 
Total Posts:  20
Joined:  2008-01-21
 

I found this to be a bug in app\code\local\Mage\Customer\Model\Convert\Adapter\Customer.php

replace lines 419-427 by this to make it work (basically replace ‘group_id’ on those lines by ‘group’)

/**
             * Check customer group
             */
            if (empty($importData['group']) || !isset($customerGroups[$importData['group']])) {
                $value 
= isset($importData['group']) ? $importData['group''';
                
$message Mage::helper('catalog')->__('Skip import row, is not valid value "%s" for field "%s"'$value'group');
                
Mage::throwException($message);
            
}
            $customer
->setGroupId($customerGroups[$importData['group']]);

Explanation: customer groups are stored in the array based on the group name and group_id was used in original code.

 
Magento Community Magento Community
Magento Community
Magento Community
 
BIll M
Jr. Member
 
Total Posts:  10
Joined:  2008-07-10
Mansfield OH
 

That correction worked Great!

One thing (and an aside - not really about this problem) - the group id you put in must be the text name of the group,, like General or Customer - not the id of the group, like 1 2 etc., as the screen calls for.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Uckflibs
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2008-11-01
Corona, California
 

Could someone a step by step on how to import my customer list into Magento? is there a back-end feature in the admin that I fail to see?
thank you

 
Magento Community Magento Community
Magento Community
Magento Community
 
oconnellc
Jr. Member
 
Total Posts:  6
Joined:  2009-07-17
 

Is there a sample file that I can copy?  What are the exact field names, etc?  I checked the wiki and I can’t find this documented anywhere.  If someone could tell me what my file should look like, that would really help.

Thanks,
Chris

 
Magento Community Magento Community
Magento Community
Magento Community
 
oconnellc
Jr. Member
 
Total Posts:  6
Joined:  2009-07-17
 

I have updated the wiki with what I was able to figure out regarding customer imports:

http://www.magentocommerce.com/wiki/how-to/import_customers_with_csv_file

Good luck everyone.

 
Magento Community Magento Community
Magento Community
Magento Community
 
vavavoom
Jr. Member
 
Total Posts:  14
Joined:  2009-03-10
 

I’ve set up an import just like the wiki article above. I try and import data in and I still get the following error:

Skip import row, is not valid value “” for field “group_id”

Here’s the first two lines of my import file.

group_id firstname lastname billing_city billing_firstname billing_lastname billing_postcode billing_region billing_street1 billing_telephone billing_country email is_subscribed website
General Jason Vance City Jason Vance 99999 ST 5099 e emerald 9999999999 US email@email.com 1 base

Is there something that I’m missing?

Thanks,

Jason Vance

 
Magento Community Magento Community
Magento Community
Magento Community
 
LAMASE
Jr. Member
 
Avatar
Total Posts:  12
Joined:  2009-02-20
Italy
 
vavavoom - 09 October 2009 02:55 PM

I’ve set up an import just like the wiki article above. I try and import data in and I still get the following error:

Skip import row, is not valid value “” for field “group_id”

Here’s the first two lines of my import file.

group_id firstname lastname billing_city billing_firstname billing_lastname billing_postcode billing_region billing_street1 billing_telephone billing_country email is_subscribed website
General Jason Vance City Jason Vance 99999 ST 5099 e emerald 9999999999 US email@email.com 1 base

Is there something that I’m missing?

Thanks,

Jason Vance

Wich format is your file? It doesn’t seems csv (comma separated) but tab separated.
however the group-id should be a number, i think.

 
Magento Community Magento Community
Magento Community
Magento Community
 
PaginasWebdotPE
Member
 
Avatar
Total Posts:  46
Joined:  2008-10-22
Lima, Peru - Miami, USA
 

good, very good, it works, is just that it replaces even the admin user, so i have no idea how to get it back wink anyway, it works

 
Magento Community Magento Community
Magento Community
Magento Community
 
fbctech
Jr. Member
 
Total Posts:  19
Joined:  2010-03-29
 

I want it to take the customer ID I have in the file and use it as the ID for the customer in Magento.

Anybody have a clue where to start?

Thanks

Steve

 
Magento Community Magento Community
Magento Community
Magento Community
 
ddevil
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2010-08-27
Nottingham
 

I used to get the same error, but after I renamed the “group_id” column name to “group” it worked just fine!

 
Magento Community Magento Community
Magento Community
Magento Community
 
frank_l
Jr. Member
 
Total Posts:  2
Joined:  2010-07-14
 
fbctech - 16 February 2011 07:48 PM

I want it to take the customer ID I have in the file and use it as the ID for the customer in Magento.

Anybody have a clue where to start?

Thanks

Steve

I would be interested in this also. I have a db of several thousand customers with our current customer IDs (not all are sequential) and would like to import them as the current IDs, then Magento can auto-increment the new customers as per usual.

Thanks!

Frank

 
Magento Community Magento Community
Magento Community
Magento Community
 
erictr1ck
Member
 
Total Posts:  56
Joined:  2009-02-12
 
ddevil - 20 July 2011 02:11 AM

I used to get the same error, but after I renamed the “group_id” column name to “group” it worked just fine!

exporting from 1.3.2.3 and importing to 1.6.2.0 and this little tip worked for me. thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
magento123
Member
 
Avatar
Total Posts:  64
Joined:  2010-12-30
 

Hello guys,

Renaming the group_id to group worked for me too.

You can also put the file into import folder in var directly.

This can speed up the import process.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top