Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Overview

Price Grids are the common way of pricing in the window furnishing industry where the widths are across the top and height/ drop down the left and the size co-ordinates give the price. BUZ supports a third dimension Depth and this is in the right most column. Each Price Grid has a Code and Description (Price Grid Description) that are used to attach it to the appropriate Inventory Items and then multiple Price Grids each with different Start Dates and Price Groups - Customer if this option is used.

...

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


Adding a New Price Grid

Price Grid Description/code → Step 1

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

Add/ Edit Price Grid Description

Click +Add to add a new Price Grid Description

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

Image Added


Enter you price grid description and code → Save

Image Added

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

Image Added

→ Select Price Grid Descriptions and Export

Image Added

→ Enter your Code for the Price Grid in the Column headed Code IE: ROLL-7

→ Enter the Description of the Price Grid in the column headed Description IE: Rollers Category 7

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

Image Added

→ Once done Save a copy of the file then Import 

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

Image Added

→ Upload 

Image Added

→ Select the spreadsheets to upload → Import

Image Added

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

Image Added

 Price Grid Template → Step 2

Now download your Price Grid template.

Import/Export Prices → Download current layouts 

Image Added

.Image Added       

                                                    Select the required Price Grid → Export

                                  Image Added


Select correct Code and Description, then attach Price Grids with a Start From date. The date can be a future date so that planned price changes can be loaded prior to the change and will be activated by an order date in that period.

...