i. Go to Set-Up → Items
ii. Click on ‘Export Item List to Excel’ button from tool strip (This will export all the items. If you want to export items of any particular category or user field, select it and export)
iii. Select the path where you want to save the excel file and click on ‘Save’
iv. You will get a success message, click on ‘OK’
v. The excel will be open. There will be a column ‘CATEGORY’. Change the category as required.
vi. Save the excel file and close it.
vii. Go back to Set-Up → Items and click on ‘Upload Items’ button from tool strip
viii. You will get a warning message to take database backup, click ‘Yes’ to take backup. If you have already saved the backup you can click on ‘No’. (It is recommended to take backup here as there will be bulk changes done to your database).
ix. A dialog box ‘Select Business Location’ will be open, click on ‘OK’
x. Select the excel file and click on ‘Start Import’. Click ‘OK’ when you get a successful upload message.
xi. Close the ‘Import Data For Items’ window.