Upload CSV and link to project record ID
I have a Project Table (ex project 1, 2, 3) and I also have a products table. I want to bulk import products into my products table. Each product has an associated project (1, 2, 3). How can I uplo...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThat was like a second nuance to your question. Are you saying you were trying to upload products and update existing products or add products if it is a new product?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sorry for my delay, Mark. I am trying to add products as new products but I want them to be linked to the Record ID.
So I have projects 199 and 193 right now. I'm adding inventory to them via the csv. I have 193 or 199 in the Related Product column on the CSV but nothing links when I upload.
------------------------------
Annie Ryden
------------------------------
So I have projects 199 and 193 right now. I'm adding inventory to them via the csv. I have 193 or 199 in the Related Product column on the CSV but nothing links when I upload.
------------------------------
Annie Ryden
------------------------------
- MarkShnier__YouIn your upload, did you upload into the field probably called [Related Project]?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Yes, I did. The products all uploaded but they didn't link to the project. The Project # is just blank on all.
------------------------------
Annie Ryden
------------------------------- MarkShnier__YouWhat is the field in the Relationship that links the Products to the Project? What is the Key field of the Project table.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------