WorkGuru supports the bulk creation of purchase orders via a csv import template. The pruchase order import template requires a minimum of 2 rows. One purchase order linetype and one product linetype (refer attached template for layout). You can import multiple purchase orders using the one import template. The import template can be uploaded on the imports dashboard (Administration -> Imports)
Purchase Order Import Field Definitions
LineType | Determines the type of purchase order line. Either purchaseorder or product | Required |
PONumber | Purchase order number/reference. Recommended outside of default sequence. | Required |
ProjectNo | Assign to a project to create a project PO if required | |
Supplier | Supplier name. Must match existing supplier name in WorkGuru exactly | Required for purchaseorder lines only |
IssueDate | Purchase order issue date. DD/MM/YYYY | Required for purchaseorder lines only |
ExpectedDate | Purchase order expected date. DD/MM/YYYY | Required for purchaseorder lines only |
DeliveryInstructions | Delivery instructions for the PO | |
DeliveryAddress1 | Dropshop delivery address. If not specified, defaults to warehouse address. | |
DeliveryAddress2 | Dropshop delivery address. If not specified, defaults to warehouse address. | |
Suburb | Dropshop delivery suburb. If not specified, defaults to warehouse suburb. | |
State | Dropshop delivery state. If not specified, defaults to warehouse state. | |
Postcode | Dropshop delivery postcode. If not specified, defaults to warehouse postcode. | |
SKU | Purchased product line SKU. If the SKU does not match to an existing product, it will be added to the project as an adhoc line. | Required for product lines only |
Name | Purchased product line name | Required for product lines only |
Description | Purchased product line description | |
OrderQuantity | Purchased product line quantity | Required for product lines only |
BuyPrice | Purchased product line purchase price | Required for product lines only |
ExpenseAccountCode | Purchase product line Xero general ledger account. If not specified, uses default Xero expense/inventory code. | |
TaxName | Purchase product line Xero tax name. Usually GST on Expenses or GST Free Expenses. | Required for product lines only |
TaxRate | Purchase product line tax as a percentage. Must be a number eg GST = 10 for 10%. | Required for product lines only |
If you have purchase order custom fields, these can also be populated on import by adding a column to the import data with the custom field name (not label). Note: Custom field name is case sensitive, has to match exactly.