Import/Export Products

Import/Export Products

Import Products: #

Steps: #

  1. Go to Products -> Import Products
  2. Download the template file.
  3. Fill in all the information as per the displayed columns’ names & instructions. Don’t remove the heading from a template file. (See Attached sample Excel File Screenshot )
  4. Import the file

Import product

Sample excel file #

  #

Common Errors: #

  1. Error: UNIT not found
    Solution: Make sure the unit you provided in the excel file is already present in the system. Go to  Products -> Units, add the unit & import the file again.

product unbiit

 

  1. 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(11-25-2018).
formatcells 500x440 1
Import/Export Products 8

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.

you can export the product in the same template as the import product template.

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

exportprod 600x310 1
Import/Export Products 9