Online channel products

Qingpu stores a channel-side product snapshot after a product has been published. This snapshot is independent from the publish record: a successful publish record describes a past submission, while an online product describes the latest state returned by the marketplace.

The user entry is /user/ops/products inside the Store Operations workspace. ops supplies the product shell and cross-product navigation only; channel product facts remain independently owned by channel-products. The legacy /user/channel-products URL redirects to the new entry.

Endpoints

GET /api/qingpu/channel-products

Returns paginated channel product snapshots, status counts, configured stores, and per-store sync freshness.

Query parameters:

  • storeKey: optional store ID.
  • status: active, pending, error, delisted, archived, unknown, or out_of_stock.
  • search: title, offer ID, platform product ID, or SKU.
  • unlinkedOnly: true to return marketplace products without a linked Qingpu product.
  • page and limit: pagination; limit is capped at 100.

POST /api/qingpu/channel-products/sync

Body:

{ "storeKey": "123" }

Runs a complete Ozon store sync using the store credentials held by Qingpu. It reads the Ozon product list, product details, and inventory, then updates qingpu_channel_products in one database transaction.

A failed sync records the error but preserves the latest successful snapshot. Products missing from Ozon are marked delisted only after a complete sync succeeds. Unknown marketplace states remain unknown instead of being guessed as active.

The initial release is read-only. It does not change price, stock, archive, or sale status on the marketplace.