How to update customer information directly in the database

I have several customers that I need to change a field in. In my case, the account manager email address. I’m trying to determine the best way to approach this. I have enough that I don’t want to have to go through the UI to do it as that would be time prohibitive. It seems like making the changes directly in the database would be easiest but I can’t figure out which table contains that information.

What is the best way to go about doing this? If it is directly in the database, which table contains that data?

I’m using Magento Commerce v2.3.5

Magento Asked by Darrell Brogdon on October 2, 2021

1 Answers

One Answer

Changing data in the database directly has several inherent problems: it may leave orphans especially if you're only starting with Magento, it is prone to errors and it is not reusable.

For your customer problem, it may be quite simple fortunately, you may want to look in the backend System/Import and use the type 'customer main file' like the screenshot below

enter image description here

for general purpose of batching a change, I would recommend scripting, it is quite reasonably straight forward to write commands in Magento 2:

for instance, feel free to take a look at: which is a basic example on writing a command

Correct answer by Herve Tribouilloy on October 2, 2021

Add your own answers!

Related Questions

Get userid of the admin logged in magento 2 helper

1  Asked on February 12, 2021 by fahad-bashir


Product saving problem in admin control panel

1  Asked on February 12, 2021 by venkatesha


Print Address / Shipping Label For Magento 2

0  Asked on February 12, 2021 by naveen-sama


are the two codes same?

1  Asked on February 11, 2021 by hong-thng


Create custom Attributes in Customer Form in magento 1.9

1  Asked on February 6, 2021 by maiitsyuj


Magento2 Language Character Problem

0  Asked on February 5, 2021 by stifboy


Magento Add Cart To Header

2  Asked on February 5, 2021 by ks6814


Ask a Question

Get help from others!

© 2021 All rights reserved.