From Fishbowl Inventory

The pricing rule module allows you to markup or markdown your product prices for customers. Pricing Rules may apply to Specific Customers, Customer Groups, Products, and/or Product Trees. The pricing module is a convenient way to quickly and accurately provide price adjustments for your products.

A few main features of the Pricing Rule Module include:

• Setting quantities or date ranges per pricing rule
• Setting quick and easy discounts for temporary sales
• Providing discounts or specific prices for valued customers
• Specifying Cost Plus Pricing

You can duplicate pricing rules using the Duplicate button in the Module Toolbar. With a duplicated pricing rule you only have to change product and price for each given customer.

Contents 1 Create a New Pricing Rule 2 Edit or Delete a Pricing Rule 3 Duplicate a Pricing Rule 4 Adjust Prices Wizard 5 Applying Pricing Rules 6 Pricing Rule Precedence 7 Pricing Tiers 7.1 3 Tier Pricing Rules 8 Pricing Examples 8.1 Give VIP Customers a 10% Discount off the List Price 8.2 Give a Customer a Fixed Product Price 8.3 Markup prices 50% higher than their Average Cost 9 About the Pricing Rule Module 10 MODULE OPTIONS

Create a New Pricing Rule

To create a new Pricing Rule, first choose the New icon from the Module Toolbar. This will create a blank pricing rule on the main screen for you to enter the following information:

First, enter the Name and Description of your new pricing rule. Next, beneath the Apply to Customers(s) section choose whether this Pricing Rule applies to Everyone, a specific Customer, or a Customer Group.

Step two is to choose whether this rule applies to all Products, a single Product, or a Product Tree. If your rule applies to a specific product or product tree choose the appropriate items from the given drop-down menu.

Next, beneath the Apply Price Adjustment section you may choose the price adjustment for this rule. Your price adjustment options include: Markdown, Markup, Margin, Percent, Amount, or Fixed Price. The default percentage will be shown as 10%; however you may modify this percentage by entering your own number into the given field. Next, you may choose whether this rule is relative to the Product Price, Average Cost, Default Vendor Cost, Last Cost, List Price, or Standard Price. If you choose a flat rate, choose the Fixed Rate option and enter the appropriate amount in the given space.

Edit or Delete a Pricing Rule

Edit a Pricing Rule

In the Sales Module Group | Pricing Module double click on the name of the pricing module so it is displayed on the main screen. Once the rule is displayed, any of the following fields may be modified:

• Pricing Name and description
• Products rule is applied to
• Price Adjustment
• Whether or not to apply rounding
• Whether the rule is in an active or inactive status
• Customers the rule is applied for
• Min or Max Qty associated with the rule
• Date range associated with the rule
• Whether the pricing rule is Tier 2 or Tier 3

After the necessary fields have been adjusted, click Ok to save the changes. These changes will take effect on any Sales Orders created from here on out.

Delete a Pricing Rule

In the Pricing Module highlight the name of the pricing rule you would like to delete. Click the delete button from the Module Toolbar. A dialog box will be displayed asking if you are sure you would like to delete this pricing rule. click Yes.

A pricing rule may be set as Inactive by deselecting the Active icon located beneath the General subtab. Once a rule has been set inactive it will no longer be visible in the pricing rule module, nor will it apply to any orders. You may search for an inactive pricing rule through the Advanced Search tool located in the Search Panel of the pricing rule module. Once the inactive rule has been found and is displayed, you may re-activate the rule by checking the active box and choosing save from the Module Toolbar.

Duplicate a Pricing Rule

You may duplicate a Pricing Rule by simply clicking the Duplicate button located on the Module Toolbar. A confirmation box will be displayed asking if you are sure you wish to duplicate this pricing rule. Choose Yes. Fishbowl will immediately display a dialog box informing you of the pricing rule that was duplicated. Whenever a pricing rule is duplicated it will always be created as a 'Copy of ___'. After the rule is created you may change or edit any fields in the Main Screen if necessary. Make sure to save your changes by selecting the save button on the Module Toolbar.

Adjust Prices Wizard

The Adjust Prices Wizard allows the user to update your Product Price within the Product Module according to an existing Pricing Rule. For example, if you wanted to update all of the product prices to reflect a 50% markup from their average cost, you could do so through the Adjust Prices Wizard.

To adjust the price of a product affiliated with a Pricing Rule, choose the Adjust Prices icon located on the Module Toolbar of the Sales Module group | Pricing Rule Module. The Adjust Prices Wizard will be displayed. Choose the Pricing Rule from your given drop down menu that includes the product for which you wish to adjust the new price (options shown in the drop down menu must have previously been created via the Pricing Rules Module). Choose Next.

Step 2 of the Adjust Prices Wizard will provide a list of all the products to be affected. If your pricing rule specified for all products to receive a 50% markup from their average cost, then the Adjust Prices Wizard will indeed affect the prices of all products. Likewise, if your pricing rule only applied to a Product Tree, then only the products within that tree will be adjusted. After verifying the new prices in step 2, choose Finish to complete the wizard. The product prices will be adjusted immediately.

• Note: Pricing Rules that are created for the Adjust Prices Wizard should have the option Apply This Rule as products are added to a Sales Order (located beneath the Advanced Subtab) unchecked. This will insure that the Pricing Rule is applied when wanting to adjust the Product Price via the Adjust Prices Wizard, but will not adjust prices added to a Sales Order.

Applying Pricing Rules

Example 1:

You have a Customer Group labeled Valued Customers, and set a pricing rule to state that all of your Valued Customers receive a 20% discount (markdown) off the product price of all items. With the information shown below, each Valued Customer to purchase the super flash handlebars would receive $2.80 off their purchase, and $11.20 would show in blue on the Sales Order to confirm it has been modified from the List Price.

Item	Type	Price	Markdown	New Price
Super Flash Handlebars	20% Product Price Markdown	$14.00	-$2.80	$11.20

Example 2:

Your company desires to have a 100% markup on a certain product. Below the pricing rule has been established for Heavy Duty Water Bottles to be marked up 100% relative to the Average Cost. With the information shown below customers would be charged a markup of $3.00. The new price of $6.00 would show in blue on the Sales Order to confirm this price has been modified from the List Price.

Item	Type	Average Cost	Markup	New Price
Heavy Duty Water Bottles	100% Average Cost Markup	$3.00	$3.00	$6.00

Pricing Rule Precedence

Since you are not limited in the number of pricing rules that may be created, several rules may apply for the same customer or product (for example, a customer may exist in more than one Customer Group pricing rule, etc.) In cases such as these, the following rules apply:

1. Pricing Rules have a precedence in the following order:
   1. Customer Specific Pricing Rules
   2. Customer-Group Pricing Rules
   3. Fixed Pricing Rules
2. If multiple pricing rules exist for a product then the higher/lower (based upon the Pricing Rule Module Options) calculated price will be the price given on the Sales Order.
3. Pricing Rules referencing nodes lower in the Product Tree take precedence over rules assigned to higher nodes of the tree.
4. When two or more pricing rules are deemed valid, but each rule applies to a distinct Product Tree branch, rule 2 will be used to determine which rule to apply.

NOTE: When a price comes down from a previous tier it is just the price; not the pricing rule. So, for instance, if the winning rule from Tier 2 was a Customer Specific pricing rule and there is a Customer-Group Pricing Rule in Tier 3, the Customer-Group Pricing Rule would take precedence because the Tier 2 price is simply a price. It does not come down with the precedence of a Customer Specific Pricing Rule.

Pricing Tiers

Within Fishbowl, pricing tiers are available to allow multiple pricing rules to apply to the same product, customer, etc. For example, a company could set a Tier 2 pricing rule to mark up their products 100% from its average cost, and set another Tier 3 pricing rule to provide a temporary holiday discount off the Tier 2 pricing rule. In the Pricing Rule Module Options you have the option of choosing whether Tier 2 and Tier 3 look for the highest or lowest price from the previous tier. The following information explains how Fishbowl uses Pricing Tiers:

• Tier 1: Tier 1 will always be the Product Price. If no Tier 2 rules are defined, then the List Price will also be the Tier 1 price.
• Tier 2: Tier 2 will always be the List Price. By default, Tier 2 will look for the highest price.
• Tier 3: Tier 3 will be the price placed on the Sales Order. By default, Tier 3 will look for the lowest price.

3 Tier Pricing Rules

Your company has a pair of bike handlebars that cost you $5.00. Your Product Price is set to $8.00 (The Tier 1 price will always be the Product Price). However, you have pricing rules set for this product. The following represents the product's Tier 1 information:

Tier 1	Cost	Price
	$5.00	$8.00

For this example our Module Options state for Tier 2 to look for the highest price. Below you can see that this product has two Tier 2 pricing rules resulting in $10.00 and $7.50. Our price from Tier 1 will be brought down to be included with these prices, making the price options $8.00, $10.00, or $7.50. Because the module options for Tier 2 is set to take the highest price, $10.00 is determined to be the Tier 2 price. The Tier 2 price is considered to be the List Price.

Tier 2	Pricing Rules	Pricing Rule Outcome	Tier 2 Pricings
	100% > Average Cost	$10.00
	50%> Average Cost	$7.50 →	$8.00 (Pulled from Tier 1)
			$10.00
			$7.50

*NOTE* The List Price is always the price that was brought down from Tier 2. If no Tier 2 rules are defined, then the List Price is simply the Tier 1 price (ie. the Product Price). If Tier 3 establishes a price different than the List Price it will be displayed in blue while creating the Sales Order.

Your company now wants to have a 10% off List Price Labor Day Weekend Sale. A Tier 3 pricing rule would be created giving 10% off the List Price. The Module Option is set to look for the Lowest price from Tier 3. The highest price from Tier 2 will be brought down to be included in our Tier 3 prices, making our price options $10.00 and $9.00. Due to our Module Options set to take the lowest price, $9.00 will be the price placed on our Sales Order and will show in blue because it is different from the List Price established in Tier 2.

Tier 3	Pricing Rules
	10% < List Price	$9.00 →	$10.00 (highest price from Tier 2)
			$9.00

Pricing Examples

Give VIP Customers a 10% Discount off the List Price

Your company has a number of VIP customers who regularly purchase items from you. By creating a discount and assigning it to a Customer Group, you may efficiently ensure that all of your VIP's are well taken care of (customers must already be assigned to a Customer Group).

1. Choose the New icon from the Module Toolbar.
2. Enter a Name and Description for your Pricing Rule (ie: a name could be "VIP Customer Discount" with a description of "VIP customers receive a 10% discount off the List Price").
3. Beneath the Apply To Customers section, choose the Customer Group option. From here, you may choose your Customer Group from the given drop down menu (all customer groups must already be created through the Customer Module).
4. It is likely that a VIP Customer Group would receive a discount off all items, so beneath the Apply to Products section choose the All Products option.
5. Beneath Apply Price Adjustment choose to Markdown 10% relative to the List Price.
6. Choose Save from the Module Toolbar to save your changes.

Give a Customer a Fixed Product Price

Perhaps your company has a specific customer that receives a fixed price for a product. This may be a VIP customer, or perhaps they purchased an item with a guarantee to always receive an agreed upon price. For whatever reason, this customer will always receive the same price for a product. For Fishbowl to recognize a fixed price for this customer you must first create a Pricing Rule.

1. Select the New icon from the Module Toolbar.
2. Enter a Name and Description for your Pricing Rules (ie: A name could be "Fix-It Bike Shop" with a description of "Set Product Price for Bike BB2001")
3. Choose the Customer to whom this pricing rule will apply beneath the Apply To Customer section. Any customer shown in the given drop down menu will have already been created through the Customer Module
4. Due to the fact that this Pricing Rule will apply to only one product, choose the Product option beneath the Apply To Products section. Then choose the product this pricing rule applies to by selecting the product from the drop down menu (any product shown in this menu has already been created via the Product Module).
5. Beneath the Apply Price Adjustment section choose the Fixed Price option and enter the fixed amount of this product for the customer.
6. Choose the Save option from the Module Toolbar to save your changes.

Markup prices 50% higher than their Average Cost

Suppose your company has the intention of selling all your products for 50% more than their Average Cost. Use the following steps to create a pricing rule to define this.

1. Select the New button located on the Module Toolbar.
2. Enter a Name and Description for your Pricing Rule. (ie: 50% markup from Average Cost)
3. Beneath Apply to Customers choose "Everyone".
4. Since your company desires to sell all of your products at a 50% increase, choose to apply this rule to All Products.
5. Beneath the Apply Price Adjustment section, choose Markup.
6. Next to 'Markup', enter 50% relative to the Average Cost.
7. Choose Save from the Module Toolbar to save your changes.

• For additional advanced settings, choose the Advanced subtab where you may assign this pricing rule to specific dates or quantities.

About the Pricing Rule Module

General Subtab

To create a new Pricing Rule, first choose the New icon from the Module Toolbar. This will create a blank pricing rule on the main screen for you to enter the following information:

First, enter the Name and Description of your new pricing rule. Next, beneath the Apply to Customers(s) section choose whether this Pricing Rule applies to Everyone, a specific Customer, or a Customer Group.

Step two is to choose whether this rule applies to all Products, a single Product, or a Product Tree. If your rule applies to a specific product or product tree choose the appropriate items from the given drop-down menu.

Next, beneath the Apply Price Adjustment section you may choose the price adjustment for this rule. Your price adjustment options include: Markdown, Markup, Margin, Percent, Amount, or Fixed Price. The default percentage will be shown as 10%; however you may modify this percentage by entering your own number into the given field. Next, you may choose whether this rule is relative to the Product Price (price of the product within the Product Module), Average Cost, Default Vendor Cost, Last Cost, List Price (price on the Sales Order after it has been modified by pricing rules in other tiers), or Standard Price. If you choose a flat rate, choose the Fixed Rate option and enter the appropriate amount in the given space.

Advanced Subtab

When creating a New Pricing Rule, you have the option to offer advanced features such as Rounding. If desired, your company may choose to have all products round to the nearest $0.99.

You may also give a Date or time frame for when this rule will be valid; or if your pricing rule is only valid when a customer purchases a certain quantity amount, then you may specify a Minimum and Maximum amount beneath the Apply to Quantities section.

Pricing Rules may be set as Tier 2 or Tier 3 level pricing. By default, Tier 2 will look for the highest pricing level, while Tier 3 will look for the lowest pricing level. These options may be changed through the Part Module Options. For detailed information on Tier pricing, see Advanced Pricing.

Fishbowl will default to apply your new pricing rule as items are added to a sales order. If you do not wish for this to occur, simply deselect the checkbox that states, Apply This Rule as Products are Added to the Sales Order.

After all of the necessary information has been added to the Pricing Rule, click the Save icon located on the Module Toolbar to save your changes. Your pricing rule will be effective immediately to Sales Orders placed from this point onward.

Details Subtab

The Details subtab provides a Summary of Information regarding the pricing rule. Here you can view the day the rule was created, last modified, and who modified it. The Details subtab will also provide a summary of which customer the pricing rule has been set for, which products it applies to, and the dates and quantities (if any) associated with this rule.

Lastly, the Details subtab will provide a list of all the products this pricing rule applies to. From here you can view the List Price with the New Price being applied. Prices may not be edited here; However, the Product Price may be edited through the Adjust Prices Wizard.