ZC Inventory Report Module

[strettonbull]

Hi, I have installed this mod, but it does not appear under "Admin", "Tools" despite refreshing. I do have "Sage Configuration" under the "Configuration" menu though.

Any help would be appreciated.

[wmorris]

Hi, I have installed this mod, but it does not appear under "Admin", "Tools" despite refreshing. I do have "Sage Configuration" under the "Configuration" menu though.

Any help would be appreciated.

Its not under "Tools" its under "Reports"

[strettonbull]

Its not under "Tools" its under "Reports"

Doh! How thick am I?

Thanks so much.

[BrightGreen]

This is a really useful mod.

My brief was to find away to check stock on the website against actual stock in our warehouse. I spent ages trying to work out how to download stock list to an Excel spreadsheet for cross checking as that was all I could think of.

This report/function is even better than I had hoped in that our website can be immediately updated using a tablet/iPad as the stock is checked on the ground.

Thank you :-)

Natalie

[jbthomasfl]

This is a really useful mod.

My brief was to find away to check stock on the website against actual stock in our warehouse. I spent ages trying to work out how to download stock list to an Excel spreadsheet for cross checking as that was all I could think of.

This report/function is even better than I had hoped in that our website can be immediately updated using a tablet/iPad as the stock is checked on the ground.

Thank you :-)

Natalie

So... is it possible to export the resulting report to a spreadsheet?

[DivaVocals]

So... is it possible to export the resulting report to a spreadsheet?

Try copy & paste.. I copied and pasted the full report into an Excel spreadsheet with no issues..

[dbltoe]

Really liking this and appreciate (as usual) ajeh's addition. Hope it will be added to the plug-in release soon.
Just want to suggest two small changes to the stats_inventory_report.php that Linda added above (post 21).
Note: The following line numbers are based on the changed file.
The heading row starts on line 134 and ends on line 148 of the file.

      <tr>
        <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=p.products_id&dir=<?php echo $dir_id; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_NUMBER; ?></b></a></td>
                <td class="dataTableHeadingContent"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_name&dir=<?php echo $dir_name; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_PRODUCTS; ?></b></a></td>
                <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>
                <td class="dataTableHeadingContent" align="right"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_price&dir=<?php echo $dir_price; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_PRICE; ?></b></a></td>
                <td class="dataTableHeadingContent" align="right"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=total&dir=<?php echo $dir_total; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_TOTAL; ?></b></a></td>
              </tr>

The outputs for the Master Category and Model are actually left aligned while the titles are centered.
How about this for a little cleaner look?

      <tr>
        <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=p.products_id&dir=<?php echo $dir_id; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_NUMBER; ?></b></a></td>
                <td class="dataTableHeadingContent"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_name&dir=<?php echo $dir_name; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_PRODUCTS; ?></b></a></td>
                <td class="dataTableHeadingContent"><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"><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>
                <td class="dataTableHeadingContent" align="right"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_price&dir=<?php echo $dir_price; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_PRICE; ?></b></a></td>
                <td class="dataTableHeadingContent" align="right"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=total&dir=<?php echo $dir_total; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_TOTAL; ?></b></a></td>
              </tr>

What this does is change the

<td class="dataTableHeadingContent" align="center"> 

for both the Master Category and Model to

<td class="dataTableHeadingContent"> 

removing the align="center". Don't forget to also remove the space that was in front of the align call.