I’ve been using Dolibarr in a test and evaluation capacity and i’ve recently imported some live products and customers.
The products have imported fine and I can see them in the products view. However, the customers have been imported into the llx_societe table but they don’t appear when i go to Third Parties>List of Customers although they are in the list of the last 15 modified third parties and show up in the pie chart. I have added a new customer manually and that shows up in the customer list ok.
I can’t see any differences between the two types - for instance the status is open, they have a customer code and a sales rep is assigned. Any suggestions would be appreciated - probably a common issue.
A third party can be a customer or not. Open the card from list of third party. Then edit card and chack that property “customer/propect” is on.
It’s probably not. Field during import may had value 0 instead of 1 (customer) or 3 (customer and prospect).
Thanks for the speedy reply - I did consider that myself and have changed that in the Dolibarr GUI and set the client column to 3 in the llx_societe table but it hasn’t made any difference. I’ve been through the differences in the database and can’t see any real issues.
You can see below the SQL for the failing customer “ZAMIN” and the working user “TEST”. I think i’ll go through and make all fields exactly the same to see whether that makes a difference.
Do you think that this is likely to be related to anything in a different table?
i’ve worked it out - fk_stcomm was set to NULL on import and this obviously needs to be set to a non-null value. I’ll go through and set them all to 0 now.
Thanks for your help, loving the product and hoping to be able to support it in the UK for customers.
