Using the Inventory Details Page

This page helps you:

• Track real-time and historical inventory changes
• Manage stock levels across multiple locations
• Understand bundled product availability

Steps

1. In the app, go to Inventory → All Inventory.
2. Select a product (SKU) to open the Inventory Details page.
3. Use the Location dropdown to view inventory for a specific location.
4. (Optional) Update one or more inventory counts. Select Edit in the page header to enter edit mode, update On Hand, Unavailable, or any other editable field in a single pass, then select Save changes in the sticky footer. You can also click an individual editable field inline to update only that value.
5. Use the Inventory Ledger to review what changed, when, and why.

Product Information

Inventory Status

You can edit inventory fields in two ways: 

1. Select Edit in the page header to enter edit mode and update multiple fields together, for example, On Hand and Unavailable at the same time, then select Save changes in the sticky footer. 
2. Click an individual editable field to update only that value inline. Available is calculated automatically and is read-only.

Use Edit in the page header when you need to change On Hand together with Committed or Unavailable. Because Available is recalculated from the other counts on every save, updating them one at a time can produce intermediate values that do not match what you intended. Editing them together avoids that.

Bundled Items Section

This section appears only for bundle products. It shows a table of all component SKUs, each row showing:

• SKU (linked to the component's Product Details page)
• Product Name
• Quantity In Bundle (how many units of this component are required per bundle)
• Current inventory levels for the component: On Hand, Committed, Available, Future, Committed Future, Inbound, and Unavailable

Bundle availability behavior depends on the location configuration:

• If the location does not preserve bundles, the app can calculate bundle availability based on components. A common approach is to limit bundle availability by the lowest component availability (based on the required quantities).
• If the location preserves bundles (Preserve Bundles flag enabled), bundle availability may be managed differently, and component-based calculation may not apply for that location.

Activity Section with Inventory Ledger

Activity Chart/Ledger Diagram

Displays a line chart of the last 100 ledger events for the selected SKU–location record. Each of the following quantities is plotted as a separate line over time: On Hand, Committed, Available, Future, Committed Future, Inbound, and Unavailable. Use this chart to spot trends, sudden drops, or unexpected spikes before drilling into the ledger table. Click View last 100 ledger events to expand or hide the chart.

Inventory Ledger Table Filters

Event Types and Meanings

 ℹ️ The custom event type is a standard event available to any connector, not exclusive to Logiwa IO. Its effect on inventory levels depends on the specific connector's implementation. Some connectors use it for informational purposes only (such as reason codes), while others may use it to apply inventory adjustments. Check the behavior of your specific integration if you see unexpected custom events in the ledger.

View JSON Option

Each ledger event includes a View JSON option. This opens the complete raw data structure, including all metadata. It is useful for debugging and in-depth analysis.

Add Custom Column

The Inventory Ledger table supports custom columns, allowing you to surface additional data from each ledger event, including fields from custom events or any standard fields in the ledger JSON.

Click Add Custom Column (top right of the Activity section) to open the modal. Each column is defined by a small JavaScript snippet that receives the ledger event object as input and returns the value to display.

Writing the Code

The entire ledger event JSON is available as input. You can return any top-level or nested field:

// Return a standard field
try {
  return input.locationId;
} catch (err) {
  return '-';
}

// Return a nested field from the internal object (e.g. on custom events)
try {
  return input.internal.fromWarehouseCode;
} catch (err) {
  return '-';
}

Tip: Click View JSON on any ledger row to inspect the full event structure before writing your column code. You can copy that JSON and paste it into the Input panel of the modal to test your expression before saving.

Steps

1. In the Activity section, click Add Custom Column.
2. Enter a Name for the column.
3. (Optional) Enter a Fallback value for when the field is missing or null.
4. Write your expression in the Code editor.
5. Click Test to validate. The Output panel shows the result.
6. Click Save. The new column appears in the ledger table.

To remove or update a column, click the ⋮ menu icon in the column header and choose Delete.

Troubleshooting and Best Practices

Manual Inventory Adjustments

Future Inventory Management

Bundle Inventory Management

Location Management

Using the Inventory Ledger

Integration Considerations

General Usage Tips

Need Help?

If you need additional assistance:

• Use Ask Pippen, our AI agent, located at the top of the app page.
• Submit a support request with as much relevant detail as possible. Learn how to submit a request.
• For urgent issues, email us directly at support@pipe17.com.

We're here to help you succeed with your operations.