Import order

7 March 22, 2024
Export to PDF

Import order

You can import an exported order form to add multiple orderlines in an easy way to T1 Studio. Through the import process, you can either create a new order or update an existing one. If you need more information on exporting order forms, refer to “Export order form“.

Note:

A submitted order cannot be overwritten or updated and you need to contact the Sales Person to reopen it then import the updated file.

To import the file, follow these steps:

  1. Click the Import button, the following window appears:
  1. Drag and drop the file or click Select File to browse for the file you want to import, then click Next, the following window appears:
  1. Select the sheet you want from the dropdown list then click Next, the following window appears:
  1. Select the column of the sheet that matches each field,
  2. Click the radio button to select whether you want to create a new order or overwrite an existing one. In case the order is overwritten, quantities are updated as per the imported file,
  3. Click Next, the number of valid and invalid rows are displayed. If the file contains invalid rows, the window appears as shown below:

You can either click Get Result to check the invalid rows and fix the file then import it again, or click the checkbox next to “Skip invalid rows” and import the valid rows.

  1. Click Import, imported order is created with status “Draft” and you can update the order and send it.

Notes:

  • If you select “Overwrite Existing Active Orders”, you need to enter the order reference of the existing order that you want to overwrite in the field under the location code.
  • If the delivery date is inactive or not available, or sizes are not assigned to the article, an error appears. Click Get Result, the sheet opens with a new “Status” column showing which rows are invalid and why as in the below example:

Make the necessary changes and import the sheet again.

  • If any of the orderlines does not have delivery dates, or its delivery dates are not available, sizes are not available, an error message is displayed and the file cannot be imported.