Hi! I’m importing a CSV into a database that has a field that references email addresses in another database. Even though they match up perfectly i get “Referenced item not found. Search for another item.” for each item. If i click search it instantly connects to the correct one. Can i fix this on mass? doing it for each individual entry isn’t fun.
Scrap this. I give up. I did it manually and now i find out you can’t filter by reference because its spitting out an ID instead of the info its meant to. Standard half finished Wix product.
Hello Bento,
I apologize for the struggle I’m sure you had to go through, I hope things are working better for you now. Thank you for sharing your experience, we appreciate all feedback as we always are working on ways to improve Wix for all of our users.
You can vote and recommend new features for wix here:
Best wishes,
Majd
Hey man, I had the same problem. For some reason the only way to import the CSV with a new field, and have it work correctly is by using the Unique ID auto assigned by the wix database. So when you import you have to have you use the ID field for reference because it’s unique to each row on the table. Then what ever you want it to display from the original data table, has to be set as the main field on the original table.