Go to Bottom

Alternate Barcodes & SKUs Tab of the Inventory Screen

In this Topic: ShowHide

Overview

Use the Alternate Barcodes & SKUs tab to create, view, and edit any alternate barcodes or SKUs associated with a given product. The Inventory screen synonymous with the Microsoft Access Form Object or user interface. can be accessed from the Main Menu of the Order Manager.

This feature is helpful when the same product is sold at various Web sites using different barcodes or SKUs at each location. By entering all of the different SKUs that are used at various web sites (shopping carts) into the Alternate Barcodes & SKUs tab for the given product, the Order Manager can recognize orders for those Web SKUs and translate them into the Primary product SKU the abbreviation for Stock Keeping Unit; a unique identifier used to track product inventory as orders are imported. (LocalSKU)

Likewise, if the same item is purchased from multiple suppliers and each supplier vendor uses a different barcode for the item, each of the supplier barcodes can be entered on the Alternate Barcodes & SKUs tab of the given product record. When the various supplier barcodes are scanned, the Order Manager will recognize each of them as the Primary product (LocalSKU).

Alternate SKUs cannot be selected as line items when placing a Manual Order or when revising line items on orders.

Description of the Alternate Barcodes & SKUs Tab

Figure 1: Inventory screen - Alternate Barcodes & SKUs tab

Fields and Controls on the Alternate Barcodes & SKUs Tab

Alternate Barcodes List

• this box will contain any alternate barcodes that have been defined for the selected product

• refer to topic, Alternate SKUs, for more information

Delete Button

• select to mouse "left-click" on an object, usually a row in a table, in the context of Order Manager documentation an entry in the Alternate Barcodes list and click the Delete button to disassociate the chosen barcode from the current product record

Alternate SKUs List

• this box will contain a list of any Alternate SKUs that have been associated with the current product record

Add Button

• click this button to open a dialog box where an Alternate SKU can be defined; click the [OK] button to associate the new Alternate SKU with the current product record

Delete Button

• select an entry in the list and click this button to remove the chosen Alternate SKU from the list and disassociate it from the current product record

Associated Shopping Carts List

• alternate SKUs can be associated with a particular instance of a shopping cart an e-commerce software system that allows a merchant to sell products on the Web. In the context of the Order Manager, it refers to the settings that describe a merchants web store to the program, allowing it communicate with the online shopping cart and import orders, and other information etc. system for which inventory synchronization is enabled
• double-click on a shopping cart definition to associate or disassociate it with the current Alternate SKU

Product Data Override

• enter a value different from that of the Primary SKU, if desired
• if no value is entered in these fields, the Alternate SKU will inherit the values in these fields of the Primary SKU record

Replaces this old SKU

• if the current product record is taking the place of another SKU that is no longer available or discontinued, enter the SKU that is being retired into this field

Browse Button

• click this button to use the Search Inventory/Select a Product screen to locate the SKU that is being retired

Adding Alternate Barcodes & SKUs to a Product Inventory Record

1. Navigate to the inventory record of the product that will have an Alternate Barcode or SKU assigned to it.

2. Click on the [Alternate Barcodes & SKUs] tab.

3. To enter an alternate barcode:

   1. scan the alternate barcode

   2. enter [A] in the input field of the Which barcode was just scanned? screen

Figure 2: Which barcode was just scanned? screen

1. 3. click [OK] and the numbers that make up that barcode will be listed in the Alternate Barcodes list box  

4. To enter an alternate SKU:

   1. click the [Add] button next to the Alternate SKU list box

   2. enter the alternate SKU in the text field when prompted by the program

Figure 3: Enter Alternate SKU prompt

1. 3. click [OK] to have the new alternate SKU associated with the current product record; it will now appear in the Alternate SKUs list box

Replacing a SKU with Another SKU

1. Navigate to the inventory record of the SKU that will replace another discontinued or unavailable product SKU.

2. Click on the [Alternate Barcodes & SKUs] tab.

3. Click the [Edit] button in the upper right-hand corner of the Inventory screen to unlock the field.

4. Enter the replacement SKU by one of two ways:

   1. Type in the SKU of the product that it replaces in the Replaces this old SKU field.

   2. Use the [Browse] button to open the Search Inventory/Select a Product screen and locate the SKU that will replace the existing inventory item. Then select the desired item from the search results list of the Search Inventory screen and then click the button labeled [OK - Use Selected Item]. The discontinued or unavailable item's SKU appears in the Replaces this old SKU field.

Figure 4: Find a Product/Search Inventory

1. 3. Then select the desired item from the search results list of the Search Inventory/Find a Product screen and then click the button labeled [OK - Use Selected Item]. The discontinued or unavailable item's SKU appears in the Replaces this old SKU field.

Figure 5: Alternate Barcodes & SKUs tab

5. Click the [Save] button to retain the change.

Created: 1/11/11

Modified: 2/6/12

Go to Top