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
This live-blog and twitter session contains non-GAAP measures relating to the company’s performance. You can find the reconciliation of those measures to the nearest comparable GAAP measures here.
This Twitter session may make forward-looking statements relating to our future performance that are based on our current expectations, forecasts and assumptions and involve risks and uncertainties. These statements include, but are not limited to, statements regarding expected financial results for the third quarter and full year 2010, the focus on the Payments and Marketplaces business units going forward and future growth in the Payments and Marketplaces businesses.
Our actual results may differ materially from those discussed in this call for a variety of reasons, including, but not limited to, the further impact of the credit crisis and the sovereign debt crisis in Europe; continued or worsening global economic downturn; changes in political, business, and economic conditions; foreign exchange rate fluctuations; the impact and integration of recent and future acquisitions; our increasing need to grow revenues from existing users in established markets; an increasingly competitive environment for our businesses; the complexity of managing an increasingly large enterprise, with a broad range of businesses; our need to manage regulatory, tax, IP and litigation risks (including risks specific to PayPal, Bill Me Later and the financial industry); and our need to upgrade our technology and customer service infrastructure at reasonable cost while adding new features and maintaining site stability.You can find more information about factors that could affect our operating results in our most recent annual report on our Form 10-K and our subsequent quarterly reports on Form 10-Q (available at http://investor.ebayinc.com). You should not unduly rely on any forward-looking statements, and we assume no obligation to update them. All information in the presentation is as of July 21, 2010, and we do not intend, and undertake no duty, to update this presentation.
Cheers,
RBH
eBay Inc. announced financial results for its second quarter ending June 30, 2010. Second quarter revenue was up 6% to $2.2 billion (or 15% excluding Skype), compared to Q2 2009. The company recorded Q2 net income on a GAAP basis of $412.2 million (or $0.31 per diluted share) and non-GAAP net income of $530.2 million (or $0.40 per diluted share).
PayPal delivered a record Q2 performance and added a million new accounts each month during the quarter. For 3 consecutive quarters, PayPal’s merchant services business has grown by over 40% year over year.
eBay marketplace showed a strong performance in Europe, expected performance in Asia and slower than expected growth in the US.
“We delivered strong second quarter results, demonstrating the global strength and increasing diversity of our business,” said John Donahoe, eBay Inc. President and CEO. “PayPal is strong and getting stronger, building a robust and innovative global footprint serving all of ecommerce. And our eBay turnaround remains on track, with strong performance in Europe, significant changes in the U.S. and continued improvements to the buying and selling experience. We continue to focus on delivering strong financial results, managing a healthy balance sheet and making the necessary investments to compete, win and satisfy our customers.”
There are a number of options for you to get more information around today’s earnings announcement. You can listen along to the live eBay earnings call. You can follow along with my tweets in real-time, beginning at 2pm PT. I will be live-blogging here on the homepage of eBay Ink. Also, you can get up-to-the-minute eBay news and information. Finally, you can access the full Q2 eBay earnings announcement.
For folks interested in following the entire conversation on Twitter, the hashtag is #eBayQ210.
Cheers,
RBH

In what can only be described as remarkable, the eBay community has surpassed the $200 million mark for cumulative funds raised with eBay Giving Works since 2003. This represents year-over-year double digit growth.
How it works:
eBay Giving Works enables eBay users to support their favorite causes whenever they buy and sell. Today the program offers five easy ways to make a difference:
• Community Selling: Any seller can donate part of their sale price to a nonprofit. The seller decides which organization to support and how much to give (10-100 percent), and gets a tax deduction for their gift.
• Direct Selling: Nonprofits can sell their own items on eBay to raise funds. eBay waives most basic selling fees for nonprofits, making Direct Selling practically free.
• Shop eBay Giving Works: Every item posted by a Community or Direct Seller bears the eBay Giving Works blue and yellow charity ribbon, so it’s easy for buyers to shop for items to support causes that matter to them.
• Give at Checkout: 1.5 million shoppers every day are invited to add a donation on top of their eBay purchase, when they pay by PayPal. Give at Checkout has raised nearly $5 million in its first 12 months.
• Donate Now: eBay and PayPal users who discover an eBay Giving Works organization they care about can give as little as $1 right away without buying or selling.
It goes without saying that the fact that $50 million was raised in 2009 alone, coupled with the unbelievable final auction price of the lunch with Warren Buffett (the highest value charity auction ever sold on eBay at $2.63 million), greatly contributed to this superb achievement.
Cheers,
RBH
Great to see one of our first eBay Ink Social Media Sellers, John Lawson (@colderICE), give out tips and tricks to selling on eBay. Watch the video here…
Cheers!
RBH
The mobile applications just keep on coming… Today, eBay announced the eBay Fashion app for the Apple iPhone, delivering a personalized shopping experience where shoppers can browse, buy—and virtually “try on”—items from the world’s largest online selection of new, designer, branded and vintage merchandise—virtually anytime, anywhere.
I’m going to download the app later today and test its ability to find pretentiously ironic t-shirts to add to my collection. In the meantime, here are some videos and a list of features highlighting the new app.
Cheers,
RBH
Features of the App include:
• A Personalized Closet allowing users to add, store and curate favorite fashion finds in one place.
• An Outfit Builder enabling users to mix and match items from their Closet and virtually try them on to create unique looks.
• Social Media Sharing functions enabling users to share favorite fashion finds via Facebook, Twitter, and email.
• Direct entry to the eBay Fashion Vault offering instant access to new, fixed price clothing, shoes and accessories at great value through exclusive, limited time discounts on coveted designer brands so users never have to miss a sale.
• A Virtual Style Gallery showcasing the latest trends and fashions on the home screen in a slide show format. Users simply tap the picture of an item they like to search for similar items available on eBay’s Marketplace.
• A customized eBay account view from the fashion perspective through My eBay (Fashion), only displaying fashion listings to help users plan their wardrobe.
The mobile applications just keep on coming… Today, eBay announced the eBay Fashion app for the Apple iPhone, delivering a personalized shopping experience where shoppers can browse, buy—and virtually “try on”—items from the world’s largest online selection of new, designer, branded and vintage merchandise—virtually anytime, anywhere.
I’m going to download the app later today and test its ability to find pretentiously ironic t-shirts to add to my collection. In the meantime, here are some videos and a list of features highlighting the new app.
Cheers,
RBH
Features of the App include:
• A Personalized Closet allowing users to add, store and curate favorite fashion finds in one place.
• An Outfit Builder enabling users to mix and match items from their Closet and virtually try them on to create unique looks.
• Social Media Sharing functions enabling users to share favorite fashion finds via Facebook, Twitter, and email.
• Direct entry to the eBay Fashion Vault offering instant access to new, fixed price clothing, shoes and accessories at great value through exclusive, limited time discounts on coveted designer brands so users never have to miss a sale.
• A Virtual Style Gallery showcasing the latest trends and fashions on the home screen in a slide show format. Users simply tap the picture of an item they like to search for similar items available on eBay’s Marketplace.
• A customized eBay account view from the fashion perspective through My eBay (Fashion), only displaying fashion listings to help users plan their wardrobe.
All,
I’ve been working on a program behind the scenes here at eBay that I’m hoping will help promote all of the great online sellers that are embracing social media tools as a way to augment their presence online, ultimately promoting their stores and sales. It’s something that I’m hoping to build upon over the coming months so I’m launching with 6 “eBay Ink SM Sellers” while we iron out some of the potential kinks. I am excited to launch with the following 6, social media savvy individuals…
@ColderICE
@PowerSellingMom
@thesavvyseller
@galleriagifts
@auctionwally
@kats411
You can view the page by clicking HERE.
You can follow the eBay Ink Social Media Seller Twitter feed here: http://twitter.com/ebayinkblog/smsellers
I’m providing our SM Sellers with badges that they can put on their blogs, websites, etc. to drive traffic to their social media seller profiles and/or their ecommerce stores…
About the program:
The adoption of social media tools over the past 24 months has been unprecedented. It has given individuals the world over, the ability to create strong, impressive brands online that had been otherwise reserved for large companies and budgets. This has never been more evident than in the world of ecommerce. A large group of online sellers have embraced these new social tools to enhance their reach online and, ultimately, increase traffic to their online stores and content. It’s no surprise, really, social networking is part of eBay’s DNA. One could argue that the first online social network back in 1996 was the introduction of AuctionWeb/eBay.Over the past 2 years we’ve been seeing an emergence of individuals taking these social media tools to the next level and transferring their entrepreneurial instincts to the world of Twitter, Facebook, blogging and podcasting. As a result, I wanted to start highlighting some of these sellers here on Ink; ask them questions about how they got started; and see if they could share some of their tips and tricks. This list is by no means exhaustive and I intend to grow it regularly over the coming months and years. If you feel you should be considered as an eBay ink Social Media Seller, please contact us at <a href="mailto: ebayink@ebay.com">ebayink@ebay.com.
Let me know what you think and please let me know if you’re interested in joining the program.
Cheers!
RBH
I sat down with Todd Lutwak, VP of Seller Experience for eBay earlier today to talk about the initial feedback we’ve been hearing coming out of the third and final Seller Release of 2010. Here you go…
Cheers,
RBH
All,
eBay announced its third and final seller release for 2010 this morning. All updates are scheduled to launch the week of September 7 unless otherwise noted.
I sat down with Dinesh Lathi, VP of Buying and Selling Experience for eBay, while we were in Chicago for eBay: On Location to talk more about the updates coming in the Fall. Here you go…
From the AB post:
Stay on top with great value and service
• New shopping experience for iPod/MP3 players, GPS, and DVDs highlights great eBay values on these hot holiday products. Starting mid-September, listing with the eBay catalog will be required in these subcategories (Auction-style and Fixed Price, including Good ‘Til Cancelled). Pay no Insertion Fees when you list or relist with the catalog.
• eBay Listing Analytics application gives you new insight into how your listings are performing: impressions, clicks, sales.
• Bulk-edit more fields, revise up to 500 listings at once with new functionality in the eBay bulk edit and relist flow.
• Get your unpaid items re-listed and back in front of buyers fast with auto-relist option in Unpaid Item Assistant. Choose to exempt some customers from the automated process.
Shipping enhancements improve service, reduce buyer questions
• Industry-standard shipping terms —Economy, Standard, Expedited, and One-day—used to describe domestic shipping services. Shipping options displayed prominently along with estimated delivery time on the item page and in checkout.
• Shipping to Alaska and Hawaii, APO/FPO addresses, and special US areas such as Guam and Puerto Rico: Exclude these buyers or show exact charges based on their location.
• Pass on your shipping discounts to buyers with the Shipping Calculator: Specify one domestic and one international discount.
• Low-cost shipping insurance: Available exclusively with eBay label printing.
Streamline buyer communications
• Updates to reduce and manage buyer contacts: Ask a question link moved down on item page; Automated Answers turned on for all sellers.
• Enhancements to My Messages: Use it as your central inbox for buyer email with out-of-office reply, customized email signatures, and message filtering.
Complete details can be found HERE.
Cheers,
RBH
It was announced this morning that eBay will be one of the first customers of Microsoft’s new Windows Azure platform appliance for cloud computing. The announcement was made at the Microsoft Worldwide Partner Conference (WPC) taking place this week in Washington D.C.
According to the announcement, eBay will incorporate the Windows Azure platform appliance into two of its data centers. The goal being to further optimize its platform and achieve greater strategic agility and datacenter efficiency. The agreement comes on the heels of a a successful pilot deployment by eBay of Microsoft’s public Windows Azure platform – eBay’s page for iPad listings (http://ipad.ebay.com) is hosted on the public Windows Azure platform.
eBay VP of Technology, James Barrese, took the stage this morning at the WPC but I managed to catch up with him before eBay: On Location this past weekend and interviewed him about the news. We talked, among other things, about what cloud computing means for eBay and what it means for buyers and sellers in the online marketplace. Here you go…
Cheers!
RBH
All,
In addition to releasing the eBay application for Android internationally earlier today, eBay also announced the international release of the eBay Selling application and the eBay for iPad app. The Selling application is now available in Germany and the United Kingdom, and the eBay for iPad application is now translated into French, Italian, German and Spanish for international users and is currently available through all of Apple’s iTunes App Stores.
eBay has done an excellent job positioning itself as a leader in the mobile commerce market in a relatively short period of time. eBay launched its first mobile application for the iPhone in the Summer of 2008. In 2009, eBay generated over $600 million in GMV through its mobile platforms. eBay expects to generate over $1.5 billion in mobile GMV in 2010. Over half of eBay’s mobile GMV comes from international purchases. Here is a list of the eBay app portfolio:
** eBay Mobile App for iPhone
** eBay Mobile App for Android
** eBay Mobile App for Blackberry
** eBay for iPad
** eBay Classifieds App
** eBay Selling App
** eBay Deals App
** PayPal Mobile
** Shopping.com App
** StubHub App
Cheers,
RBH
The eBay Application for Android is now available in three additional countries: Australia, Canada and the United Kingdom. The new, updated app includes the ability for immediate checkout through PayPal, and voice search capabilities unique to the Android platform.
The free eBay application for Android includes features such as:
* Buyer alerts – Stay up to date on the status of auctions and watched items with timely alerts
* Daily Deals – View limited time bargains on popular items, where items are often more than 50% off the original price and include free shipping
* Feedback – Leave Feedback for items bought and sold within the application
* My eBay – Improved experience that includes an easier to use interface so sellers can quickly access listings, watched items, bids and sales
* Member Messages – Buyers and sellers can now receive and reply to messages and emails sent through My eBay. Ask a seller a question or reply to an inquiry or keep track of notifications directly through the app
* Sharing – Enabled with sharing functions so that buyers and seller can share items via Facebook, Twitter or email with friends and family
* Payments – PayPal account users can purchase items directly through the application
* View Sellers Other Items – View what other items a particular seller has to offer across eBay
* Voice search – In addition to type search, the eBay application comes enabled with speech-to-text voice search
The following was just posted over on the eBay AdCommerce blog:
In order to focus on the best selling and shopping experience, the specific AdCommerce program that allowed eBay sellers to purchase pay-per-click advertisements on search result pages linking to their eBay stores and listings will be retired for eBay.com and eBay.ca as of August 4, 2010. The service will continue for eBay sellers using AdCommerce in Europe and Australia.
According to the blog post, those that have recently purchased AdCommerce ads for their store or listings don’t need to do anything at this time because the placements they’ve already purchased to appear on these sites will automatically expire on August 4 with final billing to be sent out in early September.
The AdCommerce team is in the process of proactively contacting sellers involved in the program via email and phone call.
The full AdCommerce blog post can be read here.
Cheers,
RBH
Bill Zielke, senior director of merchant services for PayPal, has an interesting post over on the PayPal blog talking about mobile payments – specifically PayPal Mobile Express Checkout – a mobile version of PayPal’s Express Checkout service that allows merchants to offer the PayPal experience to their on-the-go customers.
We are in the early stages with Mobile Express Checkout, and it’s being initially rolled out on the iPhone and Android 2.0 (and higher) devices by a few innovative retailers, including Nike and Buy.com, over the next few weeks. Jeff Wisot, vice president of marketing at Buy.com shared a few words about Mobile Express Checkout recently saying, “We’re seeing a huge opportunity in mobile commerce right now. PayPal’s Mobile Express Checkout will allow us to enhance the convenient shopping experience for on-the-go customers.”
Mobile Express Checkout will be available for the rest of our merchants later this summer. Here are just a few of the features it will include:
* One-stop payment service that allows merchants to sell to millions of mobile shoppers
* Quick deployment and integration to get merchants in the mobile game fast
* A seamless customer experience which is especially important with smaller screens and keyboards – no cumbersome data entry, just a few clicks and customers are done
* Strong fraud detection
Check out the full blog post here and keep an eye out for developments over the coming months.
Cheers!
RBH
The free eBay Application for BlackBerry smartphones is immediately available on BlackBerry App World in six more countries: Australia, France, Germany, Italy, Spain and the United Kingdom. The application is also now officially available to North American BlackBerry smartphone users after a successful beta preview period.
I haven’t had a chance to play with the app myself but for those of you who have, I’d love to find out what you think.
In the meantime, here is a video demo of the app in action.
Cheers!
RBH
It has been 3 years since eBay Classifieds launched in the U.S. and to mark the occasion they’ve launched their own blog. Good stuff! Here are some fun stats listed from today’s blog entry…
• Three years ago we had just a couple hundred thousand visitors. Today we have over 5 million. What a birthday party!
• We started out with just a few thousand ads back in 2007, now we have nearly 1 million. Keep them coming!
• Did you know that the frilled shark has a gestation period of 3.5 years? It’s been three years for eBay Classifieds and we’re already generating over 50 million page views a month. Take that, frilled shark!
They’re just getting started with the blog so please add them to your subscriptions. The blog can be found at http://blog.ebayclassifieds.com/.
Also, if you’re not following them already, you should add @eBayClassifieds to your Twitter feed.
Cheers!
RBH