Home » Categories » Multiple Categories

What listing information can I import and export?

By using the 'Bulk Import' feature you can quickly create new progfiles or update existing ones, dramatically cutting down the time to having you looking more professional on eBay! Existing profile information can also be made available to other software by using the 'Bulk Export' feature.

Profile information is imported and exported via CSV or TSV files. The format of which is explain in detail further on in this article.

The software will take care of generating the file when exporting but you will have to construct it yourself when importing. The points below need to be considered when creating the import file.

  • The first line of the file must be a tab or comma separated list of field names. These can be in any order but must be from the valid names as shown below. The software will use this line to determine which information is been imported and an error will occur if it is missing.
  • yo
  • Each line in the file contains the information for a new or existing profile.
  • Not all fields are required when importing. Exclude fields that you do not wish to update.
    For example, If you only wish to update the 'Buy It Now Price' of existing profiles you do not need to include any other fields.
  • You can use the import to update existing profiles by specifing an existing name in the profile_name field.

To help with creating your import file we have created a template that you can download. This file can be opened in a spreadsheet and provides information on what can be imported.

A detailed list of the available fields that can be imported or exported is shown below.

Name: profile_name
Required: Yes
Value: Text
Description: You may specify an existing profile name. By default the import will not update an existing listing profile with the same name. You may use the options in the 'Duplicate Listing Profiles' field, on the upload form, to determine what should happen in this situation.
If updating an existing profile you may leave any optional fields in the file empty. This will allow you to selectively modifiy the fields of a profile as the import will not overwrite existing values with empty ones.
Max Length: 70
Example: Organic Body Lotion
Name: relationship
relationship_details
Required: Optional
Value: Text
Description: Used for rows that form a hierarchical relationship with rows that describe a profile. These fields describe the relationship between the row and the parent profile. A typical example would be parts compatibility information.
For profiles these fields can be left blank.
More information on the use of these fields can be found at the following URLs
Importing Multi-variations
Importing Item Specifics
Importing Parts compatibilities for eBay Motors
Importing Parts compatibilities for UK Motors
Importing Parts compatibilities for US motorcycles
Importing Parts compatibilities for Australia Motors
Example: compatibility
Name: title
Required: Conditional
If you are updating an existing listing profile then this field is Optional otherwise it is Required.
Value: Text
Description: This will be the title of your listing on eBay. Use words that potential buyers would enter in a search.
Max Length: 80
Example: Organic Body Lotion
Name: subtitle
Required: Optional
Value: Text
Description: Subtitle to use in addition to the title. Provides more keywords when buyers search in titles and descriptions. If you pass any value, this feature is applied (fees apply).
Max Length: 55
Example: Organic Body Lotion
Name: description
Required: Optional
Value: Text (may contain HTML)
Description: Comprehensive description of your item. The more detail, the better.
Be careful if entering HTML generated by other software. It is often the case that you will end up with tags that are not required. If possible you should ensure that the following tags are not included.
<!DOCTYPE/>, <HTML/>, <HEAD/>, <TITLE/>, <META/>, <BODY/>
Example: The is a <strong>great</strong> product!
Name: listing_method
Required: Optional
Value: Frooition or Third Party
Description: Select how your eBay listings are posted. Directly to eBay using Frooition Freedom, or a 3rd party listing tool.
If you are uploading a new profile and you do not specify this field it will default to 'Frooition'.
Name: site
Required: Optional
Value: See here
Description: Indicates which eBay site your are listing to.
If you are uploading a new profile and you do not specify this field, then the default will be the eBay location you are registered with.
Example: UK
Name: primary_ebay_category
Required: Conditional
If you are updating an existing listing profile then this field is Optional otherwise it is Required.
Value: Category ID. See here
Description: The primary ebay category (specified as a number) in which the item is listed.
Example: 13850
Name: secondary_ebay_category
Required: Optional
Value: Category ID. See here
Description: The secondary ebay category (specified as a number) in which the item is listed.
Example: 13850
Name: primary_store_category
Required: Conditional
If you are updating an existing listing profile then this field is Optional otherwise it is Required.
Value: Store Category ID. See here
Description: The primary store category (specified as a number) in which the item is listed.
Example: 45914780
Name: secondary_store_category
Required: Optional
Value: Store Category ID. See here
Description: The secondary store category (specified as a number) in which the item is listed.
Example: 45914780
Name: item_condition
Required: Optional
Value: Item Condition ID. See here
Description: Allows you to specify the condition of the item. The condition that can be specified will be determined by the category the item is listed in.
Example: 1000
Name: item_condition_description
Required: Optional
Value: Text
Description: Help your buyers to understand an item's condition and thereby reduce disputes by clarifying the condition.
Example: Case is slightly scratched.
Name: sku
Required: Optional
Value: Text
Description: A SKU (stock keeping unit) is an identifier defined by a seller. Some sellers use SKUs to track complex flows of products and information on the client side.
Max Length: 25
Example: 4512KCD
Name: auction_type
Required: Optional
Value: Online Auction or Fixed Price
Description: The auction type for the listing. The two types you can specify are described below.
Online Auction:
Lets buyers bid for your item and the highest bidder wins.
Fixed Price:
No bidding, let buyers purchase your item at the price you set.
Name: starting_price
Required: Optional
Value: Amount
Description: If auction_type is 'Online Auction' then this will be the minimum acceptable bid for the item. For 'Fixed Price', this is the Fixed Price at which you are selling the item.
Example: 100.50
Name: buy_it_now_price
Required: Optional
Value: Amount
Description: If auction_type is 'Online Auction' then this allows a buyer to instantly purchase the item at a set price and end the auction. Do not specify the price in this field if the auction_type is 'Fixed Price', you should use the starting_price field instead.
Example: 100.50
Name: reserve_price
Required: Optional
Value: Amount
Description: The reserve price is the absolute lowest price at which you are willing to sell your item. If the highest bid does not meet this price, you're under no obligation to sell the item to the high bidder.
Example: 100.00
Name: duration
Required: Optional
Value: 1, 3, 5, 7, 10, 30 or GTC
Description: Number of days the auction is active. If auction_type is 'Online Auction' then you may specify 1,3,5,7 or 10 days. For 'Fixed Priced' you may specify 3,5,7,10,30 or Good Til Cancelled (GTC).
Name: quantity
Required: Optional
Value: Number
Description: Number of items being sold in the listing.
Example: 9
Name: out_of_stock_control
Required: Optional
Value: Yes or No
Description: Out of stock control for GTC. Due to the potential to incur expensive fees, we advise our clients to please read the following Knowledge Base article before activating this option.
Name: best_offer
Required: Optional
Value: Yes or No
Description: If the auction_type is 'Fixed Price' you can allow buyers to send you their Best Offers for your consideration.
Name: best_offer_auto_accept_price
Required: Optional
Value: Amount
Description: The price at which best offers are automatically accepted.
This field is only applicable when best_offer has been set to 'Yes'
Example: 100.00
Name: minimum_best_offer_price
Required: Optional
Value: Amount
Description: The minimum acceptable best offer price. Submitted offers that are below this value will be automatically declined.
This field is only applicable when best_offer has been set to 'Yes'
Example: 100.00
Name: private_listing
Required: Optional
Value: Yes or No
Description: Allow buyers to remain anonymous to other eBay users.
Name: upc,
ean,
isbn
Required: Optional
Value: Text
Description:
  • upc - Universal Product Code
  • ean - European Article Number
  • isbn - International Standard Book Number
Supply any product identifiers that you may have.
Please note that the type of product identifier you can enter will be determined by the eBay category you are listing in. E.g. ISBN will only be available to categories related to books.
You can use our category feature tool found here to look up what is available.
Name: vat_rate
Required: Optional
Value: Amount
Description: VAT rate for the item if applicable. Since VAT rates vary depending on the item and seller's country you are responsible for entering the correct VAT rate as eBay will not calculate it.
This field is only applicable to sellers who have registered a VAT-ID with eBay and are listing on a VAT-enabled site.
You should not enter the percentage sign %. Only specify the amount with digits.
Example: 3.456
Name: shipping_policy_id
Required: Optional
Value: Valid Business Policy ID
Description: ID of a shipping Business Policy
Example: 5000817000
Name: domestic_shipping_type
Required: Optional
Value: Flat, Calculated, Freight or No Shipping
Description: Indicates type of domestic shipping offered. New profiles will default to 'Flat' if this field is not specified.
Name: domestic_shipping_service_1,
domestic_shipping_service_2,
domestic_shipping_service_3,
domestic_shipping_service_4
Required: Optional
Value: Domestic Shipping Service ID. See here
Description: Specifies which domestic shipping service will be used.
Name: domestic_shipping_cost_1,
domestic_shipping_cost_2,
domestic_shipping_cost_3,
domestic_shipping_cost_4
Required: Optional
Value: Amount
Description: The cost for the domestic shipping service.
Example: 1.50
Name: domestic_shipping_additional_cost_1,
domestic_shipping_additional_cost_2,
domestic_shipping_additional_cost_3,
domestic_shipping_additional_cost_4
Required: Optional
Value: Amount
Description: The cost of domestic shipping for each additional item beyond the first item.
Example: 1.50
Name: free_domestic_shipping
Required: Optional
Value: Yes or No
Description: Indicates if you offer free domestic shipping.
Name: dispatch_time
Required: Optional
Value: 0, 1, 2, 3, 4, 5, 10, 15, 20 or 30
Description: The maximum number of business days for preparing an item to be shipped after receiving a cleared payment. Note: Enter a value of 0 to specify same business day
Name: click_and_collect
Required: Optional
Value: Yes or No
Description: Offer 'Click & Collect' at Argos For UK sellers only.
Name: international_shipping_type
Required: Optional
Value: Flat, Calculated or No Shipping
Description: Indicates type of international shipping offered. New profiles will default to 'Flat' if this field is not specified.
Name: global_shipping
Required: Optional
Value: Yes or No
Description: Offer International Shipping with eBay's Global Shipping Program.
Name: international_shipping_service_1,
international_shipping_service_2,
international_shipping_service_3,
international_shipping_service_4,
international_shipping_service_5
Required: Optional
Value: International Shipping Service ID. See here
Description: Specifies which international shipping service will be used.
Name: international_shipping_cost_1,
international_shipping_cost_2,
international_shipping_cost_3,
international_shipping_cost_4,
international_shipping_cost_5
Required: Optional
Value: Amount
Description: The cost for the international shipping service.
Example: 1.50
Name: international_shipping_additional_cost_1,
international_shipping_additional_cost_2,
international_shipping_additional_cost_3,
international_shipping_additional_cost_4,
international_shipping_additional_cost_5
Required: Optional
Value: Amount
Description: The cost of international shipping for each additional item beyond the first item.
Example: 1.50
Name: domestic_handling_cost
Required: Optional
Value: Amount
Description: Enter your handling fee (if any) when domestic_shipping_type has been specified as 'Calculated'.
Name: international_handling_cost
Required: Optional
Value: Amount
Description: Enter your handling fee (if any) when international_shipping_type has been specified as 'Calculated'.
Name: package_type
Required: Optional
Value: Package Type ID. See here
Description: Enter the type of package for shipping the item.
A value in this field will cause an import error if either domestic_shipping_type or international_shipping_type has not been set as 'Calculated'.
Name: package_length,
package_width,
package_height
Required: Optional
Value: Number
Description: The dimensions of the package.
A value in these fields will cause an import error if either domestic_shipping_type or international_shipping_type has not been set as 'Calculated'.
Note that you should not enter the units of measurement as this will cause an import error.
Name: package_weight_major,
package_weight_minor
Required: Optional
Value: Number
Description: The weight of the package.
A value in these fields will cause an import error if either domestic_shipping_type or international_shipping_type has not been set as 'Calculated'.
Note that you should not enter the units of measurement as this will cause an import error.
Example: To specify a package that is 5lbs 2oz you will set the fields as below.
package_weight_major: 5
package_weight_minor: 2
Name: irregular _package
Required: Optional
Value: Yes or No
Description: Indicates if the package is irregular and therefore cannot go through the stamping machine at the shipping service office and thus requires special or fragile handling.
A value in this field will cause an import error if either domestic_shipping_type or international_shipping_type has not been set as 'Calculated'.
Name: domestic_rate_table
Required: Optional
Value: Yes or No
Description: Apply domestic postage rate table
Name: international_rate_table
Required: Optional
Value: Yes or No
Description: Apply international postage rate table
Name: use_tax_table
Required: Optional
Value: Yes, No or Specify
Description: If you charge sales tax you can choose to use the tax table associated with your eBay account or specify the state and tax yourself.
Yes:
Will use the tax table associated with your eBay account.
No
Sales tax will not be applied to the listing
Specify
Use the sales_tax_state and sales_tax_percentage fields to specify the sales tax.
New profiles will default to No if this field is not specified.
Name: sales_tax_state
Required: Optional
Value: State or Jurisdiction ID. See here
Description: State or jurisdiction for which the sales tax is being collected.
A value in this field will cause an import error if use_tax_table has not been set as 'Specify'.
Name: sales_tax_percentage
Required: Optional
Value: Amount
Description: Percentage of the listing's price to be charged as the sales tax for an order.
You should not enter the percentage sign %. Only specify the amount with digits.
A value in this field will cause an import error if use_tax_table has not been set as 'Specify'.
Example: 3.456
Name: shipping_included_in_tax
Required: Optional
Value: Yes or No
Description: Determines whether shipping costs were part of the base amount that was taxed.
A value in this field will cause an import error if use_tax_table has not been set as 'Specify'.
Name: location_country
Required: Optional
Value: Country Name. See here
Description: Geographical location of the item.
Max Length: 50
Example: United States
Name: location_city
Required: Optional
Value: Text
Description: Geographical location of the item.
Max Length: 75
Example: Beverly Hills
Name: location_postcode
Required: Optional
Value: Text
Description: Geographical location of the item.
Max Length: 15
Example: 90210
Name: payment_policy_id
Required: Optional
Value: Valid Business Policy ID
Description: ID of a payment Business Policy
Example: 5000817000
Name: paypal
Required: Optional
Value: Yes or No
Description: Indicates if you accept payment via PayPal.
Name: paypal_address
Required: Optional
Value: Email address
Description: Email address for accepting PayPal payments.
Name: immediate_payment
Required: Optional
Value: Yes or No
Description: Require immediate payment when buyer uses Buy It Now.
Name: return_policy_id
Required: Optional
Value: Valid Business Policy ID
Description: ID of a returns policy Business Policy
Example: 5000817000
Name: returns_accepted
Required: Optional
Value: Yes or No
Description: Specifies that returns will be accepted.
Name: return_policy
Required: Optional
Value: Text
Description: Additional information to let buyers know how to return the item.
Max Length: 5000
Name: extended_holiday_returns
Required: Optional
Value: Yes or No
Description: Accept extended holiday returns.
Name: checkout_instructions
Required: Optional
Value: Text
Description: Additional Checkout Instructions.
Max Length: 500
Name: counter_style
Required: Optional
Value: NoHitCounter, BasicStyle, RetroStyle or HiddenStyle
Description: The style of counter that will appear at the bottom of the listing.
Name: scheduled_listing
Required: Optional
Value: Yes or No
Description: Allows you to create a scheduled listing. By selecting 'Yes' you can use the schedule_date and schedule_time fields.
Name: schedule_date
Required: Optional
Value: Date
Description: Specify a date in the future when the listing will become active. Leave blank if scheduled_listing has been set to 'No'.
Date is in the following format. YYYY-MM-DD
YYYY is a four digit year
MM is a two digit month
DD is a two digit day
Example: The date 25th January 2012 would be specified as 2012-01-25
Name: schedule_time
Required: Optional
Value: Time
Description: Specify a time in the future when the listing will become active. Leave blank if scheduled_listing has been set to 'No'.
Time is in the following format. HH:MM
HH is a two digit hour. Note that hours are specified using the 24 hour format.
MM is two digit minutes
Example: The time 1:15 am would be specified as 01:15
The time 3:30 pm would be specified as 15:30
Name: picture_display_type
Required: Optional
Value: 1,2 or 3
Description: Specify how you would like your pictures displayed within your listing template.
Name: image1_url,
image2_url,
image3_url,
image4_url,
image5_url,
image6_url,
image7_url,
image8_url,
image9_url,
image10_url,
image11_url,
image12_url,
image13_url,
image14_url,
image15_url,
image16_url,
image17_url,
image18_url,
image19_url,
image20_url
Required: Optional
Value: URL or Filename. If specifying a URL it must begin with http://
Description: You may specify up to twenty photos to be displayed in your listing.
If you enter a URL the photos must be self-hosted, meaning the URL entered points to your photos on a web server accessible on the internet.
If you enter just a filename the import will assume that the photos are been hosted by Frootion.
Example: http://example.com/image1.jpg
Name: video_embed1,
video_embed2,
video_embed3,
video_embed4,
video_embed5,
video_embed6
Required: Optional
Value: Code to embed a video within the item's description.
Description: This allows you to embed videos within your listings. It assumes that you have some code that will display the video. You may specify up to six videos to be displayed in your listing.

List of eBay sites that can be imported

Return to top
  • UK
  • US
  • Australia
  • Austria
  • Belgium_Dutch
  • Belgium_French
  • Canada
  • CanadaFrench
  • eBayMotors
  • France
  • Germany
  • HongKong
  • India
  • Ireland
  • Italy
  • Malaysia
  • Netherlands
  • Philippines
  • Poland
  • Singapore
  • Spain
  • Sweden
  • Switzerland

List of countries that can be imported

Return to top
  • Afghanistan
  • Albania
  • Algeria
  • American Samoa
  • Andorra
  • Angola
  • Anguilla
  • Antigua and Barbuda
  • APO/FPO
  • Argentina
  • Armenia
  • Aruba
  • Australia
  • Austria
  • Azerbaijan Republic
  • Bahamas
  • Bahrain
  • Bangladesh
  • Barbados
  • Belarus
  • Belgium
  • Belize
  • Benin
  • Bermuda
  • Bhutan
  • Bolivia
  • Bosnia and Herzegovina
  • Botswana
  • Brazil
  • British Virgin Islands
  • Brunei Darussalam
  • Bulgaria
  • Burkina Faso
  • Burma
  • Burundi
  • Cambodia
  • Cameroon
  • Canada
  • Cape Verde Islands
  • Cayman Islands
  • Central African Republic
  • Chad
  • Chile
  • China
  • Colombia
  • Comoros
  • Congo, Democratic Republic of the
  • Congo, Republic of the
  • Cook Islands
  • Costa Rica
  • Cote d Ivoire (Ivory Coast)
  • Croatia, Democratic Republic of the
  • Cuba
  • Cyprus
  • Czech Republic
  • Denmark
  • Djibouti
  • Dominica
  • Dominican Republic
  • Ecuador
  • Egypt
  • El Salvador
  • Equatorial Guinea
  • Eritrea
  • Estonia
  • Ethiopia
  • Falkland Islands (Islas Makvinas)
  • Fiji
  • Finland
  • France
  • French Guiana
  • French Polynesia
  • Gabon Republic
  • Gambia
  • Georgia
  • Germany
  • Ghana
  • Gibraltar
  • Greece
  • Greenland
  • Grenada
  • Guadeloupe
  • Guam
  • Guatemala
  • Guinea
  • Guinea-Bissau
  • Guyana
  • Haiti
  • Honduras
  • Hong Kong
  • Hungary
  • Iceland
  • India
  • Indonesia
  • Iran
  • Iraq
  • Ireland
  • Israel
  • Italy
  • Jamaica
  • Japan
  • Jordan
  • Kazakhstan
  • Kenya Coast Republic
  • Kiribati
  • Korea, North
  • Korea, South
  • Kuwait
  • Kyrgyzstan
  • Laos
  • Latvia
  • Lebanon, South
  • Lesotho
  • Liberia
  • Libya
  • Liechtenstein
  • Lithuania
  • Luxembourg
  • Macau
  • Macedonia
  • Madagascar
  • Malawi
  • Malaysia
  • Maldives
  • Malta
  • Marshall Islands
  • Martinique
  • Mauritania
  • Mauritius
  • Mayotte
  • Mexico
  • Micronesia
  • Moldova
  • Monaco
  • Mongolia
  • Montenegro
  • Montserrat
  • Morocco
  • Mozambique
  • Namibia
  • Nauru
  • Nepal
  • Netherlands
  • Netherlands Antilles
  • New Caledonia
  • New Zealand
  • Nicaragua
  • Niger
  • Nigeria
  • Niue
  • Norway
  • Oman
  • Pakistan
  • Palau
  • Panama
  • Papua New Guinea
  • Paraguay
  • Peru
  • Philippines
  • Poland
  • Portugal
  • Puerto Rico
  • Qatar
  • Raunion
  • Romania
  • Russian Federation
  • Rwanda
  • Saint Helena
  • Saint Kitts-Nevis
  • Saint Lucia
  • Saint Pierre and Miquelon
  • Saint Vincent and the Grenadines
  • San Marino
  • Saudi Arabia
  • Senegal
  • Serbia
  • Seychelles
  • Sierra Leone
  • Singapore
  • Slovakia
  • Slovenia
  • Solomon Islands
  • Somalia
  • South Africa
  • Spain
  • Sri Lanka
  • Sudan
  • Suriname
  • Svalbard
  • Swaziland
  • Sweden
  • Switzerland
  • Syria
  • Taiwan
  • Tajikistan
  • Tanzania
  • Thailand
  • Togo
  • Tonga
  • Trinidad and Tobago
  • Tunisia
  • Turkey
  • Turkmenistan
  • Turks and Caicos Islands
  • Tuvalu
  • Uganda
  • Ukraine
  • United Arab Emirates
  • United Kingdom
  • United States
  • Uruguay
  • Uzbekistan
  • Vanuatu
  • Vatican City State
  • Venezuela
  • Vietnam
  • Virgin Islands (U.S.)
  • Wallis and Futuna
  • Western Sahara
  • Western Samoa
  • Yemen
  • Zambia
  • Zimbabwe

eBay Site Details

Return to top
Attachments (2) Attachments
Related Articles RSS Feed
How can I change the product images or description that appear within my listing design
Viewed 9687 times since Wed, May 9, 2012
Showing quantity of items available
Viewed 7398 times since Thu, Apr 14, 2011
Do I need a maintenance package?
Viewed 3184 times since Fri, Feb 1, 2013
Why do my item listings have a default photograph picture?
Viewed 4450 times since Fri, Apr 15, 2011
Listing with Business Policies
Viewed 3404 times since Wed, Mar 20, 2013
Frooition - Getting Started Guide
Viewed 3078 times since Mon, Mar 3, 2014
Overview of bulk importing (Frooition Bulk Import feature)
Viewed 5915 times since Thu, Nov 17, 2011
BIN icon shows in promo boxes for auction items
Viewed 5263 times since Tue, Apr 19, 2011
Frooition ServicesSoftware LoginContact UsCopyright Frooition © 2010-2017