osCommerce logo

osCommerce

Sync osCommerce order, product, customer, and category data into your warehouse.

Overview

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 can sync

Ingest syncs the following osCommerce data into your data warehouse, each as its own table refreshed on your schedule:

  • Orders
  • Products
  • Customers
  • Categories

Authentication

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 credentials in a secure form, never in chat. Ingest stores and rotates them for you.

Resources