BuzzardJunction

Importing Line Items: Populating Products Foreign Key

Discussion created by BuzzardJunction on Jun 11, 2018
Latest reply on Jun 11, 2018 by keywords

When you're importing an invoice's line items from a spreadsheet, how do you populate all of those product foreign keys. I can't imagine it done manually, line-by-line; especially in a situation where there are tens of thousands of invoice line items and a ton of products records.  Do you use ExecuteSql() and try to pull the keys by querying the names of the products?  I thought of that first, but it seems like an awkward way to go about things. Other ways?

Outcomes