How to Submit Inventory Batches
Author:
Fluent Commerce
Changed on:
12 Feb 2025
Overview
Pre-requisites:
- You should have knowledge of Inventory Batch
- You should have knowledge of Inventory Batch Pre-Processing
This technical guide provides detailed steps on how you can submit Inventory Batches to the Fluent platform.
Submit Inventory Batches With Attributes
Author:
Fluent Commerce
Changed on:
9 Jan 2025
Key Points
- Create new Inventory Batches using the Job API
- Sample Inventory batch payload
- Inventory batch details
Steps
API Authentication
Authenticate against the Retailer you are sending the Inventory Batch to
Please follow the Authentication API page for how to Authenticate against a Retailer.
The returned token will be used to authenticate all the following API calls.
Set Up a New Job to Execute Your Batches
Using the Job API you can create a new Batch Job.
Inventory Batch Preprocessing Settings and Behavior in Job API
The
`meta`
`meta`
`preprocessing`
The behavior of the
`meta.preprocessing`
`fc.enable.batch.preprocessing`
|
| Additional Info in Job Payload | Result |
true | "preprocessing": "skip" | BPP should not be used | Do not use BPP |
true | "preprocessing": "enabled" | BPP should be used | Use BPP |
true | "meta": null or "meta": {} | BPP should be used | Use BPP |
true | Omitted or previously created Jobs | BPP should be used | Use BPP |
false | Any value | BPP should not be used (overridden) | Do not use BPP |
- When is
`fc.enable.batch.preprocessing`
:`true`
- "preprocessing": "skip"
- Action: BPP should not be used.
- "preprocessing": "enabled" ( any value other than "skip" )
- Action: BPP should be used.
- "meta": null or "meta": {}
- Action: BPP should be used.
- Jobs without
`meta`
- Action: BPP should be used.
- "preprocessing": "skip"
- When is
`fc.enable.batch.preprocessing`
:`false`
- Regardless of the value (including
`meta.preprocessing`
or omitted)`null`
- Action: BPP should not be used.
- Regardless of the
- The fc.enable.batch.preprocessing setting takes precedence over the value. If fc.enable.batch.preprocessing is set to
`meta.preprocessing`
, BPP will not be used regardless of the`FALSE`
value.`meta.preprocessing`
- Ensure that when setting , only the supported values (
`meta.preprocessing`
or`"skip"`
) are used to avoid unexpected behavior.`"any value not skip"`
- A job-level override will affect only the batches containing inventory data created under the specific job, and this impact will remain in effect until the job expires.
1{
2 "name": "Batch Inventory Job",
3 "retailerId": "{{retailer.id}}"
4}
Language: json
Name: Example payload
Description:
Example payload
1{
2 "id": "199"
3}
Language: json
Name: Example response
Description:
Example response
This ID number is the created job ID. Save this ID as we will use it in the following requests for sending a Batch. This Job ID and the created Job will be used to group subsequent Batches together.
Create and send a new Inventory Batch
Using the Job API you can create an Inventory Batch to be processed under the previously created Job.
The URL is using the Job id returned by the last API call, for example 199 as per the previous response.
Inventory Batch Model
The Inventory Batch Model consists of:
- Batch-Level Fields: Define overall batch properties.
- Entities Array: Contains individual inventory items to process.
Field | Type | Mandatory? | Possible Values | Default Value | Description | Notes |
action | String | ✅ | "UPSERT" | N/A | Specifies the operation on inventory entities (e.g., "UPSERT" to insert/update). | Must be a valid action type for inventory operations. |
entityType | String | ✅ | "INVENTORY" | N/A | Defines the type of entity being processed. | Must be "INVENTORY". |
source | String | ❌ | Any valid source identifier | "batch" | Identifies the origin of the batch data (e.g., "ERP", "POS"). | Defaults to "batch" if not provided. |
event | String | ❌ | Any valid event name | "InventoryChanged" | Custom event name associated with the batch operation. | Defaults to "InventoryChanged" if not provided. |
catalogueRef | String | ❌ | Any valid catalogue reference | "DEFAULT:<retailerId>" | References the catalogue associated with the inventory batch. | Influences
|
conditions | Object | ❌ | Configuration object | Uses default transient settings | Configurations like transient types and statuses are used in de-duplication checks. | |
hasRelatedInventoryQuantities | Array | ❌ | List of transient IQ types and statuses | Default transient types and statuses | Defines custom transient types and statuses for checking during de-duplication. | Do note for performance reasons, any transient type with the status "INACTIVE" is ignored |
ref | String | ❌ | Any unique identifier | Constructed if not provided | Unique identifier for each Inventory Quantity (IQ). Used for de-duplication and updates. | Follows the pattern
|
Each object within the
`entities`
Field | Type | Mandatory? | Possible Values | Constraints | Description | Notes |
locationRef | String | ✅ | Any valid location reference | N/A | The location reference used to match the inventory. | |
skuRef | String | ✅ | Any valid SKU reference | N/A | The SKU reference of the inventory item. | |
qty | Integer | ✅ | Any non-negative integer | N/A | The quantity to match the on-hand inventory. | |
correctedQty | Integer | ❌ | Any non-negative integer | Defaults to 0 if not provided | The current outstanding correction quantity to be saved. | |
type | String | ❌ | Any valid type identifier | N/A | Specifies the type of inventory operation (e.g., "LAST_ON_HAND"). | Defaults to "LAST_ON_HAND" if not provided. |
ref | String | ❌ | Any valid reference | Must follow
| A reference identifier for the inventory entity. | If not provided, constructed using
|
status | String | ❌ | Any valid status value | N/A | The status of the inventory entity (e.g., "ACTIVE"). | |
retailerId | String | ✅ | Any valid retailer ID | N/A | The retailer ID for which the inventory is uploading. | |
attributes | Object | ❌ | Any complex key-value pairs | Keys must be strings; values can be any valid JSON type | Additional attributes for flexible metadata storage. |
1{
2 "action": "UPSERT",
3 "entityType": "INVENTORY",
4 "source": "SAP_ERP",
5 "event" :"InventoryChanged",
6 "catalogueRef": "FUTURE:2",
7 "conditions": {
8 "hasRelatedInventoryQuantities": [
9 {"type": "SALE", "status": "ACTIVE"},
10 {"type": "SALE", "status": "CREATED"},
11 {"type": "CORRECTION", "status": "ACTIVE"}
12 ]
13 },
14 "entities": [
15 {
16 "locationRef": "LOC_MEL",
17 "skuRef": "D45",
18 "qty": 350,
19 "correctedQty": 0,
20 "retailerId": 2,
21 "type": "FUTURE",
22 "ref": "24-MG02:LOC_MELB_RET2:FUTURE",
23 "status": "ACTIVE",
24 "attributes": {
25 "expectedOn": "2024-10-31T00:00:00.00Z", // ISO 8601 format
26 "storageAreaRef": "LOC_MELB_RET2-SR1",
27 "condition": "NEW",
28 "countryOfOrigin": "China",
29 "expiryDate": "2025-12-31T23:59:59.00Z", // ISO 8601 format
30 "supplierId": "SUP12345",
31 "unitOfMeasurement": "PCS",
32 "serialNumber": "SN123456789",
33 "purchaseOrderNumber": "PO987654321",
34 "transferFrom": "STORE01",
35 "inventoryPurpose": "For Sale",
36 "manufacturingBatchInfo": {
37 "batchNumber": "BATCH001",
38 "productionDate": "2024-01-15T00:00:00.00Z" // ISO 8601 format
39 }
40 }
41
42 }
43
44 ]
45}
Language: json
Name: Example Inventory Batch Request Payload
Description:
Example Inventory Batch Request Payload
1{
2 "id": "331"
3}
Language: json
Name: Example Inventory Batch Response
Description:
Example Inventory Batch Response
The returned id will be used to check the Batch status in a following call. If you needed to send multiple groups of updates you would run this call for each group of Batches that you are running. If you needed to send 15,000 updates, you would run this 3 times for every 5,000 records( for illustration ) , all under the same Job, using the same job ID.
For a more technical deep dive into how Batch processing works when BPP is enabled, check out this document
Check Job status
You can use the Job API again to check the status of an existing Job
1{
2 "jobId": "199",
3 "status": "OPEN",
4 "batch": [
5 {
6 "batchId": "331",
7 "status": "COMPLETE",
8 "createdOn": "2022-10-06T00:31:08.104+0000"
9 }
10 ],
11 "createdOn": "2022-10-06T00:31:08.104+0000"
12}
Language: json
Name: Example response
Description:
Example response
Check Inventory Batch status
You can view the status of a specific Batch as well, this provides a few more details than the previous Job status check.
The URL uses the Job id and the Batch id returned by previous APIs.
1{
2 "batchId": "331",
3 "entityType": "INVENTORY",
4 "status": "COMPLETE",
5 "start": 1,
6 "count": 10,
7 "total": 0,
8 "results": [],
9 "createdOn": "2022-10-06T00:36:09.344+0000"
10}
Language: json
Name: Example response
Description:
Example response
How to Use Enhanced Inventory Attributes in Your Payloads
Author:
Fluent Commerce
Changed on:
9 Feb 2025
Overview
This guide explains how to leverage the
`attributes`
`attributes`
`expectedOn`
`storageAreaRef`
`condition`
Key points
- Flexible Attribute Structure: The object supports any combination of key-value pairs, including complex JSON structures and arrays. This flexibility allows you to customize the data sent in your inventory payloads to meet specific business needs.
`attributes`
- Recommended Attributes: Certain key attributes, such as ,
`expectedOn`
, and`storageAreaRef`
, are automatically integrated into our platform’s workflows. These fields will be directly updated in the inventory quantity associated with the incoming record, facilitating seamless integration with existing fields.`condition`
- Custom Attribute Availability: Any custom attributes that you include in the object will be available in workflows via
`attributes`
. This enables you to incorporate custom data into rule-based processes or other logic tailored to your business requirements.`inventoryPosition.inventoryQuantity.attributes.<fieldname>`
- ISO 8601 Date Format: For any date-related attributes, it is recommended to use the ISO 8601 format (e.g., ) to ensure consistency and proper handling within the system.
`YYYY-MM-DDTHH:MM:SSZ`
- Integration with Workflows: The system is designed to handle both recommended and custom attributes, making them accessible within the workflow context. This ensures that you can leverage these attributes in custom rules and other logic, depending on the specific needs of your implementation.
- Extensibility: While the table of recommended attributes provides a useful starting point, you are encouraged to extend the object with any additional fields relevant to your business processes. The flexibility of this structure allows for robust customization.
`attributes`
Prerequisite: Workflow and Plugin Requirements
Leveraging Recommended Attributes
While the
`attributes`
`expectedOn`
`storageAreaRef`
`condition`
Flexibility for Custom Attributes
Beyond the recommended attributes, you have the flexibility to include additional fields that are specific to your business requirements. Whether you need to send simple key-value pairs, nested JSON structures, or arrays, our system will process these and make them available within the workflow via
`inventoryPosition.inventoryQuantity.attributes.<fieldname>`
The table below provides examples of the recommended attributes along with their descriptions, usage, and examples. However, you are not limited to these fields—you can extend the
`attributes`
Recommended Attributes Table
Attribute Description | Recommended Attribute Key Name | Example | Notes |
Specific storage locations in a warehouse. |
| "LOC1-SR-1" | Available in the workflow via
|
Date when new stock is expected. |
| "2024-10-31T00:00:00.00Z" | Available in the workflow via
|
Information on the manufacturing country. |
| "France" | Available in the workflow via
Alternate field name for this madeIn |
Details like production date and location. |
|
| Available in the workflow via
|
Indicates the last date a product is safe to use. |
| "2025-12-31T23:59:59.00Z" | Available in the workflow via
|
Unique identifier for each supplier. |
| "SUP12345" | Available in the workflow via
|
Details on how inventory is quantified. Use Case: Ensure consistency in inventory counting, aid in order fulfillment, and simplify stocktaking processes. |
| "PCS" | Available in the workflow via
|
Unique identifier for high-value items. |
| "SN123456789" | Available in the workflow via
|
Links inventory to specific purchase orders. |
| "PO987654321" | Available in the workflow via
|
Source of inventory transfer. |
| "STORE01" | Available in the workflow via
|
Purpose of the inventory. |
| "For Sale" | Available in the workflow via
|
Indicates the condition of the inventory item. |
| "NEW" | Available in the workflow via
|