select item_id from 0p4_item where item_code 
in (
'UNI-UMN S 38DF-ACGN',
'UNI-UMN S 38DF-PYRD',
'UNI-UMN S 38DF-NMBU',
'UNI-UMN S 38DF-SSGY',
'UNI-UMN S 38DF-CPBR',
'UNI-UMN S 38DF-MGOR',
'UNI-UMN S 38DF-BK1',
'UNI-UMN S 38DF-BK2',
'UNI-UMN S 38DF 3C-PX',
'UNI-UMN S 38DF 3C-DN'
);

update 0p4_item set item_code='UNI-UMN SDS 38-AAG',art_no='UMN SDS 38-AAG',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- AVOCADO GREEN'
where item_code='UNI-UMN S 38DF-ACGN';

update 0p4_item set item_code='UNI-UMN SDS 38-APR',art_no='UMN SDS 38-APR',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- POPPY RED'
where item_code='UNI-UMN S 38DF-PYRD';

update 0p4_item set item_code='UNI-UMN SDS 38-ANB',art_no='UMN SDS 38-ANB',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- NEMOPHILA BLUE'
where item_code='UNI-UMN S 38DF-NMBU';

update 0p4_item set item_code='UNI-UMN SDS 38-ASG',art_no='UMN SDS 38-ASG',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- SESAME GREY'
where item_code='UNI-UMN S 38DF-SSGY';

update 0p4_item set item_code='UNI-UMN SDS 38-ACB',art_no='UMN SDS 38-ACB',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- CAPPUCINO BROWN'
where item_code='UNI-UMN S 38DF-CPBR';

update 0p4_item set item_code='UNI-UMN SDS 38-AMO',art_no='UMN SDS 38-AMO',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- MANGO ORANGE'
where item_code='UNI-UMN S 38DF-MGOR';

update 0p4_item set item_code='UNI-UMN SDS 38-AMB',art_no='UMN SDS 38-AMB',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- MICKEY BLACK'
where item_code='UNI-UMN S 38DF-BK1';

update 0p4_item set item_code='UNI-UMN SDS 38-ATB',art_no='UMN SDS 38-ATB',description='UNI-BALL ONE DISNEY FIKA 0.38MM -- TOY BLACK'
where item_code='UNI-UMN S 38DF-BK2';

update 0p4_item set item_code='UNI-UMN SDS 38 3C-AT',art_no='UMN SDS 38 3C-AT',description='UNI-BALL ONE DISNEY FIKA 0.38MM 3 COLOR SET  --  TOY'
where item_code='UNI-UMN S 38DF 3C-PX';

update 0p4_item set item_code='UNI-UMN SDS 38 3C-AM',art_no='UMN SDS 38 3C-AM',description='UNI-BALL ONE DISNEY FIKA 0.38MM 3 COLOR SET  --  MICKEY'
where item_code='UNI-UMN S 38DF 3C-DN';