How to Map Product SKUs and Reference IDs for eCommerce

Use eCommerce Map Product SKUs to make the management of products through numerous sales channels easier. When you connect the product SKUs to corresponding reference IDs on such platforms as eBay and Amazon, those SKUs will be synchronized with inventory and fulfilled accurately.

Map Product SKUs

With eCommerce, you can track products with different identifiers across different sales channels.

Map Product SKUs 

With eCommerce, you can track products with different identifiers across different sales channels.  

For example, suppose you sell a tumbler with an SKU (Stock Keeping Unit) "TUMBLER_GREEN_17". However, your product reference ID is "1234-567-8901-2345" on eBay. You must ensure that your eCommerce account recognizes these two identifiers as a single product.  

We offer a mapping option to ensure your product identifiers are recognized as a single item so we can accurately sync your inventory.  

Select the options below for more information: 

Update the Reference ID within the User Interface

  1. Log in to your account via https://www.networksolutions.com/my-account/login.
  2. On your Account Manager homepage, click Websites on the left menu.
    • If you only have one package, you will be automatically redirected to your Website Builder.
    • If you have multiple packages, click Launch next to the eCommerce product you want to manage.

  1. Once inside your Website Builder, click Store on the left sidebar.

  1. In the Products section, click on the Actions (⋮) icon and choose Details for the specific product for which you need to map reference IDs. 

  1. Go to the Listings tab and choose the sales channel you need to update. 

Please Note: The Listings tab will appear only after Marketplace Selling add-on is activated in Store Settings -> Add-ons. For more details, please refer to How to Connect Your eCommerce Store to Marketplaces.

  1. Click the Actions icon (⋮), select  Details, then  input the reference ID.

  1. Revise the list (if active) or Save the product for later if you are not ready for the updates to go live.

Update Reference IDs through File Upload

The File Upload option allows you to update reference IDs in bulk. Please follow the steps below: 

  1. Log in to your account via https://www.networksolutions.com/my-account/login.
  2. On your Account Manager homepage, click Websites on the left menu.
    • If you only have one package, you will be automatically redirected to your Website Builder.
    • If you have multiple packages, click Launch next to the eCommerce product you want to manage.

  1. Once inside your Website Builder, click Store on the left sidebar.

  1. Navigate to the Settings section. If Bulk Editing Tools aren't activated in your eCommerce, click Manage on the Add-ons card. If Bulk Editing Tools are activated, skip to step 7.

  1. Select Learn More for Bulk Editing Tools.

  1. Click Activate in the modal window.

  1. In the Settings section, look for the File Templates tile and click on the Manage button. 

  1. Click Add New in the top-right corner of the page.

A pop-up will open.

  1. Fill in the details required and click the Next button.

Please Note: Select Import as the Type. You can select any warehouse as long as no warehouse-specific fields are included in the format. For the identifier, select SKU, Warehouse SKU, or Supplier SKU.

  1. Add Attributes to your template and search for the Reference ID. Click on the plus (+) icon.

  1. Click the Save Template button in the top-right corner of the page.


Please Note: You can download the format you have saved by clicking on the Actions icon (⋯) and clicking on Download Format.

  1. Go to Products on the left menu.
  2. On the top-right corner of the page, click on Import Inventory.

  1. Complete the steps below:

    • Select the file you have downloaded and updated from your computer. 
    • Select the format you used in the previous step.
    • Click the Next button and choose how you want to process your data: 
      • Perform no action – If your file contains products that are already in your eCommerce account, our system will skip those details and only create products that are not in your account. 
      • Overwrite existing details – If your file contains products already in your eCommerce account, our system will replace the existing information with the new file details. Choose this option if you want to update existing reference IDs.
      • Increase existing quantity – Our system will add the quantity in your uploaded file to the existing quantity.

  1. Click the Upload button.

Review

By following these steps, you can match product SKUs and reference IDs. This ensures that your inventory stays accurate and that you can manage your products across different sales channels. Our eCommerce offers flexible options for making updates, whether you prefer to do it manually or in bulk through file uploads.