AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: jaysbar on May 06, 2016, 05:26:34 AM

Title: Possible to see the net worth of my total product inventory?
Post by: jaysbar on May 06, 2016, 05:26:34 AM

Hi

Is it possible to see the total net worth of my total product inventory? For example, lets just say I have a total of 10 products in my store and each one is worth £10. The total worth of my store is £100. But where can I see this info at a glance?

Thanks

Jay

Title: Re: Possible to see the net worth of my total product inventory?
Post by: jaysbar on May 12, 2016, 05:16:56 AM

Hi

Please can someone let me know if I can see the total value of my products for sale?

Title: Re: Possible to see the net worth of my total product inventory?
Post by: abolabo on May 12, 2016, 11:27:57 AM

Quote from: jaysbar on May 06, 2016, 05:26:34 AM

Hi

Is it possible to see the total net worth of my total product inventory? For example, lets just say I have a total of 10 products in my store and each one is worth £10. The total worth of my store is £100. But where can I see this info at a glance?

Thanks

Jay

all possible, but only with your own extension. it's you custom case.

fyi AbanteCart can sale not only products that present in inventory (for ex. digital products, pre-order etc)
 

Title: Re: Possible to see the net worth of my total product inventory?
Post by: abantecart on May 12, 2016, 12:50:46 PM

Quote from: jaysbar on May 06, 2016, 05:26:34 AM

Hi

Is it possible to see the total net worth of my total product inventory? For example, lets just say I have a total of 10 products in my store and each one is worth £10. The total worth of my store is £100. But where can I see this info at a glance?

You can run a simple database query that will give you SUM of your products.
select sum(price) from abc_products;

Title: Re: Possible to see the net worth of my total product inventory?
Post by: jaysbar on May 13, 2016, 05:30:22 AM

OK that helps. Thank you.

Would d it not be possible to add "total store worth" in the reports section? I'm sure many people would like to know how much their inventory is currently worth. Or maybe a custom reports section where they can choose various fields from the DB to report on.

Nevertheless Abantecart is AWESOME software! Thank you!