Skip to main content

Product listing & bulk product updates

· 3 min read
Albert Tiñena
Albert Tiñena
Chief Technology Officer (CTO)
David Sancho
David Sancho
Principal Engineer & Technical Architect

The OpenTiendas API continues to evolve with a major step forward for catalog integrations.

This release introduces several foundational capabilities that significantly expand what can be built on top of the API: product listing with filtering and sorting and bulk catalog updates prepared for ERP and PIM integrations.

Alongside these endpoints, we’re also introducing a new background Jobs system, allowing the platform to safely process large asynchronous tasks such as mass catalog updates.

Together, these changes represent an important milestone in making the OpenTiendas API scalable, predictable, and ready for large external system integrations.

List Products with filtering and sorting​

A new endpoint allows retrieving products from the catalog with pagination, filtering, and sorting.

GET /api/v1/products

It supports filtering by common catalog attributes such as brand, category, supplier or product structure.

For the complete list of supported filters, sorting options, and query parameters, see the List Products API reference.

Bulk product upsert​

Large catalogs are often managed in external systems such as PIMs or ERPs.

To support these workflows, we've introduced the bulk product upsert endpoint:

POST /api/v1/products_bulk_upsert

This endpoint allows clients to create or update products and variants in bulk.

Important characteristics:

  • Asynchronous processing
  • Supports both product and variant updates
  • Suitable for full or partial catalog synchronization from external systems

Instead of processing the entire request synchronously, the API creates a background job that performs the operation.

For the complete request structure and supported fields, see the Bulk Product Upsert operation in the API reference.

Background Jobs system​

Bulk operations through the API require a safe way to process large tasks without affecting store performance.

OpenTiendas now includes a background Jobs system designed to support API-triggered asynchronous operations.

When an asynchronous operation is triggered (such as products_bulk_upsert), the API creates a Job responsible for executing the task.

Jobs provide:

  • Background execution of heavy operations
  • Status monitoring
  • Execution logs
  • Result inspection

A new Jobs section is available in the backoffice under: Settings → Advanced Options → Jobs

From this interface, administrators can inspect running tasks, review logs, and check the outcome of these async API operations.

What's next​

With product retrieval and bulk catalog updates in place, the next steps focus on:

  • Direct access to list product variants.
  • Improving catalog synchronization workflows.
  • Bulk updates at the variant level to support additional integration scenarios.
  • Expanding the API with Orders.

👉 API Overview