I don't have an invoice for the products yet, how can I import them?

The step-by-step guide to import your products into haddock.

If you don't have any of your products uploaded to haddock yet and can't wait to start creating your bill of materials, you have two options:

1. Upload the delivery notes/invoices from your suppliers and wait for them to be digitised. Check here how to do it.

Import the products with a template that you can download from the 🍎 Products tab. Here's how to do it:

- Download the template you will find in the 🍎 Products module, by clicking on the Import products button.

- Open it with your computer's spreadsheet editor and fill in the fields with the necessary information. Help yourself with the legend that you will find in the same template.Β 

Important! Make sure that all the mandatory columns are entered, otherwise the import will give you an error. We recommend that whenever possible, you enter the code that your supplier has (the one that comes on their delivery notes or invoices) to facilitate the assignment with other documents.

πŸ‘‰ Once filled in, make sure you save it in xlsx format or, if you do it from Numbers on Mac, export it in Excel format.


Two of the particularly important points are:

Product name→ The product name must be the same as on the supplier's invoice/delivery note. If it is not the same, it will not be able to be merged with future purchases that are digitised.

Supplier VAT number β†’ If the products you are importing do not have their supplier created in haddock, the suppliers will be created at the time of import. The VAT number is crossed with our internal database and the supplier profile is completed with all the information, you can see them in the 🚚 Suppliers tab.

  1. Once prepared, upload the Excel file to haddock, and you're done! If there are any problems with the import, you will get an error message.
  2. Go back to haddock and, from the same screen from where you downloaded the template, upload the completed template.

If the upload is complete, you will be able to see all products in the 🍎 Products tab.

If, on the other hand, something is wrong, the products will not be uploaded and the error message will be displayed. In this case, we recommend that you check the template again and make sure that the products are correct:

  • All mandatory fields (those in the orange title) are completed.
  • You have selected one of the proposed units of measurement (kg/gr/l/l/ml/pc).
  • In the supplier TIN column all numbers have a letter + 8 digits (X00000000).
  • The price per unit of measure field has a numeric format with no special letters or characters (e.g. 0,00).

Still have doubts?

Contact us and we will be happy to help you πŸ™Œ.