Step 1 → Price Grid Description/code
You need to create the code and description for the price grid.
Go to Settings → Inventory settings → Price Grids → +New Grid (button)
Enter your price grid description and code → Save
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 Price Grid Descriptions and Export
→ 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)
→ 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 → Price Grid Template
Once the Price Grid code/description has been created download your Price Grid template.
Settings → Inventory Settings → Price Grids → Import/Export Prices
Download current layouts
.
Select the required Price Grid → Export
Step 3 → Price Grid
Add your pricing to your Price 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 → Price Grids → Import/Export Prices → Select File
Upload
Select the required Price Grids to be imported
Select the date you required the Price Grid to start from (This means that you can get ready for a Price increase before it happens and BUZ will automatically change to your new prices 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 → Price Grid Link to Inventory Item
Download your Inventory Items and add the required Price Grid Code to Inventory Items excel file and import as per the Inventory Items help
A few things to consider/remember when setting pricing up.
Price Grids are Imported with a START date and your prices / costs will start from the date you enter. This means that you can get ready for a Price increase before it happens and BUZ will automatically change to your new prices on your selected date.
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.
Price can be imported with or with decimal places, this can be set in step 4. when importing the Price grids.
Having a zero (0.00) Price indicates that the size is not available so it may be necessary to add width and drop 1 less than the minimum with 0.00 Price to stop orders for that size and less.
If you want the order to still happen but with a zero amount, 0.01 will round to zero but still allow the order to be processed.
Ensure that all numbers in the Drop, Width and Depth are whole numbers, Decimal's will not work in the blue area's.