This tutorial will teach you how to update listings with variations on Ebay, using Ebay File Exchange. This task will be completed with one simple upload to Ebay File Exchange. If you have been re stocking your item quantity or revising prices manually, this is guaranteed to save you a lot of time.
If you have found this tutorial and are new to Ebay File Exchange have a look at my previous tutorial which covers
- What is Ebay File Exchange
- Creating a template for Ebay File Exchange uploads
- Revising the price and quantity of multiple single item listings
- Uploading to Ebay File Exchange
Read: How To Update Product Quantities and Prices Using Ebay File Exchange
How to update listings with variations using Ebay File Exchange
Presuming you have followed my previous tutorial linked to above it is actually quite easy to advance your Ebay spreadsheet to update the quantity and prices of listing which have variations, and even multiple variations.
First i will show you how to update an item with a single variation, for example multiple colour choices, then after that i will show you how to update an item with multiple variations, for example colour and size variations.
Updating an Ebay listing with a single variation using Ebay File Exchange:
Again i will presume you have a basic template setup from reading my previus tutorial, if not you can download my Example Ebay File Exchange Excel XLS Template which you can open in Microsoft Excel.
To get started our spreadsheet should be setup as follows:
In this example our Ebay listing with variations is as follows:
So nice an easy, our variation is called Colour
And our variation choices are:
So to set this up in our spreadsheet we would enter the following
- Action = Revise (We are revising an existing listing)
- ItemID = 100916777364 (obviously this vary for every item you wish to revise, your item must already be listed on Ebay)
- Relationship = Leave this empty for now, you will see why in a minute
- RelationshipDetails = Colour=Red;Blue;Yellow;Green (Here you must enter the variation name, so for this example it is Colour, you then want = followed by the name of each variation. Each variation must be separated by a ; (semicolon) you do not need to put a semicolon after the last variation however.
- Title = Matts Single Variation Example (This is the title of the item as listed on Ebay)
- Quantity = Leave this empty for now, you will see why in a minute
- StartPrice = Leave this empty for now, you will see why in a minute
If you follow the above you will end up with the following:
The important bit here is that you have all your variations in the RelationshipDetails column.
Now all we need to do is add each variation to its own row below, if we do it for the first variation we will end up with the following:
Here ebay already knows we are looking at item 190811999538 so we simply need to enter the following for each variation
- RelationshipDetails: Colour=Red (Here you always need the variation name, which in this example is colour, then the = (equals sign) along with the name of the variation
- Quantity: This is how many of the particular variation you have to sell
- StartPrice: Again this is unique to that variation, the price you wish to update the variation to
You simply need to repeat the above for all the variations a product has and you would end up with the following:
That it, when uploaded to Ebay that would update the price and quantity for all the colour variations in that Ebay listing.
Updating an Ebay listing with multiple variation using Ebay File Exchange:
Now you have learned how to update a listing with a single variation, we can expand upon this and update an Ebay listing that has multiple variations, for example colour and size.
In this example our first variation is called Colour and the second variation is called Size
Our Colour variation choices are:
Our Size variation choices are:
So to set this up in our spreadsheet we would set this up very similar to doing a single variation, however we would use a vertical bar (|) to separate each variation choice.
So basically as can be seen about all that has changed is that the relationship details have the additional options from the second variation, separated by a vertical bar: Colour=Red;Blue;Yellow;Green|Size=1;2;3;4
As before when we set details up for the variations we need to do this again, however we must now do it for every possible combination of your variations, e.g. Red in size 1,2,3 and 4.
So for example that would then look like this:
We now basically have to repeat that for all the other variations in your listing, so we would end up with the following:
As you can see from the above screenshot the spreadsheet has an entry for every possible colour variation, in every possible size variation.
That is basically it, you should now be able to create a spreadsheet that can be uploaded through Ebay File Exchange, that will automatically re stock all your listed items to a specific quantity, and allow you to update the price of items and variations with ease.
Ebay File Exchange Example Downloads:
Here are XLS (Microsoft Excel) downloads of the examples from above, this might be a good starting point to work from, or to reference if you are having problems.
Ebay File Exchange Single Variation Example Download
Ebay File Exchange Multiple Variation Example Download
Ebay File Exchange Single Listing, Single Variation and Multiple Variation Example Download (This shows how you can revise different types of listing all from the same spreadsheet)
Remember in part one of this blog post I talked about setting the spreadsheet up in more detail and actually uploading to Ebay using File Exchange.
I hope this blog post is useful anyway, it her certainly saved me a lot of time updating Ebay listings like this, if you have any questions i’ll try my best to assist you.