SAP B1 and InRiver
Integration Agency & Consultants
Operational friction between InRiver and SAP B1 usually becomes visible when the product data finance sees in the ERP no longer matches what sales is presenting to customers. At scale, inconsistent attribute definitions and mapping errors lead to incorrect inventory valuation, margin leakage, and reconciliation debt. We connect these systems so that enriched marketing data in InRiver remains in step with the structured financial and logistical requirements of SAP B1.
Diagnosing gaps in ERP and PIM workflows
Cogent2 connects your SAP B1 and InRiver systems efficiently, ensuring your ERP and PIM work in harmony. Our consulting services, including comprehensive system audits, identify inefficiencies and integration gaps, enabling your team to take decisive action. By optimising your tech ecosystem, we help your SAP B1 and InRiver platforms operate smoothly, ensuring your ERP and PIM deliver exceptional customer experiences. Our audits provide actionable insights, allowing your business to run efficiently and effectively, ultimately enhancing customer satisfaction and operational performance.
Solution Design
Design decisions for SAP B1 and InRiver focus on maintaining a clean separation between the marketing experience and the financial record. InRiver is the master for enriched product attributes, while SAP B1 remains the authoritative source for inventory and cost valuation. We typically sequence the flow to ensure ERP records are enriched before they impact sales or accounting. A primary trade-off in this pair is the choice of batch synchronisation for product catalogues versus targeted triggers for price and stock. Batch sync protects SAP B1 from excessive load and remains easier to reconcile, though it introduces a reporting lag compared to real-time events. This design ensures the finance team closes the month using validated ERP data while the ecommerce team operates with high-fidelity product content. Remaining manual checks are defined for the launch phase to manage edge cases safely.
Mapping product hierarchies to the item master
The integration functions by translating enriched attributes in InRiver into the fields required by the SAP B1 environment. Control lists and product hierarchies in the PIM are mapped to the Item Master where necessary. Data integrity is maintained through validation rules that prevent incomplete product data from reaching the ERP. We include issue detection by monitoring the flow of SKU updates; if a required attribute is missing in InRiver, the sync is flagged before it can affect the SAP B1 database. This ensures that the system of record for inventory and financials remains accurate.
iPaaS
The integration functions by translating enriched attributes in InRiver into the fields required by the SAP B1 environment. Control lists and product hierarchies in the PIM are mapped to the Item Master where necessary. Data integrity is maintained through validation rules that prevent incomplete product data from reaching the ERP. We include issue detection by monitoring the flow of SKU updates; if a required attribute is missing in InRiver, the sync is flagged before it can affect the SAP B1 database. This ensures that the system of record for inventory and financials remains accurate.
Detecting data drift before financial reporting
Standard dashboards often show that a sync has occurred, but they rarely show if the data inside is correct. Our approach surfaces hidden issues, such as mapping mismatches where a product in InRiver does not align with the Item Master structure in SAP B1. We monitor for instances where updates are accepted but fail to update the record correctly due to ERP constraints. By surfacing these issues early, we help prevent data drift that is often only discovered during manual stock-takes or year-end reporting. The goal is to provide finance and ops with a clear view of synchronisation health.
Training teams to manage data lifecycles
Handover ensures finance, ecommerce, and operations teams own their respective segments of the data lifecycle. We move beyond technical manuals to provide an operational reference that explains how the InRiver and SAP B1 connection actually runs. Your teams learn to verify that enriched product data in InRiver correctly maps to the financial and inventory structures in SAP B1. Training covers daily monitoring of the integration layer and identifying which team owns specific exceptions like mapping errors or valuation mismatches. Documentation is provided as an operational reference for the people running the business, rather than a technical archive for IT.
Resolving sync exceptions and attribute failures
After launch, we provide ongoing monitoring of your product data flow. Instead of basic technical support, we focus on identifying and resolving the root causes of sync exceptions before they create downstream gaps. Our monitoring helps detect issues like broken resource links or failed updates, ensuring that an issue in InRiver does not lead to a failure in SAP B1 reporting. We provide clear escalation paths and reviews to ensure the integration continues to match your business processes as you scale or add new product categories.
Common failures
Product attribute mapping conflicts
Operational impact: If attributes like costing methods, tax codes, or units of measure are mapped incorrectly from InRiver to SAP B1, the consequences hit the balance sheet. Finance will encounter incorrect gross margin calculations on sales orders and inaccurate inventory valuation in the general ledger. This triggers a cycle of manual journal entry adjustments during month-end close, undermining trust in core financial reports.
Prevention: Establish a clear ownership boundary where SAP B1 owns financial and logistical attributes while InRiver owns marketing enrichment. The integration logic must prevent enriched data from InRiver from overwriting protected financial fields in the SAP B1 Item Master Record (OITM). Use exception reporting to flag attempted mismatches rather than allowing silent data corruption.
Inventory valuation gaps
Operational impact: When a new product record is synchronised without an established cost price in SAP B1 before the first Goods Receipt PO, the ERP may post stock at a zero or estimated value. This leads to incorrect cost of goods sold (COGS) postings upon fulfilment. Fixing this requires complex, manual inventory revaluation, which delays margin analysis and risks financial reporting errors.
Prevention: Ensure the integration enforces process sequencing. InRiver pushes the new SKU to SAP B1 with a 'holding' status. The record remains blocked for purchasing until the finance or procurement team updates the Item Master Data with the validated cost price, ensuring no stock enters the business without a financial value.
Data load and API contention
Operational impact: Updating data in InRiver can trigger high-volume API calls that degrade ERP performance. If non-critical updates are pushed constantly, it can lead to table locking on the SAP B1 Item Master, slowing down essential operations like sales order creation. This creates operational latency that affects finance, sales, and warehouse teams simultaneously.
Prevention: Implement a batching strategy for synchronising data from InRiver to SAP B1. Consolidate minor marketing updates into scheduled intervals and prioritise critical inventory or logistical changes for faster processing. This ensures the integration does not consume excessive system resources during peak trading hours.
Frequently asked questions
Should we create new products in InRiver or SAP B1 first?
We recommend creating the core Item record and SKU in SAP B1 to establish the financial and stock-keeping foundation. InRiver then subscribes to this new SKU, acting as the master for enriching it with marketing-focused attributes and images. This enriched data is then synchronised back to the SAP B1 Item Master Data record, preventing duplicate records and ensuring financial data integrity from the start.
What is the typical role of each system in this integration?
In a common operating model, SAP B1 acts as the system of record for all core financial and inventory data, including the initial creation of the Item record. InRiver serves as the Product Information Management (PIM) system, taking that core SKU and enriching it with detailed marketing copy, specifications, and digital assets. This ensures sales and finance teams are working from a single, accurate product definition tied to a financially-validated Item record in SAP B1.
Why do some product updates from InRiver fail to post to SAP B1?
Failures can occur when an attribute from InRiver has a dependency on a setting within SAP B1 that is not correctly configured. For instance, attempting to sync batch or serial numbers will fail if the corresponding 'Manage Item by' setting is not activated on the Item Master Data record in SAP B1. The integration must be designed to handle these specific validation rules for data to synchronise reliably between InRiver and the ERP.
Our stock levels seem to be wrong in our sales channels. How does this integration address that?
This often happens if the integration logic does not correctly handle SAP B1's warehouse data structure. For example, if you have multiple SAP B1 warehouses (OWHS) that need to be aggregated into one inventory figure for InRiver, a simple integration might fail or pull from the wrong source. A correctly configured integration aggregates inventory from specific SAP B1 warehouses to provide an accurate available-to-promise figure in InRiver for reliable stock synchronisation.
We already update SAP B1 from InRiver manually. What's the main reason to automate?
The decision to automate is typically driven by costly errors in financial reporting or sales operations. For example, a manual mistake in updating a product's dimensions or weight from an InRiver specification sheet into the SAP B1 Item record can lead to incorrect shipping charges and flawed inventory valuation reports. Automation prevents these manual errors by creating a direct, reliable link between the master product data in InRiver and the financial records in SAP B1.