Update stock levels to Etsy variation skus

We know it’s important that your stock levels are accurate to enable a smoothing running business.  Finale acts as a central inventory hub constantly scanning for new orders from all our online selling channels.  When we find them, we’ll update product levels across all integrated sales channels, keeping quantities accurate wherever you sell.   Finale will update stock levels to Etsy variation skus (Stock Keeping Unit) or Etsy listings in near real time to mitigate overselling.

etsy variation skus


Overview of  updating stock levels to Etsy variation skus

(Videos: See complete list of available videos)


Video Transcription

Hi, this is Chinh Nguyen from Finale Inventory. In this video, I wanna show you how Finale pushes stock quantities to Etsy variation skus.

So, this is my Etsy test account and, you know, one of the things that’s been a big pain for Etsy customers is the inability and previously an inability to push up stock quantities when you have variations. Recently, Etsy has rolled out a new feature that has enabled, basically, Etsy variation skus for their products, for your variation products for your listings. So, for example, I’m selling polo shirts in this listing, so we have basically the options are blue and red. My SKU, which is new, is polo-blue and polo-red, and the quantity is one of each. So, I’m gonna show you how now Finale can be connected to this account and push up stock quantities so that way Finale Inventory can be used to manage your inventory and push up stock quantities to these new Etsy variation SKUs. Okay?

So, the first thing we do is open up Excel, and what you do is you create a mapping file that associates the product ID to the lookup. So, in this case, if I go back to my account, my two products are my blue polo shirt, which has a product ID of 500, and my red polo shirt, which has a product ID ramin2. Okay? And if I go back to my Etsy, the two Etsy variation SKUs are polo-blue and polo-red. So, you know, there’s two ways to do this to create the mapping and the association. One is through an Excel file, here, where the three columns, one is the product ID, the product lookup, which is the marketplace SKU, and the connection name, in this case it’s called the Etsy SKU. Also, you can also create this same kind of association within the interface itself. So it’s pretty handy to do the bulk import when you have a lot of lookups, but if you’re doing one or two, in fact for this example there’s no reason why you couldn’t just do them, add them directly in the interface. But, let’s just go continue this example.

I’m gonna import here. Copy this, and then import into Finale. And what I do is I go to Home, I click on Import & export. I click on Import to batch & create product lookups. Okay? So, here’s my product ID, here’s my lookup, and here’s my store. Or, connection name’s probably the better term. Okay? So, now if I go to my View stock, you see the blue polo shirts has  zero. The available of 100 because there’s a purchase order of 100, so as a result, Finale would push up zero because there’s nothing available for us to actually sell. You know, basically, remaining is basically quantity on hand minus any outstanding commitments. So in this case it’s zero. So, I have zero for my blue polo shirts, and zero for my red polo shirts. If I click on this blue polo shirt, we go to the product details page and what I want to kind of quickly show is if I scroll all the way to the bottom, this is where it says my association between my product lookup and my store. So, in this case, what I’m looking at is the blue polo shirt and it’s associated with my Etsy SKU, as my connection name. Okay?

So, now let’s say that we have a purchase order, like we have right here of these products, and the shipment has arrived. So, I went ahead and created a purchase order before and basically we’re expecting 100 blue polo shirts and 80 red polo shirts. So let’s say the shipment has arrived, so I’m just gonna basically receive them in now. So I’m just gonna receive them in. So, Finale is configured, or designed, to push up stock quantities to the marketplace whenever there’s a stock change. So before, we had zero, but now we have 80, or 100 and 80, respectively, because we just received it from a shipment. So from here, normally Finale would push up those stock changes automatically, because it pushes up stock changes within five minutes of any stock change operation. But instead of waiting five minutes, I’m just gonna hit Run task now to manually force it to Finale to push up those stock changes. So, if you see here, if I go to View stock I think Finale has finished.

If you see here, here’s the two quantities, the red polo shirt has 80 and the blue polo shirt’s 100, so that’s from the status log, so let’s see if you go to Etsy if it updated. So I go back to my products here, scroll down, and here you go. Here’s 80 and 100. So let’s make one more adjustment, just to confirm it works. Let’s say that, for example, we found, for example, two of the polo shirts were damaged, so I’m just gonna make a quick stock change here. Let’s say the blue polo shirts, we found two that were defective so I’m gonna subtract two. So now the new total is 98, so if we go to View stock here, we have basically 98 remaining to sell. So let’s go back to Connections. Again, Finale would normally push these stock changes up automatically within five minutes, but again we’re just gonna manually run it to force it to run. And that’s done. So I go to View status log, you see it now it’s 98. And lastly if we go and refresh the screen here, we imagine that the 100 should change to 98 for the blue polo shirts.

And there you go, 98. So that’s concludes this tutorial, and that kinda shows you how Finale has the ability to also push stock quantities up to the Etsy variation skus. It’s a new change for them, and subsequently it’s a new feature that we recently built for our Etsy customers. If you have any questions about this feature, feel free to email us at [email protected] Thank you.