How to use consumable bulk import ?

This feature allows adding the multiple consumables at the same time.

To Bulk Import a Consumable

Instructions

• Company must be a name from Config > Companies Page.
• Name must be alphabets either uppercase or lower case letters.
• Department can be empty or must be a department name from Config > Department Page.
• Category must be a category name from Config > Categories Page. You can add the new category which is not in Master Page.
• Manufacturer can be empty or must be a name from Config > Manufacture Page.You can add the new manufacture which is not in Master Page.
• Location must be a location name from Config > Location Page.
• Supplier can be empty or a supplier name from Config > Suppliers Page.
• Order Number can be empty or with allowed characters (Alpha, Numbers and limited special characters).
• Purchase Reference can be empty or a value of invoice number from Config > Purchases Page.
• Purchase Date can be empty or must be a valid Excel Date (eg mm/dd/yyyy)..}
• Purchase Currency can be empty or value of currency e.g. INR
• Purchase Cost can be either empty or must be a valid number.
• Quantity must be whole number.
• Notes can be empty or with allowed characters (Alpha, Numbers and limited special characters).
• Custom Fields: To import a component with custom filed, Add the custom "field code" as a new column and enter the required value below. You can get the "field codes" by clicking above "Download Custom Field Codes" button.

Consumable Import Information

Consumable Import Information tab provides the entire history of the import attempts with the counts of each status and the date of the attempt made. By clicking the download document, you can get a copy of the particular attempt information with the given details. Additionally, it will give status and error message.