• From: Bangladesh
  • Registered: 09/03/2013
  • Posts: 6

Topic: Sample CSV/Excel file for Items import

Hello,

I have installed and activated "Inventory Items CSV Import" extension by Tom Hallman. Can anyone kindly provide a sample CSV/Excel file that I can use to import the items? I am confused about how to make the CSV/Excel file. For example, I have a following sample items to import:

Item Code: 1007
Name: Keyboard
Description: Sample Description
Category: Components
Item Type: Purchased
Supplier: AR Bhai
Quantity: 50
Re-order Level: 10
Purchase Price: 500
Sales Price Wholesale: 550
Sales Price Retail: 600

Thank you very much.

2 Reply by apmuthu (edited by apmuthu 09/03/2013 10:51:25 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sample CSV/Excel file for Items import

I trust you are referring to the Import Multiple Journal Entries v2.3 extension by Tom Hallman.

Documentation is available here.

If you are referring to Import Items Extension by Tom Moulton (wrongly stated as Tom Hallman in the config file), then the documentation is available here

apmuthu's Website

  • From: Bangladesh
  • Registered: 09/03/2013
  • Posts: 6

Re: Sample CSV/Excel file for Items import

Yes I am referring to Import Items Extension by Tom Moulton. I have read the documentation but not understanding the format of how to prepare my csv file with my above mentioned requirements.

Thank you very much.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sample CSV/Excel file for Items import

1. Manually enter one item directly from the FA GUI
2. From the Import Items Extension, choose to export the Items
3. Prepare the rest of your Items as per the exported file
4. Now import this prepared file into FA from within the Import Items Extension

apmuthu's Website

  • Registered: 07/12/2011
  • Posts: 18

Re: Sample CSV/Excel file for Items import

Dear All,

When i import the csv file, the fa complain like this:
"Line 2: Update
The entered information is a duplicate. Please go back and enter different values."
What it mean ?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Sample CSV/Excel file for Items import

When you exported the csv file you had some earlier entry - delete it in the csv and populate the csv with other items that have not been entered as yet and then import it.

apmuthu's Website