Purpose

To bulk import items into FrontAccounting.

Procedure

  • Install Extension in the Default Company
  • Activate Extension for the target Company
  • Logon to the Target Company and Enable the Permissions for the extension for the SysAdmin Role
  • Logout and Login again to the Target Company
  • Items & Inventory => Maintenance => Import CSV Items
  • Choose to export atleast 1 item and then populate the file in the same format and import it in.
  • All these data go into the item_codes table and a corresponding entry goes into the stock_master and loc_stock tables. Images of the items can be named as ITEMCODE.jpg and placed in the company/#/images/ folder.

Tips and Tricks

  • If there are no items pertaining to the stock_id in the import csv file for PriceList updates, the prices table will import these as orphan records.

Resources