Edit eBay Condition ID using File Exchange

Select Create a Download Request. Select Active from the Listings and Records Drop Down. Leave the download format as standard, and leave the date range as all active listings. The email address is a notification address only, no actual files are sent. Click Save. Your reference number tells you the request has been initiated.

Open up the ConditionIDs by Category CSV file within the File Exchange Instructions and Resources page. http://pics.ebaystatic.com/aw/pics/pdf/ConditionIDs_by_Category-us.csv Note available ConditionIDs needed. 1000 is consistently Brand New, Retail style item, but the other values vary.

Next, go to the Completed Downloads page. Download the results csv, and open in a CSV editor. (MS Word, Open Office, Google docs, etc.)
From here, you can use any available column to sort existing item condition, title, or category. Once sorting is completed:
1. Change Item ID to ItemID
2. Change Condition ID to ConditionID
3. Add a column in front of ItemID, and title it Action
4. Remove all columns except the aforementioned
5. Fill in Revise for all items under the Action column
6. Ensure the new CategoryID is filled in (1000, 1500, 2000, 3000, etc)
7. Save as .csv file somewhere accessible.

Go back into eBay, and go to the Upload Files page, Type in the notification email address, and browse to the saved .csv. Click Upload.

Next, go to the View Upload Results page. Download the Load Results Report. Success means complete. Warnings are dependent, so read them and spot check. Failure is failure.

Things to keep in mind.
1. Only revisable items can be revised- no auctions with bids. FP with sales can be revised.
2. Existing Item Condition will be overwritten by CondtionID. This is a good thing.
3. Certain Categories do not currently allow CondtionID to be revised. Adult Categories do not allow Condition ID to be revised.
4. International sellers/items- Create a template request to get the appropriate Action Column header.

Good luck, and happy selling!

Learn more about eBay Condition ID here:
http://ebayinkblog.com/2010/07/27/video-concise-informative-demo-by-ebay_andy...

Category:

Education

Tags:

• ebay
• File
• Exchange
• Item
• Condition
• ID

[trilogy1421]

I need help with file exchange can you help me?

[david4943]

Great video.

Question:

How do you populate the comparability feature AUTOMATICALLY using file exchange when uploading auto parts?

When you list an auto part manually the comparability feature is populated AUTOMATICALLY. The information is ALREADY in eBay's catalog.

How do I duplicate this using File Exchange?

[channelplex]

good stuff

[katskloset]

Great info and demo Andy - thanks for posting this!