Deleting PLU from the Imported Items in Bulk

If you need to import a large number of items with PLU codes and after the import, you need the items have the UPC codes instead of PLU, you can do it easily with Import Tool. You can delete the PLU codes from the imported items in bulk first, and then to save the items with automatically generated UPC codes to your location. For details, see the step-by-step procedure below.

1. Prepare the source file for import with the Price Book items.

Make sure the SKU Type value in the file equals to 4. For details, see Preparing a File for Data Import.

2. Import the file to the buffer.
How to import the file into the buffer

1. Go to Operational Menu > Price Book and then click Items.
2. Go to Drafts and create a new draft. For details, see Working with Drafts List.
3. Go to the Data Sources Panel and then click the Add More button.
4. Click From file > Browse and select the prepared file.
5. Click Load Data Source.

To see the full procedure for importing data from file with, go to the Importing Data from File section.

3. Delete the PLU codes from imported items in bulk.
How to delete PLU codes from items in the buffer in bulk

1. In the buffer, select all items.
2. In the PLU column, delete the PLU code value for one item.
3. Click any empty space on the form.

4. In the confirmation window, click Yes, to confirm the PLU code values deletion for all selected items.

   

Result: The PLU codes are deleted. The UPC codes are generated automatically by the system.

4. Select all items and click Save To, to save the items to the draft.

   

By default, all selected items are saved to the current draft. If you want to change the draft, to the right of the Save To button, click the drop down arrow, select the draft you need, and then click Save To.

5. Go to Operational Menu > Price Book and then click Items.
6. Go to Drafts and select the draft to which you saved the items from the buffer.
7. Select all items in the draft and export them to your location.
1. To the right of the Save To button, click the drop down arrow and select the location.
2. Click the Save To button.

   

To see the full procedure for exporting items from the draft to a location, go to the Exporting Draft Data to a Location section.