This is a guest post by Maxim Godin, co-Founder of Crazylister.
A vast majority of merchants creates eBay listings individually, not utilizing the advantages of bulk listing. Over time, sellers who master the bulk listing technique gain a significant advantage by saving huge amounts of time which can be dedicated to further expanding their business and gaining a competitive advantage.
eBay Bulk listing in abstract –
Most sellers fill in the “Sell your item” form on eBay for creating individual listings.
eBay also offers several other interfaces to communicate with the marketplace and create listings among other tasks.
One such interface is called – File Exchange. Just as the name suggests, File Exchange allows sellers to communicate with eBay via excel-like files named CSV (Comma-separated values) files.
Sellers can submit CSV files which contain the required data for bulk listing 100’s and 1000’s of products via File Exchange.
Below are the key concepts you must familiarize yourself with in order to successfully bulk list items on eBay.
The best way to explain how bulk listing works is with a real example, so let’s get to it.
If you’re not subscribed yet, follow this link to subscribe to File Exchange (it’s free).
The first thing you want to do is download a CSV template which you can fill in with your products data.
You basically have 3 options here:
For this example, I’ll continue with the Item Specifics Category Template option.
Once you click on “Select a category”, you’ll be asked to enter the category id number –
How to find the category id number?
In order to get the category number, you can look it up at eBay’s category list –
Alternatively, you can find the category id number in the URL of that category on eBay.
For example, let’s look for the category id number of an Apple laptop.
Find a listing from that category, then click on the category link at the top –
Next you’ll see the category id in the URL –
You’re all set, enter the desired category id (“111422” in our example) and click on “Generate template”.
Now click on “Item Specifics Category Template” and download the CSV template.
Here’s what the CSV template file looks like when opened using MS excel –
The template is basically the headers you see in row 1. Rows 5-20 are simply comments explaining the various item specifics for your category, so you can delete those.
Now that you have the template, fill in your products data.
Filling in an excel file is much faster and easier than filling in eBay’s “sell your item” form for every listing.
I’ll explain the mandatory fields in detail, for info about the optional fields click here for eBay’s File Exchange tutorial.
Below are the mandatory (must fill) fields in the CSV template:
One of the required fields in the CSV template is “PicURL”. As opposed to manually uploading individual images when listing through the “sell your item” form, when bulk creating listings, we are able to upload multiple images for multiple listings with one CSV file.
Below is a step by step tutorial for preparing and working with images when listing in bulk:
To automatically construct the URL path, use the concatenate excel formula. Here’s a quick guide for using concatenate in excel.
To add multiple images (up to 12) per listing, separate the URLs with a pipe ” | ” character.
This is how your PicURL field will look like for 3 images:
Tip: You can use the concatenate excel formula to automatically structure multiple image URLs. This is why I recommend to have the same number of images per listing. Otherwise you’ll have to make manual adjustments to the picURL filed per listing.
We’ve now entered the items and images into the CSV template, and are ready to upload the file to File Exchange.
From within File Exchange, click on “Upload Files”, choose your file and click “Upload”.
It will take eBay a couple of minutes to process your request, this may vary depending on how many listings you’re uploading.
Click on “View Upload Results”, right below the “Upload files” on the left menu.
Here you can download a report which shows the result of your request –
Click on “Download” from the right most column “Load Results Report**”.
Your file will contain the upload results for each and every listing from your upload.
The “Status” column will indicate if your listing loaded successfully, or if you have an error.
Any status other than “Error” indicates that your listing was created successfully and you can see the listing number under the “ItemID” column.
Tip: It may take several attempts until you manage to get your template right and successfully launch your listings. If you see an error status, read the error message from eBay to get an idea of what the problem is and how to fix it.
A “warning” status is very common, you can usually disregard it.
You should now have created basic “text only” listings in bulk using File Exchange.
The next step is to apply a professional template to your listings to increase your sales and conversion rates.
Once your basic (text only) listings are live, you can use CrazyLister to apply a professional template to multiple listings with one-click.
Here is how it works:
1. From within your CrazyLister account, click on the “Listings” tab –
2. Click on “Sync from eBay” on the right side to import your recently created listings –
3. Select all of your listings and pick a template to apply –
4. Pick a template and apply.
Congratulations! You’ve now applied a professional template to all your listings.
There are four main steps in creating eBay listings in bulk with File Exchange:
1. Download and fill in a File Exchange CSV template.
2. Name your images in a structured format and upload them to an online hosting.
3. Upload the CSV template to File Exchange to create the listings.
4. Apply a professional template to your listings.
Need help with eBay bulk listing? Contact CrazyLister’s support by clicking the support widget at the bottom right of any page at CrazyLister.com