PickingOrderItem

PickingOrderItem Type

Represents an individual item within a picking order, specifying the product to be picked and the quantity required. PickingOrderItem is a line item that belongs to a PickingOrder and contains the details needed for warehouse picking operations.

Fields

Field	Type	Description
id	ID!	Unique identifier of the picking order item
tenantID	UUID!	Tenant identifier
dataTypeID	UUID	DataType identifier for schema validation
dataTypeSlug	String	DataType slug for easier reference
data	Map	Custom metadata stored as JSON
createdAt	Time!	Creation timestamp
createdBy	UUID!	User identifier who created the item
updatedAt	Time	Last update timestamp
updatedBy	UUID	User identifier who last updated the item
deletedAt	Time	Deletion timestamp
deletedBy	UUID	User identifier who deleted the item
sku	String!	Stock Keeping Unit identifier of the item to pick
orderID	ID!	Reference to the parent PickingOrder
quantity	Int!	Quantity of the item to be picked
order	PickingOrder!	The parent picking order

Interfaces

• Node

Usage Example

query {
  pickingOrderItems(first: 10) {
    edges {
      node {
        id
        sku
        quantity
        orderID
        order {
          id
          status
          customerID
        }
        data
        createdAt
        updatedAt
      }
    }
  }
}

Query by Order

query {
  pickingOrderItems(
    where: {
      orderID: "order-uuid-here"
    }
  ) {
    edges {
      node {
        id
        sku
        quantity
        data
      }
    }
  }
}

Mutation Examples

Create a PickingOrderItem

mutation {
  createPickingOrderItem(input: {
    sku: "PROD-001"
    orderID: "order-uuid-here"
    quantity: 5
    dataTypeSlug: "order_item"
    data: {
      location_hint: "A1-B2-C3"
      special_instructions: "Handle with care"
      priority: "high"
    }
  }) {
    pickingOrderItem {
      id
      sku
      quantity
      order {
        id
        status
      }
    }
    workflows {
      id
      status
    }
  }
}

Update a PickingOrderItem

mutation {
  updatePickingOrderItem(
    id: "item-uuid-here"
    input: {
      quantity: 3
      data: {
        picked_quantity: 3
        picker_notes: "Last 2 units damaged"
        pick_location: "A1-B2-C3"
      }
    }
  ) {
    pickingOrderItem {
      id
      sku
      quantity
      data
    }
    workflows {
      id
      status
    }
  }
}

Delete a PickingOrderItem

mutation {
  deletePickingOrderItem(id: "item-uuid-here") {
    deletedID
    workflows {
      id
      status
    }
  }
}

Relations

• PickingOrderItem N:1 PickingOrder: Multiple items belong to a single picking order

• PickingOrderItem N:1 DataType: Items can reference a DataType for schema validation

• PickingOrderItem references InventoryItem via SKU: Items are picked based on SKU matching

Federation Key

PickingOrderItem is federated by the sku field, allowing it to be resolved across different services in the GraphQL federation.

Common Use Cases

• Order Fulfillment: Breaking down customer orders into pickable line items

• Wave Picking: Organizing items for batch picking operations

• Pick List Generation: Creating picking instructions for warehouse workers

• Inventory Allocation: Reserving specific quantities for order fulfillment

• Pick Performance Tracking: Monitoring picking efficiency by item and SKU

Pick Status Tracking

Use the data field to track picking progress:

{
  "status": "pending|picking|picked|short|damaged",
  "picked_quantity": 3,
  "picker_id": "user-123",
  "pick_time": "2024-01-15T10:30:00Z",
  "location_picked": "A1-B2-C3",
  "notes": "Found alternative location"
}

Best Practices

• Always validate SKU availability before creating picking order items

• Use the data field to store pick-specific instructions and metadata

• Monitor picking workflows to track completion status

• Consider implementing quantity validation to prevent over-picking

• Link items to inventory locations for efficient pick routing