# Uploading a Purchase Order CSV (ASN alternative)

**CSV Upload (recommended)**

A CSV example directly from Helm can be downloaded from the [Import/Export Purchase Order](https://onlinefulfilmentcentre.myhelm.app/imports_exports/purchase-orders) page accessed through Imports/Export-&gt;Purchase Orders

This consists of the following (but may alter, so I recommend checking the CSV download from Helm on occasion).

<table border="1" id="bkmrk-name-description-exp" style="border-collapse: collapse; width: 100%; height: 507.2px;"><colgroup><col style="width: 27.0556%;"></col><col style="width: 53.974%;"></col><col style="width: 19.0658%;"></col></colgroup><thead><tr style="height: 29.6px;"><td style="height: 29.6px;">Name</td><td style="height: 29.6px;">Description</td><td style="height: 29.6px;">Expected Value</td></tr></thead><tbody><tr style="height: 29.6px;"><td style="height: 29.6px;"><span style="color: rgb(224, 62, 45);">\*</span>Purchase Order ID</td><td style="height: 29.6px;">A Unique ID for the Purchase Order</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;"><span style="color: rgb(224, 62, 45);">\*</span>Supplier Email</td><td style="height: 29.6px;">The email address of the supplier (can be own email)</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;"><span style="color: rgb(224, 62, 45);">\*</span>Location ID</td><td style="height: 29.6px;">The location this item will be stocked to (Warehouse is 6, so choose 6)</td><td style="height: 29.6px;">6</td></tr><tr style="height: 46.4px;"><td style="height: 46.4px;">Expected Delivery Date</td><td style="height: 46.4px;">When it should be getting to the warehouse</td><td style="height: 46.4px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;"><span style="color: rgb(224, 62, 45);">\*</span>Product SKU</td><td style="height: 29.6px;">The SKU for the product on this line</td><td style="height: 29.6px;">PDT-123, etc</td></tr><tr style="height: 46.4px;"><td style="height: 46.4px;"><span style="color: rgb(224, 62, 45);">\*</span>Product Quantity</td><td style="height: 46.4px;">The amount of this product getting delivered</td><td style="height: 46.4px;">120</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Product Name</td><td style="height: 29.6px;">The name of the product</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Product Line Total Discount</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">0</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Product Expected Delivery Date</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">PO Notes</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Payment Currency</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">**GBP**, etc</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Product Notes</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Product Delivered Quantity</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Product Unit Price</td><td style="height: 29.6px;">  
</td><td style="height: 29.6px;">  
</td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;">Custom Fields</td><td style="height: 29.6px;">Any custom field data for the product(s)</td><td style="height: 29.6px;">  
</td></tr></tbody></table>

**Uploading/Importing**

Once the PO is completed

Go to [Imports/Export-&gt;Purchase Orders](https://onlinefulfilmentcentre.myhelm.app/imports_exports/purchase-orders)

Upload the file

Check the mappings are correct (if you use the template they should be, but double check for safety)

Press Submit Mapped Data

**Final Part**

Once the PO is added and looks good/has been sent wherever it needs to be sent this needs to be set as Submitted.

To do so, select the dropdown at the top-right and choose Submitted.