Importing upsell products does not update product links in Adobe Commerce on cloud infrastructure
When you import multiple upsell, cross-sell, or related product settings using a CSV file in Adobe Commerce, the import process might complete without errors but not update the product links as expected. To fix this, confirm that your CSV file format is correct.
Description description
Environment
- Adobe Commerce on cloud infrastructure
- Adobe Commerce on-premises
Issue/Symptoms
- Importing a CSV file with upsell, related, or cross-sell products results in no changes to product data.
- The import process shows no errors, but the product relationships are not updated.
In the CSV file, product relations values should be comma-separated. Only one row is required per SKU, and each product relation type must use its own column.
Resolution resolution
To ensure Adobe Commerce processes product relation updates correctly, verify that your CSV file follows the standard product export format. Use these steps to confirm your structure:
-
Export a sample product CSV file. This is recommended if sample data is installed. (For detailed steps, refer to Export data).
-
Go to System
>Data Transfer>Export. -
Select Entity Type = Products.
-
Select Download Sample File.
-
Review the CSV column headers:
related_skusupsell_skuscrosssell_skus
-
-
Export a manually configured SKU if sample data is not installed. (For detailed steps, refer to Export filters).
- Go to Catalog
>Products. - Edit the product SKU you want to use as a sample.
- In Related Products, Up-Sells, and Cross-Sells, assign multiple SKUs.
- Return to System
>Data Transfer>Export. - Filter by the SKU and export the CSV file.
- Download the CSV after processing completes.
- Go to Catalog
-
Format your CSV correctly:
-
Use only one row per SKU in the CSV file.
-
Place multiple related SKUs as comma-separated values within the proper columns.
-
Ensure column headers match the following values exactly:
related_skusupsell_skuscrosssell_skus
-
Remove any unnecessary columns that are not required for the import operation.
-
Save the CSV file using UTF-8 encoding.
-
-
Test your CSV with an import of a SKU first to confirm that product relationships update correctly. After validation, proceed with the full file.
Cause
Incorrect CSV formatting prevents Adobe Commerce from interpreting the product relations updates. Common issues include multiple rows per SKU (see first table below) or missing the required related_skus, upsell_skus, and crosssell_skus columns. Each SKU can appear only once, with comma-separated product relations included in the appropriate columns (see second table below).