Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / All Other Contributions/Addons / ZC Inventory Report Module

ZC Inventory Report Module

Results 1 to 20 of 75
29 Feb 2012, 14:54
#1
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Posts:
4,260
Plugin Contributions:
34

ZC Inventory Report Module

Zen Cart Inventory Report Module v 1.6
https://www.zen-cart.com/downloads.php?do=file&id=1365

This Zen Cart Report module allows for you to check stock levels of the products
in your Zen Cart store. Values included in the table style report are:

Product ID
Quantity in Stock
Product title
Master category
Product Price
Extended Retail value of stock on hand

Included in this report is the ability to sort all of the values above
ascending/descending as well as viewing all or paginating the stock and drop
down filter to show this report by category instead of all products
05 Mar 2012, 19:38
#2
gaffettape avatar

gaffettape

Zen Follower

Join Date:
May 2009
Posts:
433
Plugin Contributions:
0

Re: ZC Inventory Report Module

Hi,

I'm getting the following error on v1.5:

"Parse error: syntax error, unexpected '}' in ..\my_admin\stats_inventory_report.php on line 160"

And the following error on 1.3.9h:

"Parse error: syntax error, unexpected '}' in ..\my_admin_zen\stats_inventory_report.php on line 191"

:blink:
05 Mar 2012, 21:33
#3
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Posts:
4,260
Plugin Contributions:
34

Re: ZC Inventory Report Module

PHP version?

This module is currently running w/o the error you reported on an array of 1.3.7 to 1.5.0 carts numbering in the 50 to 60ish.

So please answer the following:


PHP version?
Modules installed?

The statement, the same in both below is properly closed. I would suspect an error related specifically to your own hosted environment, cart, mods etc.

<? if(is_object($products_split)) {?>
<tr>
<td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_REPORTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_REPORTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], "sort=$sort&dir=$dir&cat=$cat"); ?></td>
</tr>
</table></td>
</tr>
<?php } ?>
05 Mar 2012, 21:44
#4
gaffettape avatar

gaffettape

Zen Follower

Join Date:
May 2009
Posts:
433
Plugin Contributions:
0

Re: ZC Inventory Report Module

Weird.

PHP version: 5.3.10
Addons: 0

Looks like a very handle little addon, I really want to get it working on my store.
05 Mar 2012, 21:55
#5
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Posts:
4,260
Plugin Contributions:
34

Re: ZC Inventory Report Module

It is not PHP 5.3 compatible, sorry
05 Mar 2012, 21:59
#6
gaffettape avatar

gaffettape

Zen Follower

Join Date:
May 2009
Posts:
433
Plugin Contributions:
0

Re: ZC Inventory Report Module

Ah, I see.

Thanks for getting back to me.
08 Mar 2012, 19:52
#7
cerbopoli avatar

cerbopoli

New Zenner

Join Date:
Mar 2012
Posts:
3
Plugin Contributions:
0

Re: ZC Inventory Report Module

I installed this module per the directions and even after refreshing my Admin panel I am not seeing this option in my Reports menu.
08 Mar 2012, 20:02
#8
cerbopoli avatar

cerbopoli

New Zenner

Join Date:
Mar 2012
Posts:
3
Plugin Contributions:
0

Re: ZC Inventory Report Module

Please disregard my post. I resolved the issue.
21 Mar 2012, 00:49
#9
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Posts:
1,558
Plugin Contributions:
1

Re: ZC Inventory Report Module

gaffettape:

Hi,

I'm getting the following error on v1.5:

"Parse error: syntax error, unexpected '}' in ..\my_admin\stats_inventory_report.php on line 160"

And the following error on 1.3.9h:

"Parse error: syntax error, unexpected '}' in ..\my_admin_zen\stats_inventory_report.php on line 191"

:blink:


I got the same error.

To fix it go to line 151 where it says


<? if(is_object($products_split)) {?>


and replace it with


<?php if(is_object($products_split)) {?>



Using zen 1.5
php 5.39


There is also another error which cause the following bug down the bottom of the page where the totals are

format($total); ?>

line 147
<td class="dataTableHeadingContent" align="right"><?echo $currencies->format($total); ?></td>

replace with
<td class="dataTableHeadingContent" align="right"><?php echo $currencies->format($total); ?></td>
21 Mar 2012, 01:02
#10
stizzed avatar

stizzed

New Zenner

Join Date:
Jan 2012
Posts:
42
Plugin Contributions:
0

Re: ZC Inventory Report Module

I recently installed the MOD into a ZC v150 installation. Everything works fine except that I and am having trouble with Admin Security Functionality. Despite the fact that I selected the add-on in several profiles, I receive a 'Sorry, your security clearance does not allow you to access this resource' message using any account other than SuperUser.

Any guidance is greatly appreciated!
21 Mar 2012, 01:13
#11
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Posts:
4,260
Plugin Contributions:
34

Re: ZC Inventory Report Module

Stizzed:

I recently installed the MOD into a ZC v150 installation. Everything works fine except that I and am having trouble with Admin Security Functionality. Despite the fact that I selected the add-on in several profiles, I receive a 'Sorry, your security clearance does not allow you to access this resource' message using any account other than SuperUser.

Any guidance is greatly appreciated!


That one might be a different issue all together. Have you other modules installed and can alter their usage in other profiles?
21 Mar 2012, 01:24
#12
stizzed avatar

stizzed

New Zenner

Join Date:
Jan 2012
Posts:
42
Plugin Contributions:
0

Re: ZC Inventory Report Module

mprough:

That one might be a different issue all together. Have you other modules installed and can alter their usage in other profiles?


Yes. There are several add-ons installed which work perfectly with Admin Security. An example would be SALES REPORT (Judy Gunderson), recently updated for v150.
21 Mar 2012, 01:37
#13
mprough avatar

mprough

Totally Zenned

Join Date:
Nov 2007
Posts:
4,260
Plugin Contributions:
34

Re: ZC Inventory Report Module

Seems odd, as the page register simply adds it to the registered pages. It has nothing to do with the profile function itself.
21 Mar 2012, 01:47
#14
stizzed avatar

stizzed

New Zenner

Join Date:
Jan 2012
Posts:
42
Plugin Contributions:
0

Re: ZC Inventory Report Module

mprough:

Seems odd, as the page register simply adds it to the registered pages. It has nothing to do with the profile function itself.


I asked for guidance regarding the Admin Profile Security functionality in the General Questions Forum. However, after nearly 100 looks I have gotten no responses other than to refer me to this thread.

After reading through some of the newer threads regarding Admin Profile Security it could be that I may not posses the credentials to warrant responses to those inquiries. And I have to guess that if it ~is~ discussed I simply haven't entered the correct search terms :dontgetit
21 Mar 2012, 02:31
#17
nigelt74 avatar

nigelt74

Totally Zenned

Join Date:
Sep 2005
Posts:
1,558
Plugin Contributions:
1

Re: ZC Inventory Report Module

I will confirm that i am getting the same error on a

zen 1.5
php 5.3.9
store

the only changes I have made to the mod have been the changes mentioned in my previous post, which were required to get the mod to work correctly

Stizzed:

I recently installed the MOD into a ZC v150 installation. Everything works fine except that I and am having trouble with Admin Security Functionality. Despite the fact that I selected the add-on in several profiles, I receive a 'Sorry, your security clearance does not allow you to access this resource' message using any account other than SuperUser.

Any guidance is greatly appreciated!
03 Jun 2012, 15:48
#18
gaffettape avatar

gaffettape

Zen Follower

Join Date:
May 2009
Posts:
433
Plugin Contributions:
0

Re: ZC Inventory Report Module

Tried installing this again and seems to be working correctly now, which is great.

I was wondering if there was a way to show and sort via model number, the same way you can via ID#, price, total etc.?

Thanks.
03 Jun 2012, 16:58
#19
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Posts:
62,757
Plugin Contributions:
1

Re: ZC Inventory Report Module

You'd need to customize a few things ...

In the case statement add:
// bof: add products_model
    case('products_model'):
        $dir_model = $op_dir;
        break;
// eof: add products_model


                <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=cd.categories_name&dir=<?php echo $dir_name; ?>&cat=<?php echo $cat; ?>"><b>Master Category</b></a></td>
<!-- // bof: add products_model -->
          <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_model&dir=<?php echo $dir_model; ?>&cat=<?php echo $cat; ?>"><b>Model</b></a></td>
<!-- // eof: add products_model -->
                <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_quantity&dir=<?php echo $dir_quantity; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_QUANTITY; ?></b></a></td>


// bof: add products_model
  $products_query_raw = "select p.products_id, products_quantity, pd.products_name, p.products_model, p.products_price, (products_quantity * p.products_price) as total, categories_name from ".TABLE_PRODUCTS." p left join ".TABLE_PRODUCTS_DESCRIPTION." pd using(products_id) LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON(cd.categories_id = p.master_categories_id AND cd.language_id = '$lang_id') $db_category_where group by p.products_id order by $sort $dir";
// eof: add products_model


                <td class="dataTableContent" align="left"><?php echo $products->fields['categories_name']; ?> </td>
<!-- // bof: add products_model -->
          <td class="dataTableContent" align="left"><?php echo $products->fields['products_model']; ?> </td>
<!-- // eof: add products_model -->
                <td class="dataTableContent" align="center"><?php echo $products->fields['products_quantity']; ?> </td>


              <tr class="dataTableHeadingRow">
<!-- // bof: add products_model -->
                <td colspan="6"> </td>
<!-- // bof: add products_model -->
                <td class="dataTableHeadingContent" align="right"><?php echo $currencies->format($total); ?></td>
03 Jun 2012, 17:26
#20
gaffettape avatar

gaffettape

Zen Follower

Join Date:
May 2009
Posts:
433
Plugin Contributions:
0

Re: ZC Inventory Report Module

Wow, thanks Linda!

It's always appreciated when you go out of your way to help out like that! (Not to take anything away from the addon author, of course.)

I had a go at making the changes to the file myself but I ended up with mismatched table headings and contents. Would it be possible for you to post the entire customized stats_inventory_report.php file?

Thanks :smile: