Can I find my inventory worth?

Highlighted
New Member
5 0 0

Hi, Im doing my books, and I don't know how to get a total of what my inventory is worth? is there a way to view that, or an app that will tell me how much the worth is, of all my stock?

0 Likes
Highlighted
Shopify Partner
1901 82 242

https://docs.shopify.com/manual/products/import-export/export-products -> CSV -> Excel.

Problem Solved? ✔️Accept and ? Like the solution so you can help others.
Buy me a coffee ☕ paypal.me/paulnewton or donate to eff.org
Confused? Busy? Buy a custom solution paull.newton+shopifyforum@gmail.com.
0 Likes
Highlighted
New Member
5 0 0

thanks paul!

 

0 Likes
Shopify Partner
1901 82 242

No problem , that is most direct method to add it to the office workflow.

But if you need to check it often but can't automate yet,  there is also the option of using liquid to get custom displays by duplicating your theme(for private previewing only) and customizing  collection.liquid to be a inventory tool:

  <div class="row products">
    
  {% assign InventoryTotal = 0 %}
	<table>
      <tr><td>title</td><td>price</td><td>inv. qty.</td><td>Total</td></tr>
    {% for product in collection.products %}
		{% assign sortedVariants = product.variants | sort:'price' | reverse %}
      {% for variant in sortedVariants %}
      <tr>
        {% assign variantTotalWorth = variant.price | times: variant.inventory_quantity %}
        {% assign InventoryTotal  = InventoryTotal | plus:variantTotalWorth %}
        <td><a href="/admin/products/{{product.id}}/variants/{{variant.id}}">{{ variant.title }}</a></td>
        <td>{{variant.price | money_with_currency}}</td>
        <td>{{ variant.inventory_quantity }} units</td>
        <td>{{variantTotalWorth | money_with_currency }}</td>
      </tr>
      {% endfor %}
	{% endfor %}
	<!--        dom trick makes it appear at top of table, to put at bottom place the H2 element outside of the table element -->
       <H2>Total Inventory Worth: {{ InventoryTotal | money_with_currency  }}</H2>
          </table>
   
  </div>

etc

Problem Solved? ✔️Accept and ? Like the solution so you can help others.
Buy me a coffee ☕ paypal.me/paulnewton or donate to eff.org
Confused? Busy? Buy a custom solution paull.newton+shopifyforum@gmail.com.
0 Likes
Highlighted
New Member
1 0 0

Hey Paul,

I exported my products by vendor in hopes of figuring our worth of products in stock by vendor but there's no inventory count? What did I do wrong??

~LeeAnne

0 Likes
Highlighted
New Member
2 0 0

I have been looking for this myself. It's hard to imagine but it seems you need to make a price list, them download the inventory report and match them up based on sku. Not a simple process. What else are people doing?

0 Likes