How to hard delete product records in bulk
Hi Team,
I accidentally imported lots of data with incorrect skus. So is there a way I can delete all products without running destructive pipeline.
I checked in Product Facade, but it does not have hard delete api available.
Answers
-
I can suggest you some "unofficial" way to get rid of them.
If you only imported the products (without publishing) you can easily delete them via SQL. Could be a couple of cascaded deletes on different tables. If they are already published, you should update the products first (is_Active = false) and retrigger product events to make sure the products getting deleted from Elastic, etc. Afterwards you can delete the rows and cleanup.
1 -
Hi @Fred Jung ,
Thanks for your detailed explanation,
0 -
@vinod.agarwal your answer was cutted :)
1
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 69 Spryker News
- 899 Developer Corner
- 760 Spryker Development
- 83 Spryker Dev Environment
- 361 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 24 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 68 Spryker Safari Questions
- 50 Random