Versions Compared

Key

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

...

Exports the current Inventory Items to an XLSX format spreadsheet.

                                                Image Added

Step 2: Copy your inventory items into the template

...

To see a list of items and save click arrow on left. The Save button is at the bottom left of list.

Image Added

Import Error Messages

If there are errors in the imported data there is a separate error section below the valid data section and the Save button will be disabled. To see a list of items and save click arrow on left.

...

                                                                                                                                    

  Manually type the inventory item information into BUZ → Save

...

                                                                                                           Image RemovedImage Added

Deactivating Inventory Items

This process is used when you need to change your Inventory Items due to 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.

Image RemovedImage Added

                                   Image Added                                                                                                    

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

Image Added

Step 3: Edit your inventory items file

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.

Image Added

Add the product details to be updated and save the excel document to a new file name

The Operation should be D=Deactivate

Image Added

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    

    Image Added                                                                                                                                              




                                                                                                                  



Image Added




Explanation of Inventory item spreadsheet

...