Import/Export Products

Import Products:

Steps:

  1. Go to Products -> Import Products
  2. Download the template file.
  3. Fill all the information as per the displayed columns name & instructions. Don’t remove the heading from template file.
  4. Import the file

Common Errors:

  1. Error: UNIT not found
    Solution: Make sure the unit you provided in excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again.
  2. Error: The separation symbol could not be found the separation symbol could
    Solution: Format your cells in excel as text in your excel for the expiry date field and give the date as specified(01-25-2026).

Not well-defined error:

Many times it can show some not well-defined errors like “non-numeric value encounter” or others

In this case, the best way is to split your import into multiple files.

For example, if you’re importing fil with 500 products, divide it into 2 files of 250 each and import it.

Export Products:

The products can be exported in excel/pdf formats from the list products screen.

In the list products screen, click the download excel button.

Removing Action Column in Export File:

While you export the products list in excel, cv or pdf, the actions button column might be added in the exported files. In order to avoid this, use the column visibility feature and hide the actions button.

Did you find this article useful?

  • Products Management

    Adding Products To add a new product to the system, follow the steps below: Step 1: Navigate to Add ...
  • Delete Product (Bulk delete)

    Deleting Products Deleting of a product will remove the products from the database. NOTE: This...
  • Variations

    Variations can be added from the Products -> Variations menu. These variations are us...
  • Product Units

    Different Products have different units. Our software allows you to add different units for products...
  • Product Category (Categorizing products)

    Categorizing products helps you to easily manage and filter them in reports. Adding Category & ...