Ggtkuk

How to know if one is suitable for pursuing academia or Research work their entire life?

Like totally amazing interchangeable sister outfit accessory swapping or whatever

Using a map function on a 'Map' to change values

Has a Nobel Peace laureate ever been accused of war crimes?

PIC mathematical operations weird problem

Married in secret, can marital status in passport be changed at a later date?

How long can a nation maintain a technological edge over the rest of the world?

Book with legacy programming code on a space ship that the main character hacks to escape

What to do with someone that cheated their way though university and a PhD program?

What's parked in Mil Moscow helicopter plant?

Raising a bilingual kid. When should we introduce the majority language?

Why isn't everyone flabbergasted about Bran's "gift"?

Where to find documentation for `whois` command options?

"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?

Help in K.331 Andante Grazioso

Philosophers who were composers?

Function on the set of limit countable ordinals

What's the difference between using dependency injection with a container and using a service locator?

What do you call an IPA symbol that lacks a name (e.g. ɲ)?

How can I wire a 9-position switch so that each position turns on one more LED than the one before?

What was Apollo 13's "Little Jolt" after MECO?

Will I lose my paid in full property

"Working on a knee"

Arriving in Atlanta after US Preclearance in Dublin. Will I go through TSA security in Atlanta to transfer to a connecting flight?

Magento 1.9: Massive set customer confirmation attribute

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I imported over 3000 customers in magento, I need to set them all as confirmed. How can I do?

magento-1.9 database customer import confirmation

share|improve this question

asked Mar 20 at 16:35

AlessioAlessio

376

add a comment | 

1

I imported over 3000 customers in magento, I need to set them all as confirmed. How can I do?

magento-1.9 database customer import confirmation

share|improve this question

asked Mar 20 at 16:35

AlessioAlessio

376

add a comment | 

I imported over 3000 customers in magento, I need to set them all as confirmed. How can I do?

magento-1.9 database customer import confirmation

share|improve this question

asked Mar 20 at 16:35

AlessioAlessio

376

share|improve this question

asked Mar 20 at 16:35

AlessioAlessio

376

share|improve this question

asked Mar 20 at 16:35

AlessioAlessio

376

asked Mar 20 at 16:35

AlessioAlessio

376

asked Mar 20 at 16:35

AlessioAlessio

376

1 Answer
1

active

oldest

votes

1

Basically you just have to remove the value of the attribute confirmation for each of this customer. If a customer has a confirmation attribute value set that means that confirmation is required. Without that value a customer is considered confirmed.

You can do that either with the following code for a given $id (for example you can loop through all ids if you now them):

$customer = Mage::getModel('customer/customer')->load($id);
$customer->setConfirmation(null);
$customer->save();

or by running a SQL statement

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id = [YOUR CUSTOMER ID TO CONFIRM];

If you now the ids of the customer you can specify the range in SQL and delete all (I assume all imported ids are coherently):

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id >= [YOUR SMALLEST CUSTOMER ID TO CONFIRM]
and entity_id <= [YOUR LARGEST CUSTOMER ID TO CONFIRM];

share|improve this answer

edited Mar 20 at 18:07

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f266738%2fmagento-1-9-massive-set-customer-confirmation-attribute%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

Basically you just have to remove the value of the attribute confirmation for each of this customer. If a customer has a confirmation attribute value set that means that confirmation is required. Without that value a customer is considered confirmed.

You can do that either with the following code for a given $id (for example you can loop through all ids if you now them):

$customer = Mage::getModel('customer/customer')->load($id);
$customer->setConfirmation(null);
$customer->save();

or by running a SQL statement

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id = [YOUR CUSTOMER ID TO CONFIRM];

If you now the ids of the customer you can specify the range in SQL and delete all (I assume all imported ids are coherently):

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id >= [YOUR SMALLEST CUSTOMER ID TO CONFIRM]
and entity_id <= [YOUR LARGEST CUSTOMER ID TO CONFIRM];

share|improve this answer

edited Mar 20 at 18:07

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423

add a comment | 

1

Basically you just have to remove the value of the attribute confirmation for each of this customer. If a customer has a confirmation attribute value set that means that confirmation is required. Without that value a customer is considered confirmed.

You can do that either with the following code for a given $id (for example you can loop through all ids if you now them):

$customer = Mage::getModel('customer/customer')->load($id);
$customer->setConfirmation(null);
$customer->save();

or by running a SQL statement

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id = [YOUR CUSTOMER ID TO CONFIRM];

If you now the ids of the customer you can specify the range in SQL and delete all (I assume all imported ids are coherently):

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id >= [YOUR SMALLEST CUSTOMER ID TO CONFIRM]
and entity_id <= [YOUR LARGEST CUSTOMER ID TO CONFIRM];

share|improve this answer

edited Mar 20 at 18:07

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423

add a comment | 

Basically you just have to remove the value of the attribute confirmation for each of this customer. If a customer has a confirmation attribute value set that means that confirmation is required. Without that value a customer is considered confirmed.

You can do that either with the following code for a given $id (for example you can loop through all ids if you now them):

$customer = Mage::getModel('customer/customer')->load($id);
$customer->setConfirmation(null);
$customer->save();

or by running a SQL statement

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id = [YOUR CUSTOMER ID TO CONFIRM];

If you now the ids of the customer you can specify the range in SQL and delete all (I assume all imported ids are coherently):

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id >= [YOUR SMALLEST CUSTOMER ID TO CONFIRM]
and entity_id <= [YOUR LARGEST CUSTOMER ID TO CONFIRM];

share|improve this answer

edited Mar 20 at 18:07

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423

$customer = Mage::getModel('customer/customer')->load($id);
$customer->setConfirmation(null);
$customer->save();

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id = [YOUR CUSTOMER ID TO CONFIRM];

delete from customer_entity_varchar 
where attribute_id = ( 
 select attribute_id from eav_attribute 
 where entity_type_id = 1 and attribute_code = 'confirmation'
)
and entity_id >= [YOUR SMALLEST CUSTOMER ID TO CONFIRM]
and entity_id <= [YOUR LARGEST CUSTOMER ID TO CONFIRM];

share|improve this answer

edited Mar 20 at 18:07

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423

answered Mar 20 at 17:09

HelgeBHelgeB

3,4481423