When migrating multiple Magento websites to Shopware 6 via migrations assistant, you can end up with the same customer account (aka email address), not being a guest and no sales_channel attached.
To find the customers, you can run the following SQL query, it will show you the email address, the ids of the customer rows and the count.
SELECT email, GROUP_CONCAT(id SEPARATOR ', '), COUNT(*) c FROM customer WHERE guest = 0 AND bound_sales_channel_id IS NULL GROUP BY email HAVING c > 1;
I was grepping through vendor/shopware/core for the hidden-gems series and stumbled over Shopware\Core\Service\AllServiceInstaller. Two-argument constructor, twelve lines of logic, @internal. Nothing dramatic — until I read what it actually does: it installs apps on your shop. By itself. In production. Once a day. Unless you told it not to. So this one isn’t going to […]
Twenty-three parts into this series, my research folder still has a stack of finds that are real, useful, undocumented — and about two paragraphs big. Instead of stretching each into a full post, here’s the lightning round. One problem, one gem, one file reference. Go. 1. rawUrl() — URLs for mail templates that actually work […]
A slow-burn bug report, verbatim from memory: „Google Search Console shows our sitemap is three months old. New categories aren’t in it.“ Three months. No errors in the log worth noticing, the scheduled task looks healthy, and regenerating „worked“ — or seemed to. The cause turned out to be a mechanism that’s completely reasonable and […]
