We are developing a customers shop and want to develop locally, but without all the user / order data.
How can we achieve this?
The question has those points:
You can use the smile SA gdpr dump to create a anonmyized dump which is fine for development.
This can be either stored in GIT or downloaded from the production server or you might setup another server to store those dumps.
There is also a nice script from kellerkinder especially for shopware 6 https://github.com/kellerkinderDE/shopware6-database-dump
To import just use mysql --force -u -p my-database < dump.sql
