Inventory Item List Fields (Import/Export)
Inventory
Product Catalog Fields
Web Site Catalog Fields

How Do I...

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)