Strange behaviour in Excel imports to Creatio
Hello Community,
We have a client for whom we perform Excel imports of products into quotes. This import process includes a validation step where the system checks the PartNumber to verify if the product already exists. If it does, the corresponding ID is assigned to the product in the quote. If it does not exist, a new product is created with the appropriate classifications.
However, we discovered that when the PartNumber in the Excel file contains "00", Creatio is unable to process it correctly and instead associates a product with no PartNumber assigned.
Can you help us resolve this issue? Any suggestions would be appreciated!
Like
Hello,
I recommend that you make sure that the type of the PartNumber field in Creatio matches the format you are trying to insert, i.e. it should be a text field.
In addition, the system has a lookup “Excel import log”, we recommend that you search for your import logs, if there were errors with filling in the column, they will be displayed in this lookup.
If you cannot solve the problem yourself, we recommend contacting our support team for a more detailed check. (support@creatio.com)
Best regards,
Pavlo!