# Correctly Format Bulk Import Orders File

To bulk import past affiliate orders into your program, you will be required to upload a correctly formatted CSV file. 

To correctly format the CSV file for bulk importing past affiliate orders into your program, click on **bulk import** in the **All Sales** section of the **Sales** tab in the GoAffPro admin panel.

![Sales > All Sales > Click on bulk import](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJ7WeuIYAEd-wcc_xK%2FAnnotation%202020-07-28%20120239.png?alt=media\&token=985ab925-6366-43f1-a039-7450ae1a21ea)

Here, click on the **sample CSV file** to download the file.

![Click on the sample CSV file](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJ857ZBef7MxlbBEnG%2FAnnotation%202020-07-28%20120555.png?alt=media\&token=0079fadd-4cd8-4084-a8a7-4b0fcb72e979)

Now, open the CSV file.

{% hint style="info" %}
The CSV file can be opened in programs such as Microsoft Excel or Google Sheets.
{% endhint %}

![Open the CSV file](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJiS7RCu-0GPg9Ww4H%2Fimage.png?alt=media\&token=ec52d5f1-d325-4838-8e6e-03fd4336d09d)

After this, fill in the order information according to the columns provided in the sample file.

![Fill in the order information](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJhcyfW6Pk5THJws20%2Fimage.png?alt=media\&token=e99734e0-7ce9-45aa-a950-558c9bf333cb)

Finally, click on **Browse** and upload your CSV file.

![Click on Browse](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJ8MSYPEzk9WISubp7%2FAnnotation%202020-07-28%20120555.png?alt=media\&token=cdb3d5e4-92a0-45f6-a77e-18c6d7a6b40f)

Now, click on **Start Importing** to begin the importing process.

![Click on Start Importing](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJfFx0-78tWmAbx9dQ%2FAnnotation%202020-07-28%20134729.png?alt=media\&token=a97ba9ba-b2dc-4aee-abcc-36e1e53dc841)

After the import process is completed, you can check the import status of each order in the status column.

![Check the import status](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJf_wewXE6QmlNLJQ3%2Fimage.png?alt=media\&token=f98c6153-4d41-4410-8809-d5b533287445)

The newly imported affiliate orders will now appear in the All Sales section of the Sales tab. 

![](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MDJ5eK_8-3ZHO9xU8w5%2F-MDJhLsA9I8U3jPgW-SX%2Fimage.png?alt=media\&token=cab6ddfb-9ab6-4eed-ba0a-ccb753ffa67e)