Order Import - Checking/Creating Ship_to address
Does anyone know what the order import checks to determine if an address exists, prior to creating it, using the oe_customer_info_iface_all table.
Here is our situation. We have code in place that checks Data we have coming in from a source with , Address information, such as Company name, Address1, Address2, City , State , Zip.
We are wanting our process to check to see if the ship to address exists for a particular Customer. If we dont find that it does exist from our query, then we populate the oe_customer_info_iface_all table . Then we run Order Import. If the address does exist, we dont populate this table. We just get the location_id and use it to build our Order.