Hi, I imported a list of brands that was capitalised. When I tried to import a list of items it said that the brands didn’t exist as in my item list they weren’t capitalised. So I tried to reimport the brand list without capitals and it shows it as being updated, but then they don’t actually update. If I try and upload the brand list as a new import just without being capitalised it gives an error that they already exist.
I don’t think the import tool cares about case sensitivity.
I suggest using an unused column (or create a custom column) to use as a “flag”.
Flag all the records you’d like to change, using update records.
For example, if you are trying to fix addresses, use the zipcode column. Update
all records and set the zipcode as “needsfix”. Perform a filter in list view and delete
all records where zipcode=“needsfix”. Then import records as new with upper or lower case as you desire.
1 Like