There are 2 ways to update purchase order details in bulk:

Option 1: Update Purchase Order Details Directly

**Step1 :**From the purchase order list, select purchase orders you want to update.

Step 2: Click ‘Bulk Update’ and then select 'Update Purchase Order Details'.

Step 3: You will be directed to update purchase order details page. Update purchase order details.

📘
Update all order item to 'Customer Order Cancelled' order item status in order to cancel the purchase order.

**Step 4:**Click ‘Submit’.

Once the purchase orders are successfully updated, a green banner will appear at the top of the purchase order list.

Alternatively, you may download Excel template and fill in order item data on your computer.

Option 2: Update Purchase Order Details Using Excel Template

Step 1: From the purchase order list, select the purchase orders you want to update.

Step 2: Click ‘Bulk Update’ and then select 'Update Purchase Order Details'.

Step 3: You will be redirected to update purchase order details page. Click 'Export Template'.

Step 4: Update purchase order details in Excel template.

Step 5: Click 'Upload Template'.

Step 7: Select the Excel template from your computer.

Step 8: A confirmation message will appear. Click ‘Replace’ to start the upload.

Once the Excel template data is successfully imported, a green banner will appear at the top of the purchase order list.

**Step 9:**Click ‘Submit’.

Once the purchase orders are successfully updated, a green banner will appear at the top of the purchase order list.

In case you already have Excel template, you can upload the existing Excel template through more option button on vendor quote list.

Step 1: Click 'More Options' (...) and then select ‘Update Purchase Order Details’.

Step 2: You will be directed to update purchase order details page. Click 'Upload Template'.

Step 3: Select the Excel template from your computer.

Once the Excel template data is successfully imported, a green banner will appear at the top of the purchase order list.

**Step 9:**Click ‘Submit’.

Once the purchase orders are successfully updated, a green banner will appear at the top of the purchase order list.