How do I map multiple SKUs to a single product?

How to map products.

What is the scenario?

You are selling on Amazon and Shopify. The same product has different SKUs:

Product Channel SKU
W5-5JTZ-4M82 Amazon W5-5JTZ-4M82
W5-5JTZ-4M82 Shopify 7063

This can happen for many reasons:

  1. Typos in the selling channels. A user entered the wrong SKU.
  2. You can have multiple Amazon listings for the same product. Each listing must have a different SKU.
  3. It is possible products come from a different supplier, so companies have different SKUs for the same product on different channels.

How do I fix these issues?

Here are the steps:

  1. Login to Connex Inventory Planner.
  2. Go to products.
  3. Click the all inventory report. Enter 7063 and W5-5JTZ-4M82. Notice how you have 2 different products.
  4. Click product mapping.
  5. Enter W5-5JTZ-4M82 as the product to map from and 7063 as the product to map to in Connex. TO DO ENTER SCREEN SHOT
  6. Click all inventory.
  7. Enter 7063.
  8. You will see higher numbers because sales with W5-5JTZ-4M82 have been merged with sales from 7063.

How does this work?

Here is some sample data:

Channel Product Parent QTY Sold
Amazon ABC-123   100
Shopify ABC-123-1 ABC-123 50
Walmart ABV-123-2 ABC-123 50

The -1 and -2 are the same product on different channels.

Without a product mapping tool, you are unsure how many sales of ABC-123 you had. Therefore, you are unable to predict your sales velocity and when to reorder inventory. 

The same product exists on multiple selling channels, but the SKU is different. With Connex, we would merge this data together. ABC-123 would encompass all the sub products, so ABC-123 sold 200 units.

To prevent running out of stock, you must reorder ABC-123 when the quantity on hand reaches 500. There are 1,000 units on hand. There were 100 orders of 1 unit each for ABC-123 in 100 days. Your sales velocity is 1 and you have 500 says before reordering. Connex will merge the sub products. You had 200 units sold and your sales velocity is 2. You must reorder inventory in 250 days.