canadasatellite-ca / site

The canadasatellite.ca website (Magento 2)
https://upwork.com/fl/mage2pro
0 stars 1 forks source link

All invoices between 2021-10-01 and 2021-10-09 do not have items #256

Closed dmitrii-fediuk closed 3 years ago

dmitrii-fediuk commented 3 years ago

E.g.: invoice 19914 (for order 54729) Related to https://github.com/canadasatellite-ca/bambora/issues/12

dmitrii-fediuk commented 3 years ago
SELECT i.entity_id, i.created_at, i.updated_at, i.base_grand_total, ii.entity_id
FROM sales_invoice i
LEFT JOIN sales_invoice_item ii
ON ii.parent_id = i.entity_id
WHERE ii.entity_id IS NULL
ORDER BY i.created_at ASC;

01