Skip to main content
All CollectionsPrediko FeaturesBuying Table
What columns can you add to the Buying Table?
What columns can you add to the Buying Table?
Anya Bacon avatar
Written by Anya Bacon
Updated over a month ago

Different types of columns in Buying Table

With Prediko you can add 80+ columns to report and make a decision on how many units you should purchase in your next order.

How to add a column to a Buying Table?

Click on the "Columns" on the Buying Table to see the selection.

What columns are there in the Buying Table?

The Buying Table offers around 100 customizable columns, giving you flexibility to choose the most relevant data for managing your inventory and making informed decisions. Below is a detailed explanation of key column options, grouped by category:

Info

SKU Metrics

These columns provide insights into the performance and status of each SKU:

  1. Health
    Displays the status of the SKU based on current inventory levels and settings for Recommended Days Left.

    • Indicates whether the stock is below Safety Stock (At Risk, Out of Stock) or above Days of Cover (Overstock).

    • Note: This is based on "In Stock" units and excludes "In Transit" quantities.

  2. ABC Classification
    Categorizes products based on performance metrics such as sales and quantities.

    • Helps identify top-performing products.

  3. Tags
    Lists Shopify Tags associated with the product, making it easier to group or filter products.

  4. SKU Note
    Custom notes added in Prediko for tracking special information about the SKU.

  5. Product Type
    Shopify Product Type linked to the product, aiding in product categorization.

  6. Selling When Out of Stock
    Indicates whether the product is set to continue selling even when inventory levels reach zero, based on Shopify settings.

  7. Unit Cost (Shopify)
    The unit cost as defined in Shopify, shown in the store's primary currency.

  8. Unit Cost (Prediko)
    The unit cost saved in Prediko, which may differ from Shopify data.

  9. Retail Price
    The retail price of the product, as defined in Shopify.

  10. Gross Profit %
    Calculates gross profit margin using the formula:
    ​(Retail Price - Unit Cost Shopify) / Retail Price

  11. Purchase Orders
    Displays the count of purchase orders (POs) raised in Prediko that include this SKU.

    • Provides a direct link to view detailed PO information.

Info

Settings

These columns show the settings that are applied to this SKU

  1. Reorder
    Indicates whether the SKU is discontinued and no longer needs to be repurchased in Prediko.

    • Removes forecasts after current stock is depleted.

  2. Shopify Status
    Shows if the SKU is currently ACTIVE or DRAFT on Shopify. Draft Products won't have any forecast (unless launched via New Product Launch).

  3. Safety Stock Days
    Minimum days of cover to maintain on hand for the SKU.

    • Notifications to repurchase are triggered when stock is Safety Stock + Lead Time days away from depletion.

  4. Days of Cover
    Maximum days of cover to hold for the SKU.

    • Buying recommendations suggest orders to maintain inventory up to this limit.

Info

Suppliers

These columns provide info that is set for this SKU on the Supplier level.

  1. Supplier
    Displays the name of the supplier assigned to this SKU in Prediko.

    1. Useful for identifying sourcing partners.

  2. Vendor
    Shows the vendor linked to this SKU in Shopify.

    1. Helpful for aligning supplier data across systems.

  3. Lead Time Days
    The number of days required to receive this SKU after placing an order.

    1. Also indicates the expected arrival date for the next order.

  4. MOQ (Minimum Order Quantity)
    Displays the minimum quantity required to place an order for this SKU.

    1. Ensures compliance with supplier ordering constraints.

  5. MOQ Type
    Specifies whether the MOQ applies per product or SKU.

    1. Helps clarify ordering terms with suppliers.

  6. Pack Type
    Indicates if the packing type applies to a product or an SKU.

    1. Useful for streamlining bulk orders.

  7. Pack Size
    Specifies the quantity of units per pack (or case) that must be ordered.

    1. Ensures adherence to supplier packing rules.

Stock

These columns provide info about stock and various stock analysis.

  1. Available

    • The number of units currently available for sale.

    • Useful for: Identifying sellable stock levels at a glance.

  2. In Transit

    • Number of units currently on their way, based on Purchase Orders (POs) in Prediko.

    • Note: Only POs in "Ordered" status are included in the In Transit calculation.

    • Useful for: Planning future availability and ensuring stock accuracy.

  3. Inventory Value

    • Calculation: Available Stock * Unit Price (Shopify)

    • Represents the cost of the current stock available.

    • Useful for: Assessing how much capital is tied up in inventory.

  4. Inventory Retail

    • Calculation: Available Stock * Retail Price

    • Represents the potential revenue from the current available stock.

    • Useful for: Evaluating potential sales value.

  5. Days Left

    1. Shows how many days the current "Available" stock will last based on your Plan.

    2. Note: Does not account for "In Transit" stock.

    3. Useful for: Predicting when stock may run out and planning replenishments.

  6. Days until Next Delivery

    1. Displays the estimated time until the next delivery arrives, based on POs in Prediko.

    2. Useful for: Managing lead times and ensuring stock continuity.

  7. Est. Out of Stock Days

    1. Forecasts how many days a SKU is likely to be out of stock if orders are not placed immediately.

    2. Useful for: Sorting Buying Table on SKUs which are forecasted to be most out of stock.

  8. Days since Out of Stock

    1. If a SKU is currently out of stock, shows how many days it has been unavailable.

    2. Useful for: Prioritizing long-term stockouts for replenishment.

  9. Out of Stock Days in a Year

    1. Tracks the total number of days a SKU has been out of stock over the past year.

    2. Useful for: Identifying recurring stock issues and improving stock availability.

  10. Best Order Date

    1. Suggests the optimal order date to align with Safety Stock + Lead Time.

    2. Ensures stock health is maintained without ordering too early, optimizing cash flow.

    3. Useful for: Timing orders efficiently to minimize holding costs.

  11. To Buy (Live)

    1. Displays the number of units (and cost) you need to buy immediately to meet your stock cover by the next delivery.

    2. Useful for: Reacting to urgent stock needs.

  12. To Buy (at Best Order Date)

    1. Shows the number of units (and cost) to buy on the suggested Best Order Date.

    2. Useful for: Planning purchases to maintain stock cover without overordering.

  13. Units to Order (Next PO)

    1. Editable field where you can set the number of units to order for the next PO.

    2. Overrides automatic calculations for customized ordering.

    3. Useful for: Adjusting nexxt orders directly within the Buying Table.

Performance

Historical and Planned performance.

Pick columns for: 1 week, 1 month, 3 months, 12 months. Or average over next/past year: daily, weekly, yearly.

  1. Qty Historical

    • Total quantity sold during the selected historical period.

    • Useful for: Reviewing past demand and identifying sales trends.

  2. Qty Plan

    • Forecasted quantity to sell during the planned period, based on your Plan.

    • Useful for: Comparing expected vs. historical performance.

  3. Sales Historical

    • Total sales during the historical period, in the store's currency.

    • Useful for: Understanding revenue trends over time.

  4. Sales Plan

    1. Forecasted sales for the planned period, based on your Plan, in the store's currency.

    2. Useful for: Setting revenue expectations and goals.

  5. Gross Profit Historical

    • Gross profit in the historical period, calculated in the store's currency.

    • Formula:
      ​Gross Profit = (Retail Price - Unit Cost Shopify) * Qty Sold

    • Useful for: Evaluating profitability of SKUs over time.

  6. Gross Profit Plan

    1. Forecasted gross profit for the planned period, based on projected sales and costs.

    2. Useful for: Setting profit expectations and aligning with revenue goals.

  7. Return Rate

    1. Percentage of returned items over the past year for this SKU.

    2. Useful for: Highlighting SKUs with high return rates that may require review or improvement.

  8. Qty Historical (ex. Stockout Days)

    1. Average quantity sold during days the product was in stock.

    2. Formula:
      ​Qty Sold / Days in Stock

    3. Example: If 1,000 units were sold in 365 days, but the SKU was in stock only 20 days, the average is:
      ​1,000 / 20 = 50 units per day in stock.

    4. Useful for: Understanding true demand when stock was available.

  9. Sales Historical (ex. Stockout Days)

    1. Average daily sales (in the store's currency) for days the product was in stock.

    2. Useful for: Evaluating sales potential without stockout disruptions.

Sales & Quantity Distribution

What propotion of Sales and Quantities are attributed to this SKU Historically and in the upcoming Plan. Over the last/next 12 months.

  1. Quantity % of Total Historical

    • Represents the SKU's share of total quantities sold over the last 12 months.

    • Formula:
      ​(Qty Historical for SKU / Total Qty Historical) * 100

    • Useful for: Identifying high-performing SKUs and their role in overall sales.

  2. Quantity % of Total Plan

    1. Forecasted share of total quantities sold for this SKU over the next 12 months.

    2. Formula:
      ​(Qty Plan for SKU / Total Qty Plan) * 100

    3. Useful for: Assessing how important the SKU is projected to be in the future inventory strategy.

  3. Sales % of Total Historical

    1. Represents the SKU's share of total sales over the last 12 months, calculated in the store's currency.

    2. Formula:
      ​(Sales Historical for SKU / Total Sales Historical) * 100

    3. Useful for: Understanding which SKUs drive the most revenue historically.

  4. Sales % of Total Plan

    1. Forecasted share of total sales for this SKU over the next 12 months, calculated in the store's currency.

    2. Formula:
      ​(Sales Plan for SKU / Total Sales Plan) * 100

    3. Useful for: Identifying projected key revenue drivers.

Growth

See historical Quantity growth Month-over-Month or Week-over-Week (for the latest period).

  1. Historical Qty WoW%

    1. Represents the week-over-week growth in quantity sold for the SKU.

    2. Formula:
      ​((Qty Sold This Week - Qty Sold Last Week) / Qty Sold Last Week) * 100

    3. Useful for:

      1. Monitoring recent demand changes.

      2. Identifying fast-moving SKUs or addressing declining trends.

  2. Historical Qty MoM%

    • Represents the month-over-month growth in quantity sold for the SKU.

    • Formula:
      ​((Qty Sold This Month - Qty Sold Last Month) / Qty Sold Last Month) * 100

    • Useful for:

      • Evaluating demand stability over time.

      • Planning restocks based on emerging trends.

Customers

Customers related data

  1. AOV (Average Order Value)

    • The average value of orders that include this product, calculated over the last 12 months or less if the product has been live for a shorter period.

    • Formula:
      ​Total Sales from Orders with SKU / Total Number of Orders with SKU

    • Useful for:

      • Assessing the financial impact of the SKU on overall order value.

      • Identifying products that drive higher-order values.

  2. First Order AOV

    1. The average value of first-time orders made by customers that include this product.

    2. Formula:
      ​Total Sales from First Orders with SKU / Total Number of First Orders with SKU

    3. Useful for:

      1. Understanding how this product performs in acquiring first-time customers.

      2. Optimizing product placement for customer acquisition campaigns.

  3. New Customers

    • The number of customers who purchased this product as part of their first-ever order on your store, calculated over the last 12 months or less if the product has been live for a shorter period.

    • Useful for:

      • Measuring the SKU's effectiveness in attracting new customers.

      • Identifying potential "gateway" products for customer acquisition.

Did this answer your question?