Feature: Size Columns

Learn how to use My Stock Sheet on Shopify and show one row per product with size-level quantities and a total stock column for your wholesale buyers and sales reps.

  • Basic plan
  • Size columns
  • Total stock

Why use My Stock Sheet

If you're looking for a Shopify App that allows you to export your inventory in Excel format for your wholesale business operations - we've got you covered. My Stock Sheet allows buyers to export your live inventory in a standard Excel format, complete with all product-related fields they might need.

When buyers are looking at your exported inventory to place an order, they expect immediate legibility: products should be easily identifiable, quantities per size should be clear and additional columns should support the buyer by offering additional details about each item. Shopify's default Excel export does not meet those requirements.

How to use Size Columns

Creating your customized size-run stock sheet is very simple with My Stock Sheet, and only takes one minute.

Download the Shopify App and install it on your webstore - all features mentioned in this guide are included in the Free plan. After you've installed it, open the app in your Shopify Admin section. Your size-run stock sheet file is already available in the dashboard, and can be downloaded by visiting the download link. If you're located in a non-English speaking country, you need to configure your Size Attribute Name in the Settings section according to the size variant naming system your online store uses.

For example, if you're a store based in France, you probably use Taille instead of Size. In this case, you should set the Size Attribute Name setting to Taille. Size columns in your exported file will be automatically displayed based on this setting, and any other variants will be displayed as individual rows.

Frequently Asked Questions

Are size columns fixed?

No. They are generated from the Size Attribute Name you configure.

Can totals still be shown?

Yes. By default, each row includes both size values and a total stock column.

Does it work for single-variant products?

Yes. Single-variant products export in the same structure with total quantities.