Here is the list of all field types you might face while importing/exporting products and their descriptions. The data is in the following format: field name, type, description.
<-- Ignore this column - the field selected in such a way will not be imported
Product ID - integer, product's identifier
Is Product Shown - integer, 0 - product is shown, 1 - product isn't shown on site
Product Name - string, product's name
Friendly URL - string, friendly URL of the product's page
Product Order - integer, product's order
Product Type - integer, ID from the 'Product Types' static table
Product Option - string, name of product's property
Category - string, product's category name
Manufacturer ID - integer, manufacturer's identifier
Manufacturer Code - string, manufacturer's code
Manufacturer Name - string, manufacturer's name
Weight - float, product's weight
Issue Date - string in correct format as set by variable $date_edit_format in var_definition.php, product's issue (addition) date
Tax Free - integer, 0 - product is taxable, 1 - product isn't taxable
Language - string, language code for which product is available or empty string for all languages
Price - float, product's selling price
Is Price Edit - integer, 0 - product's price cannot be edited by clients, 1- price is editable
Options Price - float, product options' price
Is Discount Active - integer, 0 - discount is inactive, 1 - active
Discount Price - float, amount after discount
Trade Price - float, special second (e.g. wholesale) price (feature of version 2.8)
Discount Trade Price - float, discounted second price (feature of version 2.8)
Discount Percent - float, discount shown for second price (feature of version 2.8)
Buying Price - float, product's buying price
Short Description - string, short product's description
Features - string, features' text
Full Description Type - string, 0 - text, 1 -html
Full Description - string, full product's description
Specification - string, specification's text
Is Special Offer - integer, 0 - isn't special offer, 1 - is special offer
Special Offer - string, text of special offer
Small Image - string, path to small image
Big Image - string, path to large image
Super-Sized Image - string, path to super image
Use Stock Level - integer, 0 - don't use stock level, 1 - use stock level
Stock Level - integer, amount of product in stock
Hide Off Limits Products - integer, 0 - show products that are out of stock, 1 - hide out of stock products
Disable Off Limits Products - integer, 0 - product that is out of stock can be bought, 1 - out of stock product can't be bought
Is Downloadable - integer, 0 - not downloadable product, 1 - downloadable product
Download Period - integer, number of days
Download Path - string, absolute, relative or web path to downloadable product
In Stock Availability - integer, ID of row in the 'Shipping Times' static table
Out of Stock Availability - integer, ID of row in the 'Shipping Times' static table
Shipping Restrictions - integer, ID of special shipping rule from the 'Shipping Rules' static table
Shipping Cost - float, cost of product's shipping
Total Votes - integer, number of users' votes
Total Points - integer, number of users' points
Rating - float, product's rating
Notes - string, text of notes
Direct Buy Link - string, link to directly buy a product (in affiliate programs)
|
5.7.1. Product Import/Export Fields
Here is the list of all field types you might face while importing/exporting products and their descriptions. 
