Terms

What is an inventory-related variable in the Analysis menu?

An inventory-related variable allows using $ sign to apply formulas with your already accumulated inventory data on BoxHero. All variables are shown based on the designated period. Please refer to the below for more.

  • Current quantity : Shows product/sub-item’s current quantity.
  • Number of days : Shows the number of days in a chosen period on Analysis.
  • Average quantity in a period : Shows the average quantity in the chosen period. The average is calculated by the quantity of 23:59:59 for each date.
  • Initial quantity in a period : Shows the quantity on 23:59:59 of the prior date from the chosen period.
  • Final quantity in a period : Shows the quantity on 23:59:59 of the day after from the chosen period.
  • Total stock-in quantity : Shows the total product/sub-item quantity from stock in.
  • Stock-in frequency : Shows the number of times stock in has been made.
  • Total stock-out quantity : Shows the total product/sub-item quantity from stock out.
  • Weighted stock-out average (linear, 2) : Shows the weighted average of product/sub-item’s stock out quantity by each date. Calculated by weighting the oldest date’s stock out quantity as 1 and, the recent date’s quantity as 2 in a linear function.
  • Weighted stock-out average (linear, 3) : Shows the weighted average of product/sub-item’s stock out quantity by each date. Calculated by weighting the oldest date’s stock out quantity as 1 and, the recent date’s quantity as 3 in a linear function.
  • Weighted stock-out average (linear, 4) : Shows the weighted average of product/sub-item’s stock out quantity by each date. Calculated by weighting the oldest date’s stock out quantity as 1 and, the recent date’s quantity as 4 in a linear function.
  • Stock-out frequency : Shows the number of times stock out has been made.
  • Variation quantity from audit : Shows the variation in quantity by subtracting the decreased quantity from increased quantity through auditing product/sub-item.
  • Decreased quantity from audit : Shows the decreased quantity from auditing product/sub-item.
  • Increased quantity from audit : Shows the increased quantity from auditing product/sub-item.
  • Audit frequency : Shows the number of times auditing product/sub-item has been made.
  • Variation quantity from move : Shows the variation in quantity by subtracting the decreased quantity from increased quantity through auditing product/sub-item on Location Mode.
  • Decreased quantity from move : Shows the decreased quantity from moving product/sub-item on Location Mode.
  • Increased quantity from move : Shows the increased quantity from moving product/sub-item on Location Mode.
  • Move-out frequency : Shows the decreased number of product/sub-item moves.
  • Move-in frequency : Shows the increased number of product/sub-item moves.

What's a Product category?

The product category is extra information you can add for each product. For example, you can add type, brand, manufacturer for each product to efficiently categorize and easily search, manage on BoxHero.

You can add, delete, or edit product categories on Data Center(about Data Center).

What's the difference between Product Category and Sub-item Category?

The sub-item category is information designating each sub-item's attribute. Even if a product has a single barcode, you can sort it by expiration date or its condition by adding it as a sub-item category. Moreover, each sub-item category has its item ID, where you can print as a QR-code label.

Thus, product category is an attribute of a product, while sub-item category is additional information that allows to product information to be divided by expiration date, condition, location, serial number, and more.

Example 1) Handmade Shoe Retail

note
  • The same model of shoes is affixed with different barcodes based on size and color.
  • Separate inventories exist, the store and the warehouse.
  • The store needs inventory management including B-grade products(try-on product).

For a handmade shoes retail shop, the following categories can be added.

Category NameExample
Size40, 41.5
ColorBlue, White
TypeSneakers, Loafer, Derby
LocationWarehouse, Shop B-1, Shop B-4
ConditionGrade B, Returned

**Size, Color, Type** is a default product information, therefore, should be registered as product category.

For Location, Condition is a variable information that can be changed by the product, so it should be registered as sub-item category.

Example 2) Used Mobile Phone/Appliance Sales

note
    • The purchased date, purchase price, condition, and appraisal price of the devices are recorded.
  • Inventory management by product type and model is needed.

For this business, the following additional info can be added to the product inventory.

Category NameExample
Product NameiPhone6, Galaxy S8
CategoryiPhone, Tablet
ColorWhite, Pink
ConditionA, B
Purchased Date2019-08-14
Purchased Price$300
Appraisal Price$340

**Product Name, Category, Brand** is a default product information, therefore, should be registered as product category.

For Condition, Purchased Date, Purchased Price, Appraisal Price, they are variable information that can be changed by the product, so it should be registered as sub-item category.

What's the difference between Product and Sub-item?

Product is a basic unit in BoxHero when managing the inventory stocks. When registering your inventory, the product's barcode and name must be inserted. You can also upload a photo and input product categories if needed. For products without a barcode, you can generate it on BoxHero automatically.

Sub-item is a unit supported only on Multi Mode that allows classifying products by expiry, condition, or quality.

For example, by registering a product with its information(barcode, name, product category) and add sub-items, the product information is automatically copied and allows you to only insert data for the sub-item(expiry date, condition, quality).

What's the difference between Product List and Data Center?

Although you can search for various product name or category from both of the menus, from Product List, you can:

  • Sort and view products by categories
  • Add, delete, edit products individually
  • View a specific product's current quantity and past transactions
  • Print a specific product barcode label

From Data Center, you can:

  • View all product data in an Excel format
  • Import/Export product data in an Excel file
  • Change photos of several products at once
  • Edit/delete several products at once
  • Print barcode of several products at once
  • Manage Product Categories and/or Partner

What's the difference between Auditing and inserting a past transaction?

Auditing is to sync when there is a difference between the quantity on BoxHero and the actual quantity. Inserting a past transaction is to increase the accuracy of transaction history, which adds a new transaction, whereas auditing is only editing the current quantity of selected products.

What's the difference between auditing and moving?

Auditing is to sync when there is a difference between the quantity on BoxHero and the actual quantity. Moving is to move a product from a location to another, that's only supported on Location Mode.

What's the difference between auditing and editing a transaction?

Auditing and editing transaction is both for auditing product's quantity. Please make a transaction edit if the quantity for a certain transaction must be edited. If you cannot find the transaction or several transactions need to be edited, auditing is highly recommended.

caution

If the transaction is edited, the current inventory quantity is changed as well. Unless necessary, auditing over editing transactions is highly recommended for clear management.