For Business

Map your products using the MCF and Buy with Prime app for Shopify

Map your Shopify product SKUs to your Amazon product SKUs

On the Managing Buy with Prime and MCF menu, go to Product catalog and fulfillment options and click Manage products.

Managing Buy with Prime and MCF.PNG

Map your products

Amazon products are auto-mapped to the Shopify products on the Product Mapping page in the MCF and Buy with Prime app for Shopify. Buy with Prime compares the Shopify SKU value to the Amazon SKU value:

  • If they’re the same, the status appears as Matched.
  • If they aren’t the same, the status appears as Match not found. You can map unmatched products manually using the following process.
Perfume.PNG

A list of your SKUs appears, including the Product description, Shopify SKU, Amazon SKU, Status, and Amazon services. The status of the SKUs is either Matched or Match not found.

Note: Drafted, archived, or non-existent Shopify site SKUs don’t appear.

Map products.PNG

To Map your products, follow these steps:

1. For the products with status Match not found, enter the Amazon SKU.
2. For each SKU, choose an Available Amazon Service:

  • Don’t fulfill with Amazon services. SKUs with this choice need to be fulfilled without Amazon.
  • Activate MCF only. Fulfillment occurs for these SKUs through MCF (and they don’t include the Buy with Prime button).
    • Activate Buy with Prime. Buy with Prime also enables MCF as a fulfillment option for orders without Prime.

      Note: Activate Buy with Prime is only available when you choose to set up Buy with Prime on the MCF and Buy with Prime app for Shopify.

You can also Import mappings by CSV file.

Validate that your product is mapped and ready to offer Buy with Prime

To validate that your product SKU is mapped and ready to offer Buy with Prime, follow these steps:

  1. On your Shopify admin, choose Buy with Prime.
  2. On the Managing your account section, choose Manage Buy with Prime products.
  3. Select the Matched tab.
  4. If your SKU isn’t in the Matched list, complete these steps:
    1. Ensure that the Amazon SKU contains the correct product ID.
    2. If the status is Matched, choose an Available Amazon Service:
      • Don’t fulfill with Amazon services. SKUs with this choice need to be fulfilled without Amazon.
      • Activate MCF only. Fulfillment occurs for these SKUs through MCF (and they don’t include the Buy with Prime button).
      • Activate Buy with Prime. Buy with Prime also enables MCF as a fulfillment option for orders without Prime.

        Note: Activate Buy with Prime is only available when you choose to set up Buy with Prime on the MCF and Buy with Prime app for Shopify.

    3. Ensure that the Conditions to offer Buy with Prime - Shopify are met.

Filter your products

To filter product SKU, follow these steps:

  1. On your Shopify admin, choose Buy with Prime.
  2. On the Managing your account section, choose Manage Buy with Prime products. to see your list of products.
  3. Choose one of the following tabs
    • Matched
    • Match not found

Note: You can also filter your list of products by Available Amazon Service:

  • Don’t fulfill with Amazon services. SKUs with this choice need to be fulfilled without Amazon.
  • Activate MCF only. Fulfillment occurs for these SKUs through MCF (and they don’t include the Buy with Prime button).
  • Activate Buy with Prime. Buy with Prime also enables MCF as a fulfillment option for orders without Prime.

    Note: Activate Buy with Prime is only available when you choose to set up Buy with Prime on the MCF and Buy with Prime app for Shopify.

Import mappings by CSV

You can match your products by uploading a CSV file. The CSV file includes the following fields:

  • Shopify SKU: Shopify SKU is always pre-populated with your latest Shopify catalog.
  • Amazon SKU: Enter the Amazon SKU that matches the Shopify product.
  • VariantID: The VariantID is autogenerated by Shopify whenever a product or variant is created. The VariantID uniquely identifies your Shopify products. To locate the productID or VariantID, refer to the Shopify admin URL for that product: https://admin.shopify.com/store/daintree-beta-test-08/products/<ProductID or VariantID>.
  • Available Amazon Service:
    • Don’t fulfill with Amazon services. SKUs with this choice need to be fulfilled without Amazon.
    • Activate MCF only. Fulfillment occurs for these SKUs through MCF (and they don’t include the Buy with Prime button).
    • Activate Buy with Prime. Buy with Prime also enables MCF as a fulfillment option for orders without Prime.

      Note: Activate Buy with Prime is only available when you choose to set up Buy with Prime on the MCF and Buy with Prime app for Shopify.

Note: To remove Buy with Prime from one or more products, choose Don’t fulfill with Amazon services as Available Amazon Service.

To upload a CSV file with your SKU mapping, follow these steps:

    1. On the Import mappings by CSV page, download your catalog as a CSV, and then add your Amazon SKUs.
      Note: Only CSV format files are supported.
    2. In the Import CSV box, select Add file, then upload your catalog file. You can also drag and drop the file into the box.
      Note: Data uploaded through a CSV file overwrites existing SKU mapping.
    3. To change the file you selected, choose Replace file.
    4. After you select the correct file, choose Upload and continue.
      The message Loading CSV data. You don’t have to keep this page open while data loads appears at the top of the products page.
      After this step is complete, the message CSV file successfully uploaded at HH:MM:SS on MM DD YY appears at the top of the products page. Your Amazon SKUs are added and show Matched status and Offer Prime is activated.
      Note: When you choose Activate Buy with Prime as Available Amazon Service on a product, it’s live on your Shopify site immediately as long as the Conditions to offer Buy with Prime are met.
    5. Check your product page to ensure that the Buy with Prime button is active on the page.

    Note: When you complete mapping your products, go to Return policy.

    Manage duplicate SKUs

    If more than one Shopify product uses the same, duplicate Shopify SKU value, review the values to verify that they’re mapped accurately. Click Edit to fix inaccuracies for individual SKUs or click Update using CSV to update them in bulk.
    Examples of duplicate SKUs are as follows:

    Duplicate variants:

    • Variant ID: 1284719828; SKU Name: BDUX8827; Product Name: Crystal Sandal Shoe; Size: 8
    • Variant ID: 1284719834; SKU Name: BDUX8827; Product Name: Crystal Sandal Shoe; Size: 9

    Duplicate sales channels:

    • Variant ID: 1284719817; SKU Name: BDUX8823; Sales Channel: Online Store
    • Variant ID: 1284719813; SKU Name: BDUX8823; Sales Channel: Social Ads store

    Duplicate selling plans:

    • Variant ID: 1284719829; SKU Name: BDUX8829; Selling Plan Group: Subscribe and Save
    • Variant ID: 1284719849; SKU Name: BDUX8829; Selling Plan Group: Prepaid

    Duplicate status:

    • Variant ID: 1284719842; SKU Name: BDUX8881; Status: Active
    • Variant ID: 1284719852; SKU Name: BDUX8889; Status: Draft

    Duplicate landing pages:

    • Variant ID: 1284719867; SKU name: BDUX9900. Landing page 1
    • Variant ID: 1284719899; SKU name: BDUX9900. Landing page 2

    Use the following steps to check for duplicate SKUs:

    1. Open your Shopify admin, and then choose the Products page for your store.
    2. On the top right, choose Export > All Products > CSV to Excel.
    3. Open the exported file in Microsoft Excel and highlight the Variant SKU column.
    4. Choose the Home tab, and then Conditional Formatting.
    5. In the drop-down menu, choose Highlight Cells Rules, and then Duplicate Values.
      Excel navigation
    6. Choose OK. Excel highlights cells in the Variant SKU column that have the same value as another cell in the column.
    7. The red highlighted cells identify which products or variants have a duplicate SKU that’s used more than once across your product list.

    Note: Each SKU needs to be unique to be compatible with Buy with Prime. If you have duplicate SKUs, go to Bulk editing for more information on editing your SKUs.

    Looking for something else?