The steps for adding products from an archived catalog are the same as adding from the current catalog. See Use multiple versions of the same catalog for instructions on archiving a catalog.
-
Add the product from the archived catalog. You can drag and drop from the Explorer bar or use Insert.
-
Display the Alt MFG column.
Notice that the MFG code appears as though the item came from the actual manufacturer. In the example shown below, an item brought in has the original MFG code of AIS. The MFG code of the archived catalog is displayed in the Alt MFG column. This is how you can differentiate the archived catalog from the current one.
The Alt MFG value is important because it is used when doing an Update against catalog. Worksheet will check this field first. If there is no value, it will check MFG, then CAT.
You can change the Alt MFG value of items that are already in the worksheet by manually typing in the Alt MFG value, using Assign, or Block Assign. For example, if you inserted an item from the current catalog but you want an archived catalog’s pricing, simply change the Alt MFG of this item to the archived catalog's MFG code. Then do an Update against catalog.
As another example, if you inserted an item from the archived catalog but want to get pricing from the current catalog, simply delete the value in the Alt MFG column then do an Update against catalog.
Note: If you set the Alt MFG to an invalid one, the item gets flagged and a question mark is displayed in the Complete column.