|
 |
 |
 |
Importing and Exporting Records
|
|
|
 |
 |
What is "CSV"?
What is a CSV "import" or "export"?
How do I create a CSV file?
How do I export items to CSV format from Turbo Lister?
How do I import items from CSV format into Turbo Lister?
Why does Turbo Lister support importing and exporting items in CSV format?
What is the Turbo Lister CSV format? (advanced users only)
What is "CSV"?
"CSV" stands for Comma Separated Values. It is a text-only format used to store data, often used with spreadsheet or database software. In a CSV file, "fields" of data are separated by commas. This allows programs to re-create the correct field structure for the data by reading through the file and starting a new field every time a comma is encountered. Here is a simple example of a CSV file: "This is my item title,1234,This is my item description" Read into a spreadsheet program or similar, the example above would result in three data fields with the following values:
This is my item title
1234
This is my item description
What is a CSV "import" or "export"?
"Importing" a CSV file refers to a program reading a CSV file and entering the data into its own storage. "Exporting" a CSV file refers to a program taking data that it has stored and creating a new file that contains the data in CSV format.
How do I create a CSV file?
There are many ways to create a CSV file. The most common is to use a spreadsheet program such as Microsoft Excel. (In Microsoft Excel, just select File > Save As..., then select "CSV (comma delimited) (*.csv)" in the "Save As Type" drop-down selector.)
How do I export items to CSV format from Turbo Lister?
To create a CSV file containing items that are in your Turbo Lister program, just select the items you'd like to export, then select File > Export Selected Items. You'll then be prompted to name your new CSV file.
How do I import items from CSV format into Turbo Lister?
To import a CSV file into Turbo Lister, first make sure that the file has the correct set of columns that Turbo Lister will be looking for (see below). Then select File > Import items > From.... Then select the file you'd like to import.
To import listings directly from eBay simply select File > Import items > From eBay Listings… Then select to import Active and/or Ended listings. Once your listings are imported, you can edit or list the item again to eBay.
Why does Turbo Lister support importing and exporting items in CSV format?
Many sellers have their listing information stored in spreadsheet or database programs. This feature will help those sellers get their listing information into the Turbo Lister program much easier than cutting-and-pasting or entering by hand. This feature will also allow all users to transfer listings between separate installations of Turbo Lister, or even between users in the same installation. For example, if you want to transfer your listings from your Turbo Lister program at home to your Turbo Lister program at work: Just export the listings to a CSV file, email the file to your other computer, and import the file into the other Turbo Lister program.
What is the Turbo Lister CSV format? (advanced users only)
If you'd like to create your own CSV files to import into Turbo Lister, the correct columns to put in your CSV file are listed below. You must make sure that your CSV file contains the specified columns to ensure that the file will be able to be successfully imported into Turbo Lister. (Note: The easiest way to get an example template for your CSV files is to create an item in Turbo Lister and export it to CSV format. The resulting file can serve as a CSV "template" for you.)
- For the Boolean fields listed below, 1 = "on" or "yes", and 0 = "off" or "no"
- Fields 69-77 are applicable to Sothebys.com listings only
- Fields 78-79, 90-93 are applicable to eBay Motors US listings only
- Fields 80-89 are not currently used.
Other tips:
- Any field containing a comma or a double-quote character must be surrounded by double-quotes. (To specify a double-quote character within the field, you must enter two double-quote characters. Example: "He said, ""Goodbye"", then he left.")
- Newline characters should be replaced with %0a in text fields (Description).
Note: Creating CSV files "from scratch" is for advanced users only - we recommend that most users create items with the user interface provided by Turbo Lister.
|
Field Number
|
Field Name
|
Values
|
1
|
Site
|
- eBay US = 0
- eBay Canada = 2
- eBay UK = 3
- eBay Australia = 15
- eBay Belgium (French) = 23
- eBay France = 71
- eBay Germany = 77
- eBay Italy = 101
- eBay Belgium (Dutch) = 123
- eBay Netherlands = 146
- eBay Spain = 186
- eBay Taiwan = 196
|
2
|
Format
|
- Auction = 1
- Dutch Auction = 2
- Live Auctions = 5
- Ad Format = 6
- Store Inventory = 7
- Fixed Price = 9
|
3
|
Currency
|
- US $ = 1
- C $ = 2
- GBP = 3
- AU $ = 5
- EUR = 7
- NT $ = 41
|
4
|
Title
|
Text
|
5
|
Description
|
Text
|
6
|
Category 1
|
Category ID
|
7
|
Category 2
|
Category ID
|
8
|
Store Category
|
Store Category Number
|
9
|
Pic URL
|
URL
|
10
|
Quantity
|
Integer
|
11
|
Duration
|
[3, 5, 7, 10, 20, 30, 60, 90, 120]
|
12
|
Starting Price
|
Currency amount
|
13
|
Reserve Price
|
Currency amount
|
14
|
BIN Price
|
Currency amount
|
15
|
Private Auction
|
[0, 1]
|
16
|
Counter
|
- No counter = 0
- Honesty-style = 1
- Green LED = 2
- Hidden = 3
|
17
|
Buyer pays shipping
|
[0, 1]
|
18
|
Seller pays shipping
|
[0, 1]
|
19
|
Payment Instructions
|
Text
|
20
|
Specifying Shipping Costs
|
[0, 1]
This must be set to "1" if you are specifying values for many of the following fields (e.g. Shipping & Handling).
|
21
|
Shipping & Handling
|
Currency amount
|
22
|
Additional Shipping
|
Currency amount
|
23
|
Insurance Option
|
- No counter = 0
- Optional = 1
- Required = 2
- Insurance incl. in S&H = 3
|
24
|
Insurance Amount
|
Currency amount
|
25
|
Sales Tax Amount
|
Currency amount
|
26
|
Sales Tax State
|
State abbreviation
|
27
|
Apply tax to total
|
[0, 1]
|
28
|
Accept PayPal
|
[0, 1]
|
29
|
PayPal Email Address
|
Text (email address)
|
30
|
Accept MO Cashiers
|
[0, 1]
|
31
|
Accept Personal Check
|
[0, 1]
|
32
|
Accept Visa/Mastercard
|
[0, 1]
|
33
|
Accept AmEx
|
[0, 1]
|
34
|
Accept Discover
|
[0, 1]
|
35
|
Accept Payment Other
|
[0, 1]
|
36
|
Accept Payment Other Online
|
[0, 1]
|
37
|
Accept COD
|
[0, 1]
|
38
|
Payment See Description
|
[0, 1]
|
39
|
Accept Money Xfer
|
[0, 1]
|
40
|
CCAccepted
|
[0, 1]
|
41
|
CashOnPickupAccepted
|
[0, 1]
|
42
|
MoneyXferAccepted
|
[0, 1]
|
43
|
MoneyXferAcceptedinCheckout
|
[0, 1]
|
44
|
Ship-To Option
|
- SiteOnly
- WorldWide
- SitePlusRegions
- WillNotShip
(if "SitePlusRegions" is specified, at least one of the following 9 fields must be "1")
|
45
|
Ship-To Africa
|
[0, 1]
|
46
|
Ship-To Asia
|
[0, 1]
|
47
|
Ship-To Caribbean
|
[0, 1]
|
48
|
Ship-To Europe
|
[0, 1]
|
49
|
Ship-To Latin America
|
[0, 1]
|
50
|
Ship-To Middle East
|
[0, 1]
|
51
|
Ship-To North America
|
[0, 1]
|
52
|
Ship-To Oceania
|
[0, 1]
|
53
|
Ship-To South America
|
[0, 1]
|
54
|
Escrow Buyer
|
[0, 1]
|
55
|
Escrow Seller
|
[0, 1]
|
56
|
BuyerPaysFixed
|
[0, 1]
|
57
|
Location - City/State
|
Text
|
58
|
Location - Region
|
Country-specific code - There are a lot of these, so we recommend you find out which code you need by exporting an item with that region selected. (e.g. San Francisco = 49)
|
59
|
Location - Country or Region
|
Country-specific abbreviation - There are a lot of these, so we recommend you find out which code you need by exporting an item with that country selected. (e.g. United States = "US")
|
60
|
Title Bar Image
|
[0, 1]
|
61
|
Gallery
|
[0, 1]
|
62
|
Gallery Featured
|
[0, 1]
|
63
|
Gallery URL
|
URL
|
64
|
Bold
|
[0, 1]
|
65
|
Highlight
|
[0, 1]
|
66
|
Featured Plus
|
[0, 1]
|
67
|
Home Page Featured
|
[0, 1]
|
68
|
Gift Icon
|
[0, 1]
|
69
|
EstimateLow
|
Currency amount
|
70
|
EstimateHigh
|
Currency amount
|
71
|
ItemNotes
|
Text
|
72
|
Condition
|
Text
|
73
|
Measurements
|
Text
|
74
|
NumItems
|
Text
|
75
|
ShippingNotes
|
Text
|
76
|
InventoryNumber
|
Text
|
77
|
AuctionCode
|
Text
|
78
|
DepositType
|
- No deposit = 0
- Other method = 1
- Fast deposit = 2
|
79
|
DepositAmount
|
Currency amount
|
80
|
ShippingRate
|
Currently not used
|
81
|
ShippingCarrier
|
Currently not used
|
82
|
ShippingType
|
1 = Flat shipping rates
2 = Calculated shipping rates
|
83
|
ShippingService
|
USPS Priority Mail = 7
USPS Parcel Post = 8
USPS Media Mail = 9
USPS First Class Mail = 10
UPS Ground = 3
UPS 3-Day Select = 4
UPS 2nd Day Air = 5
UPS Next Day Air Saver = 6
|
84
|
ShippingPackage
|
Letter = 1
Large Envelope = 2
USPS Flat Rate Envelope = 3
UPS Letter = 7
Package/Thick Envelope = 4
Large Package/Oversize 1 = 5
Very Large Package/Oversize 2 = 6
|
85
|
ShippingIrregular
|
0 = Standard, 1 = Irregular/Not Standard
|
86
|
ShippingWeightUnit
|
1 (always)
|
87
|
WeightMajor
|
Integer
|
88
|
WeightMinor
|
Integer
|
89
|
ShipFromZipCode
|
A ZIP code
|
90
|
PackagingHandlingCosts
|
Currency amount
|
91
|
Year
|
The year of the vehicle the part fits.
|
92
|
MakeCode
|
There are many possible values. We recommend that you find out what code you need by exporting an item with that vehicle make selected.
|
93
|
ModelCode
|
There are many possible values. We recommend that you find out what code you need by exporting an item with that vehicle model selected.
|
94
|
EngineCode
|
There are many possible values. We recommend that you find out what code you need by exporting an item with that vehicle engine selected.
|
95
|
ThemeId
|
There are many possible values. We recommend that you find out what ThemeId you need by selecting an item with the desired theme selected.
|
96
|
LayoutId
|
There are several possible values. We recommend that you find out what LayoutId you need by selecting an item with the desired layout selected.
|
97
|
AutoPay
|
0 = Disabled, 1 = Enabled
|
98
|
Apply Multi-item Shipping Discount
|
0 = Disabled, 1 = Enabled
|
|
|
 |
|