This is one way.

import pandas as pd

shipments = pd.read_csv('shipments.csv')  
products = pd.read_csv('products.csv')    

merged = pd.merge(shipments, products, how='left', on='product_code').fillna("N/A")

print(merged)