Consolidation of Purchase Order Number in Stock Checklist

Objective

  • As a Seller, I want to have one single document containing all my purchase order (PO) numbers instead of multiple documents with a single PO number in each.
  • As a Venture, I want to increase my operational efficiency, especially for cross-docking orders.
    Critical Knowledge

    • A new table is created, not a new document. This table can be used on the “Stock Checklist” document.
    • PO numbers are received from OMS when “Ready to ship” status is reached.
      • If a user attempts to print the table before “Ready to ship” status, it will return empty values.
    • In order for the table to consolidate PO numbers properly, OMS needs to be configured accordingly and return the same PO number for multiple items.

    Configuration

    1. The following code has to be copy-pasted into the Stock Checklist template:

      <div class=“print-pick-list”>
      <table>
      <thead>
      <tr>
          <th>PO number</th>
          <th>PO number barcode</th>
          <th>Seller SKU</th>
          <th>Product names</th>
          <th>Quantity</th>
          <th>Order numbers</th>
      </tr>
      </thead>
      <tbody>{{#check_list_items_by_purchase_order_number}}
      <tr>
          <td>{{purchase_order_number}}</td>
          <td>{{{purchase_order_number_barcodes}}}</td>
          <td>{{order_item_seller_sku}}</td>
          <td>{{order_item_title}}</td>
          <td>{{order_item_quantity}}</td>
          <td>{{order_nr}}</td>
      </tr>
      {{/check_list_items_by_purchase_order_number}}
      </tbody>
      </table>
      </div>
      

      Note: Please make sure to use the HTML editor by clicking on the “<>” icon.

    2. If needed, the following placeholders can be included outside the table :

      {{check_list_items_quantity}} // It will count the number of items inside the table
      {{orders_count}} // It will count the number of orders inside the table
      

    3. Some columns can be removed if they are not needed. Be sure to remove both the and tags of the column.

      Table usage

      Description Example
      • If several items are assigned to the same PO number, they will all be displayed under this number.
      • Each PO number will be displayed once.
      consolidated-PO document staging