# Import Purchase Orders

Alternatively to manually creating new purchase orders users can import orders using excel spreadsheet file. 

Here is an example of the spreadsheet that is compatible with P4W system:

{% file src="<https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FjNYa2Ubf5S807M1NWc8E%2Forders%20import.xlsx?alt=media&token=da0e53a5-2e97-4250-aca8-58ee1049b5e0>" %}

To import purchase orders navigate to Receiving > Pending POs. Click 'Data entry' button and select 'Import'. Select desired file from your computer.

![](https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2FUVKdZ43Lt4G6xGqsj1f7%2Fpo_import.png?alt=media\&token=120ae8be-980f-4ab1-aed1-26361363a141)

{% hint style="info" %}
Notice: Make sure that information from the file is fully consistent with the data from P4W warehouse management system. Discrepancies will prompt descriptive error messages.
{% endhint %}