Overview
Adding and Deactivating a single item.
Exporting the current Inventory Items
Importing the Inventory from a spreadsheet has a limit of 5000 records for import
On this page:
Manually adding an Inventory Item to BUZ
Settings → Inventory Items → New Item
Manually type the inventory item information into BUZ → Save
Deactivating Inventory Items
To watch the video on How to Deactivate Inventory Items click here.
This process is used when you need to change your Inventory Items for various reasons eg:colour changes in fabrics etc. Set the Inventory Items to inactive then Add new Inventory Items. This allows you to active these items again if required.
To set multiple items to be inactive:
Export the existing Inventory Items
Settings → Inventory Items → Import/Export
Step 1: Download our inventory items template file
Exports the current Inventory Items to an XLSX format spreadsheet.
Step 2: Save a copy of the Inventory Item file
This ensures you have a backup of the existing data in the system save a copy of the downloaded file before any changes are made.
Open the downloaded file → Enable editing → File → Save As → Choose your file location → Save
Step 3: Edit your inventory items file
****NOTE limit your upload number of lines to lots of 5000 inventory items.
Edit your items spreadsheet.
The PkId= Primary Unique Identifier column will already be populated with the unique identifier BUZ has already allocated, this MUST stay the same.
Add the product details to be updated and save the excel document to a new file name
The Operation should be D=Deactivate
Example Inventory Items deactivate import format
Step 4: Upload an excel document, Import & Save
Select the “updated” excel document to import and then upload it to BUZ
Highlight the worksheet to upload → Import → Check the correct items are Updating → Save All → Check the message these Items have been successfully modified.
The Inventory items are now deactivated in BUZ.
Manually deactivating an Inventory Item in BUZ
Settings → Inventory Items → Search for Inventory Item → Display
→ Click the Inventory Item link to be Deactivated
→ Archive
BUZ confirmation message
Reactivating Inventory Items
To watch the video on how to Reactivate inactive Inventory Item click here
If an item needs to be re activated follow this process.
Export the existing deactivated Inventory Items
Settings → Inventory Items → Import/Export
Step 1: Download our inventory items template file
Exports the current Inventory Items to an XLSX format spreadsheet.
Step 2: Save a copy of the Inventory Item file
This ensures you have a backup of the existing data in the system save a copy of the downloaded file before any changes are made.
Open the downloaded file → Enable editing → File → Save As → Choose your file location → Save
Step 3: Edit your inventory items file
To watch the video on how to edit Inventory Items click here
****NOTE limit your upload number of lines to lots of 5000 inventory items.
Edit your items spreadsheet.
The PkId= Primary Unique Identifier column will already be populated with the unique identifier BUZ has already allocated, this MUST stay the same.
Add the product details to be updated and save the excel document to a new file name
Active needs to be updated from FALSE to TRUE
The Operation should be E=Edit
Example Inventory Items reactivate import format
Step 4: Upload an excel document, Import & Save
Select the “updated” excel document to import and then upload it to BUZ
Highlight the worksheet to upload → Import → Check the correct items are Updating → Save All → Check the message these Items have been successfully modified.
The Inventory items are now activated in BUZ.
Manually reactivating an Inventory Item in BUZ
Settings → Inventory Items → Search for Inventory Item → Display
→ Click the Inventory Item link to be Deactivated
→ Activate
BUZ confirmation message
Manually editing an Inventory Item in BUZ
Settings → Inventory Items → Search for Inventory Item → Display
→ Click the Inventory Item link to be edited
→ Edit Details
→ Update the required details → Scroll to the bottom of the screen → Save
BUZ confirmation message
Explanation of Inventory item spreadsheet
| Field | Details | Notes |
|---|---|---|
| PKID | This is the Primary Unique Identifier for the row in the database | BUZ creates this for you, leave this field blank |
| Code | Your Code for the item | If this is in a main inventory group and has an * in the heading BUZ will auto generate this for you |
| Description | Item Description | If this is in a main inventory group and has an * in the heading BUZ will auto generate this for you |
| DescnPart1 (Material) | Description Part 1 | in most cases used for Material |
| DescnPart2 (Material Types) | Description Part 2 | in most cases used for Material type (Blockout / Translucent) |
| DescnPart3 (Colour) | Description Part 3 | in most cases used for Material Colour |
| Price Grid Code | Price grid code that this inventory items relates to | |
| Cost Grid Code | Cost grid code that this inventory items relates to | |
| Discount Group Code | Discount group code that this inventory items relates to | |
| Last Purchase Price | The price you last purchased it for | |
| Standard Cost | The suppliers normal sell price | |
| Tax Rate | Your tax rate | |
| Units Purchase | What unit do you purchase in IE: BX is Box (These units of measure can be edited in inventory settings Purchase Orders ) | use the unit of measure code not description |
| Stocking Multiplier | Multiple "Unit Stock" by "Units purchased" | |
| Units Stock | What unit do you stock in IE: BX is Box | use the unit of measure code not description |
| Selling Multiplier | Multiple "Unit Sell" by "Units purchased" | |
| Units Sell | What unit do you sell in IE: BX is Box | use the unit of measure code not description |
| Cost Method | What cost do you want to default to (Average, Standard, Last purchased) | |
| Product Size | ||
| Product Type | Component = "C", Service = "S", Manufactured = "M" | Use only the first letter in the column |
| Supplier | Enter your Supplier here | use supplier code which is setup in BUZ contacts→ Suppliers |
| Supplier Code | Enter the Code your Supplier provides you for the inventory item, used for purchase orders | |
| Supplier Description | Suppliers Description of goods, used for purchase orders | |
| Length | ||
| Maximum Width | Maximum width this item is available in | |
| Extra Time to Fit | Extra time in minutes to fit this item (additional to the inventory group) | |
| Customer Var 1 (Pack Size) | Pattern Repeats in millimetres. used for Curtain pricing script | |
| Custom Var 2 (PackOpt) | Fabric Width in millimetres. used for Curtain pricing script | |
| Custom Var 3 (PackType) | Y or N | Continuous /Railroad Y or N |
| Warning | Warning flag to appear when item is selected in cart | |
| RptCat | Report Categroy | used to group items in a category for reporting |
| Operation | If this is a new item then the operation is A, E is to edit and existing item and D in to Deactivate |
Fabric lists - Commonly used Fabrics to import
Rollers
Roller Fabric 20151209.1242_InventoryItems_BUZ.xlsm
Awnings
Awning Fabrics 20151209.1334_InventoryItems_BUZ_.xlsm
Shutters
Shutter Materials 20151210.0940_InventoryItems_BUZ.xlsm
Doors and Screens
Doors and screens material list20151210.1019_InventoryItems_BUZ_.xlsm