You can use an Excel file to import multiple Production Orders (PO's) to Prodsmart.
This feature is extremely useful because it allows you to use the functionalities of a spreadsheet to quickly fill the file with hundreds of PO's - saving you time.


You should use the template we provide for the import of PO's.
This template can be downloaded at "Production orders" menu in the left side panel, by clicking on "Import Production plan" option in the upper-right corner.

You will find an option to download a template file and you should Select the "Excel" option. 

This file is what you will need to use whenever you want to import new PO's. Save it in the location you prefer so you can reuse it whenever you need to.

How to fill the Template

When you open the Template, it will be filled with an example.

The columns that you must fill out are:  
"Production order Code": Unique identifier of the production order;
"Product Code": Product to be produced;
"Quantity": quantity of product to be produced;
"Start date and Due date": Day and time when the production of this production order must start and end;


1. Consider formatting the columns in text before you begin filling;

2. When completing the dates use the format indicated in column H and I,  "ex: 21/12/2015 10:00 ";
3. Do not use formulas in cells;
4. Only the first page of the file is imported. You can use other pages but only the first one will be taken into account.

Small example of the template used for two different PO's. Notice that the first one is for 2 products and the second one is only for 1:

How to import the file

Returning to where you downloaded the template, you will see in the center of the page an option to choose and import a template. After clicking "Start to send" a page will be shown to confirm all the information (if there are errors, they will be identified on this page as well). If everything is as you want, click "Confirm".

Did this answer your question?