Mappping alias skus to a single product id
When you are selling on multiple platforms, it is not always possible that the products have unique SKU (stock keeping unit) codes on all the sites. To help ensure a smooth running business, Finale has the ability to easily map multiple alias SKUs to a single product id to save on time and money. Mapping alias SKUs allows store owners to have a better grasp of the inventory stock levels.
(Videos: See complete list of available videos)
Video Transcription of Alias SKUs
Hi, this is Chinh Nguyen from Finale, and today what we’re going to do is show you how to create a product lookup table and map alias SKUs for your ShipStation orders. Right now, for many of our ShipStation customers, they sell on multiple marketplaces, so they may sell the same product on eBay, or Amazon, and their own online store. Unfortunately, a lot of these marketplaces you don’t have too much flexibility on your SKU numbering convention. So, what we’re going to do is show you how to map alias SKUs so that way when a product gets sold on Amazon, it gets properly decremented in your inventory levels. So, let’s go through the example really quickly.
In this exercise, you know, I went ahead and created a new product called a yellow polo shirt. And as you see here, the product ID is 10035. So, to create the product lookup table. You first open Excel. This illustration here is, essentially, I have four columns and, you know, I have two extra columns just for illustration purposes, but, let’s just go through that really quickly. So, for example, let’s say you have, you’re selling the same yellow polo shirt on three different marketplaces, eBay, Amazon, and Magento.
As you see here, the product ID is what we created in Finale, which is 10035, and it’s populated in each column or each cell. The product lookup table allows you to map alias SKUs to a single product id. So, I just made up some scan keys for these illustrations, but as you see here, there are three different scan keys that are tied into your product ID. We’re doing one product now, but I imagine when you set up your file, initially, you’ll be able to export a lot of these SKUs from eBay and Amazon. So that way it’s very easy for you to create a large Excel file in a short period of time.
For this example, we created one product. So, let’s copy these two like I said, columns A and B were…column D, was for just simply for illustration. You copy these two, and you go back to your Finale, and what we’re doing is we want to import these records. What we want to do is click on the fourth button, which is to import to batch create and scan and lookup tables. Again, it’s a simple Copy and Paste operation where we hit Control V. As you see here we have three rows, the scan key, and these are the SKUs that are tied back to the marketplaces. One for eBay…one for Amazon, one for eBay, and one for Magento. As you see the product IDs are the same. You hit next, you commit.
Let’s just do a quick check. So, if I type in yellow, here we go. Here are the three scan keys, and so we’re all set up. So that way when you make a sale from Amazon, then this scan key will be associated with this product ID, so we will be able to know where to decrement your inventory levels. This is how you’re able to map multiple alias SKUs to a single product id. Thank you.