Content Comparison

This is a similar format to the Inventory Group sheets and is used as a single set of options that apply to the whole Quote/Order.

Extras -Adding to Unit Cost and RRP

Column F has an Option Code of OPEXCST and to get the Unit cost and the RRP to use this 1 Option code for pricing you must set it up as below

Colunm F

• Unique name - COST
• Inventory Code for Pricing - OPEXCST
• Related Data Field - UNITCOST

Column H

• Unique name - EXTRACHARGE
• Value applies to price from related Option Name - COST (this links it back to the Option code in the COST column)
• Related Data Field - RRP

If either Cost or RRP are left blank BUZ will only apply the cost or the RRP but if both are entered then both will be applied

This is THE SAME format as the Extras sheet and is used as a single set of options when finalizing an order when creating the invoice. This is usually used by wholesale companies. The FREIGHT and DISCOUNT columns below are explained below the example.

Marketing is also in a similar format and contains questions relating to current marketing campaigns and demographics.

It is found in the same output spreadsheet as above.

***Note: For the Lead Sources reports to work the first 2 column must be TYPE and  COMPTYPES

Below is the top section of a typical Marketing sheet.

Picture URL using Dropbox

First the folder your images are in on drop box need to be public, to do this follow the below;

1. Right-click Hover your mouse on a folder you want to publishmake public.
2. Select "Dropbox -- Share linkShare".
3. On the following dropbox websiteOnce you select 'Share", click "Get Create a link". Now your folder became public and anyone can access it with the folder link.

Now to Image Added

Second the Images in your Folder need to be Public

1. Place the Images into the Folder and then on each image
2. Hover your mouse on a file/image you want to make public.
3. Select "Share"
4. Once you select 'Share", click "Create a link". Now your image became public and anyone can access it with the folder link

Image Added

Third upload images and add URL;

1. Upload images to this drop box folder
2. Right click on the image within dropbox and select copy image address (see below)
   

3. In your questions layout exported from BUZ, paste this link in row 16 “Picture URL”

4. Import the layout back into BUZ

Import Errors

Typical Error "Error in sheet: AWZS - Sheet Name: AWZS,Inventory Code: OPRLBRKT Column #:6 Row #:13"

Option Product Codes are validated as existing during the import and the above message indicates the Inventory Code was not found. If the Code is not a Code this indicates the column is not formatted correctly.

Important Price Calculation considerations

Zero Quantity required

When calculating the prices most involve quantity(Qty), ItemWidth, ItemHeight and ItemDepth. Often these are not all set using the Options so BUZ sets them to 1 (one), if you have an Option that includes a response of 0(zero) you may end up with 1 flowing through, this mainly effects quantity. So if you have an Option that asks, for example, the quantity of brackets and a valid answer is 0 then the Options needs to structured so that the resultant charge is not for 1.

Price Grid returns zero

When pricing both the main product and the add-ons and Price Grid is used if the Price Grid returns zero price, this includes sizes greater than the maximum setup in the grid, are considered "not available" so when this happens unexpectedly don't forget to check the Options as well as the main product.

Generic layouts to download

Products

Extras

Invoice Extras