How to Import Purchase Order Using Excel

This allows you to to place an order from your supplier in order to add stock to your items in bulk import without having to create purchase orders for each individual item. Through this, you can create purchase order with multiple items and multiple outlets in the same time.

  1. Go to Inventory > Purchase Order > Select Item Library.

    Import_PO_Item.png
  2. Click Import > Import PO.

    Import_PO_Item_Drop_Down.png

  3. Click Download Our Template.

    Download_Template.png
  4. Open the file saved to your computer using Excel.

  5. Fill in Supplier Email column (column C) to request and send order item by email to your supplier. (Keep it blank if you don’t have supplier email)

  6. Fill in Order column (column I) to input your order quantity of your items.

  7. Fill in Unit Cost column (column J) to input the unit cost of your items.

    Notes: Please do not edit any other columns

    Import_PO_Item_Excel.png

  8. Save the edited CSV file to your computer.

  9. Drag and drop the CSV file into the upload area or click on the upload area.

  10. Click Upload.

    Notes:
    After you finished importing the Purchase Order, the status of those orders will be Created.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Still Have Questions?

Our customer care team is here for you!

Contact Us