> For the complete documentation index, see [llms.txt](https://docs.p4warehouse.com/v2/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.p4warehouse.com/v2/receiving/pending-purchase-orders/import-purchase-orders.md).

# Import Purchase Orders

Alternatively to manually creating new purchase orders users can import orders using excel spreadsheet file.&#x20;

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

{% file src="/files/hfg3bMij0CNJYUyiTJcX" %}

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

![](/files/38lHziZWnFhe7AMIntdS)

{% 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 %}
