Commerce CSV import versus Data Loader for product data
Key Takeaway
Use the Commerce CSV import for up to 10,000 products with nine images each, because it keeps commerce relationships correct for you. For more than that, use Salesforce Data Loader and maintain the relationships yourself.
B2B Commerce gives you two ways to bulk load product data. The Commerce CSV import is built into the Commerce app. Salesforce Data Loader is a general bulk data tool. Salesforce recommends the CSV import because it keeps commerce records correctly linked. Data Loader is the option for imports larger than the CSV import supports.
The Commerce CSV import
The Commerce CSV import loads products, product variations, and images from a CSV file that you upload. The import runs asynchronously, so you can do other work while it runs.
Salesforce recommends the CSV import because the commerce import file keeps the correct relationships between commerce objects. The import also makes the required updates to records in related objects for you. For 10,000 products, the import typically makes more than 50,000 related-object updates.
Only one Commerce import job can run at a time. The limit covers both category imports and product imports. If an import job is running, wait for it to finish or cancel it before you start a new one.
CPQ (Configure, Price, Quote) triggers are not compatible with a CSV import.