You can use an Excel file to import multiple Orders into Autodesk Fusion Operations.
This feature is extremely useful because it allows you to use the functionalities of a spreadsheet to quickly fill the file with hundreds of Products/Sales Orders - saving you time.
To import several Sales Orders into Autodesk Fusion Operations at once, follow the steps below.
1. On the left menu, click in ‘Sales Orders’
2. Click in ‘Import Sales Orders’
3. You can choose to import or to download a file template in case you are not sure which columns to include. In case you choose to download the file template, in the right side of the page, you will find an option to download it. After choosing the most convenient format, an excel/csv file with the correct headers will be exported into your computer.
The file should be previously prepared as follows:
Mandatory Fields:
Sales Order Code (Column A): reference that identifies the Sales Order.
Product Code (D): code of the ordered product.
Quantity (F): amount of ordered products.
Optional Fields:
Client (B): Client Code. You can check this on the menu on the left, under the tab ‘Clients’.
Creation Date (C): Day and hour when the Sales Order was created. If you don't define a Creation Date, the current time and date will be used.
Depending on your User ‘locale’, the creation date format varies. It is possible to verify the date format of your company on the creation page of a sales order. If you need help on how to access this page please select here.
Product Parameters (E): variable parameters of the products to be sold. They must be added in the format ‘parameter1:value1,parameter2:value2’.
Product Total Price (G): It corresponds to the multiplication between the quantity ordered and the unit price.
Due Date (H): the due date of the ‘Sales Order’. Must be filled with the same format as the one used in the Creation Date column (Column C).
Product Observations (I): observations/notes to add to the products in the ‘Sales Order’.
Delivery Address (J): the address in which the sales order will be delivered.
Parameters (K): custom fields that sales order may require; these can consist of a Sales order attribute that is constant and must be added in the format ‘customfieldname1:value1,customfieldname2:value2’.
Shipping Code (L): the shipping code that will be associated to the identified product in column D. Note that in the same sales order can exist more than one shipping code and one shipping code can be associated with multiple products.
Requested Date (M): the date requested by the client. Must be filled with the same format as the one used in the Creation Date column (Column C).
Sales Orders Observations (N): observations/notes to add to the Sales Orders.
Notes:
1. Consider formatting the columns in text before you begin filling;
2. Do not use formulas in cells;
3. Only the first page of the file is imported. You can use other pages but only the first one will be taken into account.
4. The import only accepts 1001 lines at the time, if you have more than 1001 lines you will have to separate them into several imports.
4. Choose the excel/csv file to import and click in ‘Start to send’.
5. Read carefully the warnings that may appear:
Yellow warnings - there is an issue with the selected line of the file you imported; however, the system will adapt it and import the file anyway. You must recheck what might have been changed and if you agree with it.
Red warnings - the system will not import the line with the warning, because something is wrong and a workaround cannot be applied. Nevertheless, you can ignore a line and import the rest of the file, by clicking in ‘Ignore line’.
6. Click on the ‘Confirm’ button and your 'Sales Orders’ have been uploaded!
Update Sales Order
Beware that it's possible to update sales orders on your account via import. At the moment, we allow different behaviors on sales order updates. If you're not sure which one you have, please contact support.
Default behavior:
It's possible to add new products to an existing sales order as long as the sales order code matches the one already on the account. It's possible to add new products to the same shipping by identifying its code on the column "L" or to create a new shipping by leaving this column empty or by filling it with a specific shipping code.
It's also possible to update the sales order parameters.
Alternative behavior:
It's possible to add new products to an existing sales order as long as the sales order code matches the one already on the account. It's also possible to update specific product fields.
If the shipping code column "L" is not filled out, Fusion Operations will add the product, inside a new shipping. It's also possible to update the sales order parameters.
If the shipping code column "L" is filled out Fusion Operations will update the sales orders parameters as well as the shipping and product entities such as: product code, quantity ordered, product parameters, price, shipping due date, and product observations.
The fields shipping delivery address, shipping code, shipping requested date, and observations are not updated.
Need help? Request a Fusion Operations expert to contact you here.