Need help?

How to import products

You can import products or services, and it's possible to select different columns with the desired data.

Which columns can I import?
  • Name*
  • Category*
  • Price*
  • Price with tax*
  • Reference*
  • Summary
  • Type (product or service)*
  • Unit of measure*
  • Stock inventory
  • Tax amount
  • Stock
  • Minimum Stock
  • Has stock (Integer - 0 or 1) - 1 yes, 0 no
  • Exemption reason
  • Supplier - code
  • Supplier - VAT number (NIF)
  • Supplier - Cost price (without VAT)
  • Supplier - Internal reference
  • Price tables - name
  • Price tables - value (without VAT)
  • Tax - name*
  • Tax - percentage*
  • Tax - exemption reason*
  • Warehouse - code
  • Warehouse - name
  • Warehouse - minimum stock
  • Warehouse - stock
  • Variants - within these, you can import the warehouse and the corresponding stock, provided they have been created previously so they can be imported.
  • Variants - price tables - name
  • Variants - price tables - value

Fields marked with * are mandatory.

Important note:

  • The last three points focus on taxes. In the tax - name field, if the tax was previously created in Moloni ON, you should enter the same name in the column to avoid creating a duplicate tax.

  • If you enter a single column with the tax - percentage, having an associated name will create a new tax which, after you complete the import, must be accepted to make the products visible.

  • When importing the warehouse, the import is guided by the warehouse code, which may already be created in Moloni ON. In the absence of the code, it will be guided by the warehouse name.

Follow the steps:

1. Go to the menu Tools > Imports.

2. Drag the desired file to the imports area.

3. The system will indicate when the file is ready. Click the 3 dots and select Sheets.

4. Start organising: under Import type, select Product. In the header row, select the row corresponding to the file's header. It's important to activate the tick mark located next to it if the header row has been changed. Click this button to activate the selected option.

   Select the columns you wish to import, according to the instructions given previously.

5. With the information organised and the correct option selected for each column, click Start import so that the products are imported.