support

Author Topic: Possible to see the net worth of my total product inventory?  (Read 7365 times)

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
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

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
Re: Possible to see the net worth of my total product inventory?
« Reply #1 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?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2174
  • Karma: +345/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Possible to see the net worth of my total product inventory?
« Reply #2 on: May 12, 2016, 11:27:57 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)
 
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4367
  • Karma: +302/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Possible to see the net worth of my total product inventory?
« Reply #3 on: May 12, 2016, 12:50:46 PM »
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;

Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline jaysbar

  • Full Member
  • ***
  • Posts: 139
  • Karma: +13/-5
    • View Profile
Re: Possible to see the net worth of my total product inventory?
« Reply #4 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!


 

Powered by SMFPacks Social Login Mod