Product

From Fishbowl

Jump to: navigation, search
Product
Training Videos
Product Training Videos
Related Pages
Part
Kitting
Inventory
Sales Order
Accounting
Work Orders

Icon.Product.png The Product module, located in the Materials group, keeps track of products. Products are items that are sold while parts are items that are purchased or manufactured. It is possible to have more than one product associated with the same part. When a part is created and marked to be sold, a product is automatically created. Products can also be imported from a spreadsheet.

Contents

Module buttons
Jump to top of page

New Button.png New creates a new product.

New Options Button.png New also gives the option to create a kit when clicking the drop-down arrow.

Save Button.png Save saves any changes made to the product.

Delete Button.png Delete deletes the product.

To Inventory Button.png Inventory opens the product in the Small.Inventory.png Inventory module.

Duplicate Button.png Duplicate creates a duplicate copy of the product.

Product Tree Button.png Product Tree opens the product tree.

Email Button.png Email opens a window to compose an email. If the module's default report is specified, the PDF report will be attached. Email can be configured on the Email tab of the Small.Company.png Company module.

Print Button.png Print sends the default module report to the printer.

How To Button.png How To opens this article in a web browser.

Refresh Button.png Refresh reloads whatever is currently open in the module.

Create a new product
Jump to top of page

Products can be automatically created when creating new parts. To manually create a new product, follow the instructions below.

  1. Click the New Button.png New button in the Small.Product.png Product module.
    Product general subtab.png
  2. Select a corresponding part.
  3. Enter the product info.
  4. Click the Save Button.png Save button.

Descriptions of each field can be found on the General tab. Products can also be imported from a spreadsheet.

Add a product image
Jump to top of page

To add a product image, click the Open Icon Button.png Open Image button located on the component toolbar to the right. Locate the image file and click Open. Click the Save Button.png Save button. The new image will also be visible in the search pane.

Add image.png

Image options.png

To upload pictures for multiple products at once, see Batch upload product pictures.

Batch upload product pictures
Jump to top of page

The Product import can be used to upload pictures for multiple products at once.

  1. Export the Product CSV by clicking the File menu, selecting Export, and then choosing Product.
  2. Choose a location to save the file.
  3. Browse to the location where the file was saved (Documents Folder by default) and open the file in a spreadsheet program like Excel.
  4. Type the path to the image file into the ProductPictureUrl column.
    • If the images are located in an images folder on the C: drive, the cell value would look similar to this:
      file://localhost/C:/images/B201.jpg
    • If the images are predictably named, a formula can be used to reference other cells. For example, if the image is named the same as the product number, then the product number field (A2) can be used in the formula. The same formula can be copied into all applicable cells. The formula would look similar to this:
      ="file://localhost/C:/images/"&A2&".jpg"
  5. Import the Product CSV by clicking the File menu, selecting Import, choosing Product, and then selecting the edited file.

TIPS

Modify or delete an existing product
Jump to top of page

To modify an existing product, double-click the product in the Search pane, and then double-click the product. The product details will appear on the right hand-side of the screen. After making any changes, click Save.

Once a product has been created and acquired a history, it cannot be deleted. However, a part can be inactivated through the Small.Product.png Product module.

  1. Choose the product to inactivate and select the General tab.
  2. Beneath the General Information section, deselect the Active box. The product will no longer be visible in the Small.Product.png Product module, or available for any orders.


Inactive product.png

To activate or view the part again, click the Advanced Search feature located next to the standard search button, search for the desired product, and select the Active box.

Duplicate a product
Jump to top of page

Use the following steps to duplicate a product in the Product Module.

  1. Locate the product to duplicate using the Search pane and double-click on it.
  2. Click the Duplicate Button.png Duplicate button located on the module toolbar.
  3. A dialog box will appear stating that the product was duplicated.

A duplicated product will always be named as a copy of the original. It can be renamed by editing the Product field and clicking the Save button on the module toolbar.

A duplicate product is still tied to the Part of the original product. Therefore, the inventory tied to the duplicate product will be the same as the original product. When a product is duplicated the Substitute, Pricing, and Memo tabs will not be copied over from the original product.

Assign substitute products
Jump to top of page

If a product with insufficient inventory is added to a sales order, Fishbowl will provide the option of selecting a substitute product which can be configured on the Substitute tab of the Small.Product.png Product module. To add a new substitute product, click the Add Icon Button.png Add button located on the component toolbar to the right and select a substitute product. The Substitute tab also displays which kits a product is included in.

Product substitute subtab.png

Assign multiple products per part
Jump to top of page

A product may not be assigned to multiple parts. However, a part may have multiple products assigned to it.

  1. Open the Details tab of the Small.Part.png Part module, which displays all of the products associated with a part.
    Parts Products.png
  2. Click the New Icon Button.png New Product button located on the right side of the Product section.
  3. The product number and description will be automatically entered.
  4. Enter any other applicable fields and then click the Save Button.png Save button.

Product tree
Jump to top of page

The Product Tree organizes products into categories and subcategories. This simplifies the process of applying pricing rules to groups of products, viewing sales by category, etc. A product can also be listed in multiple categories.

To access the product tree, click the Product Tree Button.png Product Tree button located on the module toolbar. The product tree window is divided into two basic sections. To create categories and to organize products, use the Product Tree pane on the left. To search and filter a list of products, use the Product Search on the right.

Product tree.png

Creating a new category

Categories can be imported into the product tree using a CSV import file, or they can be manually entered into the client.

To add a category manually, select the Product category in the Product Tree pane, click the New Icon Button.png Add Category button in the bottom left-hand corner of the screen, and enter the name and description of the new category.

To add a subcategory, follow the same process by selecting the desired parent category, clicking the New Icon Button.png Add Category button, and entering the subcategory name and description.

Product tree category.png

Adding products to the tree

Products can be imported into a category using a CSV import file, or they can be manually entered into the client. To move a product into a category manually, use the following steps.

  1. In the Product Tree window, highlight the desired category.
  2. On the right side of the screen search for the desired product using the product number, product description, part number, or through an advanced search.
  3. Select the desired product from the search results.
  4. Click the Left Arrow Icon Button.png Add Product button to move the product to the left side of the screen.

To edit the product tree or to delete portions, select the category, subcategory, or product to be modified and click the Edit Icon Button.png Edit button or Delete Icon Button.png Delete button at the bottom of the product tree pane. To refresh the product tree, click the Refresh Icon Button.png Refresh button.

For information on adding pricing rules to a product tree, see Small.Pricing Rule.png Pricing Rule module.

Associated pricing
Jump to top of page

Associated pricing allows additional costs to be tied to a specific product. For example, if a product has an additional charge for delivery, this could be added as an associated price on the Pricing tab.

To create a new associated price, go to the Pricing tab of the Small.Product.png Product module, and click the New Icon Button.png New button to the right of the Associated Prices pane. Enter the price and select the Associated Price Type. To create a new Associated Price Type, click the New Icon Button.png New button next to the Associated Price Type drop-down list.

To add associated pricing to a sales order, open the Small.Sales Order.png Sales Order module, and click the Add Icon Button.png Add Item button located on the right. Select Associated Price from the list of items to add to the sales order. Click Next, choose the correct associated price type from the drop-down list, and then click Finish. The total of the associated price line item will be the sum of all the associated prices for products above the line item.

Associated price.png

Associated Pricing can also be imported from a spreadsheet.

Associated products

Fishbowl provides the ability to add multiple products to a sales order simultaneously by using associated products. An associated product has the same name as the main product plus a special suffix to identify it as an associated product. Associated products are often used in industries where recyclable cores can be returned to offset the cost of a new item. For example, when selling a new car battery, an auto parts store may give a discount to a customer that returns an old battery. Below is one example of how associated products could be used with core products.

  1. Create a new part and product named Battery.
    Battery.png
  2. Create a new part and product named Battery-Core.
    Battery-Core.png
  3. Open Battery-Core in the Small.Product.png Product module and click the Details tab. Set the SO Item Type to Credit Return.
    Battery-Core Credit Return.png
  4. Click Tools on the menu bar, and open the Small.Product.png Product module options. Enter -Core% as the Associated Product Suffix. The % symbol functions as a wildcard search, meaning it will look for products named Battery-Core plus any other characters after that (for example, Battery-Core2 or Battery-CoreABC).
  5. Create a new sales order and add the Battery product. The Battery-Core product (and all other products that match the wildcard search) will be added automatically.
    Battery Core Sales Order.png

Associated products aren't limited to core products. By adjusting part types, default product types, prices, and suffixes, a company could use the associated product feature to fulfill various company needs, such as bundling products together (similar to a kit), adding service items or delivery fees (similar to associated pricing), or many other possibilities.

Search
Jump to top of page

To search for products, use the search pane on the left of the Small.Product.png Product module.

Product Search.png

The product search pane is displayed in other areas of Fishbowl, such as in the product tree window, and can also be found by clicking the Product Search Icon Button.png Search button in the Sales Order module, the Pricing Rule module, etc. The image and inventory data can be hidden by clicking the Tools menu, selecting Program Options, and then customizing the Inventory Data options on the General tab.

Program Options.png

To perform a more advanced search, click the Advanced Search button.

Product Advanced Search.png

TABS

General tab
Jump to top of page
Product general subtab.png

The General tab contains important information about the product.

Details tab
Jump to top of page
Product details subtab.png

The Details tab displays additional details about the product.

Substitute tab
Jump to top of page
Product substitute subtab.png

The Substitute tab allows specific products to be substituted for others when they are out of stock. If an out-of-stock item is added to a sales order, a dialog will be displayed with an option to select a substitute product.

Pricing tab
Jump to top of page
Product pricing subtab.png

The Pricing tab makes it possible to create new pricing rules, as well as edit or delete existing pricing rules. For instructions on creating, editing, or deleting pricing rules, see the Small.Pricing Rule.png Pricing Rule module. For details about associated pricing, see Associated pricing.

Customers tab
Jump to top of page
Product customers subtab.png

The Customers tab displays the customer part numbers associated with the selected product.

Memo tab
Jump to top of page
Product memo subtab.png

The Memo tab is for internal use and allows users to enter notes regarding a specific product. The top portion of the screen displays the date a memo was created, by what user, as well as a preview of the memo. Click on the preview to view the entire message in the window below.

Use the component toolbar on the right to Add Icon Button.png Add a new memo, Edit Icon Button.png Edit an existing memo, or Delete Icon Button.png Delete a memo. To print all of the memos for a product, click the Print Icon Button.png Print button.

Custom tab
Jump to top of page
Product custom subtab.png

The Custom tab is an internal-use field for recording extra information. Use the Small.Custom Field.png Custom Field module to set names for each custom field. This feature makes it possible to use an advanced search for products by custom field, or to display custom information on reports in Fishbowl.

MODULE OPTIONS

Some aspects of the Small.Product.png Product module can be customized by opening the module, clicking the Tools menu, and then selecting Module Options.

General tab
Jump to top of page
Product module options general subtab.png
This field contains the associated product suffix that Fishbowl will search for automatically when adding a product to a sales order. Fishbowl provides the ability to add multiple products to a sales order simultaneously by using associated products. An associated product has the same name as the main product plus a special suffix to identify it as an associated product. Associated products are often used in industries where recyclable cores can be returned to offset the cost of a new item. For example, when selling a new car battery, an auto parts store may give a discount to a customer that returns an old battery.
By entering -Core% in the suffix field, products containing "Battery-Core" in the product name will be added to the sales order whenever the associated product, "Battery," is added. The % symbol functions as a wildcard search, meaning it will look for products named Battery-Core plus any other characters after that (for example, Battery-Core2 or Battery-CoreABC), and all items containing that suffix will be added to the sales order. For more information, see Associated products.
This option specifies whether or not all new products will be marked as taxable.

Personal tools
Namespaces
Variants
Actions
Navigation
Other Pages
Toolbox
Print/export
Translate