cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Promoted Listings Upload Error in CSV File

I'm trying to set up a promoted listing sale through my dashboard.

 

I selected the categories I was interested in and went to the next screen where I was promoted to dowload a CSV file to my computer to edit to set the rate for each item.

 

I did that and saved it and then uploaded it back to ebay and was given this error.

 

We can't upload your listings because mandatory headers "Item ID" and "Ad Rate" are missing in the file.

 

Here is the first few lines of the file as viewed in Windows Notepad. I substituted my item numbers in the bit I pasted below.

 

"Item ID","Ad Rate"
111111111111,2
2222222222,2

 

It looks perfectly formatted but fails.

 

Anyone have any thoughts?

 

Thanks,

Steven

Message 1 of 13
latest reply
1 BEST ANSWER

Accepted Solutions

Promoted Listings Upload Error in CSV File

If you are adding the quotes, don't. The quotes that are showing in your example may be what is causing the headings to be unrecognized.

eBay is continually updating this site. Some advice given may have changed. Please reply to this thread, to let us know if this advice works for you. The links on the bottom of any eBay page can help you deal with most eBay issues. Contact eBay Customer Service on Facebook.com/eBay or Twitter.com/AskeBay

View Best Answer in original post

Message 9 of 13
latest reply
12 REPLIES 12

Promoted Listings Upload Error in CSV File

Remove the spaces... ItemID, AdRate

eBay is continually updating this site. Some advice given may have changed. Please reply to this thread, to let us know if this advice works for you. The links on the bottom of any eBay page can help you deal with most eBay issues. Contact eBay Customer Service on Facebook.com/eBay or Twitter.com/AskeBay
Message 2 of 13
latest reply

Promoted Listings Upload Error in CSV File

The ItemID, I can be certain of. The ItemID field is represented by the Title ItemID in all things eBay. The API, FileExchange and TurboLister all follow this convention.

 

The AdRate, is not listed as a field on the API or is it documented in FileExchange. However, all other fields leave out any spaces between words. So I  am fairly confidant that AdRate would be the correct usage.

eBay is continually updating this site. Some advice given may have changed. Please reply to this thread, to let us know if this advice works for you. The links on the bottom of any eBay page can help you deal with most eBay issues. Contact eBay Customer Service on Facebook.com/eBay or Twitter.com/AskeBay
Message 3 of 13
latest reply

Promoted Listings Upload Error in CSV File

Regrettably that change gave the same error. Hope they get this fixed since they are retiring markdown manager in a few days.

 

Just to document, the changed file looks like this (product ids changed)

 

"ItemID","AdRate"
1111111111,2
2222222222,2
333333333,2

Message 4 of 13
latest reply

Promoted Listings Upload Error in CSV File

I do not know if this is one of the Apps from the Advanced Apps team, but would think they could forward reports to the appropriate dept.

 

Send an email, from your registered email account, to turbodata@ebay.com. Include your userid and as much detail about the issue as possible.

 

Or...This is from the eBay Advanced Apps team...

Phone Support (US - 8 AM - 6 PM MST): **To call us, click on the Help & Contact link found at the top of most eBay pages. Click on the Contact Us button at the bottom of the page. Select ‘Selling’ -> ‘Getting Started’ -> ‘Selling Tools’ for issues or concerns related to eBay listing tools that my team can assist you with. Now scroll to the bottom and click Call Us. Ask the customer support agent to transfer you to the Advanced Apps team.**

eBay is continually updating this site. Some advice given may have changed. Please reply to this thread, to let us know if this advice works for you. The links on the bottom of any eBay page can help you deal with most eBay issues. Contact eBay Customer Service on Facebook.com/eBay or Twitter.com/AskeBay
Message 5 of 13
latest reply

Promoted Listings Upload Error in CSV File

@thehistoricalarchive - Thank you for posting your concerns on this Community Board thread.

 

You can use File Exchange to download your active listings, but the uploaded file to Promoted Listings has to be formatted like this:

 

image.png

It's different than File Exchange upload headers. You should have spaces in the headers.

 

These are the only two headers you need in the file when uploading to Promoted Listings.

 

If you are getting an error message of the Item ID being invalid or missing, it could be that the Item ID information in your file wasn't formatted to numbers with zero decimal places, which will help Excel retain the numbers/values upon saving the file.

 

I hope this helps.

 

Please feel free to post your response regarding my information on this post.

 

Thank you again.

 

Sincerely,

 

mykal@ebay

eBay Support

Message 6 of 13
latest reply

Promoted Listings Upload Error in CSV File

I double checked all that and still get this error:

 

We can't upload your listings because mandatory headers "Item ID" and "Ad Rate" are missing in the file.

 

I opened the file in notepad and pasted the first several lines below so you can see exactly what is in it:

 

"Item ID","Ad Rate"
132276661256,2
142487655769,2
142487655777,2
132282832796,2
132286268715,2
142487655775,2
142487655774,2
142487655786,2
142487655784,2
132282832798,2
132277655702,2

Message 7 of 13
latest reply

Promoted Listings Upload Error in CSV File

@thehistoricalarchive - Thank you for providing an example of what you were trying to upload.

 

I don't know which file format is valid to upload. From your example, it appears to be a "Tab Delimited CSV" file.

 

Can you please try to upload it as Comma Separated Variable file?

 

It should look something like this:

 

image.png

Let us know if that works for you.

 

Sincerely,

 

mykal@ebay

eBay Support

Message 8 of 13
latest reply

Promoted Listings Upload Error in CSV File

If you are adding the quotes, don't. The quotes that are showing in your example may be what is causing the headings to be unrecognized.

eBay is continually updating this site. Some advice given may have changed. Please reply to this thread, to let us know if this advice works for you. The links on the bottom of any eBay page can help you deal with most eBay issues. Contact eBay Customer Service on Facebook.com/eBay or Twitter.com/AskeBay
Message 9 of 13
latest reply

Promoted Listings Upload Error in CSV File

That did the trick. Thank you!
Message 10 of 13
latest reply

Promoted Listings Upload Error in CSV File

Hello - I am encountering this same error.

This users issue seemed to be resolved by removing " " around the headings.

 

I do not have those, and from what I can tell my file is in the same format as the official ebay response within this thread.

I've opened my file in Numbers (the apple version of Excel) -- could that be an issue? Hopefully not, since there are a lot of Mac users out there.

 

Thanks!

Message 11 of 13
latest reply

Promoted Listings Upload Error in CSV File

Any spreadsheet will work, but you must save the csv file as a DOS csv file. FileExchange expects the DOS end of line characters. IT will not function with Apple end of line characters.

eBay is continually updating this site. Some advice given may have changed. Please reply to this thread, to let us know if this advice works for you. The links on the bottom of any eBay page can help you deal with most eBay issues. Contact eBay Customer Service on Facebook.com/eBay or Twitter.com/AskeBay
Message 12 of 13
latest reply

Promoted Listings Upload Error in CSV File

ah, thank you so much, DollyBeauty! I will do that.

Appreciate the response and help!

Message 13 of 13
latest reply