How to import purchases with an Excel or csv file

Purchasing from suppliers allows you to make stock entries in the program, and to keep track of what you are expecting and what has arrived at all times.

It is possible to import purchases directly with an Excel file.

Requirements to be able to create and place purchase orders:

• The user must have the role of OWNER, STORE MANAGER or WHOLESALER MANAGER. You can see the different types of roles in the section Create or edit a user.
• Although you can register items from the same process of creating a purchase, it is advisable to have entered all the items before starting the purchase.

Steps to create and import purchase orders:

1. Go to the side menu and click on the PURCHASE button in the INVENTORY section.
2. You will see the list of purchases, click on the top right NEW PURCHASE.
3. Once inside the new purchase screen, you must fill in at least the following fields:
   1. Serial number, Serial number delivery notes, Shipment start date, Warehouse of receipt, Period/season. 
4.  Once the fields have been filled in, click on the CONTINUE button.
5. When you click you will have changed tabs and now it is time to import the products:
   1. Select the 3 vertical dots at the top right.
   2. Select the "Import products" option.
6. When you select it, you have the option to download the example template for the import; it will be necessary to add the barcode of the product and the units you are buying.
7. Now, you can import the file; always in .xls or .xlsx format.
8. Select "File" > "Import".
9. Once the import is completed, you will receive an email notification in your user account.

Step 5: Drop-down menu to select "Import Products".

Step 6: New window to download the template and import the product file for purchase.