productid Unique Product identifier number
parentproductid Unique Product Parent identifiernumber
sku Product SKU (Stock Keeping Unit)
description Product short name
longdescription Product long name
standardnote Product short description
transactionnote Product note added during a transaction
extendeddescription Extended description
manufacturer Product manufacturer/brand
weight Product weight
sell_by Description of units to sell by (each,case,etc)
units_per_sell_by Units per sell_by (1,12,etc)
departmentid POSitive unique Department identifier
categoryid POSitive unique Category identifier
passported Passported Y or N
additionalcategories List of POSitive unique Category identifier no's
taxrate Base tax rate (used before customer specific tax rate applied)
retail_price Retail price
retail_price_taxinclusive Retail price tax inclusive
sell_price Selling price
sell_price_taxinclusive Selling price tax inclusive
pricing List of POSitive price groups, Price groups are numbered 1-6. A group of "0" means the pricing applies to all price groups
specialpricing List of Special Prices, POSitive unique Price Group identifier. Price groups are numbered 1-6. A group of "0" means the pricing applies to all price groups
in_stock Total quantity in stock
held_stock Quantity held in stock
presold Quantity presold
available Quantity available
on_order Quantity on order
held_on_order Quantity held on order
calloff Quantity that are available on reserve, Date that quantity will be available
itemsonpo Quantity that will be available when PO arrives, Date that quantity will be available
relatedskus List of SKU's related to item
crosssellskus List of cross-sell SKU's
udf List of user defined Fields (field Name, Field Value)