...
TaxID: The tax ID associated with the item is entered here.This tax will be processed during sales transactions. If left blank, default value is No Tax. The default tax is TaxID1 TaxID 1
The following is an example of the import file - Advance Mode
Description of the fields:
ItemID: Unique item ID should be entered here which are alpha numeric characters (do not use special characters or spaces).(Max Length 15 characters)
Name: Unique name for the item should be entered (no special characters such as -, *, &, etc) (Max Length 50 characters)
SellingPrice: Selling price for the items should be entered.
...
Classifications and attributes:
Including these in the item detail will allow you to analyze your inventory and sales data on a more specific basis, as well as look up items during the sales process to help customers find related products
Department: The department to which the item belongs should be entered (This is the name of the department, not the ID). If creating a new department, enter in a department that does not exist and the Import will automatically create it. (Max Length 50 characters). If not entered, default value is Default
...
SubCategory: The sub category to which the item belongs should be entered (This is the name of the sub category, not the ID). If creating a new sub category that does not already exist, the import will automatically create it. (Max Length 50 characters) If not entered, Default value is Default
TypeIDSize: If The Size of the item is a store item the ID is 1, if its a service item its 2, if its a package item its 3. (NOTE: If created a package (type 3) Status should be set to Discontinued - as the package becomes active once items are added to the package). If entered here (This is the name for the size, not the ID). (Max Length 50 characters). If not entered, default value is 1blank
QuantityOnHand: Quantity on hand number is enteredStyle: The style of the item is entered here (This is the name for the style, not the ID) (Max Length 50 characters). If not entered, default value is 0blank
StatusColor: Enter the word "Active" or "Discontinued", depending on what the user wants as the status of the item. If The color of the item is entered here (This is the name for the color, not the ID) (Max Length 50 characters). If not entered, default value is Active.is blank
SupplierNameBrand: The Vendor Name associated to brand of the item should be enteredis entered here (This is the name for the brand, not the ID) (Max Length 50 characters). If not entered, default value is Unassignedblank
Serialization Level: Enter 0 if no serialization is on the item, 1 if always, 2 if sometimesSeason: The season of the item is entered here (This is the name for the season, not the ID) (Max Length 50 characters). If not entered, default value is 0No Discount Flag: Enter 0 if no discount flag is set on the item, 1 if there is a no discount flag on the itemblank
Including Inventory Level:
If you want to include the quantity on hand of an item, at the time you are initially adding the item into the system, the following three fields need to be completed to identify the # of pieces on hand, and which location these are located
QuantityOnHand: Quantity on hand number is entered. If not entered, default value is 0
Source ID: Enter the ID of the If Inventory quantities are being added, indicate which store or warehouse that will given the quantity of the items. That QTY can then be transferred to the store in lieu of receivingyou want the inventory added to (normally Store ID 1)
Source Type: Enter If Inventory quantities are being added, enter the source Id (S for Store store or W for WarehouseUnitOfMeasure: ID for PO unit of measure. If not entered, default value is blankwarehouse) depending on where you want the quantity added
Other Common Fields:
CostPrice: The cost price of the item is entered here, if its left empty then its taken as zero by the system. If not entered, default value is 0
TaxIDSupplierName: The tax ID associated with the item is entered here.This tax will be processed during sales transactions. If Vendor Name associated to the item should be entered. If not entered, default value is Unassigned
TypeID: If the item is a store item the ID is 1, if its a service item its 2, if its a package item its 3. (NOTE: If created a package (type 3) Status should be set to Discontinued - as the package becomes active once items are added to the package). If not entered, default value is 1
UPC: Unique UPC is entered here with alpha numeric characters (do not use special characters or spaces). The UPC can be an extension of the
Item ID or completely different. But it should be unique. (Max Length 15 characters). If not entered, default value is Not TaxItemID
Other Less Commonly used Optional fields:
DiscountID: The discount ID attached to the item is entered here. This discount will be processed during sales transactions. If not entered, default value is blank
RoyaltyLevel: The royalty ID associated to the item is entered here. (Not utilized option)
Image: Enter the URL for the image. If not entered, default value is blank
TaxInc: The tax inclusive item is indicated by filling this field with 1 or left blank for tax exclusive. If not entered, default value is blank
PriceBookID: If item will be part of a pricebook, enter pricebook ID. If not entered, default value is blank
...
MaximumLevel: The maximum level to which the quantity of the item can be reached is entered here.
Size: The Size of the item is entered here (This is the name for the size, not the ID). (Max Length 50 characters). If not entered, default value is blank
Style: The style of the item is entered here (This is the name for the style, not the ID) (Max Length 50 characters). If not entered, default value is blank
Color: The color of the item is entered here (This is the name for the color, not the ID) (Max Length 50 characters). If not entered, default value is blank
Brand: The brand of the item is entered here (This is the name for the brand, not the ID) (Max Length 50 characters). If not entered, default value is blank
Season: The season of the item is entered here (This is the name for the season, not the ID) (Max Length 50 characters). If not entered, default value is blank
TaxInc: The tax inclusive item is indicated by filling this field with 1 or left blank for tax exclusive. If not entered, default value is blank
PriceBookID: If item will be part of a pricebook, enter pricebook IDNo Discount Flag: If item will not be discountable enter 1. If the NoDiscount Flag does not apply leave blank
Status: Enter the word "Active" or "Discontinued", depending on what the user wants as the status of the item. If not entered, default value is Active.
UnitOfMeasure: ID for PO unit of measure. If not entered, default value is blank
SerializationlevelSerialization Level: If item will have serial numbers associated with it "Always" enter 1, "Sometimes" enter 2. If serial number will not be added to the item leave blank
NoDiscountFlag: If item will not be discountable enter 1. If the NoDiscount Flag does not apply leave blank
SourceID: If Inventory quantities are being added, enter the source Id (S for store or W for warehouse) depending on where you want the quantity added
Source Type: If Inventory quantities are being added, indicate which store or warehouse you want the inventory added to (normally Store ID 1RoyaltyLevel: The royalty ID associated to the item is entered here. (Not utilized option)