Supplier Product - Bulk Update

An extension of Supplier Product settings, the Supplier Product An inventory item in a package size available from a particular supplier. - Bulk Update page allows you to activate, deactivate and change the Show On PO, Current Price and Sequence of multiple supplier products easily.

To access Supplier Product - Bulk Update settings:

Click on on the quick links Located at the top right corner of a page, it contains icons that allow you to quickly access important pages. bar from any page.
In the Settings window:

Settings associated to a page automatically show in the List box. If the setting that you want to access is in the List box, you can skip step a.
1. Select Inventory from the Filter drop-down list.
2. Click on Supplier Product - Bulk Update from the List box in the left pane.

The following information is displayed on the settings page for the Area* and Store selected using the filters Drop-down boxes that let you select from the options available. at the top of the page:

Status: A checkmark in the column indicates that the supplier product An inventory item in a package size available from a particular supplier. can be ordered from the supplier using the Create Purchase Order page at present and can be included on invoices, while an empty box indicates that it cannot be ordered.
Show On PO: A checkmark in the column indicates that the item will show on the PO Product List when creating a PO for the supplier. An empty box indicates that the user will have to use the Quick Search bar on the PO Product List window to include the supplier product An inventory item in a package size available from a particular supplier. in the PO Purchase Order.
Description: The name of the supplier product An inventory item in a package size available from a particular supplier..
Code: The product code used for the product by the supplier.
Pack size: Also referred to as Per Method #1 in Physical Counts, it is the size or quantity of the inventory item considered as one unit by the supplier (for example, large case, box, etc.).
Current Price*: The last invoiced price of the supplier product An inventory item in a package size available from a particular supplier. for the store selected.

The Current Price is automatically updated each time the price is updated on an invoice.
Latest Price*: The last updated price of the supplier product An inventory item in a package size available from a particular supplier. and may not be effective as yet.
Supplier Name: The name of the supplier that supplies the product.
Sequence: The order in which the product is displayed on invoices and when creating a PO for the supplier.

Update Multiple Supplier Products

If the effective date for a price change is different for some products, follow the process listed below to update the price of products that share the same effective date and then repeat the process for each different effective date.

Go to Supplier Product - Bulk Update settings.
Select the Area* and Store from the drop-down list(s).
Select the Supplier, Sub-Category and Status from the drop-down lists if required.
Enter the Description of the supplier product An inventory item in a package size available from a particular supplier. or the Product Code, if required.
Select whether you'd like to view the Current price or the LatestPrice.
- Current: Will display the current effective price of the supplier products.
- Latest: Will display the last updated price (which may not be effective as yet) of the supplier product An inventory item in a package size available from a particular supplier..
Click on the Go button.
Place a checkmark in the Active column of a product or remove it to activate or deactivate it, respectively.
Place a checkmark in the Show On PO column of a supplier product An inventory item in a package size available from a particular supplier. to include it in the PO Product List by default, or remove the checkmark to remove the supplier product An inventory item in a package size available from a particular supplier. from appearing in the PO Product List by default.

Supplier products that are set not to Show On PO can still be added to the PO Product List by using the Quick Search bar on the page when creating the PO.
Enter the new price of the supplier product An inventory item in a package size available from a particular supplier. in the Current Price* or Latest Price* column to update it if needed.
Change the Sequence if required.
Select the Effective date for price changes from the drop-down calendar if you've changed any of the prices.
Click on the Submit button.
Click on the OK button in the confirmation pop-up box A box with a prompt that opens up when you click certain links or buttons in Clearview..

Related CLEARVIEW Pages

*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.