Inventory Template

The inventory spreadsheet template from Mixtable allows you to track product availability, understand inventory distribution, and make data-driven decisions that can improve operational efficiency and customer satisfaction.

With one click, you can have inventory data directly into a spreadsheet. Here’s how to load the Inventory template:

• After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.
• Select the Inventory pre-built template in the dialog that appears, and you will be ready!

How to use the Inventory template to make data-driven decisions

Here’s what you can use the Inventory template for:

• Restock planning:

  If the spreadsheet shows low stock for a best-selling product in multiple warehouses, it suggests an urgent need to restock or adjust stock allocation. (see below how to load the data)

• Overstocked slow-moving products

  If products have large inventory and minimal orders for the last month or so, you can initiate clearance promotions or discounts to move the excess inventory. (see below how to load the data)

• Deadstock identification

  If products have high stock levels across all warehouses but haven’t had any sales in the last three months, classify them as dead stock and take steps to reduce holding costs, such as bundling them with other items, offering deep discounts, or returning them to the supplier.

• Discontinued product:

  Products with consistently low or zero stock across all locations might indicate outdated or discontinued items, which need to be removed from the catalog.

• Seasonal product patterns

  Reduce stock levels during off-peak seasons and plan for seasonal stock increases closer to the holiday sale period to optimize space and minimize overstock costs.

• Trending product

  A sharp decline in the inventory of certain products over a short period (e.g., a week) may indicate a trend or seasonal demand spike. Plan to increase stock from suppliers or transfer stock from slower-moving locations to meet demand.

Shopify data included in the Inventory template

The Inventory template contains the following default columns:

• Title
• Handle
• Option 1, 2 and 3
• Headquarters available
• Main Warehouse available
• Column for every warehouse

How to add Inventory Adjustment data to your spreadsheet:

Inventory adjustments let you quickly increase or decrease stock at a location, avoiding incorrect values when multiple users or apps make changes. Add this column to your Inventory template to manage adjustments easily.

Here’s how to do it:

• Select an empty column (or insert a new one) in your Products with Inventory worksheet.
• Click Set Sync from the column header.
• Select Inventory Adjustment, and from the drop-down on the right, choose the warehouse for which you want to apply the adjustments.
• If you want to display all warehouses, use the Set Sync function for each location.

Analyze Inventory data with spreadsheet functions

Operating in the Mixtable Spreadsheet Editor app allows you to use any spreadsheet function to analyze and manage your data, such as:

• sort ascending or descending,
• find-replacе,
• filter,
• use formulas, e.g., for price changes, etc.

Here are some examples:

Predict restocking:

• In your Inventory worksheet, add a column for Net Sales for the last 7 or 30 days (see above)
• Order the Net Sales column descending to see the best-selling products on top.
• See if stock levels are relevant to the demand or if you need to plan for faster restocking so as not to lose sales or dissatisfy customers with longer delivery times.

Identify slow-moving products or dead stock:

• In your Inventory worksheet, add a column for Net Sales for the last 90 days (see above)
• Sort the Net Sales column ascending to see the worst-selling products on top.
• See which products have high stock volume and low or zero sales for the period.
• Plan for discounts or product bundling campaigns to clear warehouse space from these products.

Frequently Asked Questions:

Q: Can I see inventory locations in a spreadsheet?

A: Yes! By default, the Inventory template loads all warehouse data and updates the product availability in real-time. Here’s how to see it:

• Follow the steps from the beginning of this page to load the Inventory template spreadsheet.
• The last columns in the spreadsheet are the warehouse locations as specified in your Shopify store. In the screenshot below, you can see how that looks for our demo store:

Find out more about the Mixtable suite of products here.