The following table lists the fields available for import or export, with a brief description of the field and (when necessary) a character limit for the field. The Import? column identifies which fields are available for import (all are available for export).
Note: Inventory item fields are exported using ITEM.CSV as the default file name. Inventory product catalog fields are exported using WEBPAGE.CSV as the default name. And Web site catalog fields are exported using WEBCATLG.CVS as the default name.
Tips on Importing Inventory Items
Field Name |
Import? |
Description of Field |
Limit |
---|---|---|---|
Item ID |
Y |
Alphanumeric - Inventory ID number |
Up to 20 characters |
Item Description |
Y |
Alphanumeric - Inventory item description. |
Up to 30 characters |
Item Class |
Y |
Numeric (Whole) - Inventory item class; valid numbers are 0 through 11, where 0=Non-stock item, 1=Stock item, 2=Description only, 3=Assembly, 4=Service, 5=Labor, 6=Activity item (Sage 50 Premium Accounting and higher), 7=Charge item (Sage 50 Premium Accounting and higher), 8=Master stock item (Sage 50 Premium Accounting and higher), and 9=Substock (Sage 50 Premium Accounting and higher). 10=Serialized Stock item (Sage 50 Premium Accounting and higher), 11= Serialized Assembly (Sage 50 Premium Accounting and higher), |
|
Inactive |
Y |
Boolean - Inactive check box; valid choices are [True] or [False], where True=Inactive and False=Active. |
|
Subject to Commission |
Y |
Boolean - Subject to commission check box; valid choices are [True] or [False] |
|
Description for Sales |
Y |
Alphanumeric - Inventory item detailed description. |
Up to 160 characters |
Blank Field |
N |
||
Description for Purchases |
Y |
Alphanumeric |
Up to 160 characters |
Sales Price/Billing Rate 1-10 |
Y |
Numeric (Real) - Inventory price levels 1 to 10. The minimum number of price levels is five (Sage 50 Pro Accounting). The maximum number of price levels is 10 (Sage 50 Premium Accounting and higher). |
|
Sales Price 1-10 Calculation |
Y |
Alphanumeric - Inventory price level 1 to 10, base calculation method selected in the Maintain Item Prices window. Valid choices are NC (no calculation), LC (last cost) + a calculation formula, and PL1 (Price Level 1) + a calculation formula. LC and PL1 include a formula such as the following: LC+20.00 = last cost increased by the amount of $20; PL1*1.10 = Price Level 1 increased by 10 percent (depending on the number of decimal places chosen in Maintain Global Settings). Note: NC, LC, and PL are case sensitive; they must be uppercase. |
|
Sales Price 1-10 Rounding |
Y |
Numeric - Inventory price levels 1 to 10, rounding method used in calculation. Valid numbers are 0 through 2, where 0 = no rounding, 1 = rounding to a specific cent, 2 = rounding to the next dollar. |
|
Sales Price 1-10 Rounding # |
Y |
Numeric - Inventory price level calculation 1-10, new value rounded to a specific cent. Depending on the number of decimal places chosen in Maintain Global Settings, this value is represented as 0 + 1 to 5 decimal places—for example, with two decimal places, 0.50 = value rounded to $0.50. |
|
Qty Discount ID |
Y |
Alphanumeric - Quantity Discount ID number |
Up to 20 characters |
Item Tax Type |
Y |
Numeric (Whole) – Inventory item tax types as set up in Maintain, Default Information, Inventory Items; valid numbers are 0 to 24. |
Up to 13 characters |
Last Unit Cost |
Y |
Numeric (Real) - Inventory item cost amount for Stock and Non-stock items. |
|
Costing Method |
Y |
Numeric (Whole) – Costing method; valid numbers are 0 through 2, where 0=Average Cost (all Sage 50 products), 1=FIFO, and 2=LIFO. This field applies to [Stock item], [Assembly], and [Master Stock item] items only. |
|
G/L Sales Account |
Y |
Alphanumeric - Usual sales account no. Must be a valid account number from your Chart of Accounts. |
Up to 15 characters |
G/L Inventory Account |
Y |
Alphanumeric – Inventory account no. Must be a valid account number from your Chart of Accounts. Required for all types of items excluding description only. Note: This field is not required for activity items and charge items. |
Up to 15 characters |
G/L COGS/Salary Acct |
Y |
Alphanumeric - Cost of Goods Sold or Salary/Wages account no. Must be a valid account number from your Chart of Accounts. Required for all types of items excluding description only. Note: This field is not required for activity items and charge items. |
Up to 15 characters |
UPC/SKU |
Y |
Alphanumeric - The Universal Price Code/Stock Keeping Unit for the item. |
Up to 20 characters |
Part Number |
Y |
Alphanumeric - Part number for an Item |
Up to 20 characters |
Item Type |
Y |
Alphanumeric - Inventory item type |
Up to 8 characters |
Location |
Y |
Alphanumeric - Location of inventory item |
Up to 10 characters |
Stocking U/M |
Y |
Alphanumeric - stocking unit of measure field |
Up to 20 characters |
Use Multi-Packs |
Y |
Boolean - buy and sell in different quantities; valid choices are [True] or [False] |
|
Purchasing U/M |
Y |
Alphanumeric - The default U/M for purchases of the item. |
|
Purch U/M Description |
N |
Alphanumeric |
|
Purch U/M No. of Stocking Units |
N |
Numeric (Whole) - The number of stocking units for the purchasing U/M, defined in Maintain Units/Measures |
|
Purchasing Weight |
Y |
Numeric (Whole) |
|
Purchasing UPC/SCC |
Y |
Alphanumeric - UPC/SCC code for the purchasing U/M. |
|
Use Purchasing U/M as Default |
Y |
Boolean - valid choices are True (use as default) or False (use Stocking U/M as default) |
|
Sales U/M |
Y |
Alphanumeric - The default U/M for sales of the item. |
|
Sales U/M Description |
N |
Alphanumeric |
|
Sales U/M No. of Stocking Units |
N |
Numeric (Whole) - The number of stocking units for the sales U/M, defined in Maintain Units/Measures. |
|
Sales Weight |
Y |
Numeric (Whole) |
|
Sales UPC/SCC |
Y |
Alphanumeric - UPC/SCC code for the sales U/M. |
|
Use Sales U/M as Default |
Y |
Boolean - valid choices are True (use as default) or False (use Stocking U/M as default) |
|
Weight |
Y |
Numeric - The weight of the item in the selected unit of measure. |
Up to 8 characters |
Minimum Stock |
Y |
Numeric (Real) – Minimum stock level |
|
Reorder Quantity |
Y |
Numeric (Real) - Amount of inventory item normally reordered. |
|
Vendor ID |
Y |
Alphanumeric - Usual Vendor ID number from your vendor list. Required only if item is a [Stock item], [Assembly item], or [Master Stock item]. |
Up to 20 characters |
Buyer ID |
Y |
Alphanumeric - ID of the company employee/sales rep designated as buyer for the item. |
Up to 20 characters |
Label for Inventory Item Custom Field 1 (entered in Inventory Item Defaults) |
Y |
Alphanumeric - The text value of what is entered in inventory item custom field 1 in Maintain Inventory Items. |
Up to 40 characters |
Label for Inventory Item Custom Field 2 (entered in Inventory Item Defaults) |
Y |
Alphanumeric - The text value of what is entered in inventory item custom field 2 in Maintain Inventory Items. |
Up to 40 characters |
Label for Inventory Item Custom Field 3 (entered in Inventory Item Defaults) |
Y |
Alphanumeric – The text value of what is entered in inventory item custom field 3 in Maintain Inventory Items. |
Up to 40 characters |
Label for Inventory Item Custom Field 4 (entered in Inventory Item Defaults) |
Y |
Alphanumeric – The text value of what is entered in inventory item custom field 4 in Maintain Inventory Items. |
Up to 40 characters |
Label for Inventory Item Custom Field 5 (entered in Inventory Item Defaults) |
Y |
Alphanumeric – The text value of what is entered in inventory item custom field 5 in Maintain Inventory Items. |
Up to 40 characters |
Master Stock ID |
Y |
Alphanumeric - ID number of master stock item. Required for all substock items (Sage 50 Premium Accounting and higher). |
Up to 20 characters |
Primary Attribute ID (there can be up to 20 of these fields) |
Y |
Alphanumeric - ID of the master stock item primary attribute. At least one required for each master stock item (Sage 50 Premium Accounting and higher). |
Up to 4 characters |
Primary Attribute Description (there can be up to 20 of these fields) |
Y |
Alphanumeric - At least one required for each master stock item (Sage 50 Premium Accounting and higher). |
Up to 20 characters |
Secondary Attribute ID (there can be up to 20 of these fields) |
Y |
Alphanumeric - ID of the master stock item secondary attribute (Sage 50 Premium Accounting and higher). |
Up to 4 characters |
Secondary Attribute Description (there can be up to 20 of these fields) |
Y |
Alphanumeric (Sage 50 Premium Accounting and higher) |
Up to 20 characters |
Item Note |
Y |
Alphanumeric - Inventory item note. |
Up to 249 characters |
Print Components |
Y |
Boolean - Print components check box under the bill of materials if the item is an assembly; valid choices are [True] or [False] |
|
Primary Attribute Name |
Y |
Alphanumeric - Name of the primary attribute. For both master and substock items (Sage 50 Premium Accounting and higher). |
Up to 20 characters |
Substock Primary Attribute ID |
Y |
Alphanumeric - ID of substock primary attribute. At least on is required for each substock item (Sage 50 Premium Accounting and higher). |
Up to 4 characters |
Substock Primary Attribute Description |
Y |
Alphanumeric - At least one is required for each substock item (Sage 50 Premium Accounting and higher). |
Up to 20 characters |
Substock Secondary Attribute ID |
Y |
Alphanumeric - ID of substock secondary attribute (Sage 50 Premium Accounting and higher). |
Up to 4 characters |
Substock Secondary Attribute Description |
Y |
Alphanumeric (Sage 50 Premium Accounting and higher) |
Up to 20 characters |
Quantity on Sales Orders |
N |
Numeric (Real) - Quantity of inventory item appearing on all sales orders. |
|
Quantity on Purchase Orders |
N |
Numeric (Real) - Quantity of inventory item appearing on all purchase orders. |
|
Quantity on Hand |
N |
Numeric (Real) - Quantity of inventory item currently in stock. |
|
Is Taxable |
Y |
Boolean - Item Tax Type list box; valid choices are [True] or [False], where True=Taxable and False=Exempt. |
|
Warranty Period <span> <units> |
Y |
Alphanumeric - Warranty period set for this item. Note: The warranty period can be set up in days, months, or years. |
90 |
Revision Number |
Y |
Numeric (Real) - Sequential number assigned to revisions based on system date and effective date of transaction. |
|
Effective Date |
Y |
Date - Date of the revision. Must be in ##/##/## (month/day/yr) format. |
|
Component Number |
Y |
Numeric (Real) - The position the component occupies in the assembly; order may be important with subassemblies or in a step-like procedure. |
300 (Sage 50 Quantum Accounting); 100 (Sage 50 Premium Accounting and Sage 50 Pro Accounting) |
Component ID |
Y |
Alphanumeric - If an item is part of an assembly, these fields (1-96) will contain the component's Item ID. |
|
Quantity Needed |
Y |
Numeric (Whole) - If an item is part of an assembly, these fields will contain the component quantity needed to produce one unit of the assembly item. |
300 ( Sage 50 Quantum Accounting); 100 (Sage 50 Premium Accounting and Sage 50 Pro Accounting) |