To prepare the Excel sheet that contains your orderlines and their quantities, follow these steps to export the order form:

1. Go to the Export module from the left-hand side:

1. Select the radio button next to Order form:

3. Click Next, the file format supported is Excel, 
4. Click Next and select the source of colorways you want:

• If you select “Full catalog” all the colorways are exported.
• If you select “My favorite”, a dropdown menu appears to enable you to select the favorite tags you want.
• If you select “From Excel”, you need to browse for the Excel file containing the colorways, select the sheet and map the columns.
• If you select “List of colorways”, you need to paste a list of colorway numbers.
• If you select “List of styles”, you need to paste a list of style numbers.

5. Click Next and select the location(s) from which you want the order to be copied, 
6. Click the columns you want to include in the sheet to move them to the Selected columns section, you drag and drop the columns to change their sequence, 
7. Click the slider button next to Include images, if you want, 
8. Click Next, the valid and invalid colorways are listed, 
9. Click Finish, a window opens to allow you to select the location to which the form is saved.
10. Open the file and fill the quantities against each size and save the file. Now the file is ready to be imported to the Orders module as explained in Creating and submitting orders.