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 Reference ID within User Interface
• Updating Reference IDs through a File Upload

Update the Reference ID within the User Interface

1. Log in to your account via https://www.web.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 eCommerce dashboard.
   • If you have multiple packages, click LAUNCH next to the eCommerce product you want to manage.

3. Once you have accessed your eCommerce dashboard, click Store on the left menu, then select Products.

4. Click on the Actions (⋮) icon and choose Details for the specific product for which you need to map reference IDs. 

5. Go to the Listings tab and choose the sales channel you need to update. 
6. Click the Actions icon (⋮), select  Details, then  input the reference ID.

7. 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.web.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 eCommerce dashboard.
   • If you have multiple packages, click LAUNCH next to the eCommerce product you want to manage.

3. Once inside your eCommerce account, click Store on the left menu, then select Settings in the drop-down menu.

4. Look for the File Templates tile and click on the Manage button. 

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

A pop-up will open.

6. 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.

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

8. 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.

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

11. 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.

12. 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.