Magento 2多商品CSV导入：如何避免图片重复？

Hey there! I’ve tackled this exact problem multiple times for Magento 2 stores, so let’s break down the most effective ways to avoid duplicate images during CSV imports—no outdated Magento 1 hacks needed.

1. Optimize Your CSV Structure & Use Magento’s Built-In Logic #

Magento 2’s import tool has built-in safeguards if you structure your CSV correctly:

• Unique Image Paths: For fields like image, small_image, thumbnail, and additional_images, ensure each image path is listed only once per product. For example, if a product has multiple additional images, use a comma-separated list without repeats:
  additional_images: image_01.jpg,image_02.jpg,image_03.jpg
• Choose the Right Import Behavior: When setting up your import, pick the correct behavior under Import Settings:
  • If updating existing products: Select Replace to overwrite existing media gallery entries (this prevents appending duplicate images).
  • If adding new products: Select Append but make sure your CSV has no duplicate paths to begin with.
• Pre-Upload Images: Make sure all images are uploaded to pub/media/import (or a subfolder) before importing. Magento will reference these files directly, so duplicates in the CSV will still create duplicate gallery entries even if the file exists once on the server.

2. Add a Custom Plugin to Filter Duplicate Images #

If you need more control (e.g., automatically cleaning duplicates during import), you can create a lightweight plugin to intercept the media gallery save process:

1. Create a plugin for \Magento\CatalogImportExport\Model\Import\Product targeting the _saveMediaGallery method.
2. In the plugin, filter out duplicate image entries before they’re saved to the database.

Here’s a simplified code snippet for the plugin:

<?php
namespace YourVendor\YourModule\Plugin;

use Magento\CatalogImportExport\Model\Import\Product;

class FilterDuplicateImages
{
    public function before_saveMediaGallery(Product $subject, $productId, $mediaGalleryData)
    {
        if (!empty($mediaGalleryData['images'])) {
            $uniqueImages = [];
            foreach ($mediaGalleryData['images'] as $image) {
                // Use image path as unique key to avoid duplicates
                $imagePath = $image['file'] ?? '';
                if (!isset($uniqueImages[$imagePath])) {
                    $uniqueImages[$imagePath] = $image;
                }
            }
            $mediaGalleryData['images'] = array_values($uniqueImages);
        }
        return [$productId, $mediaGalleryData];
    }
}

This will automatically strip out any duplicate image entries from the media gallery data before it’s saved to the product.

3. Preprocess Your CSV File #

Before importing, clean up your CSV to remove duplicate image paths. This is quick and effective for one-off imports:

• Excel/Google Sheets: Use the UNIQUE function to filter duplicates in image columns. For example, if your additional images are in column D, use =TEXTJOIN(",",TRUE,UNIQUE(SPLIT(D2,","))) to create a comma-separated list of unique paths.
• Python Script: For large CSVs, a simple script can automate the cleanup. Here’s a quick example:

import csv

input_file = 'products.csv'
output_file = 'products_cleaned.csv'

with open(input_file, 'r') as infile, open(output_file, 'w', newline='') as outfile:
    reader = csv.DictReader(infile)
    writer = csv.DictWriter(outfile, fieldnames=reader.fieldnames)
    writer.writeheader()
    
    for row in reader:
        # Clean additional_images column
        if row.get('additional_images'):
            images = row['additional_images'].split(',')
            unique_images = list(dict.fromkeys(images))  # Preserve order while removing duplicates
            row['additional_images'] = ','.join(unique_images)
        writer.writerow(row)

Final Tips #

• After importing, always flush the Magento cache (bin/magento cache:flush) and reindex (bin/magento indexer:reindex) to ensure media gallery changes are reflected.
• Verify the media gallery in the admin for a few test products to confirm no duplicates were added.

内容的提问来源于stack exchange，提问作者Tommy Cunningham