Keep your web store's stock and prices in step with your ERP.
DataBridge reads inventory and price data from your ERP's database, shapes it into the layout your store platform imports, and delivers the file on a schedule. Orders come back the same way, as a file.
A distributor's web store is only as good as the stock and price numbers it shows. Without a feed, someone exports a spreadsheet from the ERP, reformats it by hand and uploads it. That is slow, and it goes stale between uploads.
Modules. Everything bundle: Database for the query, Transfer for delivery, Flow for the schedule. A file-only version of this job fits the Integrate bundle.
Edition. DataBridge Server for unattended schedules.
How DataBridge does it.
Each step names the feature as it appears in the product.
- Step 1
Database connection
Add a connection to the ERP's database (SQL Server, PostgreSQL, MySQL or SQLite). Use a read-only login.
- Step 2
Saved query
Write a query for sellable stock and current prices against your own schema. Saved queries are read-only, so a feed cannot change ERP data.
- Step 3
Field mapping
Map the query's columns to the store's import layout. The E-Commerce Integration Pack ships Shopify and Amazon product and order templates with product mappings as a starting point.
- Step 4
Push results
Deliver the CSV to an SFTP or FTP server, a file share, Azure Blob Storage, Amazon S3 or an HTTP endpoint.
- Step 5
Scheduled job
Chain the query, the transform and the push in one job and run it hourly, nightly or on any schedule. Job Monitor records every run, and the job can email you when it fails.
- Step 6
Orders back
A source picks up the platform's order export from a folder or an SFTP server, a file template validates it, and a Write to database step loads it into a staging table that your ERP's import reads.
What this does not do.
- DataBridge does not call the Shopify or Amazon APIs. The pack ships file layouts only, so your platform needs a file-based import route, or an app or partner that picks files up.
- Writing to a table needs a connection that an administrator has switched on for job writes, and the table must already exist.
- There is no pack for any particular ERP. You write the query against your own schema.
Marketplace packs used: E-Commerce Integration Pack. See the Marketplace.
Related pages.
Try the parts that are free today.
The free browser edition needs no sign-in and never uploads your files.