how to find total inventory value on shopify

in this video i am going to show you how,to pull across your inventory count from,your inventory shopify report,and add it into your products export,report so this is the product export,this is an inventory export i've got,here,they used to have this column in this,export so when you exported all your,products from shopify just to show your,inventory count so how many products you,had for each,sku item for some reason they took that,out because it's such a useful piece of,information,they decided to remove it from the,export report i don't know why but i,imagine some,developer thought that was a good idea,and there's a technical,reason maybe anyway so now,the workaround is a quick google search,found um able bits i've got this,merging cell option that's what we're,going to do we're going to copy a cell,from another report and bring that over,and we're going to cross check it and,you can get it here merge,sheets it's called from able bits uh,once you get it install it just reload,your um you know if you install it in,here reload just refresh the page and,it'll appear under add-ons here merge,sheets,so what i do i've got my inventory,spreadsheet here we're going to copy,all of these i'm just going to copy this,entire sheet,and i'm going to go back into my all,products i'm going to add a new sheet,below here,and then i'm going to paste that in i'm,just going to rename this one,inventory let's just give that a second,to paste,in you probably could do this with two,individual um pages open but,i think it's having it in two sheets,means you can work together,i think it actually probably it works,like this so i was going to call this,inventory so i know what it is so,inside here i've got my inventory count,column okay so bring these together put,your,inventory and your sku number together,and then go to the products,export and from here i click,insert right and i'm just going to,rename this something like variant,quantity so what we're going to do now,is match up,this skew number to this sheets,skew number here and then we're going to,say give me all this quantity,match them up and then drop them into,this column here,okay so that's how we do it so we go to,add-ons and we click start,so this is the merge sheet add-on if i,just scroll over to the right we should,see both,okay come on come on right here we go um,i don't want to take this i've used this,once you might actually have to buy it,eventually,um in fact the time it's just saved me,it's probably worth buying eventually,for me when i use it,so what i'm gonna do is gonna i wanna,highlight,these two columns together like that so,i'm highlighting them saying these are,two i'm working with,n and o and we click next,and it's then asking me which columns,here on the inventory one so let me just,go to here,i want these two,so there you go i and j um so that's,what it's doing select the lookup column,sheet,so that's what i'm saying to it select,the lookup and then it's saying select,matching columns so i want to select,matching columns to be,my variant sku i want to match with the,sku,on my inventory sheet,okay don't check this one yet go to the,next page and then i'm saying,select columns to add or update so i,want to update,my main sheet now with the sku number,from the other sheet,and it's add values to,or update values in sorry update values,in select the column variant quantity so,if you remember this is the,um column that i've typed and the news,should be i've actually put a typo there,so that's on my new sheet so what it's,saying now is copy everything from this,column um kemptown update the values in,the new spreadsheet,called variant quantity and then click,next,you can do this to check this one add,non-matching rows,to the end of the table and add a status,column so this will actually tell you if,you've got things like missing rows,and stuff like that and you can choose,the colors if you want i didn't bother,click,next and what it does over here on the,right you should start see,the variant quantity appear in fact,you'll see a new row there you go new,column gets added,and it's still processing and there you,go so it says here we've got 933 of the,2049 matching rows were found,um and 109 well sorry 1933,rows were updated 56 were missing and,what you can do then if you just want to,confirm that this,has worked you know you can just scroll,on down here what i did i,copy one of these skew numbers here and,even just go you could go to the sheet,you've got here and do a double check i,actually went over to the,main sheet that i had copied off before,i do a quick search in there,there's the skew number it shows me i've,got 24,so if i go back to the product count,that i was,i've pulled over,i think it was that one with 24 let me,double check 106. there is and,i've done this a few times so scroll on,down here's one with 85 so,copy this sku number here and then go to,85 then go to the inventory report again,search,there's the sku there's the number 85.,i've done this a few times you could do,this as many times as you like just to,confirm to yourself,that it has worked here's another one,with 12.,um so if i go back to the other,inventory report and do a search,there you go it shows 12 down here so,that is how you do it,shopify if you watch this video i don't,know why you took that column out,um because it saves for,me running this site it saves me having,to buy another app,um that i then have to use that i'm,going to spend,you know some of the apps are great all,that i understand i totally get it but,for 19 quid a month or something to do,the simple report like that i don't need,to do it so it just depends on your own,budget and what you're doing,but i know for this site that i run for,the client they don't want to spend that,so they i can go on a quick report like,that and it's done,or they will actually go and do it,themselves now because they can watch,this video,so that's how you can get your inventory,quantity amounts pulled into your,product export spreadsheet,find out things like your total cost,price or,how much stock you've got on hand in,cost price or how much,stock you've got in retail value so you,obviously would times,your quantity by your cost price and,then you could run,a check if you wanted to know your cost,so insert on the right for example if i,just go,i want to create a sum so equals i want,to times,the quantity that i've got so how many,items i've got with the price so click,on that one press,enter it comes up with an auto fill,suggest it does the whole lot down there,for me,and then at the bottom i can run a total,on see how much,um stock value i've got in hand at cost,price hope that video helps some of you,and if it does let me know and if you,want any shopify help,feel free to reach out

Congratulation! You bave finally finished reading how to find total inventory value on shopify and believe you bave enougb understending how to find total inventory value on shopify

Come on and read the rest of the article!