Stock Central Columns Data

Updated 4 weeks ago

In the Stock Central table, you will find detailed info about your products. The info is sorted within the following sections:

Product Details

This section contains:

  • Image: Product small image preview.

  • ID: A WooCommerce Product ID is sometimes needed when using shortcodes, widgets, and links. ATUM's stock central page will display the appropriate ID of the product in this column.

  • Product Name: The first twenty characters of the product name. Hover your mouse over the name to see the full content.

  • Product type: This column displays the classification of individual products in WooCommerce. We specify product types by icons with a tooltip on hover. For products with children (variables, grouped, etc), these icons work as a button to expand/collapse their children.

  • SKU: An SKU, or Stock Keeping Unit, is a code assigned to a product by the store admin to identify the price, product options, and manufacturer of the merchandise. An SKU is used to track inventory in your retail store and must be unique. They are critical in helping you maintain a profitable retail business. We recommend the introduction of SKUs in your store to take full advantage of ATUM's features. You can set the SKU in this column. After you click the 'Set' button and 'Save Data', the SKU will update automatically in your store.

  • Supplier: This is the name of a supplier that supplies the products for your store.

  • Supplier SKU: The stock-keeping unit code of the product within your supplier's product list must be unique. You can set the Supplier SKU in this column. After you click the 'Set' button and 'Save Data', the Supplier SKU will update automatically in your store.

  • Location: Shows the product's location hierarchy. The grey icon means that there are no locations set and the blue icon means that there. Click the icon to view and edit the locations hierarchy in a popup.

  • Regular Price: You can configure the product price in this column. After you click the 'Set' button and 'Save Data', the product price will update automatically in your store.

  • Sale Price: You can configure the sale price of your product. Enter the date range for your sale or leave the date empty for a continuous sale price. After clicking the 'Set' button and 'Save Data', the change will automatically update your store.

  • Purchase Price: You can configure the purchase price of the product. After you click the 'Set' button and 'Save Data', the product purchase price will update automatically in your store.

  • Gross Profit: The Gross Profit column displays the difference between the selling price and the purchase price. From ATUM general settings you can choose to display it as a percentage or as a monetary value; but when you hover the value in Stock Central, it will display the non-selected format as well in a tooltip. Also, in ATUM general settings you can set a percentage to the profit margin. We’ll use this value to mark in red all the gross profit values that fall below this margin and in green all the values equal or greater than this margin. If you install our premium add-on Product Levels, the Gross Profit column will be displayed in Manufacturing Central too.

  • Weight: You can configure the product weight in this column. After you click the 'Set' button and 'Save Data', the product weight will be updated automatically in your store.


Stock Counters

This section contains:

  • Current Stock: The current stock represents the number of products available to order (values updated on the Stock Central refresh). If the WC’s manage stock option is enabled, you can set the current stock in this column. After you click the 'Set' button and 'Save Data', the current stock will be updated automatically in your store.

  • Out of stock threshold: When stock quantity reaches the Out of Stock Threshold the stock status will change to 'Out of Stock'. You can set the Out of Stock Threshold in this column. After you click the 'Set' button and 'Save Data', the Out of Stock Threshold will be updated automatically in your store.

  • Inbound Stock: Inbound stock counter represents the volume of products that have been ordered, using the Purchase Order feature, and are pending delivery.

  • Stock on Hold: All products within paid orders that are still in the warehouse but not yet shipped (order status processing or on hold).

  • Reserved Stock: There are times when the store owner needs to reserve or set aside a small or significant amount of stock. Occasions like special events, customer reservations, or quality checks will find this feature very handy. This value is the sum of the total amount of items that are part of pending Inventory Logs with the type set as 'Reserved Stock'.

  • Back Orders: Every WooCommerce product has an 'Allow Back Orders' option on the product page. It will give customers the opportunity to place an order even when the product is out of stock. The 'Back Orders' indicator will display the number of items required by customers.

  • Sold today: The value represents the number of products sold during the day. Sold products are items included in 'completed' and 'processing' orders only. Ordered items, but pending payment will show in the 'Stock on Hold' column instead.


Stock Negatives

This section contains:

  • Customer Returns: We don't think there is a store owner that wants to see products returning to the warehouse. However, in case there is an item coming back from the customer store owner can use the Inventory Logs to create a log entry with the 'Customer Returns' type. This value is the sum of the total amount of items that are part of pending Inventory Logs with the type set as 'Customer Returns'.

  • Warehouse Damages: In the unlikely event of warehouse or in-house damages, the Inventory Logs have the option to create an entry with the 'Warehouse Damage' type. This value is the sum of the total amount of items that are part of pending Inventory Logs with the type set as 'Warehouse Damage'.

  • Lost in Post: Inventory Logs add-on can create a log entry under the 'Lost in Post' tab within the 'Inventory Log' menu for all items that have gone missing on the route to the customer. This indicator helps to control the performance of postal carriers as well as the work of dispatch departments.

  • Other Logs: Within the Inventory Log tab you can create a log with the ‘Other’ type in cases when the log doesn’t match with ‘Customer Returns’, ‘Warehouse Damages’, or ‘Lost in Post’ options.


Stock Selling Manager

This section contains:

  • Sales Last X Days: Users will value this performance indicator as a tool that allows them to see the actual sales of the product within the last X days (sold products are items included in 'completed' and 'processing' orders only. Ordered items, but pending payment will show in the 'Stock on Hold' column instead). You can change the number of days by simply clicking on its blue number.

  • Stock will Last (Days): A feature that will tell the user the average amount of days that a product will keep 'in stock' status. By default, we base this indicator on sales for the past seven days (we do not include the current day sales).

  • Out of Stock for (Days): This indicator shows the number of days an item has the 'Out of Stock' status. Store owners can more accurately monitor the effectiveness of their ordering. Please, note that ATUM will only calculate products that go out of stock after the initial plugin install.

  • Lost Sales: Our users will want to see this figure as close to zero as possible. The formula calculates the volume of products that the store owner would sell if the item stayed in stock. By default, we take the average sales for the last seven days the item was in stock. We time the result by the number of days the item is out of stock.

  • Stock Indicator: The product's stock status, and can be one of:

Stock indicator status explanation:

  • Product in Stock and Managed by WC: When product stock is more than 1 and it is managed by Woocommerce.
  • Product Out of Stock and Managed by WC: When product stock is less than 1 and it is managed by Woocommerce.
  • Product is on Restock Status and Managed by WC: This is the formula used > The average sales per day for the last week * Days to reorder. We calculate the average sales by adding the sales of the product of the last week and dividing by 7.
  • Product is Out of Stock, but Managed by WC and Set to Back Orders: When the stock product is less than one and it is managed by Woocommerce, Backorders are allowed.
  • Product in Stock and Not Managed by WC: When the stock product is more than one and it is not managed by Woocommerce.
  • Product Out of Stock and Not Managed by WC: When the stock product is less than one and it is not managed by Woocommerce.
  • Product set to Backorders Only and Not Managed by WC: When Back Orders are set and the product is not managed by Woocommerce.
Did this answer your question?