How to remove all records of the table in Hybris?

Question

In my development environment, I have added wrong data to my custom ItemType. Now I want to remove all data for that Type. Basically I want to truncate my ItemType table.

Overeat

Answer 1

Run the below Impex (Change MyItemType with your ItemType)

$targetType=MyItemType
REMOVE $targetType[batchmode=true];itemtype(code)[unique=true]
;$targetType

---

You can also run SQL query from HAC, refer this post for more detail

Irrawaddy

Thanks for your prompt answer. As mentioned in post, I'll try SQL query to correct my data. – Overeat

I am glad that post helps you!! If you need more help, edit the question with more details, I am happy to answer it. – Irrawaddy

Answer 2

You can run this using commit mode on SQL Query in hac by giving TypePkString as input

delete FROM itemtype WHERE (TypePkString='8796149088338')

Wellinformed

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center. – Wildee