Bulk-link Amazon Products to Shopify Products using a CSV

Bulk-link Amazon Products to Shopify Products using a CSV

When your Amazon SKU or barcode is different from the Shopify SKU/barcode, Sync Status cannot auto-link those Amazon Products. Linking them one by one with the Link button works, but it's slow when you have hundreds of products. Instead, you can upload a single CSV that pairs each Amazon Product with the matching Shopify product, and the app links them all in one go.

Two ways to identify your Shopify products in the CSV

  • Linking by Shopify SKU — CSV columns: amazon_sku, shopify_sku
  • Linking by Shopify Variant ID — CSV columns: amazon_sku, variant_id

The app only links products specified in the CSV — every other product is left untouched.

Note: If a Shopify product in your CSV is already linked to a different Amazon Product, the app will unlink it first, then re-link it according to the new CSV. Make sure the pairings in your CSV are correct before uploading.

Steps to bulk-link via CSV

  1. Open Product Linking from the left menu and stay on the Linking Required tab.
  2. Click the More actions (three vertical dots) icon at the top right of the toolbar.
  3. Click Bulk Updates in the popover.

  1. The Bulk Update dialog opens. Switch to the Import tab.
  2. Under Select Linking Method, pick either Linking by Shopify SKU or Linking by Shopify Variant ID.

  1. Click Download sample CSV to start from the correct format.
  2. Open the sample (or your own file) in Excel/Sheets and fill the required columns:
    • SKU mode: amazon_sku, shopify_sku (e.g., AMZN-SKU-001, SHOP-SKU-001)
    • Variant ID mode: amazon_sku, variant_id (e.g., AMZN-SKU-001, 12345678901)
  3. Save as .csv, click Add file in the dialog (or drop the file into the upload area), and click Confirm.

The app picks up the file, validates the headers, and queues the linking job. You can keep using the app — once it finishes, you can check the progress in the Recent Activities section or in the Notification section. The successfully linked products move from Linking Required to Linked.

Tip: A result CSV is generated only if some rows failed to link and is available from the Recent Activities section. It lists every failed Amazon SKU along with the reason, so you can correct the CSV and re-upload. If every row succeeds, no result CSV is produced.

    • Related Articles

    • Export your unlinked Amazon Products as a CSV

      If you want to work with your Amazon Products outside the app — for example, to match them with Shopify products in a spreadsheet and then bulk-link them back — the app can export your unlinked products to a CSV file. You can export either: Selected ...

    • Link Amazon Products under Linking Required to Shopify products

      Sync Status cannot auto-link an Amazon listing to a Shopify product when their SKU and barcode don't match. Such listings stay under Linking Required in the Product Linking section, and you can pair them with the right Shopify product yourself using ...

    • Refund failed: SKU mismatch after unlink or re-link

      If the SKU on the Amazon order's line doesn't match the SKU currently linked between your Shopify product and the Amazon listing, the refund can't be matched back to a line on Amazon, and Amazon rejects it. Why it happens Each Amazon order line is ...

    • How to bulk update Shopify products from the app

      Use Bulk Update when you need to change product details — titles, inventory, price, barcode, or SKU — for many products at once. You export the products you want to edit as a CSV, make your changes in a spreadsheet, and import the same file back. ...

    • Getting Started with CedCommerce Amazon Channel

      Welcome to the CedCommerce Amazon Channel App! Effortlessly manage your Amazon business from Shopify with a single, integrated solution. The CedCommerce Amazon Channel App allows sellers to connect multiple Amazon Seller Accounts in one place, ...