DocumentationCommerceOptimizer Connector

[PaaS only]{class="badge informative" title="Applies to Adobe Commerce on Cloud projects (Adobe-managed PaaS infrastructure) and on-premises projects only."}

Feed table schema reference

Last update: June 23, 2026

CREATED FOR:

  • Intermediate
  • Admin
  • Developer

Every feed has a dedicated MySQL table in the Adobe Commerce database. All feed tables share the same column structure.

Supported feeds

For the full list of supported feeds with API endpoints, batch limits, indexer names, and feed table names, see Connector modules and feed endpoints.

Schema

Column
Type
Description
id
INT (PK)
Auto-increment primary key
source_entity_id
INT
Entity ID from the Commerce source table (for example, catalog_product_entity.entity_id)
feed_id
VARCHAR
Unique identifier for a feed item. Computed as a hash of the item’s identity fields (for example, sku + storeViewCode), not an auto-increment value.
feed_data
JSON
Feed payload for this item. Only minimal information as entity identifier and scope is populated. When PERSIST_EXPORTED_FEED=1 is set, full payload is stored.
feed_hash
VARCHAR
Content hash used for change detection. Computed from the payload, excluding timestamps (modifiedAt, updatedAt). If the hash matches the previous export, the item is not re-submitted.
is_deleted
TINYINT
Soft-delete marker. Set to 1 when the entity is deleted in Commerce.
modified_at
TIMESTAMP
Last time this feed item was modified
status
INT
Submission status code from the last export attempt. See Feed submission and error handling.
errors
TEXT
JSON-encoded error details returned by the Commerce Optimizer API for this item
metadata
JSON
Internal sync flags and lock metadata info used by the export framework

Common diagnostic queries

Use the following SQL queries to inspect feed table state directly. The feed_data column stores data in Adobe Commerce Optimizer API format. Replace placeholder values such as <SKU>, <ATTRIBUTE_CODE>, <SLUG>, and <PRICE_BOOK_ID> with actual values from your environment.

Products feed - by SKU:

SELECT JSON_EXTRACT(f.feed_data, '$.sku') AS 'SKU',
       JSON_EXTRACT(f.feed_data, '$.source.locale') AS 'locale',
       f.status, f.modified_at, f.is_deleted, f.errors
FROM cde_products_feed f
WHERE JSON_EXTRACT(f.feed_data, '$.sku') IN ('<SKU>');

Product attributes feed - by attribute code:

SELECT JSON_EXTRACT(f.feed_data, '$.code') AS 'code',
       JSON_EXTRACT(f.feed_data, '$.source.locale') AS 'locale',
       f.status, f.modified_at, f.is_deleted, f.errors
FROM cde_product_attributes_feed f
WHERE JSON_EXTRACT(f.feed_data, '$.code') IN ('<ATTRIBUTE CODE>');

Categories feed - by URL path:

SELECT JSON_EXTRACT(f.feed_data, '$.slug') AS 'slug',
    JSON_EXTRACT(f.feed_data, '$.source.locale') AS 'locale',
    f.status, f.modified_at, f.is_deleted, f.errors
FROM cde_categories_feed f
WHERE JSON_EXTRACT(f.feed_data, '$.slug') IN ('<SLUG>');

Prices feed - by SKU:

SELECT JSON_EXTRACT(f.feed_data, '$.sku') AS 'SKU',
       JSON_EXTRACT(f.feed_data, '$.priceBookId') AS 'price book ID',
       f.status, f.modified_at, f.is_deleted, f.errors
FROM cde_product_prices_feed f
WHERE JSON_EXTRACT(f.feed_data, '$.sku') IN ('<SKU>');

Price books feed - by price book ID:

SELECT JSON_EXTRACT(f.feed_data, '$.priceBookId') AS 'price book ID',
    JSON_EXTRACT(f.feed_data, '$.name') AS 'name',
    JSON_EXTRACT(f.feed_data, '$.parentId') AS 'parent price book ID',
    JSON_EXTRACT(f.feed_data, '$.currency') AS 'currency',
    f.status, f.modified_at, f.is_deleted, f.errors
FROM cde_price_books_feed f
WHERE JSON_UNQUOTE(JSON_EXTRACT(f.feed_data, '$.priceBookId'))  IN ('<PRICE_BOOK_ID>');
Related Articles
recommendation-more-help
commerce-help-aco-connector