Here’s my situation: I want to send order data to Keap regarding orders placed in our brick-and-mortar retail store. This includes line items, which include product data. Our retail-sales software has its own set of product IDs and does not currently store Keap Product IDs. What do I do if a line item is for a product that isn’t yet in our list of Keap products? Is the Keap system smart enough to automatically add a new Product record in the Products table, or do I have to specifically do something like “search for product by SKU; if product not found then add it” before I can save the order?
Keap cannot detect if a product already exists by SKU, nor will it automatically create new products via our APIs. What I would do is handle this on your side: maintain a mapping between your retail product IDs and Keap Product IDs, check each line item against this mapping, and create any missing products in Keap before sending the order.