How to Change SKUs

Contents of this Topic: ShowHide

Select a Group of SKUs to Change

For this example we will change a group of SKUs that Begin with "123" to "abc":

1. Click the radio button labeled Begin with.

2. Enter "123" in the unlabeled text field immediately below the "Change SKUs that" radio buttons.

3. Enter "abc" in the To text field.

4. Click the [Build List] button.

5. Review the proposed changes in the New SKU the abbreviation for Stock Keeping Unit; a unique identifier used to track product inventory column of the right-hand pane.

6. Click the [Test SKUs] button to check for possible errors.

7. If the changes were tested successfully, click the [Make Changes] button to make the changes permanent. The program will prompt the user for confirmation once again before making the requested changes.

8. Click [OK] to proceed with the changes, or [Cancel] to abort the change request.

Select a Single SKU and Add it to the List of SKUs to Change

Method 1 - Using the Search Button

For this example, we will add another single SKU that does not meet the pattern in the previous example to the list of SKUs to be changed.

1. Click the [Search] button, which opens the Search Inventory screen synonymous with the Microsoft Access Form object or graphical user interface (GUI).

   

   Search Inventory screen

    

2. Use any of the fields on this screen as criteria to locate the SKU in question. In this example, we are looking for a SKU that contains "book" as part of the SKU. The result is seen in the Select to "left-click" the mouse on an object, usually a row in a table, in the context of Monsoon OMS documentation a Product section of the screen.

3. Click on the SKU in the Select a Product section.

4. Click the [OK - Use Selected Item] button.

5. The Change SKU screen appears with the SKU we selected in the Select SKU to Modify pane.

6. Click the [Add to list] button to move it to the list in the right-hand pane.

7. Click the [Test Changes] button to check for possible errors.

8. If that is all of your changes, you would then click the [Make Changes] button; however, we are going to continue with another example of how to select a single SKU.  

Method 2 - Using the "SKUs " Buttons

Let's assume that we also want to change the SKU of an inventory item that starts with the letter "b".

1. Click the button labeled "B" in the SKUs section.

2. The Select SKU to Modify pane now contains a list of all SKUs that start with the letter "B".

3. Select a SKU from the list and click the [Add to List] button move the right-hand pane.

4. Enter the value "sofabed1" in the New SKU column for "bed1".

5. Click the [Test SKUs] button.

6. If there are no errors, click the [Make Changes] button to execute the changes to all of the records in the right-hand pane.

7. The program will prompt for confirmation before making the changes.

8. Click [OK] to proceed with the changes or [Cancel] to abandon the changes.

9. Click [OK] again to acknowledge the completion of the process.

Additional Information

Created: 7/15/11

Revised: 4/23/12

Published: 04/13/16