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:

  1. Export a sample product CSV file. This is recommended if sample data is installed. (For detailed steps, refer to Export data).

    1. Go to System > Data Transfer > Export.

    2. Select Entity Type = Products.

    3. Select Download Sample File.

    4. Review the CSV column headers:

      • related_skus
      • upsell_skus
      • crosssell_skus
  2. Export a manually configured SKU if sample data is not installed. (For detailed steps, refer to Export filters).

    1. Go to Catalog > Products.
    2. Edit the product SKU you want to use as a sample.
    3. In Related Products, Up-Sells, and Cross-Sells, assign multiple SKUs.
    4. Return to System > Data Transfer > Export.
    5. Filter by the SKU and export the CSV file.
    6. Download the CSV after processing completes.
  3. 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_skus
      • upsell_skus
      • crosssell_skus
    • Remove any unnecessary columns that are not required for the import operation.

    • Save the CSV file using UTF-8 encoding.

  4. 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).

sku
link_type
linked_sku
position
SKU A
upsell
upsell_SKU-1
1
SKU A
upsell
upsell_SKU-2
2
SKU B
related
related_SKU-3
1
sku
related_skus
upsell_skus
crosssell_skus
SKU A
related_SKU-1,related_SKU-2
SKU B
upsell_SKU-1,upsell_SKU-2
SKU C
related_SKU-3,related_SKU-4
crosssell_SKU-1,crosssell_SKU-2
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f