ECmall how to add users in bulk

The most recent job in Showbox, the mall made with ECmall. Because the merchants are required to add users in the store in batches, but there is no such function in the background, it is only from the sql side. By the way, check out Excel
and SQL.

After studying his database structure, he finally got the SQL statement to be added, and the result was found in the foreground. Only know that the password forgot to use MD5 to encrypt.

The last statement:

INSERT INTO jcom_mall.ecm_member VALUES (NULL , ‘yourtion’, ‘[email protected]’, ’5fa2db591ebb44529673957ed8b738fc’, ”, ’0&prime ;, NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , & rsquo; 0′, NULL , NULL , & rsquo; 0′, & rsquo; 0′, NULL , & rsquo; 0′, NULL , ”);

Add a good user, then use Excel spreadsheet to enter the user name and other data and SQL statement generation, check a lot of information and try to get the statement after many times:

=CONCATENATE ( INSERT INTO jcom_mall.ecm_member VALUES (NULL , ‘”,A1,”‘, ‘[email protected]’, ’5fa2db591ebb44529673957ed8b738fc’, ”, ’0′, NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , & rsquo;0′, NULL , NULL , & rsquo; 0′, & rsquo;0′, NULL , & rsquo;0′, NULL , ”);”)

where “A1” is the user name column, other user information is ignored, etc. When the user logs in to change the password and its information for the first time, you can also write the import statement in the form of “, A1, & rdquo; in Excel.

I hope you can give me a look. If I have time, I will find some information about SQL and Excel. I hope I can help you~