Cost Grids

Owned by Daryl Saunders (Unlicensed)
Last updated: Aug 23, 2021 by Alex Morrisson
4 min read

Click here to watch a video on how to configure Cost Grids

How Cost Grids (Buy) are used by BUZ

The Cost Grid Description's code is added to each inventory item that it applies to.

Each Cost Grid Description can have several Cost Grids attached to it that each have a different Start date.

BUZ allows 3 dimensional pricing Width/Length x Height/Drop x Depth/Thickness. They are referenced as ItemWidth x ItemHeight x ItemDepth. They are up to and including the size shown.

ItemDepth is often used to signify a package or combination price in the Product Options see Group Options for how this is used.

Add/ Edit Cost Grid Description

Step 1 → Cost Grid Description/code 

You need to create the code and description for the cost grid.

Go to Settings →  Inventory settings →  Cost Grids → +New Grid (button)

Enter your price grid description and code → Save

Note the Price grid code can only contain letters and numbers, no spaces or special characters (!@#,.-_ etc)

The code should be 4-8 characters long

OR you can create multiple price grids at once using excel (import/export feature)

Go to Settings → Inventory Settings → Import Export Inventory Settings → Download Current Layouts

→ Select Cost Grid Descriptions and Export

→ Enter your Code for the Cost Grid in the Column headed Code IE: ROLL7C

→ Enter the Description of the Cost Grid in the column headed Description IE: Rollers Cost Cat 7

→ Enter an A in the column headed Operation (to add)

→ Once done Save a copy of the file then Import 

Go to Settings→ Inventory settings→ Import Export Inventory settings → Select file

→ Upload 

→ Select the spreadsheets to upload → Import

When successful a message will appear at the bottom of the screen

Step 2 →  Cost Grid Template  

Once the Cost Grid code/description has been created download your Cost Grid template.

Settings → Inventory Settings → Cost Grids → Import/Export Prices

Download current layouts 

.

                                                                              Select the required Cost Grid → Export

                                                     

Step 3 → Cost Grid  

Add your pricing to your Cost Grid

Importing pricing "Inc" or "Exc" GST depends on what is setup as the tax rate for you inventory group/inventory items. Check the tax rate before updating pricing

  • Width/Length → Across x
  • Height/Drop → Down left side
  • Depth/Thickness → Down very right column

Save and import your file

Settings → Inventory Settings → Cost Grids → Import/Export Prices → Select File

Upload 

Select the required Price Grids to be imported 

Select the date you required the Cost Grid to start from (This means that you can get ready for a Cost increase before it happens and BUZ will automatically change to your new costs on your selected date) 

Select how many decimals places to round the cost to → Import

When the Import button is used you will receive a Save Successful message.

Step 4 → Cost Grid Link to Inventory Item

Download your Inventory Items and add the required Cost Grid Code to Inventory Items excel file and import as per the Inventory Items help

Example of Cost Grids

It is important that the right most column be the Depth. If depth is not being used then 0 (zero) should be entered on each row. See example below.