please help, 4 hours on the phone with ebay and management and they are so dumb, ho help or clue

[nylvseller]

I want to create this exact type of listing and i have all the variations in a excel sheet, but no one can tell me how to import and create this type of listing , please help!

https://www.ebay.com/itm/266612610542

[mam98031]

I've never done this before, so I'm certainly no expert.  I do use variation listings, but not in the way you are trying to do.

I think you can use Seller Hub Reports to create listings (including variation listings) by file uploads:

https://www.ebay.com/sh/reports/uploads

For information about how variations would entered, click "Learning  resources" on the left  side of Seller Hub Reports and then click "Create listings in bulk."  That will take you to the Inventory Onboarding Guide. There is a section there about listing with variations.

[nylvseller]

thanks for the reply, its close but i get this and i dont want all those fields and cant delete any, i think that option is only for separate listings

[coastaltechsolution]

Maybe you will have to create from scratch? 

[monica-sells]

all i know for sure is it needs to be formatted properly.....

stand by....i am paging the resident 'expert' for you....

@shipscript

maybe you can help this seller out

[lacemaker3 · Accepted solution]

@nylvseller 

An experienced responder, @shipscript, created a guide on how to do this, which is several years old now.

https://community.ebay.com/t5/Seller-Tools/Using-File-Exchange-to-Streamline-Variation-Listing-Creat...

Shipscript, is this guide still accurate and up to date?

[shipscript]

---

@lacemaker3 wrote:

https://community.ebay.com/t5/Seller-Tools/Using-File-Exchange-to-Streamline-Variation-Listing-Creat...

Shipscript, is this guide still accurate and up to date?

---

@lacemaker3 

Yes, the basics are still good for manually starting a listing and then fleshing it out with a spreadsheet. What is missing is that the upload button for that CSV file is now on

Seller Hub > Reports > Uploads

https://www.ebay.com/sh/reports/uploads

@nylvseller 

If you want to list entirely from a spreadsheet, it is best to start with the downloaded category template that has been suggested by @mam98031.   It can be found on Seller Hub > Reports > Uploads

https://www.ebay.com/sh/reports/uploads

The template would be for trading cards: sports cards singles

If you are using Excel, I highly recommend that you download the XSLX file. It includes several hidden pages of details that will be used to help you populate the spreadsheet.

When using the spreadsheet template, it is important to start from the left and work your way to the right as you encounter fields that can alter the requirements for each listing. Also note that droplists are not in the headers. The droplists are in the empty cells that make up each row.

The first selection you will make is to choose the category. It may already be selected for you, but if not, click into the empty cell on the row you want to populate, and a droplist will appear. 

The next required field is the "Condition ID". Again, the droplist is down in the empty cell you want to populate, so click the cell and select the condition. From there, additional columns will be mandated, based on your condition selection. And you can choose from those droplists.

When cells do not contain a droplist, you can enter text or numbers, as appropriate. Sometimes a cell will have a list, but will allow you to make up your own value.

Once you have completed a master row, you can populate the variations from you spreadsheet of cards. The variations will appear in rows below the master record, and will be quite similar to the example page you were shown. 

Action	...	Relationship	RelationshipDetails	Quantity	StartPrice	CustomLabel
Add	...		Card#=TOP-10:Player #10;TOP-11:Player #11;TOP-12:Player #12;TOP-13:Player #13;
		Variation	Card#=TOP-10:Player #10	3	1.99	T10
		Variation	Card#=TOP-11:Player #11	1	1.99	T11
		Variation	Card#=TOP-12:Player #12	2	1.99	T12
		Variation	Card#=TOP-13:Player #13	6	1.99	T13

Note that the example label "Card" is now a reserved name, so I have substituted "Card#".

Also note that the headings on eBay's template may not exactly match the headers I've shown for  older File Exchange. The new template has spaces between words. That is fine. eBay will accept either format, or a mix of formats when uploading the template to Seller Hub.

At the very bottom of this page is a tool to automatically concatenate the master row of card names. That is one aspect that trips up many sellers with typos and such. The order of the names in the master row will determine the order on the droplist on the active listing. The order of the individual variations in the spreadsheet has no effect.

https://www.isdntek.com/ebaytools/VariationBuilder.htm 

[nylvseller]

Amazing info thanks, not one person on ebay support had a clue

[lacemaker3]

---

@nylvseller wrote:

Amazing info thanks, not one person on ebay support had a clue

---

eBay CS is not trained or experienced in selling, so this is not surprising or unexpected.

You were expecting too much, TBH.

[shipscript]

---

@nylvseller wrote:

Amazing info thanks, not one person on ebay support had a clue

---

I suspect that Customer Support jobs have an average life of about 2 to 3 years - not enough time to train someone in "everything eBay".  I'm amazed they can assimilate as much knowledge as they do. After all, who can listen to complaints, day in and day out, without going bonkers and moving on?  The few that stay longer may know more, but not in full detail.

While CS may know about "variations", it is unlikely they know anything more than what is on the help page for creating variations with the listing form.

The spreadsheet is really a programming situation and customer service has no clue about anything to do with the details of programming (and it really wouldn't make sense for them to know). But that is why the community is here to help fellow members through those more difficult passages. Many community members have years, even decades (like yourself), of on-the-job experience.  Please feel free to post back to the forums if you get into a bind with listings that are not plain vanilla.

The spreadsheet CSV uploader is a "seller tool" and there is more direct support for that on the "seller tools" forum. While you were able to get an appropriate response here on the "selling" forum, the pool of problems is much broader. The "seller tools" forum is more focused if you need help with the spreadsheet uploader. 

eBay Forums: Seller Tools

[reallynicestamps]

The phone reps have a terrible reputation for getting you off the phone as soon as possible even if that means giving you the advice you want to hear instead of the advice you need to have.


https://www.facebook.com/eBayForBusiness/ — Message button in upper right on landing page.

https://www.instagram.com/ebayforsellers/


https://community.ebay.com/t5/Selling/How-do-I-contact-Customer-Support/m-p/32016431#M1783851 -> Automated Assistant, type AGENT -> enter. You will then get more options.


The social media Chat accounts are covered by trained eBay employees with some authority.
And you get a transcript so you can compare what you heard with what you were told.
 

However, there is no reason to believe that anyone,phone or Chat, is an experienced seller, they all have full time jobs for one thing, nor that they are trained on selling.

Their job is to fix problems usually with transactions, and sometimes with accounts.

There is a Technical Support division. I'm not sure what they do.

Also, this is Saturday. Most of the staff is at home playing with the kids or buying groceries. Only a skeleton staff is "at the office".

[nylvseller]

ShipScript = the most amazing, helpful person i ever met online.  I cant even explain how much time he put into helping me WOW, WOW, WOW.

[mam98031]

---

@nylvseller wrote:

ShipScript = the most amazing, helpful person i ever met online.  I cant even explain how much time he put into helping me WOW, WOW, WOW.

---

I couldn't agree more.  SHE is amazing.

[onefootflipper1]

Why would you want that. 

That listing probably took the seller 3 whole days to make so he could net an entire 20 cents each on those cards after fees. Lets say the listing created itself, and you were given all the cards for free.

Could you fill 100 orders and hour just to get to $20 an hour before self employment tax? Our fastest guy at the card shop could only pull and pack 30 of them an hour and that was when he was being timed and challenged.

So many people working for nothing or literally shipping out cards at a dead loss in the card space that it is insane.

[bashort]

asking ebay for help with how to use a ebay feature is like calling the USPS and asking them a question about shipping a item, in both cases your will likely get someone who knows very little and cares even less, your average ebay seller and youtube are a much better source of information in both cases