What Is the Inventory by Fulfillment Location Report
The Inventory by Fulfillment Location report is designed to show product stock at the locations that hold inventory for fulfillment. Review each product and location together to see how stock is distributed and decide where a closer stock check is needed.
This report shows the inventory quantity held at each fulfillment location. It represents stock at the time the report is generated, so you can see how much stock remains at every location.
Report Overview
- Period
- Current inventory snapshot.
- Data included
- Fulfillment Location, Product Name and Inventory Quantity fields.
- Best for
- Location stock reviews and preparing replenishment or transfer checks.
- Export formats
- Excel, CSV, TXT and PDF.
- Frequency
- Generate when needed or configure daily, weekly or monthly email delivery after setup.
What Can You Learn from Inventory by Location
1. Where a product’s stock is concentrated
Compare the same product across locations using the same inventory state. This helps identify balances worth reviewing before assigning more stock.
Example: Hypothetical: A product has 70 units at one location and 8 at another.
What you can do: Check local demand and transfer feasibility before moving units.
2. Which location balances need attention
Review low or zero balances to prepare a stock check. The quantity state determines whether a balance indicates stock available to sell or total stock held.
Example: Hypothetical: A product shows zero available units at a location.
What you can do: Check committed stock and incoming receipts before placing a reorder.
3. How stock is distributed across the network
Review product and location pairs to prepare an inventory review list. A large balance alone does not establish excess stock without demand information.
Example: Hypothetical: One product appears with positive balances at three locations.
What you can do: Compare those balances with a separate demand report before planning replenishment.
What Should You Check First in This Report
Establish what the quantities mean before using the export for operational decisions.
- Inventory state — Confirm whether the quantity is available or on hand; use one definition throughout the review.
- Location mapping — Confirm that each row refers to where inventory is held, including any relevant third-party locations.
- Product granularity — Check whether variants are combined. Product names alone may not identify distinct stock items.
- Generation time — Compare balances captured at the same time and recheck changing quantities before taking action.
When Should You Use This Report
| When to Use It | How It Helps |
|---|---|
| Reviewing stock distribution across locations | Review how product stock is distributed across fulfillment locations. |
| Investigating low or zero stock at a location | Prepare location-specific lists for investigating low or zero balances. |
| Comparing stock with demand and incoming supply | Identify stock balances to compare with demand and incoming supply. |
| Preparing an inter-location transfer review | Prepare transfer discussions by checking stock at the sending and receiving locations. |
How to Create This Report in Data Export
Use the inventory configuration after its fields and location mapping have been confirmed.
- Open Data Export and look for Inventory by Fulfillment Location.
- Review the location, product and inventory quantity fields.
- Confirm the inventory state and product or variant detail. Apply location or product filters only where available.
- Generate a preview and compare sample balances with the corresponding inventory records. Save the configuration once the results match.
- Choose the required export format and, if needed, set up daily, weekly or monthly email delivery.
Make the Most of This Report
Use these checks to keep location comparisons consistent.
01 / QUANTITY DEFINITION
Record the inventory state alongside each export so colleagues interpret balances consistently.
02 / PRODUCT DETAIL
Confirm variant detail before combining rows that share a product name.
03 / SNAPSHOT TIMING
Generate location comparisons together and retain the export time for later review.
04 / REPLENISHMENT CONTEXT
Use separate demand and incoming-stock information before deciding how much to reorder or transfer.
Frequently Asked Questions
Does Net Quantity show inventory remaining
No. Net Quantity is a sales measure, not a stock balance. Use the Inventory Quantity field to see how much stock is held.
Does this report show available or on hand inventory
The supplied source does not specify an inventory state. Confirm the configured quantity field before publishing or using the report.
Can I use this report to plan stock transfers
Use confirmed location balances to prepare a transfer review. Check demand, reservations and transfer constraints separately before moving stock.
Can I see inventory for a previous date
Historical inventory is not established by the source. Do not assume that selecting an earlier sales period reconstructs a past stock balance.
Can I schedule the report by email
The source describes daily, weekly and monthly email scheduling. After confirming the inventory configuration, save it and select the required schedule.
