Stachethemes Orders SKU Search is a WooCommerce extension that allows store owners to quickly search for and locate orders by SKU in the Orders section of their Admin Dashboard.
It simplifies order management by providing fast, efficient SKU-based searches, saving time and improving the workflow for admins. The extension supports both legacy and HPOS configurations.

Stachethemes Orders SKU Search

Allows store owners to quickly search for and locate orders by SKU in the Orders section of their Admin Dashboard.

<h2>Track Your Products by the Batch and Keep Tabs on Their Expiration Dates </h2>
Product Batch & Expiration Tracking for WooCommerce allows store owners to track their products stock through batches and sets of same expiration dates. Take control of your inventory and set up and track sub-quantities of your products in batches and/or expiration dates. 
This breakthrough plugin allows store owners to keep track of their inventory, as parts of a whole, allowing them to oversee their products as a group of batches and a set of expiration dates. 
<h3>Who is this for?</h3>
If you are running a WooCommerce store that carries products with expiration date, e.g. food/edible, cosmetic, medicine, drink (tea, coffee etc.), or, from time to time you might need to recall your products. This plugin is for you!
Our batch tracking feature allows you to enter the batch number, batch date and vendor (if you are not the manufacturer) info, save them in your WooCommerce store. Later on, you can track your products’ batch info from the dedicated batch report dashboard. This is a great feature for food/edible manufacturer.
Our product expiry/expiration date tracking feature allows you to track your product’s expiration date, send you email notification of expiring products, as well as moving them into sales/clearance category automatically.
To sum up, our target audience is WooCommerce store owners who are looking to upgrade their inventory management by incorporating expiration date tracking, or expiration date tracking. By being able to track expiring products, better planning around promotions and sales can be done. In addition to expiration date tracking, there is batch tracking for store owners who are interested in being able to reference orders by a batch number.
<h2>Most Important Features </h2>
Product Batch & Expiration Tracking has a wide variety of features which allow you to manage inventory and keep yourself notified of any inventory with upcoming expiration dates. Using it will save you tons of time and money, which would normally be spent on keeping track of all the varying expiration dates of products on your store. Here’s a list of features: 
<ol>
<li style="font-weight: 400">Product Batch & Expiration Tracking – When enabled each product will have its own batch tracking and expiration date tracking table.</li>
<li style="font-weight: 400">Managed stock in Batches – Manage and track product quantities using a batch system, assigning each batch an ID, a batch date, and a supplier name.</li>
<li style="font-weight: 400">Managed stock by Expiration Date– Manage and track product quantities, using expiration dates, assigning each sub-quantity of your product an expiration date.</li>
<li style="font-weight: 400">Expiration Report – Dedicated page that lists all currently existing records with expiration dates that are close to expiration.</li>
<li style="font-weight: 400">Batch Report – Dedicated page that lists all currently existing batches sorted by their batch date.</li>
<li style="font-weight: 400">Track Orders by Batch – Orders of products with batches set up, remember which batch was used and the batch can be searched for. </li>
</ol>
<img class="alignnone size-medium wp-image-8046927" src="https://woocommerce.com/wp-content/uploads/2021/05/PBET-Expiry-Report.png?w=620" alt="" width="620" height="250" /> <img class="alignnone size-medium wp-image-8046925" src="https://woocommerce.com/wp-content/uploads/2021/05/PBET-Batch-Report.png?w=620" alt="" width="620" height="227" />
<h2>Additional Features </h2>
In addition to the main features listed above, there are some additional features you can opt in to that can be configured in the settings. The settings page can be found by going to the products tab and clicking the “Batch & Expiration by Webis” sub-tab (Note that these settings require expiration tracking to be enabled). Here is the list of additional features: 
<ol>
<li style="font-weight: 400">Display the Expiration Date – If this option is enabled, the expiration date will appear on the product page if a batch is expiring in a set number of days. </li>
<li style="font-weight: 400">Receive Emails for Soon-to-expire Products – If this option is enabled, the plugin sends a notification email with a list of products that are expiring a set number of days from the current day.</li>
<li style="font-weight: 400">Add to Clearance Category – If this option is enabled, when the expiration date of a product reaches a set number of days, the product is added to a set category.</li>
<li>Shortcode to Show Batch Number and Expiry Date –You can use [wpbet_batch_expiry] shortcode to show batch number or expiry date wherever you want.</li>
</ol>
<img class="alignnone wp-image-8147446" src="https://woocommerce.com/wp-content/uploads/2021/06/PBET-Settings.png?w=620" alt="" width="492" height="479" />
<h2>Why Did We Develop This Plugin? </h2>
As a store owner, we encountered the need to be able to track and record the expiration dates of our perishable goods like food products. We searched for existing solutions on the market but couldn’t find one that fulfilled the need in a straightforward and easy-to-use way. As a result, we developed this plugin to satisfy this need for expiration date tracking and we hope it can be of benefit to you as well. 
<h2>How Do I Set It Up? </h2>
Once the plugin is enabled, in the product data section of the product edit page, under the inventory tab, there will be a section called “Product Batch & Expiration Tracking”. In that section, you can enable “Expiration & Batch Tracking”. Once you’ve enabled it, the batch table will appear underneath if the product type is simple and under each variation if the product type is variable. Within this table you can create new batch entries that are saved when the product is saved. 
The steps: 
<ol>
<li style="font-weight: 400">Enable the plugin </li>
<li style="font-weight: 400">Go to the product edit page, go into the Inventory tab, enable the “Enable Expiration & Batch Tracking” option </li>
<li style="font-weight: 400">You can find the table in the Inventory tab if the product type is simple, and under each variation if the product type is variable. 
<img class="alignnone size-medium wp-image-8147450" src="https://woocommerce.com/wp-content/uploads/2021/06/PBET-Simple-Product.png?w=620" alt="" width="620" height="401" /><img class="alignnone size-medium wp-image-8147449" src="https://woocommerce.com/wp-content/uploads/2021/06/PBET-Variable-Product.png?w=620" alt="" width="620" height="405" /> 
</li>
<li style="font-weight: 400">Fill in the table with the information about your batches. </li>
<li style="font-weight: 400">You’re all set to start tracking your batches! </li>
</ol>
<h2>How Can I Use the Shortcode?</h2>
Shortcode [wpbet_batch_expiry type=”” order_id=”” variation_id=””] can render batch number or expiry date of the product variation that was ordered. It requires three parameter, type, order_id and variation_id. Type can be either batch_num or expiry_date depends on what you would like to show.
<h2>What Can Our Plugin Do? (Use Cases) </h2>
The Product Batch & Expiration Tracking for WooCommerce plugin allows you to track your product expiration date and batch numbers. You can also segment the product inventory into separate batches.
<h3>For Example (Expiration Date Use Case)</h3>
Say you have 100 bags of candy in stock, you purchased these 100 units in two batches. some of them are going to expire in 30 days, the rest of them are expiring next year.
<h4>Without our plugin:</h4>
You will need to ask your warehouse stuff constantly for each SKU in order to plan your clearance sales.
<h4>With our plugin:</h4>
Not only that you just need to go to the Expiry Report Dashboard to check the expiring products, you will also get email notifications regarding the expiring products. And if you setup the auto on sale feature, the product will automatically move into the clearance category (you can choose which category it is). These features will save you a lot of money from product wasting.
<h3>Another Example (Batch Number Use Case)</h3>
Say you sell chocolate cakes for years, and you just got notified by your supplier that, the last batch’s cakes are on the recall list. You want to notify your customers about this.
<h4>Without our plugin:</h4>
You will need to guess which orders contain the recalled cakes
<h4>With our plugin:</h4>
You can search orders by typing the batch number from the WooCommerce’s orders page. This will save you a lot of time.
There are much use cases of batch & expiry date tracking, and we pick a few more use cases that our plugin can cover: 
<ol>
<li style="font-weight: 400">Track the expiration date of products, so that when the expiration date approaches a promotion can be held to clear out items before expiration. 
</li>
<li style="font-weight: 400">Track expiration dates for multiple shipments to clear out inventory in a FIFO system based on closeness to expiring. 
</li>
<li style="font-weight: 400">Recording inventory shipments as batches, in the case a recall becomes necessary and the orders involved with the inventory requiring a recall can be tracked. </li>
</ol>
<h2>A Comparison of the Different Possible Implementations of Expiration Date & Batch Tracking </h2>
As always, prior developing our plugins, we check to see whether the existing plugin can fulfill the features we want to fulfill. After testing the existing product batch tracking or product expiration plugins, we found that either some of the plugins are not working at all, or the setup configuration is overly complicated, or lack of features. That was why we developed this plugin for our own use case, as well as sharing with WooCommerce store owners and hope to help out stores like us.
To sum up, there are a few approaches to solving the product expiration date problem: 
<ol>
<li style="font-weight: 400">A centralized dashboard where you can create records for all products. 
The problem with this solution, is that it is overly complicated. When a store manager goes to update the stock of a product, they would normally go to the product edit page to make their changes. By adding another dashboard that they have to use to make records, the process becomes very inefficient and inconvenient. We prefer to remain the existing workflow for normal store owners, and not introduce million other places to setup the product. 
</li>
<li style="font-weight: 400">Use expiration date tracking to only track expiration date. 
Some plugins do handle expiration date tracking, but they usually only provide the default features like updating stock values, and simple features like displaying the expiration date. Our plugin offers much more in-depth features, for example, moving expiring products into sales/clearance category (you can select which category to go to), sending expiring notifications to store manager regarding the upcoming expiring products. 
</li>
<li style="font-weight: 400">Use expiration date tracking alongside batch tracking right on the product edit page, and have a dedicated dashboard for the report. 
This is our solution, and we believe that it is the most effective and complete solution.</li>
</ol>
<h3>It Works Well With</h3>
<ul>
<li><a href="https://woocommerce.com/products/variation-shared-inventory-for-woocommerce/">Variation Shared Inventory for Woocommerce</a> 
Variation Shared Inventory for WooCommerce is an inventory management system that allows a group of variations to share a single quantity.</li>
</ul>
<h3>Requirements</h3>
Minimum PHP version: 7.0
<h3 class="p-rich_text_section">Get started</h3>
<ul class="p-rich_text_list p-rich_text_list__bullet" data-stringify-type="unordered-list" data-indent="0">
<li>Purchase this extension</li>
<li>Download, install, and activate the extension, in your WooCommerce store</li>
<li>Review our <a href="https://woocommerce.com/document/product-batch-and-expiration-tracking-for-woocommerce/">documentation</a> for any additional information</li>
</ul>

Product Batch & Expiration Tracking

Track product batch & expiration date info, get email alerts on expiring products, auto add to clearance category for expiring products and search orders by batch number.

Stachethemes Orders SKU Search vs Product Batch & Expiration Tracking