{% extends "shopyo_base/module_base.html" %} {% set active_page = 'inventory' %} {% block pagehead %}Inventory Reports{% endblock %} {% block sidebar %}{% include 'inventory/blocks/sidebar.html' %}{% endblock %} {% block module_content %}

Inventory Reports

{{ products|length }} products tracked

Low Stock

{{ low_stock|length }}

Out of Stock

{{ out_of_stock|length }}

Valuation (Cost)

${{ '%.2f'|format(total_cost) }}

Valuation (Retail)

${{ '%.2f'|format(total_retail) }}

Potential Margin

${{ '%.2f'|format(total_retail - total_cost) }}

Low Stock Alerts

{{ low_stock|length }}
{% for p in low_stock %}
{{ p.name }}
{{ p.in_stock }} / {{ p.min_stock }} min
{% else %}
All stocked up
{% endfor %}

Out of Stock

{{ out_of_stock|length }}
{% for p in out_of_stock %}
{{ p.name }}
0 in stock
{% else %}
Nothing out of stock
{% endfor %}

All Products

{% for p in products %} {% else %} {% endfor %}
NameStockCostRetailMarginValue (Cost)
{% if (p.in_stock or 0) == 0 %} {% elif p.min_stock and (p.in_stock or 0) <= p.min_stock %} {% else %} {% endif %} {{ p.name }}
{{ p.in_stock or 0 }} {% if p.min_stock and p.in_stock %} {% endif %}
${{ '%.2f'|format(p.cost_price|float) }} ${{ '%.2f'|format(p.selling_price|float) }} ${{ '%.2f'|format((p.selling_price|float) - (p.cost_price|float)) }} ${{ '%.2f'|format((p.cost_price|float) * (p.in_stock or 0)) }}
No products
{% endblock %}