How to do accessory bulk import ?

This feature allows adding the multiple an accessories at the same time.

To Bulk Import an Accessory

go to the Accessories > Click on the upload icon > Click on download format > As per the instruction fill the datasheet > Choose an updated file to upload > Click on Upload.

BulkImportAccessoryPic

Instructions

  • Never change the first row of the Format Excel Sheet
  • 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 > Departments.
  • 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.
  • Supplier can be empty or must be a supplier name from Config > Supplier Page
  • Location must be a location name from Config > Location Page
  • Qty must be a valid number
  • Purchase Reference can be either empty or a invoice number from Config > Purchases Page
  • Purchase Date can be empty or must be a valid Excel Date (eg mm/dd/yyyy)
  • Purchase Currency Format can be empty or value of currency e.g. INR
  • Purchase Cost can be either empty or valid number
  • Order Number can be empty or with allowed characters (Alpha, Numbers and limited special characters).
  • Notes can be empty or with allowed characters (Alpha, Numbers and limited special characters).

Accessory Import Information

Accessory 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.

BulkImportFormAccessory