[LSR] Changing Item Categories by Exporting and Reimporting in Lightspeed Retail R Series

It is important you save a backup copy of the initial items you exported in case you need to revert back. If you want, you can run a test run with just an item or two first to understand the process and review the results. 

In Lightspeed Retail R Series.

1. Go to "Inventory" -> "Item Search".
2. Filter by your desired category.
3. Export.
4. Save a backup copy.

In Excel.

1. In Excel.
2. Left click the System ID column (should be column "A"), to highlight the entire column.
3. Right click the System ID column and select "Format Cells".
4. Select "Custom".
5. Under Type, change "General" to "#".
6. Click "OK" (This is to expose the entire System ID).
7. Change the Category to your new desired category.
8. Remove all other columns so you only have the System ID and Category columns in the spreadsheet.
9. Save the spreadsheet with a different name.

In Lightspeed Retail R Series.

1. In LS POS go to "Inventory" -> "Import Items".
2. Click "Choose File".
3. Select the file just saved.
4. Select import method "Update Items Only".
5. Match on field "System ID".
6. Be sure the columns mapped are the System ID and Category.
7. Click "Review Import".
8. Once okay, select "Import Items".