Stock vs. Sales Report Thread

[ts232]

I am happy to give back to the ZC community with this report that I have found very useful for managing my own store.

https://www.zen-cart.com/downloads.php?do=file&id=1371

Stock vs. Sales Report
--------------------------

- For each product sold in a given period (specified in the stats_stock.php file), determines total sales for the product, current stock level, and how many days until the product is projected to be out of stock.

- This is very useful for catalogs where the rate of sales between different products varies significantly. For a low selling item you might be fine having only 3 items in stock compared to a high selling item that you need 100 in stock.

- If the product is projected to be out of stock within a number of days that you specify, it highlights the product and shows you an estimate of how many units need to be reordered to remove the alert status.

- Sort by stock projection, current stock, or current sales.

- This contribution tested and working on my Zen-Carts 1.3.9.h. & 1.5.0. I hope it helps you keep track of stock ordering issues as much as it helps me!

[lankeeyankee]

Hi! Thanks for putting this together for everyone!! One question, does this take attributes into account? If not, do you think it can be added without too much reworking of the code?

[ts232]

Hi! Thanks for putting this together for everyone!! One question, does this take attributes into account? If not, do you think it can be added without too much reworking of the code?

That's definitely something that I want to do. I am planning to install the stock by attributes contribution to my 1.3.9h cart soon, and would like the report to work with that.

In the mean time, as a halfway measure, it might be useful to at least break down the sales figures by attributes.

[ozetrade]

Hi. I've just installed this mod but I've got a problem - I get an error - I believe it has to do with the fact that I'm supposed to edit the stats_stock.php file. Problem is your instructions aren't clear on how to edit this file.

I'm getting the following error:

Error!

Unable to determine the page link!

Function used:

zen_href_link('', '&product_type=&cPath=&pID=&action=new_product', 'NONSSL')

Can you provide an example of what needs to changed in the stats_stock.php file.

Thanks.

[ts232]

Hi. I've just installed this mod but I've got a problem - I get an error - I believe it has to do with the fact that I'm supposed to edit the stats_stock.php file. Problem is your instructions aren't clear on how to edit this file.

I'm getting the following error:


Can you provide an example of what needs to changed in the stats_stock.php file.

Thanks.

The defaults should work fine in the php file. No edits required. What version of ZC are you running?

Just saw your signature, that all sites are running 1.3.9h, which is the same as mine. There must be something different between our installs: are you running any SEO or URL rewrites? Perhaps you have something other than the standard product categories?

[mrrocketman]

Hi. I've just installed this mod but I've got a problem - I get an error - I believe it has to do with the fact that I'm supposed to edit the stats_stock.php file. Problem is your instructions aren't clear on how to edit this file.

I'm getting the following error:


Can you provide an example of what needs to changed in the stats_stock.php file.

Thanks.

Hmm, anybody ever figure this one out? Just did a clean install of zen-cart 1.5. Added a new product category and a product to test everything and I’m getting the above error as well.

[ts232]

Hmm, anybody ever figure this one out? Just did a clean install of zen-cart 1.5. Added a new product category and a product to test everything and I’m getting the above error as well.

Does the error occur when loading the initial report page, or when trying to click on one of the product links?

I am working on a new feature version and would like to correct this error, but I am not seeing any of these errors on my cart. An example of the product links generated by the report is:

http://<DOMAIN>/<ADMIN>/product.php?&product_type=1&cPath=6_282_779&pID=106&action=new_product

Are all of the problems happening in 1.5? Anyone having problems in 1.3.x?

[ts232]

Hi! Thanks for putting this together for everyone!! One question, does this take attributes into account? If not, do you think it can be added without too much reworking of the code?

Version 2.0 now has partial support for stock with attributes. I am doing a new version that provides fuller support.

[Carmen]

Hello All!

I downloaded and implemented this addon; "Sales VS Stock Report"
but I don't know if it is working the way it should.

Basically when I run a report it's only showing some of the information. It seems as if there should be several pages but there is no button or link to go to another page. For example when I sort by stock alphabetically ascending it only shows the stock from A-M but there is no other page or button to click to display the rest i.e. N-Z. Likewise if I sort alphabetically descending it only shows from Z-W.

I have tried sorting in different ways like "qty in stock" but it's always the same, only one page of information is displayed and I know that there should be more.

Any advice or help would be very much appreciated :)