O'Reilly logo

eBay Hacks, 2nd Edition by David A. Karp

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hack #114. List Your Entire Inventory on eBay

Tie your inventory database into a custom eBay listing-creation tool and create listings for all your products automatically.

As a seller on eBay, one of the most time-consuming tasks is to create new listings. If you already have a product database for your business, you can create a tool to convert individual products into eBay listings.

For this to work, your database will need several fields that look something like the following:

Table 8-1. 

Field name

Type

Description

ID

Number (int)

A unique number for each record (product) in your database

Name

Text (20-char max)

The name of the product, to be used as the first part of the listing title (e.g., "Acme Hy-7713")

Synopsis

Text (30-char max)

A very brief description of the product, to be used as the second part of the listing title (e.g., "7 Quart Mixer")

Long description

Text

What will eventually become the heart of your listing description (e.g., "This is one of the best mixers…")

Sale price

Number

The dollar amount to be used as the Buy It Now price for fixed-price listings

Shipping

Number

The amount to charge for fixed-price shipping

Category

Number (int)

The eBay category number [Hack #13] in which to list the item

Quantity

Number (int)

The number of products you have in stock (or on hand), used to ensure that your program won't list any products you're not able to ship right away

Sell on eBay

Boolean

A checkbox that, when checked, indicates that you want this particular item listed on eBay

Naturally, your ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required