Overview
Product Inventory records from iPaaS.com can be synchronized into Clover using a manual sync method and outbound webhook. This mapping supports the synchronization of Product Inventory data from iPaaS into Clover via the Product Inventory API.
Mapping Collection Status
Mapping Status: Enabled.
Trigger Events: The sync is triggered manually or when a Product Inventory record is created or updated in iPaaS.
ID Format: When manually syncing, the correct iPaaS Product Inventory Product InventoryID must be entered (e.g., Product Inventory Tshirt with ID 10001 must be entered as 10001).
Conflicting Mappings: This mapping applies only to Product Inventory records. Ensure no other mappings target the same Clover entity to prevent data from being overwritten.
System Caveats
iPaaS Caveats
Product and related Location must exist in iPaaS.
Clover Caveats
Product and related Location must exist in Clover.
Setup Requirements
iPaaS Configuration
Pricing formulas must generate numerical values.
Inventory sync requires LocationId to be provided.
Clover Configuration
Location Id must exist in Clover. Authentication & Security.
Clover2 MerchantId: Used to access the iPaaS API for fetching data.
Clover2 API Key: Used to access the iPaaS API for fetching data.
Integration Flow
Retrieve Product Inventory Data: Fetch Product Inventory from iPaaS.
Push Inventory: Sync stock quantities for each product by location.
Mappings
Clover Product Inventory From iPaaS Add/Update Standalone
Description
To create inventory, Track Stock must be enabled in the inventory setup. If it is not enabled, the API call will still be made, but the stock will not be added to the item. To display the item stock correctly, Track Stock must be enabled.
Mapping Type | Source Field (iPaaS) | Destination Field (Clover) | Description |
Dynamic Formula |
| ProductId | Required: Retrieves the external ID of the product for the given ParentId in the Spaceport system. |
Dynamic Formula |
| Quantity | Calculates the total inventory for the product and returns the floor value as a whole number. |
Field | LocationId | LocationId | Required |
Error Handling
Quantity Formula Failure
CalculatedQty returned null or an invalid value.
Description: Clover rejects invalid Qty data.
Resolution: Fix the qty logic in iPaaS.
Validation Rules & Testing
Validation Rules
The Product must exist in Clover.
Inventory sync requires Track Stock to be enabled and a valid LocationId.
Test Scenarios
New Product Inventory With Variants: Create Product Inventory in iPaaS.
Inventory Update: Change stock β confirm stock updates for each location.
Additional Notes
Ensure that the Product exists in Clover.
