How can I get alerted for out of stock items during order processing?

sensoryspeciali · ‎05-17-2023

Hi guys,

I do a lot of invoicing. Draft orders are made, however there can be a time delay between payment coming through and then being marked as paid and created into an order. During this time delay, the invoiced item can go out of stock. Once I mark it as paid, the order is created. However, the order page is not alerting me if something is now out of stock within the order.

Unless I manually check the items inventory, I am not being alerted of the stock being sold out in the order itself.

Any advice?

JoesIdeas · ‎05-18-2023

I don't fully understand your flow but maybe you could turn off the product setting to allow selling when out of stock?

If not, if you need some kind of alert or action when an order gets marked paid, if you can't find a native solution you can do stuff like this with Order Automator app. For example, you can make it send an email to staff when an order is marked paid and an item is out of stock. It's not a stock feature but you can make customizations related to order automations.

• Creator of Order Automator [auto tag, fulfill, connect FBA, daily jobs]
• Co-Creator of Product Automator [suite of features for products / collections]
• Shopify developer for 10+ years, store owner for 7 years
• Blog: Shopify Tips, Guides, and Automation Tactics

sofiaee · ‎05-24-2023

I'm having the same issue, it used to show this but it seems like the feature has been removed?

kellyanne31 · ‎09-05-2024

I additionally would like an answer to this question. It seems crazy that Shopify will allow someone to make a manual draft order with a 0 quantity product. Not only that, but it will actually allow them to pay for the item and then will allow the item to be fulfilled, without a warning! I have had several times now (because we do alot of phone orders) where we have these giant belt orders with 300 or so belts, I am trying to quickly get these belts added (scrolling through all my variants) and don't always have time to double check the inventory levels. I try to, but it sometimes gets missed. And then there's no warning whatsoever, it just invoices like it was there. What is the point of an inventory system then? This needs to get rectified ASAP. I am aware that it will not allow online orders to process with out of stock items, but this is not enough. There needs to at least be a warning on the Manual Draft Orders. I'm unclear why such a large platform such as Shopify would not have this feature.

JuanPabloGalind · ‎09-14-2024

Hi i see that i´m a little bit late for this thread but i found a solution for this that could may be help you or someone else in the shopify community.

I found an app and it´s called "Order Printer Pro" - Order Printer Pro – Shopify Invoice App: Deliver Custom Docs | Tienda de aplicaciones de Shopify, with this app you can create a template PDF that can show you only the products with the next conditions:

If the quantity ordered is higher than the stock available of a variant.
If the stock available of a product is zero compared to the quantity ordered of a variant.

It was really hlepful because we have customers that can take up to days to make the payment and before they do it we have to check the inventory.

this is the template´s code that i used to create a template called "Verificar disponibilidad" or in english "Check availability":

{% assign SETTING_shop_logo = shop_logo_url %} 
{% assign SETTING_shop_logo_width = shop_logo_width %} 
{% assign SETTING_shop_accent_color = shop_accent_color %} 
{% assign SETTING_date_format = "%-d/%-m/%Y" %} 
{% assign SETTING_show_product_images = true %} 
{% assign SETTING_product_image_size = 58 %} 
{% assign SETTING_show_cart_attributes = false %} 
{% assign SETTING_show_order_number_barcode = true %} 
{% assign SETTING_show_product_barcodes = false %} 
{% assign SETTING_use_latest_fulfillment = false %} 
{% assign SETTING_move_qty_column_to_left = false %}

{% assign shop_name_text = "" %} 
{% assign shop_address_text = "" %} 
{% assign shop_tax_number_text = "" %}

{% assign TEXT_order = "Orden" %}
{% assign TEXT_shipping_address = "Dirección de envío" %}
{% assign TEXT_customer = "Cliente" %}
{% assign TEXT_tel = "Tel." %}
{% assign TEXT_no_customer_information = "Sin información del cliente" %}
{% assign TEXT_payment_method = "Método de pago" %}
{% assign TEXT_shipping_method = "Método de envío" %}
{% assign TEXT_pickup_date_and_time = "Recoger en" %}
{% assign TEXT_pickup_location = "Lugar de recogida" %}
{% assign TEXT_delivery_date_and_time = "Entrega en" %}
{% assign TEXT_items = "Artículos" %}
{% assign TEXT_qty = "Cantidad" %}
{% assign TEXT_sku = "SKU:" %}
{% assign TEXT_qty_of = "de" %}
{% assign TEXT_no_items_fulfilled = "No se ha completado ningún artículo para este pedido." %}
{% assign TEXT_notes = "notas" %}
{% assign TEXT_thanks = "gracias por comprar con nosotros!" %}

{% if SETTING_use_latest_fulfillment == true %}
{% assign name = latest_fulfillment.name %}
{% assign created_at = latest_fulfillment.created_at %}
{% assign line_items = latest_fulfillment.line_items %}
{% endif %}

<div class="template-840602">
<div class="header">
<div class="shop-title to-uppercase">
{% if SETTING_shop_logo != blank %}
{{ SETTING_shop_logo | img_tag: '', 'shop-logo'}}
{% else %}
{{ shop.name }}
{% endif %}
</div>
<div class="order-title text-align-right">
<p>
{% if SETTING_show_order_number_barcode == true and name != blank %}
<s-barcode type="code128" value="{{ name }}"></s-barcode><br>
{% endif %}
{{ TEXT_order }} {{ name }}
</p>
<p>
{{ created_at | date: SETTING_date_format }}
</p>
</div>
</div>
<div class="customer-addresses">
<div class="shipping-address">
<p class="subtitle-bold to-uppercase">
{{ TEXT_shipping_address }}
</p>
<p class="address-detail">
{% if shipping_address != blank %}
{{ shipping_address.name }}
{% if shipping_address.company != blank %}
<br>
{{ shipping_address.company }}
{% endif %}
<br>
{{ shipping_address.address1 }}
{% if shipping_address.address2 != blank %}
<br>
{{ shipping_address.address2 }}
{% endif %}
{% if shipping_address.city_province_zip != blank %}
<br>
{{ shipping_address.city_province_zip }}
{% endif %}
<br>
{{ shipping_address.country }}
{% if shipping_address.phone != blank %}
<br>
{{ TEXT_tel }} {{ shipping_address.phone }}
{% endif %}
{% endif %}
</p>
</div>
<div class="billing-address">
<p class="subtitle-bold to-uppercase">
{{ TEXT_customer }}
</p>
<p class="address-detail">
{% assign billing_address = billing_address | default: customer.default_address %}
{% if billing_address != blank %}
{{ billing_address.name }}
{% if billing_address.company != blank %}
<br>
{{ billing_address.company }}
{% endif %}
<br>
{{ billing_address.address1 }}
{% if billing_address.address2 != blank %}
<br>
{{ billing_address.address2 }}
{% endif %}
{% if billing_address.city_province_zip != blank %}
<br>
{{ billing_address.city_province_zip }}
{% endif %}
<br>
{{ billing_address.country }}
{% if billing_address.phone != blank %}
<br>
{{ TEXT_tel }} {{ billing_address.phone }}
{% endif %}
{% elsif customer != blank %}
{{ customer.name }}
{% if customer.email != blank %}
<br>
{{ customer.email }}
{% endif %}
{% if customer.phone != blank %}
<br>
{{ TEXT_tel }} {{ customer.phone }}
{% endif %}
{% else %}
{{ TEXT_no_customer_information }}
{% endif %}
</p>
</div>
<div class="order-details">
{% if shipping_method != blank or fulfillment.tracking_company != blank %}
<p class="subtitle-bold to-uppercase">
{{ TEXT_shipping_method }}
</p>
<p class="order-detail">
{% if fulfillment.tracking_company == blank or fulfillment.tracking_company == "Other" %}
{{ shipping_method.title }}
<br>
{{ fulfillment.tracking_number }}
{% else %}
{{ fulfillment.tracking_company }} {{ shipping_method.title }}
<br>
{{ fulfillment.tracking_number }}
{% endif %}
</p>
{% endif %}
{% if attributes.Pickup-Date != blank or attributes.Delivery-Date != blank %}
{% include "pickup_and_delivery" %}
{% endif %}
</div>
</div>

<hr>

<div class="order-table">
<div class="order-table-row order-table-header">
<div class="order-table-cell item-image-and-description subtitle-bold to-uppercase">
{{ TEXT_items }}
</div>
<div class="order-table-cell item-quantity text-align-right subtitle-bold to-uppercase">
{{ TEXT_qty }}
</div>
</div>

{% comment %}
These variables make sure your images print at high quality.
{% endcomment %}
{% assign resolution_adjusted_size = SETTING_product_image_size | times: 200 | divided_by: 72 | ceil %}
{% capture effective_image_dimensions %}{{ resolution_adjusted_size }}x{{ resolution_adjusted_size }}{% endcapture %}
{% for line_item in line_items %}
{% if line_item.quantity < 1 or line_item.quantity <= line_item.variant.inventory_quantity %}{% continue %}{% endif %}
<div class="order-table-row order-table-body">
{% if SETTING_show_product_images == true %}
<div class="order-table-cell item-image">
<div class="aspect-ratio aspect-ratio-square" style="width: {{ SETTING_product_image_size }}px; height: {{ SETTING_product_image_size }}px;">
{% if line_item.image != blank %}
{{ line_item.image | img_url: effective_image_dimensions | img_tag: '', 'aspect-ratio__content' }}
{% else %}
{{ '/product_image_placeholder.svg' | img_tag: '', 'aspect-ratio__content placeholder' }}
{% endif %}
</div>
</div>
{% endif %}
<div class="order-table-cell item-description">
<p>
<span class="item-description-line">
{{ line_item.product_title }}
</span>
{% if line_item.variant_title != blank %}
<span class="item-description-line">
{{ line_item.variant_title }}
</span>
{% endif %}
{% if line_item.sku != blank %}
<span class="item-description-line">
{{ TEXT_sku }}{{ line_item.sku }}
</span>
{% endif %}
{% for p in line_item.properties %}
{% assign p_internal = p.first | slice: 0 %}
{% unless p.first contains "builder_id" or p.first contains "builder_info" or p.first contains "master_builder" or p_internal == "_" or p.last == "" or p.last == blank %}
{% if p.last contains "/uploads/" or p.last contains "cdn.shopify.com" %}
<span class="item-description-line"><a href="{{ p.last }}" target="_blank">{{ p.first }}</a></span>
{% else %}
<span class="item-description-line">{{ p.first }}: {{ p.last }}</span>
{% endif %}
{% endunless %}
{% endfor %}

{% if SETTING_show_product_barcodes == true and line_item.variant.barcode != blank %}
<s-barcode type="code128" value="{{ line_item.variant.barcode }}"></s-barcode>
{% endif %}
</p>
</div>
{% if line_item.variant.inventory_quantity > 0 %}
{% if line_item.quantity <= line_item.variant.inventory_quantity %}
<div class="order-table-cell item-quantity text-align-right">
{{ line_item.quantity }}
{%else%}
<div class="order-table-cell item-quantity text-align-right">
{{ line_item.variant.inventory_quantity }} de {{ line_item.quantity }}
{%endif%}
{% else %}
<div class="order-table-cell item-quantity text-align-right">
{{ "AGOTADO" }}
{%endif%}
</div>
</div>
{% else %}
<div class="order-table-row order-table-body">
<p>{{ TEXT_no_items_fulfilled }}</p>
</div>
{% endfor %}

</div>

<hr>
<div class="notes-and-pricing">
<div class="notes">
{% if note != blank %}
<div class="notes-row">
<div class="notes-title subtitle-bold to-uppercase">
{{ TEXT_notes }}
</div>
<div class="notes-details">
{{ note }}
</div>
</div>
{% endif %}
{% if SETTING_show_cart_attributes == true %}
{% for attribute in attributes %}
<div class="notes-row">
<div class="notes-title subtitle-bold to-uppercase">
{{ attribute.first }}:
</div>
<div class="notes-details">
{{ attribute.last }}
</div>
</div>
{% endfor %}
{% endif %}
</div>
</div>

<div class="footer">
<p>
{{ TEXT_thanks }}
</p>
<p>
<strong>
{% if shop_name_text != blank %}
{{ shop_name_text }}
{% else %}
{{ shop.name }}
{% endif %}
</strong>
<br>
{% if shop_address_text != blank %}
{{ shop_address_text }}
{% else %}
{% if shop.address1 != blank %}{{ shop.address1 }},{% endif %}{% if shop.address2 != blank %} {{ shop.address2 }},{% endif %}{% if shop.city != blank %} {{ shop.city }},{% endif %}{% if shop.province_code != blank %} {{ shop.province_code }},{% endif %}{% if shop.zip != blank %} {{ shop.zip }},{% endif %} {{ shop.country }}
{% endif %}
{% if shop_tax_number_text != blank %}
<br>{{ shop_tax_number_text }}
{% endif %}

<br>
<a href="mailto:{{ shop.customer_email }}" target="_blank">{{ shop.customer_email }}</a>
<br>
<a href="https://{{ shop.domain }}" target="_blank">{{ shop.domain }}</a>
</p>
</div>
</div>

<style>

.template-840602 * {
font-family: "Open Sans", sans-serif !important;
font-size: 14px;
font-weight: 300;
line-height: 18px;
box-sizing: border-box;
}

.template-840602 {
margin: auto;
padding: 10px 30px 0 30px;
min-height: 600px;
}

.template-840602 p {
margin: 0 0 7px 0;
}

.template-840602 a,
.template-840602 a:link,
.template-840602 a:visited {
color: #000;
font-weight: 300;
text-decoration: none;
}

.template-840602 .header {
width: 100%;
display: -webkit-box;
display: -webkit-flex;
display: flex;
flex-direction: row;
align-items: top;
margin-bottom: 30px;
}

.template-840602 .header p {
margin: 0
}

.template-840602 .shop-title {
color: {{ SETTING_shop_accent_color }};
-webkit-box-flex: 6;
-webkit-flex: 6;
flex: 6;
font-size: 30px;
line-height: 32px;
font-weight: 400;
}

.template-840602 .shop-logo {
max-width: {{ SETTING_shop_logo_width }}px;
}

.template-840602 .order-title {
-webkit-box-flex: 4;
-webkit-flex: 4;
flex: 4;
}

.template-840602 .customer-addresses {
width: 100%;
display: -webkit-box;
display: -webkit-flex;
display: flex;
flex-direction: row;
align-items: top;
margin-bottom: 15px;
}

.template-840602 .shipping-address {
flex-grow: 1;
flex-basis: 0;
}

.template-840602 .billing-address {
flex-grow: 1;
flex-basis: 0;
}

.template-840602 .order-details {
text-align: right;
flex-grow: 1;
flex-basis: 0;
margin-bottom: 15px;
}

.template-840602 .address-detail,
.template-840602 .order-detail {
margin: 5px 0 0;
line-height: 1.5;
}

.template-840602 .subtitle-bold {
font-weight: bold;
margin: 0;
font-size: 13px;
}

.template-840602 .order-detail + .subtitle-bold {
margin-top: 15px;
}

.template-840602 .to-uppercase {
text-transform: uppercase;
}

.template-840602 .text-align-right {
text-align: right;
}

.template-840602 .order-table {
display: block;
}

.template-840602 .order-table-row {
display: -webkit-box;
display: -webkit-flex;
display: flex;
flex-direction: row;
align-items: center;
margin: 15px 0;
page-break-inside: avoid;
}

.template-840602 .order-table-header {
margin-bottom: 0;
}

{% if SETTING_show_product_images == true %}
.template-840602 .order-table-header .item-image-and-description {
-webkit-box-flex: 8;
-webkit-flex: 8;
flex: 8;
margin-right: 30px;
}
{% else %}
.template-840602 .order-table-header .item-image-and-description {
-webkit-box-flex: 7;
-webkit-flex: 7;
flex: 7;
}
{% endif %}

.template-840602 .order-table-header .order-table-cell {
white-space: nowrap;
}

.template-840602 .order-table-cell {
-webkit-box-flex: 2;
-webkit-flex: 2;
flex: 2;
margin: 0;
}

.template-840602 .item-image {
-webkit-box-flex: 1;
-webkit-flex: 1;
flex: 1;
margin-right: 15px;
min-width: {{ SETTING_product_image_size | default: 0 }}px;
}

.template-840602 .item-description {
-webkit-box-flex: 7;
-webkit-flex: 7;
flex: 7;
}

.template-840602 .item-description-line {
display: block;
margin: 0;
}

.template-840602 .item-description p {
margin: 0;
line-height: 1.5;
}

.template-840602 .item-line-price {
-webkit-box-flex: 3;
-webkit-flex: 3;
flex: 3;
}

.template-840602 .missing-line-items-text {
margin: 15px 0;
padding: 0 7px;
}

.template-840602 .barcode-image {
height: 32px;
display: inline-block;
}

.template-840602 .qrcode-image {
margin-top: 15px;
height: 75px;
display: inline-block;
}

.template-840602 .notes-and-pricing {
width: 100%;
display: -webkit-box;
display: -webkit-flex;
display: flex;
flex-direction: row;
align-items: top;
margin-bottom: 15px;
}

.template-840602 .notes {
flex-grow: 2;
flex-basis: 0;
}

.template-840602 .notes-row {
display: -webkit-box;
display: -webkit-flex;
display: flex;
flex-direction: row;
align-items: top;
margin: 15px 0;
page-break-inside: avoid;
}

.template-840602 .notes-title {
-webkit-box-flex: 1;
-webkit-flex: 1;
flex: 1;
}

.template-840602 .notes-details {
-webkit-box-flex: 3;
-webkit-flex: 3;
flex: 3;
margin-right: 30px;
}

.template-840602 .footer {
margin-top: 30px;
text-align: center;
line-height: 1.5;
}

.template-840602 .footer p {
margin: 0;
margin-bottom: 15px;
}
.template-840602 .footer p:last-of_type {
margin-bottom: 0px;
}

.template-840602 hr {
height: 2px;
border-bottom: 2px solid {{ SETTING_shop_accent_color | default: "#e1e1e1" }};
margin: 0;
}

.template-840602 .aspect-ratio {
position: relative;
display: block;
background: #fafbfc;
padding: 0;
}

.template-840602 .aspect-ratio::before {
z-index: 1;
content: "";
position: absolute;
top: 0;
right: 0;
bottom: 0;
left: 0;
border: 1px solid rgba(195,207,216,0.3);
}

.template-840602 .aspect-ratio--square {
width: 100%;
padding-bottom: 100%;
}

.template-840602 .aspect-ratio__content {
position: absolute;
max-width: 100%;
max-height: 100%;
display: block;
top: 0;
right: 0;
bottom: 0;
left: 0;
margin: auto;
}

/* BEGIN: Product table column ordering snippet */
.template-840602 .order-table-cell {
order: 2; /* Set default for all columns (same value equals original ordering) */
}
{% if SETTING_move_qty_column_to_left == true %}
.template-840602 .order-table-cell.item-quantity {
order: 1; /* Set quantity column first in ordering */
text-align: left !important;
}
{% endif %}
/* END: Product table column ordering snippet */

</style>

How can I get alerted for out of stock items during order processing?

How can I get alerted for out of stock items during order processing?

Community Blog Articles