IMporting saying items does not exists

ERPNext
1

Am trying to import sales invoices and its saying cannot find the customers but they are actually there , sometimes l rename the items when they are not found but in this case the items are too many l cannot rename them all

Column 4 (Customer)

The following values do not exist for Customer: CBZ INSURANCE, AMH, ZB BANK, COSTHAM, CBZ BANKING HALL, EVERSHARP, CBZ LIFE, ACCESS FOREX, CBZ 2ND, EUROPCAR, AROPAK

2

It could be a cache issue. Try clearing the cache. Also make sure you are using the correct field for customer. This will be the customer ID.

Take a look at your customer record, the ID will be in the breadcrumb like below.

Screenshot 2024-08-14 at 5.14.24 PM

3

I am not able to import customers using a CSV. The errors below are not really making sense to me. Further to this I am really not sure which columns I should be using. Are there any codes that explain what each column should contain or what data I should be putting where? There are over a hundred columns and I have a ton of data I want to import. I want to import as much data as I can without doing it manually later.

Or

  • Customer Primary Address: Value Company Namwe P O BOX A240 SWAZI PLAZA H100 Country Phone number missing for Address

When I try to import I get these errors “The following values do not exist for Contact:” which, again, does not expalin to me what is going wrong.

Any ideas?