ZC Inventory Report Module

[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.

[muteyaar]

Hi,
Thanks for the required file which gives the report with model number.

But this file has one problem........ The GENERATE CSV FILE link is missing.
Can you please check and rectify the problem and please upload the new file? It will be very much appreciated, as csv download link is a must.
thanks in advance.

muteyaar

[mprough]

That is not currently part of the module, it's not missing...........................

[muteyaar]

That is not currently part of the module, it's not missing...........................

The CSV DOWNLOAD link is there at the top right of the page when we upload the original files.
But as there is no option of MODEL number, I tried to search and found that Ajeh had given a new file to be replaced in this thread at page number 3.
That file shows the model number very finely, but the CSV FILE DOWNLOAD link (GENERATE CSV) is missing in that case, which is a must have option, because we can only utilize this module properly if we are able to download the csv file of inventory.

I hope you will help me out in this regard.
thank you in advance and waiting for your reply.
- muteyaar

[muteyaar]

See if this helps ...

Hi,
thanks Ajeh for uploading the new file. This file is really helpful as it displays the Model number of all products. But there is one problem...... The GENERATE CSV link is missing when we upload this file instead of original. Can you please rectify the file so that the csv download link is also there?
I really need this.

thanks in advance.

-- muteyaar

[Ajeh]

I have not looked at this since 2012 ...

I do not know when I will have time to look at it again ...

What version Zen Cart are you using?

[muteyaar]

I have not looked at this since 2012 ...

I do not know when I will have time to look at it again ...

What version Zen Cart are you using?

I am using zencart version 1.5.4

I will be really thankful to you if you may please look into it and reply soon. i know you are very busy, but I do not have any other source of help except you.

My requirements are as follows:
1. the GENERATE CSV LINK which is missing.
2. the disabled items are also showing in the inventory list. is there any way that the disabled items are not shown or they show zero quantity? I mean, the inventory list should show only the active items quantity. Is it possible?

thanks in advance Ajeh !!

- muteyaar

[dbltoe]

The original file established the $csv on line 50. What to do if $csv ==1 took place at line 95 and continues in lines 110-119 creates $filename for the .csv file.
Line 171 is probably related to the button as it is part of the form.
None of those are found in the file Ajeh submitted.
Wish I had a simple way to reinsert them but, there's a lot going on between old and new. My comparison software is not helping much. AND... Never will my skills match Ajeh.
Hopefully, this info can speed up a solution.