Skip to main content

Bulk linking Purchase Orders and Sales Orders

Link many purchase orders to their sales orders in one go.

How to bulk link POs and SOs?

Instead of linking orders one by one, you can upload a file to link many purchase orders to their sales orders at once.

❕ You can only link orders that use the same attachment template.

  1. Go to Traceability → Orders. On the Sales Orders tab, click Bulk Link PO; on the Purchase Orders tab, click Bulk Link SO.

  2. Click ‘Download template’ on the top right and fill in one row per link:

    • PO_NUMBER: the Order ID of the purchase order (on the Purchase Orders tab).

    • SO_NUMBER or CUSTOMER_PO_ID: to identify the sales order, fill in one of them:

      • CUSTOMER_PO_ID: the Customer PO ID on the Sales Orders tab. Every sales order has one, because it’s the order number your customer sent you.

      • SO_NUMBER: the Order ID on the Sales Orders tab. This is optional, and not every sales order has one.

    💡 If you’re not sure, use CUSTOMER_PO_ID.

    Then upload the file with ‘Choose file’ or drag and drop, and click ‘Continue’.

  3. In ‘Map columns’, match your columns to PO Number and Customer PO ID or SO Number, then click Next.

  4. Review your data. If a number is not found, it is listed under Issues to fix. Click the cell to pick the right order. Then click ‘Import N rows’ (N is the number of rows).

    If a PO and SO use different attachment templates, they won’t be linked and a message shows which order failed.

    Linked orders show a confirmation message.

    Full size preview

Did this answer your question?