Not able to show customers list in admin panel

Hi everyone,


I am facing a problem regarding uploading of customers list from database. I have imported customer's records in some columns of dbo.Customer table and address related information of those records in dbo.Address table. After that I mapped both table in dbo.CustomerAddresses table. Still i am not able to show the customers data in the admin panel under customers section. Can anyone please guide me to show all the customer records.







thanks,
Sachin Tripathi

Hello Sachin Tripathi,

Are sure you added record on below tables when adding customer directly from sql.

Customer
Customer_CustomerRole_Mapping
CustomerAddresses
CustomerPassword
GenericAttribute

Thanks,
Jatin

Make sure the 'Deleted' column is set to 0

Hi guys,

I seem to have the same problem, I have successfully copied customer data into another database but it's not reflecting in Nopcommerce admin panel. I managed to set 'Deleted' column to 0 but it's still not showing. Please help.

Have you check console (browser console)? Maybe there is js error.

Regards,
Tom

Did you add the customers to the Registered role?   (Customer_CustomerRole_Mapping)
By default, the filter in the admin customer list is for 'Customer roles' = Registered.  Tyy removing that filter, and then do Search.

Hi guys,

How do you add the customers to the Registered role?

When I removed the filter and then did Search, I noticed there are a lot of accounts labeled 'Guest' with emails from the previous database but their names and customer roles are not reflecting. (I'm assuming the data has been copied but not the names and customer roles.) How can I successfully copy customer data so that it reflects like in my old database? with correct customer roles and their orders?

I also checked the browser console but there is no js error.

Please help.

Manually, you can Edit the Customer, and a add another role in the "Customer roles" field.

To do it in a bulk operation using SQL, you need to insert records into the Customer_CustomerRole_Mapping table.
For example, see https://www.nopcommerce.com/boards/t/36600/how-to-set-customer-id-to-12and-3-in-customer_customerrole_mapping-table.aspx

Hi New York,

I get the part about adding another role for customers but:

Initially what I wanted to do was import data (customers info and orders only) from my old database (running on an old live site on Nopcommerce 3.2) to the new database (running on a new test site on Nopcommerce 4.0). I decided to download the old database (from the old site) and run the upgrade scripts until Nopcommerce 4.0. I then tried to use the import data function in SQL Server (to copy customers info and the orders that were placed while working on a new test site) but the only data that could be successfully copied was the emails of the customers but the Names, Customer roles and Company names are missing.

Ideally, I would replace the new database with the old database (upgraded to Nopcommerce 4.0) but I have already made major changes to the new database on the test site, that's why I only want to update the customers' info and the orders that were placed on the old site while I was working on a new test site. Can you please advise me on how to import the data successfully? Please help.