How to manage and track your Shopify inventory as a manufacturer

Today Shopify is one of the most popular e-commerce platforms around — learn how manufacturers can use third-party software to optimize your inventory.

T-shirt maker at workstation looking at an open laptop checking their Shopify Inventory Tracking.
Published: 02.12.2020

Selling online is a must in today’s digital world. Direct access to customers, immediate feedback on your products, and more control over your customer service without paying any traders or resellers are just a few of the benefits of having an online sales channel. 

Many manufacturers use Shopify as their go-to e-commerce platform. While Shopify is a great and easy-to-use tool to get started with as a direct-to-consumer (D2C) manufacturer, there’s one crucial element missing — Shopify inventory tracking isn’t built for manufacturing. Shopify may have started in a humble maker’s garage, but rapid growth has seen the number of sellers on the platform explode from 6,000 to over 800,000 in less than ten years. 

Today Shopify is one of the most popular e-commerce platforms around — and this article will look into how manufacturers can use Shopify’s online store inventory management for their business and the third-party software that helps them manage production and inventory.

Purpose-built inventory management for Shopify. Katana helps Shopify manufacturers take control of their raw materials, WIP, and finished goods inventories. Sync your sales and manufacturing orders with Katana’s 14-day free trial.

How to track product inventory with Shopify

Shopify comes with basic inventory tracking that allows you to adjust the inventory in your Shopify account manually. Because it’s already included in the Standard plan, many Shopify sellers make do by managing inventory this way. To set it up, you need to enable transfers:

  1. Go to your Shopify admin panel
  2. Select one of your Shopify product variants and click on Edit
  3. In this window, go to the Inventory section and find the Inventory Policy drop-down menu
  4. Select Shopify Tracks this Product’s Inventory
  5. Don’t forget to save your changes

After you set up a transfer for one of your products, you can Shopify to receive inventory for this particular Shopify SKU. You can click on Add Transfer to set the number of items expected to be supplied into your Shopify inventory.

If you need a way to track raw materials, inventory, product recipes, and production processes, this won’t work — and neither will large, clumsy Excel sheets. External Shopify inventory control systems have become a viable option to iron out the creases in the platform’s native system and give you the visibility you need over all aspects of your Shopify business — from sales and inventory to production.

But before diving into the different types of job shop manufacturing software that integrate with Shopify, let’s first explore the native Shopify online store inventory system in more depth.

Is Shopify’s built-in inventory solution enough for manufacturers?

Many manufacturers selling on Shopify ask if it has a ready-made Shopify inventory tracking system — and the answers yes and no. 

Shopify’s basic track inventory function is okay if you’re reselling products, as it allows you to monitor stock coming from a supplier and what you’ve sold. But companies that make their products have a more complex workflow and find the Shopify inventory solution is missing critical features like:

  • Raw material and work-in-progress (WIP) inventory tracking
  • Bill of materials (BOMs) management
  • Production planning
  • Manufacturing floor-level control
  • Manufacturing cost calculations

Do you use Excel to Shopify track inventory and production? We’ve got news! There’s a better way of managing inventory on Shopify. The best way to handle Shopify inventory tracking is to take advantage of Shopify inventory software like Katana.

When it’s time to level up to a third-party Shopify inventory management system

You may be able to manage your sales and track your inventory with Shopify, but Shopify’s online store inventory works best for drop shippers or merchants who act as a middleman. Even with a decent inventory system to track your finished goods, most inventory management systems do not come with features for monitoring your raw materials or WIP inventory.

Manufacturers can take their Shopify inventory management to the next level with third-party software that integrates with Shopify like Katana, which includes a range of manufacturing features that give control of all the moving parts of your business.

1. Master planning features

Eliminate manual tracking with software that supports master planning. Katana allocates products and raw materials to open orders based on availability and allows you visually track order progress in real time.

By easily tracking order statuses and implementing better procurement practices, you can your order fulfillment rates and keep your customers happy and your team aligned.

2. Sales order fulfillment synchronization

There’s no need to run back and forth between the different apps that you use with Katana. Synchronize your sales orders with third-party software to update the fulfilled and delivered sales on both Shopify and Katana.

This synchronization process also transfers to your inventory —once a finished good is removed from one inventory list, the other app will also reflect the reduction.

3. Optimized production process

The basic Shopify inventory system doesn’t give you any functions to manage your production processes. Using manufacturing ERP software like Katana lets you plan and schedule production while reprioritizing your important orders.

Best of all, if the system has master planning features, reprioritizing your workflows will result in automatic reallocation of your products and materials. Once integrated, Katana automatically receives all orders from Shopify and allows you to get better Shopify inventory tracking of your raw materials and production process.

This way, you never miss a deadline, and you’ll always have the right number of materials available in stock.

T-shirt maker enjoying a coffee break while checking laptop to see the operation status on their Katana account.

Setting up Katana for Shopify inventory tracking

1. First, log in to your Katana account. If you don’t have a Katana account you can sign up for a free 14-day trial here.

Screenshot of Katana log-in page.

2. Click on Settings in the main menu

3. Select Integrations from the left-hand side menu.

Screenshot of Katana's integration page.

4. An input screen will pop up showing three stages. For the first, you need to input your Shopify Store address and click Next once finished.

In our case, that will be leatherstore21 a leather manufacturer.

Screenshot of Katana integration process to connecting Shopify.

5. On the next screen, make sure the options to import Shopify customers, products, and stock levels of products are selected. You can choose to apply the same tax rates applied in your Shopify store to your Katana products.

Also, you can set the initial price of your products in Katana to exclude the tax rate applied to your Shopify products.

Screenshot of Katana integration process to connecting Shopify - importing data.

6. On the final screen, you can review your settings. When you are satisfied click Ok, connect my store and the system will automatically redirect you to your Shopify store. Install the app then you’re ready to roll!

Screenshot of Katana integration process to connecting Shopify - reviewing configuration data.

Congratulations! You have now integrated your Katana account with Shopify and it took less than a minute. This will save you hours of time importing and exporting orders manually.

How to track raw materials for your Shopify orders with Katana

Here’s a quick tutorial on setting up your Shopify and Katana integration to track inventory and more.

Now that we can see all our orders and products, we can move on to adding the materials necessary to create our products.

For example, the raw materials necessary to produce one of our wrap wallets are thread and leather in various colors — brown, black, beige, and cognac. Let’s add these into Katana, by clicking the + sign and Material.

Screenshot of Katana - adding new materials.

Add the material variants if you need them. In our case, we have leather in four different colors.

Screenshot of Katana - adding material variants.

Nex, add your variant code, reorder point, and purchase price. Once done, let’s create the product recipes, based on the materials we’ve just added.

For a wrap wallet, we need 13 feet of thread and 3 square feet of leather (brown, black, beige, or cognac). By clicking Add new row you can add all the ingredients you need, in the specified quantity and color.

Screenshot of Katana - creating a bill of materials.

Finally, let’s see what actions need to be done, in order to produce one wrap wallet.

In the Production Operations tab, we’ll add CuttingSewing, and Assembly as operation steps, with their respective resource, cost per hour, time or duration, and cost.

Screenshot of Katana - adding BOM operations.

Shopify inventory software

Managing your Shopify inventory doesn’t have to be painful. Katana connects to your Shopify store and hundreds of other integrations to help you scale your business with ease.

How to select the right Shopify inventory solution as a manufacturer

There are two important steps to start handling your production and inventory management properly:

  1. Know what needs to be produced to fulfill a sales order 
  2. What materials are required to complete production

When an order comes via your Shopify store, an integrated app like Katana will automatically pull the order and give you the answers to the following critical questions:

  • How many units of ordered products are immediately available in the stock for delivery?
  • How many units of ordered products are missing that need to be produced to fulfill the order?
  • What materials are required to produce the missing quantities?
  • Are these materials available in stock, or should you order some additional materials from suppliers?
  • When do missing materials arrive so that that production can resume?

Answers to the first two questions listed above are typically available on the sales order level. As soon as you open the Shopify-imported sales orders in your manufacturing ERP software, you will see product availability information based on your actual stock levels.

This means you can see how many units of ordered products are available in stock and how many units you need to be additionally produced to fulfill the order. But Katana takes it up a notch and shows you how many units of products are available in stock and how earlier sales orders have already reserved many units expected from production.

How priority-based resource planning software makes Shopify inventory management simple

In Katana, you can also change the priorities of sales orders via drag-and-drop if you need to prioritize a recent order for fulfillment earlier than other open orders. It also automatically reallocates available units of ordered products based on sales order ranking — this makes it easy to manage express orders that need to be delivered to customers as soon as possible.

Screenshot of Katana - sales page.

To answer the last three questions, you need to define production recipes (bill of materials) for each product you make, as in the leather accessories example above. Think of it as a link between the final product and the materials you use for producing it.

Once Katana has the production recipe info available and you have created a manufacturing order for the missing units, Katana will tell you exactly what materials you lack and when those materials will be available. For all the missing materials, you can create a purchase order with a click of a button, and it will be automatically sent to your suppliers.

Screenshot of Katana - manufacturing card.

Also, when you complete your manufacturing orders, Katana’s manufacturing ERP system will automatically reduce the stock levels of materials consumed during production and increase the stock level of products produced.

Typically, Shopify inventory apps lack the functionality of production recipes, and thus, you end up adjusting your stock levels manually. You can also use Katana to create production recipes that include sub-assemblies, which are products inside products, inside products — you get the idea. This will give you visibility over materials required throughout multilevel product recipes.

Additionally, manufacturing ERP software typically has built-in reorder point and safety stock functionality. By setting desired levels, you can always keep your stock levels optimized to have the right level of products and materials available.

Know what is being produced next and plan ahead

A manufacturing plan is rarely set in stone. On a typical factory floor, changes happen hourly, affecting your daily and weekly production plan. A sales order might get canceled, a floor-level employee might call in sick, a supply order of materials required for production may be delayed, and so on.

That’s why it is important to work with flexible software that makes it easy for you to change priorities in sales and production on the fly. A good planning functionality means you can:

  1. Change the priorities of sales orders with a drag-and-drop and immediately see the availability of products in stock and products expected from production based on changed priorities
  2. Clearly see the link between a sales order, related manufacturing orders, and related purchase orders for materials
  3. Get an live overview of the status of each sale, manufacturing, and purchase order currently being processed
Screenshot of Katana - Sales orders.

Track Shopify inventory and more with a free Katana trial

Here is a summary of what you get when using Katana’s Shopify inventory integration.

  1. Get out of spreadsheets — By upgrading to Katana’s Shopify inventory management system, you’ll be able to avoid delays caused by the inefficiencies of Excel spreadsheets.
  2. Seamless product tracking — when you get an order through Shopify, it immediately appears in the Katana system. Create a manufacturing order with Katana straight away.
  3. Keep track of raw materials — quickly allocate raw materials based on Shopify order priority. Make sure there is no confusion between products that require the same materials.
  4. Manufacturing floor-level control — get Shopify orders to your shop floor immediately. Fulfill orders with task lists for every production employee and production line. 
  5. Integrating accounting software — alongside your Shopify store, you can also connect Katana to accounting software like QuickBooks Online and Xero to generate invoices.
  6. Set reorder points – by establishing a reorder point on your products or material. Katana will notify you when inventory is running low, helping you avoid stockouts.
  7. Manage bulk orders with ease — rather than getting multiple Shopify add-ons. You can use a system built to adapt to high-demand periods to avoid inventory issues.

Take your inventory management to the next level and try Katana for 14 days free — no credit card or commitments required.

Get the visibility you need to move products and make decisions
Start a free 14-day trial*
*No credit card required