| | | | Choose A Topic | | | Welcome Turbo Lister • FAQ • Top Tips • Troubleshooting •Exporting/ Importing Records Selling Director Products • Selling Managing director • Selling Manager Pro Blackthorne Products Tool Recommendations Featured Customer Characteristic Comparing Table | | | | | | | | | 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 practice 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 information are separated by commas. This allows programs to re-create the correct field structure for the information by reading through the file and starting a new field every time a comma is encountered. Hither is a elementary case of a CSV file: "This is my detail title,1234,This is my item clarification" Read into a spreadsheet programme or like, the example above would outcome in three data fields with the following values: This is my item championship 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 information technology has stored and creating a new file that contains the data in CSV format. How practice I create a CSV file? In that location are many means to create a CSV file. The most common is to use a spreadsheet program such as Microsoft Excel. (In Microsoft Excel, simply select File > Salvage As..., then select "CSV (comma delimited) (*.csv)" in the "Salvage As Type" drop-downward selector.) How exercise 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 yous'd similar to export, so select File > Export Selected Items. You'll then exist prompted to proper name your new CSV file. How do I import items from CSV format into Turbo Lister? To import a CSV file into Turbo Lister, starting time make sure that the file has the correct gear up of columns that Turbo Lister will be looking for (see below). Then select File > Import items > From.... So select the file you'd like to import. To import listings directly from eBay simply select File > Import items > From eBay Listings… And so select to import Active and/or Ended listings. In one case your listings are imported, you tin edit or list the particular once 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 characteristic will help those sellers get their list information into the Turbo Lister program much easier than cut-and-pasting or inbound by hand. This characteristic will also allow all users to transfer listings between split up 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 consign the listings to a CSV file, email the file to your other computer, and import the file into the other Turbo Lister programme. What is the Turbo Lister CSV format? (advanced users but) If you lot'd similar to create your ain CSV files to import into Turbo Lister, the correct columns to put in your CSV file are listed beneath. You must make certain 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 y'all.) - 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 inside the field, you must enter two double-quote characters. Example: "He said, ""Cheerio"", then he left.")
- Newline characters should be replaced with %0a in text fields (Description).
Note: Creating CSV files "from scratch" is for advanced users just - we recommend that nearly users create items with the user interface provided past Turbo Lister. | Field Number | Field Proper noun | Values | 1 | Site | - eBay US = 0
- eBay Canada = 2
- eBay U.k. = 3
- eBay Australia = 15
- eBay Belgium (French) = 23
- eBay French republic = 71
- eBay Germany = 77
- eBay Italia = 101
- eBay Belgium (Dutch) = 123
- eBay Netherlands = 146
- eBay Kingdom of spain = 186
- eBay Taiwan = 196
| 2 | Format | - Auction = one
- Dutch Auction = 2
- Live Auctions = 5
- Advertising Format = 6
- Store Inventory = seven
- Stock-still Toll = 9
| iii | Currency | - Usa $ = 1
- C $ = two
- GBP = three
- AU $ = 5
- EUR = 7
- NT $ = 41
| 4 | Championship | Text | v | Clarification | Text | six | Category ane | Category ID | 7 | Category 2 | Category ID | viii | Shop Category | Store Category Number | ix | Film URL | URL | ten | Quantity | Integer | 11 | Duration | [3, 5, seven, 10, xx, xxx, 60, xc, 120] | 12 | Starting Price | Currency amount | 13 | Reserve Price | Currency corporeality | 14 | BIN Toll | Currency amount | fifteen | Individual Auction | [0, 1] | 16 | Counter | - No counter = 0
- Honesty-fashion = 1
- Green LED = 2
- Subconscious = 3
| 17 | Buyer pays aircraft | [0, 1] | 18 | Seller pays shipping | [0, 1] | 19 | Payment Instructions | Text | twenty | Specifying Aircraft Costs | [0, 1] This must be set to "1" if you are specifying values for many of the following fields (east.g. Shipping & Handling). | 21 | Shipping & Treatment | Currency amount | 22 | Additional Shipping | Currency amount | 23 | Insurance Option | - No counter = 0
- Optional = 1
- Required = 2
- Insurance incl. in Southward&H = 3
| 24 | Insurance Amount | Currency amount | 25 | Sales Revenue enhancement Amount | Currency amount | 26 | Sales Revenue enhancement State | State abridgement | 27 | Apply tax to total | [0, 1] | 28 | Take PayPal | [0, 1] | 29 | PayPal Email Accost | Text (email address) | thirty | Accept MO Cashiers | [0, 1] | 31 | Accept Personal Cheque | [0, 1] | 32 | Have Visa/Mastercard | [0, 1] | 33 | Accept AmEx | [0, 1] | 34 | Accept Discover | [0, one] | 35 | Have Payment Other | [0, 1] | 36 | Accept Payment Other Online | [0, 1] | 37 | Accept COD | [0, 1] | 38 | Payment Run into Clarification | [0, 1] | 39 | Accept Money Xfer | [0, 1] | 40 | CCAccepted | [0, one] | 41 | CashOnPickupAccepted | [0, 1] | 42 | MoneyXferAccepted | [0, 1] | 43 | MoneyXferAcceptedinCheckout | [0, i] | 44 | Transport-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, ane] | 46 | Ship-To Asia | [0, ane] | 47 | Ship-To Caribbean | [0, 1] | 48 | Ship-To Europe | [0, 1] | 49 | Ship-To Latin America | [0, one] | 50 | Ship-To Center East | [0, 1] | 51 | Ship-To N America | [0, i] | 52 | Ship-To Oceania | [0, 1] | 53 | Ship-To South America | [0, 1] | 54 | Escrow Buyer | [0, ane] | 55 | Escrow Seller | [0, 1] | 56 | BuyerPaysFixed | [0, ane] | 57 | Location - City/Land | Text | 58 | Location - Region | Country-specific code - There are a lot of these, then we recommend you find out which code yous demand by exporting an item with that region selected. (e.g. San Francisco = 49) | 59 | Location - Country or Region | State-specific abbreviation - There are a lot of these, then we recommend you lot find out which code you need past exporting an particular with that country selected. (eastward.m. United states = "US") | 60 | Championship Bar Paradigm | [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, i] | 67 | Home Page Featured | [0, ane] | 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 eolith = 0
- Other method = i
- Fast deposit = 2
| 79 | DepositAmount | Currency amount | 80 | ShippingRate | Currently non used | 81 | ShippingCarrier | Currently not used | 82 | ShippingType | ane = Flat shipping rates 2 = Calculated aircraft rates | 83 | ShippingService | USPS Priority Mail service = 7 USPS Parcel Postal service = 8 USPS Media Mail = 9 USPS Beginning Course Post = x UPS Ground = 3 UPS 3-Twenty-four hour period Select = 4 UPS 2nd Day Air = 5 UPS Side by side Twenty-four hours Air Saver = 6 | 84 | ShippingPackage | Letter = 1 Large Envelope = 2 USPS Flat Charge per unit Envelope = 3 UPS Alphabetic character = vii Packet/Thick Envelope = 4 Big Packet/Oversize ane = 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 twelvemonth of the vehicle the part fits. | 92 | MakeCode | There are many possible values. We recommend that you find out what lawmaking you need by exporting an particular with that vehicle make selected. | 93 | ModelCode | In that location are many possible values. We recommend that you find out what code yous demand by exporting an item with that vehicle model selected. | 94 | EngineCode | There are many possible values. We recommend that y'all discover out what code yous need past exporting an item with that vehicle engine selected. | 95 | ThemeId | At that place are many possible values. We recommend that you find out what ThemeId y'all need by selecting an item with the desired theme selected. | 96 | LayoutId | There are several possible values. Nosotros recommend that you find out what LayoutId you demand by selecting an particular with the desired layout selected. | 97 | AutoPay | 0 = Disabled, one = Enabled | 98 | Apply Multi-item Aircraft Discount | 0 = Disabled, 1 = Enabled | | | | |
0 Response to "How To Upload File On Ebay"
Post a Comment