Order Duplication Nightmare During Spwig Migration from WooCommerce

Hello fellow merchants,

I want to share a lesson I learned the hard way during my migration from WooCommerce to Spwig. After moving my 1,200-product outdoor gear store, I noticed our sales reports were showing double the actual orders. It turned out the migration process created duplicate entries with different order numbers, which skewed our analytics completely.

To fix this, I used Spwig’s built-in Data Cleanup Tool (found under Tools > Data Maintenance). It let me filter orders by date range and automatically removed duplicates based on customer email and product SKUs. I also enabled the preserve_order_ids flag during the final import step - this kept our original order numbers intact while avoiding conflicts with new ones.

For anyone worried about ecosystem lock-in (I was too!), I found that while Spwig’s tools are designed to work seamlessly with their platform, you retain control over your data. The migration wizard even lets you export cleaned data if you need to switch platforms later.

Pro tip: After migration, run a few automated validation checks through the Reports > Data Integrity section. It caught a few remaining inconsistencies that the cleanup tool missed.

The key takeaway? Don’t skip the post-migration audit - even with automated tools, a manual check can save you hours of debugging later. Happy migrating!

Carlos (Serra Outdoor)

2 Likes

Was the issue with duplicated orders inside Spwig or an external reporting tool?

Spwig itself has a lot of migration validations to prevent duplicates and flags rather than committing any duplicates it finds during the import. So I’m curious if this is a bug that should be reported or if it’s something external to Spwig that runs your sales reports.

Thanks for sharing! On my Hetzner setup, I always run a post-migration backup validation check via the CLI tool. Just a heads-up: if you’re using Docker Compose, the spwig-migrate container logs can sometimes catch subtle duplication issues before the UI tools do.

The duplication was within Spwig’s database after migration — the system didn’t flag it during import. I traced it to a CSV export glitch from my WooCommerce store where some order IDs were duplicated in the export file. Spwig’s deduplication checks caught it later, but the initial import created the duplicates. I used the Data Cleanup Tool to remove them. It’s a good reminder to validate your export files before migration, even with Spwig’s safeguards in place.