Stock Reports

[Jnr]

Hello all,

 

I'm new to the forum and OSCommerce so am more than likely to ask what you would consider to be dumb questions.....

 

For my first one.

 

Is it possible to produce a report that shows your current market value?

 

 

Thanks

 

Jnr

[Velveeta]

Hello all,

 

I'm new to the forum and OSCommerce so am more than likely to ask what you would consider to be dumb questions.....

 

For my first one.

 

Is it possible to produce a report that shows your current market value?

Thanks

 

Jnr

Are you a publicly traded company?

 

Richard.

[Jnr]

Are you a publicly traded company?

 

Richard.

 

I am a limited company.....

[Velveeta]

I am a limited company.....

Does that just mean LLC (Limited Liability Company)? If so, I don't know that you have a current market value... Since you reference 'market value' in a post entitled 'stock reports', I'm guessing you mean your current stock market value, and unless you're a publicly traded company, you don't really have a stock market value, you're privately owned, and your value is only determined by your sales versus your cost to maintain the company...

 

Richard.

[Jnr]

Does that just mean LLC (Limited Liability Company)? If so, I don't know that you have a current market value... Since you reference 'market value' in a post entitled 'stock reports', I'm guessing you mean your current stock market value, and unless you're a publicly traded company, you don't really have a stock market value, you're privately owned, and your value is only determined by your sales versus your cost to maintain the company...

 

Richard.

 

Ahh ok.

 

I've given the wrong impression here..... What I am after is the Retail stock value of the products currently in stock.

 

I am a UK Limited company trading with shop and online store.....

[Velveeta]

Ahh ok.

 

I've given the wrong impression here..... What I am after is the Retail stock value of the products currently in stock.

 

I am a UK Limited company trading with shop and online store.....

Oh ok, you just mean like, if you have 30 products that retail for $10 each, their retail stock value is $300?

 

Richard.

[Jnr]

Oh ok, you just mean like, if you have 30 products that retail for $10 each, their retail stock value is $300?

 

Richard.

 

Indeed, thats just what I'm after.....

[Velveeta]

Indeed, thats just what I'm after.....

Then yes, to get your stock's retail values, you could run a query like this:

 

select (products_quantity * products_price) as products_stock_value from products;

 

You might be able to do this for all products at once and get a grand total like this:

 

select sum(products_quantity * products_price) as products_total_stock_value from products;

 

I'm not sure if that'll work or not, so you'd have to just give it a shot, I'm at work right now or I could test it before giving that to you :)

 

Richard.

[Jnr]

Then yes, to get your stock's retail values, you could run a query like this:

 

select (products_quantity * products_price) as products_stock_value from products;

 

You might be able to do this for all products at once and get a grand total like this:

 

select sum(products_quantity * products_price) as products_total_stock_value from products;

 

I'm not sure if that'll work or not, so you'd have to just give it a shot, I'm at work right now or I could test it before giving that to you :)

 

Richard.

 

Thanks Richard but now this is where I come across really dumb, Where would I issue that from within OSCOmmerce?

[Velveeta]

Thanks Richard but now this is where I come across really dumb, Where would I issue that from within OSCOmmerce?

You would create a new report page for it, send it in a tep_db_query, and output the results in a listing format for each product, or just as 1 total, depending on how you wanted it displayed...

 

Richard.

[Jnr]

You would create a new report page for it, send it in a tep_db_query, and output the results in a listing format for each product, or just as 1 total, depending on how you wanted it displayed...

 

Richard.

 

Thanks Ricahrd, I shall give it a go tomorrow!

 

 

Cheers

 

John

[Guest]

Aren't there any contrib that does this? I'd really appreciate something that told me my total stock value.