Removing items from Matrix in SQL

(0) Share

Report

Posted on by nilssongonsalves

I used a 3rd party tool to create items (DRS PowerTools) which let me add items, and helped me normalize entries quickly by using the matrix editor. Now that I'm integrating to shopify, these inapropriatley matrixed items are a problem. Manually removing them from the various matrix will take far too long (10,000 or so items). Can someone please confirm if this is the correct query to remove the item from the matrix? and If there are any other tables to update when doing this? any other handy sql queries that can be used to clean up this mess would be very appreciated.

DELETE FROM ItemClassComponent WHERE ItemClassID = 211 AND ItemID = 13417

*This post is locked for comments

I have the same question (0)