Adding Products from a File (Product List)

This guide explains how you can add multiple products to the program at once using a product list.

How do I import products into SimplBooks?

  • If you have an existing product list before activating SimplBooks, the easiest way to add the entire list to the program at once is to upload it as a CSV file.
  • If you want to add products one by one, you can find instructions for that here.

Can products be added without inventory tracking?
Yes. You can add products to the program without activating inventory tracking. Instructions can be found here.

Does this guide also cover adding opening inventory?
This guide only covers importing the product list. If you have opening inventory, you can read about adding it here.

📢 Note! Use inventory tracking only if you need to know at all times how many products you have in stock. Using inventory tracking makes accounting more complex and we recommend using it only when it adds real value to your business.

1. The product list is imported under Inventory > Products > Import.

2. Select your existing product list in CSV format and click “Import” at the bottom.

3. Select whether the product list includes a header row

This selection determines whether the first row of the CSV file is a header row, i.e., whether it contains the column names.

💡 Tip: In the images above, the first row of the CSV file is a header row.

  • If the “Contains header row” option is not enabled, the program will interpret the first row as a product.
  • If the “Contains header row” option is enabled, the first row moves above the “Select target field” columns and the program will not add it as a product.

4. Select headings for the required columns from the dropdown menus.

The required fields are the product code, name, and unit.

📢 Note! The columns shown in the import preview are determined by the file being imported, so their names and order may vary. By selecting column headings, you tell the program which column each piece of information comes from.

5. Once columns have been assigned for at least the required fields, click “Import” at the bottom.

💡 Tip: We recommend adding products to the program as inventory products only if you need to use inventory tracking. If you do not need inventory tracking, it is best to add products as service products, even if they are physical goods. When a product has been added as an inventory product, the program will not allow it to be added to an invoice if there is no stock balance.

6. When the import is complete, the program will report how many products were imported successfully and whether any products were not imported due to invalid data.

Other related guides:

Was this article helpful?

Yes No

Related Articles

Leave A Comment?