pro sku diesen sql
SELECT CONCAT(
o.increment_id, ‘:’,
r.sku, ‘:+’,
ABS(SUM(r.quantity)), ‘:’,
r.stock_id
) AS comp_line
FROM inventory_reservation r
JOIN sales_order o
ON (
o.increment_id = JSON_UNQUOTE(JSON_EXTRACT(r.metadata,’$.object_increment_id’))
OR o.entity_id = CAST(JSON_UNQUOTE(JSON_EXTRACT(r.metadata,’$.object_id’)) AS UNSIGNED)
OR JSON_UNQUOTE(JSON_EXTRACT(r.metadata,’$.object_increment_id’)) =
CONCAT( (SELECT s.code FROM store s WHERE s.store_id = o.store_id), ‘-‘, o.increment_id)
)
WHERE r.stock_id = 1
AND r.sku = ‘51211001’
AND JSON_UNQUOTE(JSON_EXTRACT(r.metadata,’$.event_type’)) = ‘order_placed’
AND (o.state = ‘holded’ OR o.status = ‘holded’)
GROUP BY o.increment_id, r.sku, r.stock_id;
Ergebnis einfach (in phpmyadmin) kopieren und hier einfügen (oben zeilenweise) z.B.:
printf “000000107:51211001:+10.0000:1
4000000003:51211001:+10.0000:1
CH-A1000000004:51211001:+10.0000:1
CH-A1000000005:51211001:+10.0000:1
” | maglive inventory:reservation:create-compensations
in Konsole ausführen
danach
maglive indexer:reindex inventory
-> Hinweis: Nicht auslösen bei Produkten, die in aktuell noch offenen Bestellungen sind, sonst entstehen neue Differenzen
Ticket: https://app.asana.com/1/35897865418996/project/1198509489299789/task/1211150444990760?focus=true