Help
Help
Search the Help pages (Does not search for items or products) Search Help Pagestips

CSV File Specifications for Uploading Inventory Data

You can import your inventory data efficiently into Selling Manager Pro with our Import from Comma Separated Value (CSV) file feature.. You can download the eBay CSV template data, complete it according to the CSV File Specifications for Inventory Data Table , then upload it into Selling Manager Pro's product inventory section.

Importing a File into Selling Manager Pro
  • When Selling Manager Pro reads the CSV file and imports it into the product inventory, a confirmation message appears. If there's a problem, you will receive an email with a detailed error message so that you can try to import again. Selling Manager Pro creates a file activity report including information about both successful and unsuccessful file imports.

  • You can upload a CSV file that's up to 15MB in size.

  • Uploading works best on files containing less than 450 templates.

  • If you already have product data in another program, you can transfer this data to Selling Manager Pro using a CSV template.
To upload your product inventory:

  1. Click the "File Management Centre" under the Seller Tools section.

  2. Click the "Upload Inventory" link and download the eBay Inventory Template.

  3. Fill in the template with the required fields. These include fields for Site ID, Selling format, Title, Description, Category, Quantity, Duration, and Location. (For information on specific format and fields, see CSV File Specifications for Inventory Data Table.

    Important: To ensure acceptance of your inventory, do not change the template format.

  4. Save the template containing all your new or modified inventory, in .csv format.

  5. Click Browse to select the file you saved, or enter the file path.

  6. Click Upload Inventory button.

    Note: It can take 30 minutes or more to process your upload. You can check on the progress by clicking on the "File Management Centre" link located in the left hand navigation bar. On the File Management Centre page under the Uploads section, click the "File Activity" link.
CSV File Specifications for Inventory Data
  • Items in Red and marked with an * are the 10 required fields in the CSV file.
  • Items in Green and marked with a + have some special information for their use.
  • Items in Gray and are marked with a ~ are invalid, but may be usable in the future. Do not delete these columns, but you do not need to enter any data for them.
  • Items in Black and have no marking are optional.
  • Troubleshooting Tip: If you encounter errors during your upload of your inventory data, it may help to leave optional fields blank and enter only required fields.

CSV Column

Type

Description / Valid Values

Site*

Whole Number

Enter the number for the correct format below:

ID

Country Name

0

United States

2

Canada

3

United kingdom

15

Australia

16

Austria

23

Belgium (French)

71

France

77

Germany

100

eBay Motors

101

Italy

123

Belgium (Dutch)

146

Netherlands

186

Spain

193

Switzerland

196

Taiwan

223

China

216

Singapore


Format*

Whole Number

Enter the ID in the correct format below:

ID

Format

1

Auction

7

Inventory

9

Fixed Price


Currency*

Whole Number

Enter the ID for the correct site using the table below:

ID

Site(s)

Currency Name

1

0

US Dollar

2

2

Canadian Dollar

3

3

UK Pound Sterling

5

15

Australian Dollar

7

16, 23, 71, 77,101, 123, 146, 186

Euro

13

193

Swiss Franc

41

196

Taiwanese Dollar


Title*

Text

Title of the item being placed up for auction.
No HTML is allowed.
Maximum length: 55 characters

SubtitleText

Text

Optional to use in addition to the title.
Provides more keywords when buyers search in titles and descriptions and more information on the View Item page.
No HTML is allowed.
If you pass any value, this feature is applied (with applicable fees).
Maximum length: 55 characters

Note

Text

Maximum length: 495 characters

Description*

Text

Description of the item.

HTML is okay, but use quotation marks to enclose the text and remove all line feed characters. If there are quotes in the description text, replace them with a set of double quotes. For example: "Quotes" would be entered as ""Quotes"".

Maximum length: 500,000 characters

Category 1*

Whole Number

The main category in which the item is listed on eBay

Maximum length: 10 characters

Category 2

Whole Number

Optional second category in which the item is listed on eBay (doubles the insertion fee for the item)

Not available for Store inventory listings.

Maximum length: 10 characters

Store Category

Whole Number

Custom categories for subdividing the items within an eBay Store. Store owners can create up to 19 custom categories for their Stores. (One additional Store category cannot be customised and retains the value of "Other"). If specified, it must be a number between 0 and 20. If you specify an invalid value (e.g., 21), the system resets the value to 1 (Other).

ID

Custom Category Name

0

Not an eBay Store Item

1

Other

2

Category 1

3

Category 2

...

...

...

...

19

Category 18

20

Category 19


PicURL

URL

URL for the first image.
Maximum length: 1025 characters

Quantity*

Whole Number

Number of items being sold in the listing.
Must be greater than 0.

Duration*

Whole Number

Number of days the auction will be active. Only certain values are allowed, and the choice of values depends on the listing type (see tables below).
Maximum length: 3 characters

Listing type

ID

Valid durations

Auction

1

1, 3, 5, 7, 10

Store Item

7

30, 60, 90, 120, GTC (30,90, GTC for international sites)

Fixed Price

9

3, 5, 7, 10


Starting Price*

Currency
Number

For auction listings, this is the minimum acceptable bid for the item. For fixed price or Store item listings, this is the fixed price at which the seller is selling the item. Only numbers in standard money format (0.00) are accepted. No special characters or letters are allowed.

Maximum length: 16 total characters

Reserve Price

Currency
Number

For Auction format listings only, this is the minimum price at which the seller is willing to sell the item. (The Reserve Price must be higher than the Starting Price.) The Reserve Price is also not supported in all categories.

Maximum length: 16 total characters

BIN Price

Currency
Number

For auction format (1) only, Buy It Now (BIN) lets a user instantly purchase the item at a set price and end the auction. A seller must have a positive feedback rating of 10 or more to use Buy It Now. Additional fee applies. Not available for Fixed Price (7) or Store (9) format listings.

Maximum length: 16 total characters

Private Auction

Yes/No

Designates the listing as a private auction (if a value of 1 is specified). The list of bidders on private auctions is hidden when the active listing is viewed. Not applicable to Fixed-Price or Store format listings (Formats 7 and 9).

Counter

Whole Number


ID

Counter Style

0

No hit counter

1

Honesty style

2

Green LED

3

Hidden


Payment
Instructions

Text

Your instructions to the buyer, such as your payment terms and return policy.

Maximum length: 500 characters

Specifying Postage Costs

Yes/No

Nothing entered yet

Insurance Option

Whole Number

View Turbo Lister CSV page for valid entries.

Insurance Amount

Currency
Number

No information entered yet

Sales Tax Amount

Percentage Number

No information entered yet

Sales Tax State

Text

No information entered yet

Apply tax to total

Yes/No

No information entered yet

Accept PayPal

Yes/No

Indicates if you accept PayPal payments. If this is set to yes, you need to also specify an email address in the "PayPal email address" field.

PayPal Email
Address

Email Address

If the "Accept PayPal" field is set to yes, this field is required.

Accept MO
Cashiers

Yes/No

Indicates if you accept Money Order/Cashiers cheque payments.

Accept Personal Check

Yes/No

Indicates if you accept Personal cheque payments.

Accept Visa/Mastercard

Yes/No

Indicates if you accept Merchant Visa or Mastercard payments. Not available for all eBay sites.

Accept AmEx

Yes/No

Indicates if you accept Merchant American Express payments.

Accept Discover

Yes/No

Indicates if you accept Merchant Discover card payments. Not available for all eBay sites.

Accept COD

Yes/No

Indicates if you accept COD payments. Not available for all eBay sites.

Payment See Description

Yes/No

No information entered yet

Accept Money Xfer

Yes/No

Indicates if you accept Money Transfer payments. Not available for all eBay sites.

MoneyXferAccepted
inCheckout

Yes/No

Indicates if you accept Money Transfer payments through eBay Checkout. Must have Checkout enabled and valid Checking account information on file, or this will be ignored. Not available for all eBay sites.

Post-To Option

Code Name

Currently only supports these two options: SiteOnly or WorldWide

Location -
City/State*

Text

Indicates the geographical location of the item. Not applicable for the eBay China site (site ID 223).

Maximum length: 45 characters

Location - Region~

N/A

~

Location - Country*

Text

Two letter abbreviation for the country in which the seller is located.

Maximum length: 2 characters

Gallery

Yes/No

Listing upgrade that adds your item to the Gallery. (Additional fee applies.)

Gallery Plus

Yes/No

Listing upgrade that causes your item to include a larger popup picture in Gallery. (Additional fee applies.)

Featured First

Yes/No

Listing upgrade that causes your item to be featured in the Gallery. (Additional fee applies.) Not applicable to eBay Stores Inventory (7) items.

Gallery URL

URL

URL of a picture for the gallery. If a URL is specified and Gallery and GalleryFeatured are set to No (0), the item will still be listed in the Gallery (with the associated fee).

PicInDesc+

Yes/No

This field isn't valid. However, if you have an image in your description, and you would like to have the camera icon that appears in search results for your item, you can enter the following blank URL in the PicURL field:

http://pics.ebay.com.sg/aw/pics/dot_clear.gif

Bold

Yes/No

Listing Upgrade to have your item's title displayed in boldface font in search results. Doesn't apply to the item subtitle (SubtitleText), if any is specified. (Additional fee applies.)

Highlight

Yes/No

Listing Upgrade to have your item highlighted in search results. (Additional fee applies.)

Featured Plus

Yes/No

Listing Upgrade to have your item appear at the top of item listings for a category. Only available to accounts with Feedback ratings of 10 or greater. Not applicable to eBay Stores Inventory (7) items. (Additional fee applies.)

Home Page
Featured

Yes/No

Listing Upgrade to have your item appear on the eBay homepage and at the top of item listings for a category. Only available to accounts with Feedback ratings of 10 or greater. Not applicable to eBay Stores Inventory (7) items. (Additional fee applies.)

PostageType

Whole Number

View Turbo Lister CSV page for valid entries

PostagePackage

Whole Number

Required if ShippingType = 2 (Calculated). View Turbo Lister CSV page for valid entries.

PostageIrregular

Yes/No

Specifies if your package isn't within the regular limits for your selected shipping service.

PostageWeightUnit

Whole Number

This field is always 1.

WeightMajor

Whole Number

Required if ShippingType = 2 (Calculated).

WeightMinor

Whole Number

Required if ShippingType = 2 (Calculated).

Package Length

Whole Number

Required if ShippingIrregular = 1 and for some shipping services.

Package Width

Whole Number

Required if ShippingIrregular = 1 and for some shipping services.

Package Depth

Whole Number

Required if ShippingIrregular = 1 and for some shipping services.

PostFromPostCode

Post Code

Required if ShippingType = 2 (Calculated).

PackagingHandling
Costs

Currency
Number

Optional additional shipping cost for calculated shipping. Valid only if ShippingType = 2 (Calculated).

ThemeId~

N/A

~

LayoutId~

N/A

~

AutoPay

Yes/No

If true, immediate payment through PayPal is required for Buy It Now purchases. Accept PayPal must also be true. If format is auction, a Buy It Now price must be entered as well.

Apply Multi-item Postage Discount

Yes/No

Allows this purchase to be combined with other items a buyer may purchase.

Attributes~

N/A

~

ShippingServiceOptions+

Base64

This field requires special XML tags encoded in Base64. This should be left blank, but you can create an item in Turbo Lister and enter your postage costs. Then, export the item from Turbo Lister to a CSV file. You can then copy the encoded postage information from the PostageServiceOptions field in Turbo Lister to this field.

SMPFolderName

Text

Name of a folder in Selling Manager Pro inventory to place the item in.

SMPUnitCost

Currency
Number

The average unit cost of the item. This is only used in Selling Manager Pro inventory and is not shown to bidders.

SMPPartNumber

Text

Part number for the item. This number is only used in Selling Manager Pro inventory and is not shown to bidders.

SMPQuantity

Whole Number

The number of this item you have on hand to sell. This number is only used in Selling Manager Pro inventory and is not shown to bidders.
Related Help topics

Contact Customer Service

If you have an additional question about this subject, email us at Customer Service.
If you would like to ask a question on another subject, please use the Contact Us page.

Contact us

Have a question? We can help.

 Contact us

Ask eBay members

Get help from other eBay members. Visit the Answer Centre to post a question.