You want to combine external data with internal data via product ID. Although the data may be inconsistent, such as the external data contains the letter “O” wh...