Ebay Secrets Blog

Check out this quick, concise and informative video demo from @ebay_andy showing, in less than 4 minutes, how to edit eBay condition ID using File Exchange.

A huge thank to Andy for submitting to eBay Ink. Cheers!

Here’s a quick written tutorial too:
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.

Was this helpful? Would you like to see more like this? Let me know.

Cheers,
RBH

Go to Source

Related posts:

1. VIDEO Behind the Scenes: eBay Innovation Demo Expo – Green Sort on Motors
2. Overview and Demo of @ProStores 10; Video interview with @ecommerceguy #ebaynews
3. StubHub App now available on iPhone & iPod Touch (Video demo & screen shots)
4. eBay Classifieds iPhone App now available / Video Tutorial #eBayCnews #eBayAppNews
5. Behind the Scenes: eBay Innovation Demo Expo 2010