10009 error code for uploading to eBay Germany

[wwwisicarcom]

Hi,

I am trying to create an uploader using ExcelVBA and every time I test it on the File exchange I get the error: 3,Add,Failure,10009,"""Error - Kein <Item.ListingDuration> existiert oder <Item.ListingDuration> ist in der Anforderung als leeres Tag angegeben.|Item.ListingDuration|""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,2030,,,,,,,,,,,

in German.

I've translated it into English but cannot figure out what the problem is.

Ref. number: 46804894

[eburtonlab]

@wwwisicarcom 

According to google translate, that error means:

"Error - No <Item.ListingDuration> exists or <Item.ListingDuration> is specified in the request as an empty tag. | Item.ListingDuration | "

If you are sure that the current value is valid ("GTC"?), then the problem lies elsewhere.

Old but possibly relevant threads:

https://community.ebay.com/t5/Archive-Tools-Apps/Item-ListingDuration/td-p/20670398

https://community.ebay.com/t5/Tools-Apps/Item-ListingDuration-error-code-10009-File-Reference-780493...

[dollybeauty]

@wwwisicarcom 

You are located in Japan, and registered on the UK site. This poses special issues. I would need to see your Action statement in cell A1 of your spreadsheet (and a screenshot of your file) to help much.

1) Is your item located (shipped from) Japan, or UK?

2) SiteID=DE?

3) Are you specifying GBP as the 'Currency'? Or EUR?

4) As previously stated, are you using the value 'GTC' (this must be all capital letters)? Note...this is a required field. You cannot leave it blank.

With more info, we can help further.

[wwwisicarcom]

Thank you!

[wwwisicarcom]

@wwwisicarcom 

You are located in Japan, and registered on the UK site. This poses special issues. I would need to see your Action statement in cell A1 of your spreadsheet (and a screenshot of your file) to help much.

1) Is your item located (shipped from) Japan, or UK?

Japan

2) SiteID=DE?

Yes

3) Are you specifying GBP as the 'Currency'? Or EUR?

EUR

4) As previously stated, are you using the value 'GTC' (this must be all capital letters)? Note...this is a required field. You cannot leave it blank.

Yes, we are using "GTC".

We were successful with Spain, France and Italy but for Germany we always get the same error.

I am attaching screenshots.  Please let me know if you need different sections of the file.

Thank you for your help.

[dollybeauty]

@wwwisicarcom 

Your Action, Location and Duration values seem to be correct. I do see some differences from the Excel format that I am accustomed to, but since this works on other sites, I assume this does not matter.

So back to the error 10009. This has a couple of possible causes.

1) The heading 'Duration' is absent or is not on the same line (in the csv file) as the other headings, or

2) The duration value is absent, incorrect, or is not on the same line as the other values.

While the above does not appear to be incorrect in your spreadsheet, they can be incorrect in the uploaded csv file. I suspect that your 'Description' value may have a linefeed in it. If it does, then the values after the description will not be on the intended line, will not match up to the headings, and can cause this error.

You can check this two ways (and I would suggest you look at both).

1) Open the generated csv file in NotePad (not a word processor). Does the description break, then start a new line?

2) Look at the upload results page on eBay. Are there more '# of requested actions' than the number of lines in your file?

If you are not on a Windows based computer, you will not have NotePad, so just look for number 2).

If you are uploading 1 item, the '# of requested actions' should be '1'. If it is 2 or more, then you have linefeeds in your description, and that would cause all other values for that item to be on the next line.

You can use this eBay utility to eliminate linefeeds from a description - http://pics.ebay.com/aw/pics/pdf/us/file_exchange/FileExchangeDescriptionUtility.zip

I also notice that you have two columns for 'ItemSpecifics'. This would cause a BAF error on the US site. The correct headings would be C:Brand and C:MPN.

We are always interested in your final solution. Please repost when you do solve this.

If the above does not help, you may need to contact the Advanced Apps team, to look into the execution file to see what the issue may be. Since you are not in the US, a call to Utah would be expensive. I will include that option below, but you may wish to email them instead.

To email the Advanced Apps team, send an email from your registered email address to turbodata@ebay.com. Include your userid and the upload ref # of the file.

To call...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.**

[wwwisicarcom]

@dollybeauty

Thanks for your reply.  We got onto the Advanced Apps team and solved the problem.   Main issue was that C:Brand and C:MPN had to be in German.

Thank you again and we really appreciated your help.