Add A Field on Import
Im trying to figure out the best way to automatically add a field on import for data.
For example i have a store with a address already in my database. I import a file with the same store i dont want to add it as a new entry so i match the records by the address and zip code. Now i want it to add a field at the end of the entry's data with new data from the new file but not deleat or replace data with it.
I have a list of stores i stock so they are all in the data base everytime i restock i need to import my updated file and add what products they ordered to a list for the file.