Import Data into the Chronos eStockCard Inventory Software

April 20th, 2011, Filed in Install, Activate & Update

Chronos eStockCard inventory software allows you to import following data into the system:

  • Item Master — i.e. product details,
  • Customer Master — i.e. customers’ details,
  • Supplier Master — i.e. suppliers’ details,
  • Unit of Measurement (UOM),
  • Packing details,
  • Item Group,
  • Item Category.

 

Step 1: Data Preparation in Microsoft Excel format

  • Please feel free to download the import document templates (in Microsoft Excel format) to prepare your data that need to be imported into the eStockCard. Here is the download link:  Chronos eStockCard v3 Data Import Template
  • To import the Item Master data, just select the Item sheet (from the document).
  • You will notice that the 1st row (highlighted in yellow) is the header name.
  • Just key in or copy & paste the respective info to their respective column.
  • Key in the item code under the “item_code” header.
  • Key in the item description under the “item_des” column and so on.
  • For information which are not available, just leave the column row empty.
  • Once completed, go to the eStockCard program.

 

Step 2: Import Data from the Microsoft Excel file to Chronos eStockCard Inventory Software.

i) Login to the program.

ii) Go to Tools -> Data -> Import.

iii) Select the required file to import.

iv) Browse for the file to import.

v) Select the Sheet that contain info which you would like to import.

vi) Select the Data Table on which data to be imported into. If you are importing Item, select Item.

vii) Finally match the Source File column ( Header name ) with the eStockCard column name. Just select the Header name which have info enter into.

viii) Once done, just click Finish & Close. All the require Item Data will be imported into the eStockCard




Related posts:

  1. How many items can be supported by Chronos eStockCard Inventory Software?
  2. Currently I’m using the Free Edition of the eStockCard Inventory Software, should I re-enter my data after upgrading to the Standard Edition?
  3. Editions are available for Chronos eStockCard Inventory Software
  4. I’m quite satisfied with my current accounting software, how Chronos eStockCard can further benefit me?
  5. Unable to activate the Chronos eStockCard inventory system