5

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.

Namu
  • 103
  • 2
  • 6

2 Answers2

12

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

HybrisHelp
  • 5,518
  • 2
  • 27
  • 65
  • 1
    Thanks for your prompt answer. As mentioned in post, I'll try SQL query to correct my data. – Namu Apr 24 '18 at 10:59
  • I am glad that post helps you!! If you need more help, edit the question with more details, I am happy to answer it. – HybrisHelp Apr 24 '18 at 11:02
1

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

delete FROM itemtype WHERE (TypePkString='8796149088338')
Rohit Gupta
  • 4,022
  • 20
  • 31
  • 41
user21614604
  • 11
  • 2
  • 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](/help/how-to-answer). – Community Apr 15 '23 at 10:00