README

A Shopware 6.7 plugin that automatically sets the primaryOrderTransactionId field for orders created via the API.

Problem

Shopware 6.7 introduced a new primary_order_transaction_id column on the order table. The admin order list uses this field to display the payment status via order.primaryOrderTransaction.stateMachineState.

However, this field is only set through the cart/checkout flow (OrderConverter). Orders created directly via the Admin API — for example by ChannelEngine, ERP systems, or migration tools — do not go through this flow, leaving the field NULL. As a result, the payment status column in the admin order list is empty for these orders.

This is related to the same Shopware core issue as the delivery fix (see shopware/shopware#14051).

Solution

This plugin registers an event subscriber on order_transaction.written. Whenever a transaction is created for an order that has no primaryOrderTransactionId set, the plugin automatically assigns the first transaction as the primary one.

Requirements

• Shopware 6.7.x
• PHP 8.2+

Installation

Via Composer (recommended)

composer require mavimedia/shopware6-primary-order-transaction
php bin/console plugin:refresh
php bin/console plugin:install --activate PrimaryOrderTransaction
php bin/console cache:clear

Manual

Copy the plugin directory to custom/plugins/ or packages/, then:

php bin/console plugin:refresh
php bin/console plugin:install --activate PrimaryOrderTransaction
php bin/console cache:clear

Fixing existing orders

This plugin only handles new orders going forward. To fix existing orders with a missing primaryOrderTransactionId, run the following SQL on your database:

UPDATE `order` o
INNER JOIN `order_transaction` ot
    ON ot.order_id = o.id
    AND ot.order_version_id = o.version_id
SET
    o.primary_order_transaction_id = ot.id,
    o.primary_order_transaction_version_id = ot.version_id
WHERE o.primary_order_transaction_id IS NULL;

Then clear the cache:

php bin/console cache:clear

License

MIT