Docs / Data sources / osCommerce

osCommerce

Ecommerce

Built when you ask for it

Sync osCommerce order, product, customer, and category data into your warehouse. Ingest builds this connector the first time a customer asks for it, then keeps the tables current in a data warehouse you own, on the schedule you choose.

The osCommerce connector syncs your ecommerce storefront data into analytics-ready tables in your data warehouse. Pull orders, products, customers, and categories from the osCommerce REST Server module, with Ingest handling auth, pagination, and retries so the tables stay current. osCommerce is self-hosted software with no central vendor API — each store optionally installs the Rest Server extension, which generates its own store-specific key.

What you would get

Each of these arrives as its own table, kept current on the schedule you choose:

  • Orders
  • Products
  • Customers
  • Categories

How it gets built

  1. Choose osCommerce when you set up a pipeline, with the warehouse it goes to and a schedule.
  2. Ingest reads osCommerce's documentation, and you choose the tables you want.
  3. Ingest builds the connector and tests it against osCommerce itself.
  4. A person at Ingest reviews and publishes it, and your pipeline starts on its own.

What you will need

API key (per-store, optional extension). Install and configure the Rest Server extension under Sales Channels > Configure platform rest server; it auto-generates the store's API key.

You enter it once, in a form in Ingest, and it is kept in a secret store set aside for your organization.

Questions

Does Ingest have a osCommerce connector?
Not as a finished connector yet. Ingest builds it from osCommerce's own documentation the first time a customer asks, tests it against the real service, and lists it once it passes.
Which warehouses can osCommerce data go to?
Amazon S3, Google Cloud Storage, Azure Blob Storage, Apache Iceberg, Ingest Managed Lakehouse, MotherDuck, Postgres, Amazon Athena, Databricks, Redshift, BigQuery, ClickHouse, MySQL / generic SQL and Snowflake, in an account you own.
Do I need to write code?
No. Ingest builds, runs and maintains the connector. Someone with access to your warehouse connects it once, following a short guide.

osCommerce API documentation: https://oscommerce.com/wiki/Managing_Rest_Server_Module

Setting up the destination is its own short guide, one per warehouse or lake: Amazon S3, Google Cloud Storage, Azure Blob Storage, Apache Iceberg, Ingest Managed Lakehouse, MotherDuck, Postgres, Amazon Athena, Databricks, Redshift, BigQuery, ClickHouse, MySQL / generic SQL, Snowflake.

Other sources Ingest connects for ecommerce teams: Shopify, Etsy, Faire, Walmart Marketplace, Walmart Connect, Mercado Libre.

Request osCommerce