User guide
What this page is for
Sell by Area turns the area a customer needs into whole boxes, and adds the line to the sales order. You type the square metres or square feet. The page rounds up to whole boxes, shows the area those boxes really cover, counts the pallets, and prices the line for this customer. Nobody has to look up the box size or do the division by hand.
Start here
- Open the sales order you want to add to. Save it first if it is new.
- Click Sell by Area in the toolbar.
- Click Add product, select a product, and click Choose.
- Type the area in Target, and click Stage this line.
- Click Review and update, check the list, and click Write to the order.
The Result window lists each line. Click Close, and the order behind the page refreshes with the new lines.
Common tasks
Work out the boxes for an area
In the calculator, type the area the job needs in Target. The page divides by the product's area per box and rounds up, because a box cannot be split.
For example: 45 m² of a tile with 1.44 m² per box is 32 boxes. Those 32 boxes cover 46.08 m², and 46.08 m² is the quantity that goes on the line.
The box below the inputs shows:
| Line | What it shows |
|---|---|
| Total | The area the whole boxes cover. This is the line quantity. |
| Total pallets | Boxes divided by Boxes per pallet. 1.6 means one full pallet and part of a second. |
| Line total | The total area at this customer's price. |
Start from a box count instead
If the customer asks for a number of boxes, type it in Boxes and leave Target alone. The total area, the pallets, and the line total follow.
Add several products to one order
Stage each one in turn: Add product, the calculator, Stage this line. Each staged line shows in the grid with a badge, for example "add 46.08 m² · 32 box(es)". Staged in the footer counts them.
Nothing is written while you stage. When the list is complete, click Review and update once to write them all.
Check the price
The calculator shows Price per m² (or ft²) and Price per box. Both come from Fishbowl's price for this customer, at the area you typed. If a pricing rule gives a better price above a quantity, the price changes as you type past it. The line is written at the price shown.
Find a line on a long order
Type in Filter lines. It matches the product number and the description, as you type. Clear the box to see every line again.
In Add a product, the filter box above the list does the same for the catalog.
Throw away what you staged
Close the window before you click Write to the order. Staged lines are not written, and they are gone when you open the page again.
Every control
| Control | What it does |
|---|---|
| Add product | Opens Add a product, the list of every active product. |
| Filter lines | Filters the lines in the grid by number or description. |
| Staged | How many lines are waiting to be written. |
| Review and update | Shows the staged lines before anything is written. |
| Gear | Settings. Administrators only. |
| ? | Runs the guided tour. It changes nothing. |
| Book | Shows this guide. |
| Moon / sun | Light or dark. |
| Demo badge | The page is on sample data, not your Fishbowl. |
The grid shows the standard lines already on the order:
| Column | What it shows |
|---|---|
| Number, Description | The product. |
| Price per m² | The price for one unit of area on the line. |
| Qty m² | The area on the line. Blank on a staged line, which is not on the order yet. |
| UOM | The product's unit of measure. |
| m² per box | The area one box covers. |
| Boxes per pallet | How many boxes make a pallet. |
| Staged | What will be written for this line. |
With the unit set to square feet, every m² above reads ft².
Add a product has the same columns, plus Available: the stock you can sell, across every location, in the product's unit of measure.
In the calculator:
| Control | What it does |
|---|---|
| Target | The area the customer needs. Rounded up to whole boxes. |
| Boxes | The box count. Type here to start from boxes instead. |
| Stage this line | Puts the line in the grid. Writes nothing. |
| Cancel | Closes the calculator. Nothing is staged. |
When you review:
| Control | What it does |
|---|---|
| Write to the order | Adds every staged line to the sales order. |
| Back | Returns to the page. Everything stays staged. |
| Save the failures | Shows only if a line failed. Saves the failed lines as a CSV file, with the reason for each. |
| Close | Closes the result and reloads the order's lines. |
Questions people ask
Why does it say to open a sales order first? Sell by Area adds lines to one order, so it needs to know which one. Open the order, save it if it is new, then start Sell by Area from its toolbar.
Why is the quantity on the line more than I typed? Because boxes are whole. The line carries the area of the boxes that ship, not the area you typed. 45 m² at 1.44 m² per box writes 46.08 m².
Where does the box count go? Into the line's note, as "Total Cartons = 32". The quantity on the line stays in the product's unit of area.
Why is the area per box 1? That product has no box size set. The page counts one box as one unit of area, and one box to a pallet. Ask your administrator to fill in the box size on the product.
Why are Add product and Review and update grayed out? You need the Create Sales Order access right to add lines. Ask your administrator for it.
Why can I not open the gear? Settings are for users with the Administration access right.
Can I change a line that is already on the order? Not from this page. Change it on the sales order, the same way as any other line.
Can I sell one product in m² and another in ft²? Not at the same time. An administrator sets one unit of area for the page, and every product is sold in it.
What if one line fails? The others are still written. The Result window marks the failed line in red with Fishbowl's reason. Click Save the failures to keep a copy.
Can I undo a write? Not from here. Delete the line on the sales order, the same way you would delete any other line.