Preparing a Microsoft Excel Import File for Items 
The following fields for items can be imported into SAP Business One and can therefore be contained in the Microsoft Excel file:
Field Name |
Max. Length |
Data Type |
Item No. |
20 |
Alphanumeric |
Item Description |
100 |
Alphanumeric |
Description in Foreign Lang. |
100 |
Alphanumeric |
Group (1) |
20 |
Alphanumeric |
Bar Code |
16 |
Alphanumeric |
Tax Definition |
1 |
Y – Liable to pay tax N – Not liable to pay tax Entries must be upper case. |
Price List Code (3) |
6 |
Numeric |
Price in the Price List |
17 |
Numeric |
Currency of the Price List |
3 |
Alpha (in accordance with the defined currencies in SAP Business One) |
Sales Account |
15 |
Alphanumeric |
Expense Account |
15 |
Alphanumeric |
Regular Vendor (4) |
20 |
Alphanumeric |
Vendor Catalog Number |
17 |
Alphanumeric |
Unit of Measure for Purchasing |
5 |
Alphanumeric |
Quantity per Purchase Unit |
20 |
Numeric |
Unit of Measure for Sales |
5 |
Alphanumeric |
Quantity per Sales Unit |
20 |
Numeric |
Target Warehouse Inventory in Purchasing Unit |
20 |
Numeric |
Minimum Warehouse Inventory |
20 |
Numeric |
Purchasing Item (5) |
1 |
Y – Yes N – No Entries must be upper case. |
Sales Item (5) |
1 |
Y – Yes N – No Entries must be upper case. |
Warehouse Item (5) |
1 |
Y – Yes N – No Entries must be upper case. |
Fixed Assets |
1 |
Y – Yes N – No Entries must be upper case. |
Brand (6) |
30 |
Alphanumeric |
Customs Group (7) |
20 |
Alphanumeric |
Sales Factor 1 |
20 |
Numeric |
Sales Factor 2 |
20 |
Numeric |
Sales Factor 3 |
20 |
Numeric |
Sales Factor 4 |
20 |
Numeric |
Purchasing Factor 1 |
20 |
Numeric |
Purchasing Factor 2 |
20 |
Numeric |
Purchasing Factor 3 |
20 |
Numeric |
Purchasing Factor 4 |
20 |
Numeric |
Additional fields are available for importing information on length, width, height, weight and volume. You can also import the packaging unit and the quantity per packaging unit for an item.
Re (1)
If the imported group has not been defined in the system yet, the system automatically creates a new group.
Re (2)
If items that are liable for tax are involved, the default tax groups for the items defined under G/L account determination are used.
Re (3)
The price list with this number must already exist in the system. Therefore, you may have to define the corresponding price list before the import.
Re (4)
If no master record for the imported regular vendor exists yet in the system, the system will automatically add it during the import.
Re (5)
If these fields do not contain entries during the import, the system automatically adds the master records as purchasing, sales, and warehouse items.
Re (6)
If the imported brand has not been defined in the system yet, the system automatically creates a new brand.
Re (7)
The customs groups specified for the import must be defined in SAP Business One before the import. If one of the customs groups in the Microsoft Excel table has not been defined in the system, you will not be able to import the data.