The Bulk Edit Utility lets you modify the default settings and the Product details of all the selected products in a bulk mode.
Modifying Default Settings
The Default Settings tab enables you to change the settings of products for certain zones by changing pricing, rounding values, pricing suppliers, etc.
To modify the default settings:
1. In the RPM menu, click Product File Management and then click Bulk Edit Utility.
The Bulk Editing screen is displayed and Default Settings is selected by default.
NOTE
If making a change for all Zones, select Default Zone only. If making a change for a Zone other than the Default Zone, this will change the setting at product level for that Zone only and will differ from the Default Zone
2. Select the Product(s) you wish to edit. If you wish to edit all the products, Select All. You can also use the various filters to select the products.
3. Select the appropriate filters.
4. Enter the following information.
| Fields | Descriptions |
|---|---|
| Pricing | The pricing policy that will be implemented for the Zone. The options in the drop-down list are populated from the Pricing Policy menu under Options. For more information, refer to Pricing SetUp. |
| Rounding | The rounding rule that will be implemented for the Zone. The options in the drop-down list are populated from the Rounding SetUp menu under Options. For more information, refer to Rounding SetUp. |
| Pricing Supplier | The Supplier that determines the Product list/base pricing. The options in the drop-down list are populated based on suppliers available in Wholesaler Products. For more information, refer to Wholesaler Products. |
| Preferred Supplier | The preferred Supplier for the Zone. The options in the drop-down list are populated based on suppliers. For more information, refer to Wholesaler Products. |
| POS Message | The desired point of sale (POS) message to appear on the register when the Product is sold. |
| Markup % | The percentage markup used to obtain the retail price for the selected Zone. |
| Fixed Retail | The fixed retail value in dollars. This field will be implemented only if the pricing policy is set to Fixed Retail. |
| Min SOH | The minimum stock level held by Stores within the selected Zone This information will be sent to Stores assisting in the ordering process. |
| Min Ord Qty | The minimum Order quantity when ordering from the Preferred Supplier. |
| Discount % or $ | The amount or percentage of discount applied to the Product. This discount will be applied via LOTS POS. By default, the discount is defined as the dollar, for example, 10 = $0.10 To enter the percentage amount, type the figure followed by the percentage sign (%), for example, 15%. |
| Club Points | The amount of club points allocated per dollar when the Product is sold in the Zone. |
| Ask Price | The option will allow the salesperson to enter a price when selling the Product. This is often used for products like gift lines. |
| Product Label | The option will allow the printing a Product label for every new Product received in a delivery, if enabled. |
| Shelf Label | The option will allow the printing of a new shelf label when the Product’s price changes for Active products, if enabled. |
| Price on Label | The option will enable the sales person to print the price of the Product on the Product Label. |
| Seasonal | The option defines if the Product sales are impacted by seasonality. The setting will influence the Order quantity when generating an Order via LOTS Orders . |
| Re Order | This option will enable the sales person to continue ordering the Product. If a specific Product is discontinued, you can deselect this option. |
| Discount Allowed | This option defines whether a discount can be applied to this Product at the register. |
| Active | This option defines if the Product is managed and therefore sent to the Stores. If a Product is not ‘active’ (not selected) it will not be controlled by RPM. |
| Update Prices | The option defines if the retail price will be updated for the Product at the LOTS store. |
5. Select Apply Settings.
6. On the confirmation message, select Yes.
NOTE
Make sure to check the number of products and zones.
7. On the confirmation message, select OK.
The default settings will be modified. Go to Product Details tab.
Modifying Product Details
The Product Details tab enables you to change the Department, Sub Department, manufacturer, etc. of the selected products.
To modify the Product details:
1. On the Product Settings tab, select the Product you wish to edit.
If you wish to select all the products, Select All. You can also use filters to locate the products.
2. Select the Default Zone in Default Setting and select Product Details.
3. Enter the following information.
| Fields | Descriptions | ||
|---|---|---|---|
| Department | The Department to which you wish to allocate the Product. | ||
| Sub Department | The Sub Department to which you wish to allocate the Product. | ||
| Manufacturer | The manufacturer to which you wish to allocate the Product. | ||
| Memo | The additional information you wish to allocate to the Product. | ||
| GST Buy | The GST percentage to be applied for buying the Product. | ||
| GST Sell | This is the GST percentage to be applied for selling the Product. | ||
| Update Barcodes | If selected, the Supplier Price File updates will update the barcode information on this Product. | ||
| Update Description | If selected, the Supplier Price File updates will update the description of the Product to match what the Supplier has sent through. | ||
| Update GST | If selected, the Supplier Price File updates will update the GST of this Product. | ||
| Update Manufacturer | If selected, the manufacturer details are updated by the Supplier price file. | ||
| Product Description – Search & Replace | The Product description allows you to search for a particular word and replace it with a new word.
|
4. Select Apply Settings.
5. On the confirmation message, select Yes.
NOTE
Make sure to check the number of products.
6. On the confirmation message, select OK.
The Product details will be modified for all the selected products and added to the Products section.
