If you’re in charge of inventory at your company, then you know how important it is to keep track of everything that comes in and goes out. Overselling is one of the worst things that can happen to a business, so having a good inventory management system in place is essential. Fortunately, there are a number of software programs that can help you with inventory management.
There are a few different ways that you can keep track of your inventory.
We will cover some of the other platforms in another lesson, but for now let’s focus on the giant with the highest overall market share: WooCommerce.
You will need:
You will be installing:
WP Mail SMTP
If you are already using a hosting service provider, it’s likely that you already have a One-Click WordPress Installation feature or something similar. If you are not already using a hosting service provider, you can start with Google Hosting right from ImgFunnels. Simply click on Sites from your Dashboard, then click the WordPress tab.
Tip: Other hosting service providers, such as DreamHost, offer more flexability when it comes to hosting plans. ImgFunnels offers migrations starting at $25. If you need help, contact your hosting service provider or send us a message!
WooCommerce makes it easy to track inventory and keep track of your stock levels. In this guide, we will show you how to install and configure WooCommerce to get started with inventory management.
First, you will need to install the WooCommerce plugin. You can do this by navigating to Plugins > Add New and searching for “WooCommerce”.
Once the plugin is installed, you will need to activate it. You can do this from the Plugins page in your WordPress admin area. Once WooCommerce is activated, you should follow the onboarding section titled “Let’s Get You Started” found at the top of WooCommerce > Home.
After you have completed the onboarding, return to the Products area and click Add New.
Add a new product using the form provided. If you ever need to return to this product to Edit it, click the Edit button next to the product in the list view located in the Products area.
From the Add/Edit Product page, you can choose to track inventory by product, by variation*, or by SKU. You can also set up low stock notifications, so you can be alerted when your stock levels are low.
Once you have configured your inventory settings, you can start adding products to your WooCommerce store. To do this, you will need to go to the Products page and add a new product. On the product page, you can enter your product name, description, price, and other details. You will also need to select the Inventory tab and enter your stock level.
You can also set up backorders for your products. This allows customers to order products even if they are out of stock.
Once you have added your products, you can start selling them in your WooCommerce store.
* What is a variation?
A variation (or variant) is used to identify specific attributes of your products—usually color and size.
Tip: Make sure that you have installed WP Mail SMTP plug-in. The default (PHP) mailer does not guarantee deliverability. If you need help with deliverability, we can install an SMTP for you starting at $5 per month, $0.001 per email and $0.012 per email verification.
Installing WP Mail SMTP
Bulk Editing Plugins
This is where inventory management starts to get sort of tricky. If you’re just starting out, you may want to consider using a plug-in for bulk inventory management.
As for free plugins, we recommend BEAR – Bulk Editor and Products Manager, but at the time of writing, another plug-in called PW WooCommerce Bulk Edit, that seems to have gained attraction. If BEAR doesn’t work for you, you may want to consider trying an alternative.
As for paid plugins, we recommend the official WooCommerce Bulk Stock Edit Plugin.
Tip: You can install plug-ins from the WordPress plugin repository or by uploading the plugin files to your WordPress site.
If you are not a Database Administrator, this next section is not for you.
Doing it the “old-fashioned” way (RDBMS)
If you are an experienced developer with a healthy knowledge of database management, let me let you in on a little secret. Products in WooCommerce are found in the database categorized as “Posts” (usually found in the `posts` table). Most of the WooCommerce tables (prefixed with `wc`) are junction (or lookup) tables.