Inventory Updater...

this is the support thread for the new inventory updater. it can be downloaded here:

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

it allows for updating of inventory quantities on a single admin page for all items in a category. in addition, it also allows admins to disable or re-enable products right from that page. editing of an item can also be accessed by clicking directly on the item name.

it has been tested for use with ZC v1.5.6 and v1.5.7 only. v1.5.6 has an additional file that you need to upload to your store. instructions are provided.

no ZC core files are modified! no additional ZC fields or tables. if you want to have access to the page from an admin menu, additional instructions are provided!

support is here.

That's a very convenient plugin, and nice design too to not modify any core files or tables (using all those nifty notifiers I guess).

Quote:

---

Originally Posted by gernot

That's a very convenient plugin, and nice design too to not modify any core files or tables (using all those nifty notifiers I guess).

---

thank you for that! i'm glad you find it useful. :smile:

as this plugin is a new page, it does not make use of any notifiers. it does make use of the existing ZC infrastructure, so it has the same look and feel.

i was thinking about adding another field for potential updating from this page; perhaps the base price. i was also thinking about adding a search field; so one could search for something, and then update the results. for example, if one had a lot of inventory from a specific manufacturer, you could search for that manufacturer and then update the inventory for those search results.

its a convenient way if one has to update inventory after taking a physical or spot check or perhaps after purchasing new stock without having to dig into each item individually.

Hi,
I saw this and installed and used it the same day, heh. It certainly makes life easier (since we sell products outside of Zen Cart).
I was pleasantly surprised how clean the page is, good to hear the explanation.

Updating the price would be a great help, adjusting quantities and prices en masse are both common operations.
Regarding search, I am lucky I categorized by manufacturer, so I just select that manufacturer to get the list I want.
I suppose for abstract categories a search would indeed be useful (maybe other attributes too if you are about it).

Something that might be cool would be the ability to change the model and product name directly too. I don't know how useful/risky this would be, most times a change in say the vintage of a wine also means changing the content of the product description too. But it still makes correcting various errors easier (especially when mixing languages like on my site). Note that I am not complaining, since you can click on the product and go straight to its editing page already.

As you say, perfect for stock updates, it matches my needs perfectly, so very much appreciated.

I too find this useful, thank you.

I added a product image column as this helps with managing the inventory of greeting cards.

Quote:

---

Originally Posted by simon1066

I too find this useful, thank you.

I added a product image column as this helps with managing the inventory of greeting cards.

---

:thumbsup:

This looks great and what I have been looking for, my only feedback would be the category list, I have a large list of categories and sub categories and some sub sub categories. The list order in the dropdown can make it hard to find the category that I am looking, is there any way that it could be placed into the store category order?

Quote:

---

Originally Posted by jcrennan

This looks great and what I have been looking for, my only feedback would be the category list, I have a large list of categories and sub categories and some sub sub categories. The list order in the dropdown can make it hard to find the category that I am looking, is there any way that it could be placed into the store category order?

---

Yes, ideally incorporating the category structure from the dropdown on admin/category_product_listing.php, which uses this code:

Code:

---

echo zen_draw_pull_down_menu('cPath', zen_get_category_tree(), $current_category_id, 'onchange="this.form.submit();" class="form-control"');

---

I had a look but the code changes required are a bit beyond me.

i can certainly take a look at that when i have a moment.

best.

Quote:

---

Originally Posted by jcrennan

This looks great and what I have been looking for, my only feedback would be the category list, I have a large list of categories and sub categories and some sub sub categories. The list order in the dropdown can make it hard to find the category that I am looking, is there any way that it could be placed into the store category order?

---

i see what you are talking about... it's a good point, and worth addressing in a new release....

Quote:

---

Originally Posted by simon1066

Yes, ideally incorporating the category structure from the dropdown on admin/category_product_listing.php, which uses this code:

Code:

---

echo zen_draw_pull_down_menu('cPath', zen_get_category_tree(), $current_category_id, 'onchange="this.form.submit();" class="form-control"');

---

I had a look but the code changes required are a bit beyond me.

---

:laugh: if it only involved that code. sub sub categories will take some thinking about how best to do this....

ok, a new version has been submitted for approval.

thanks to both @jcrennan and @simon1066 for pointing out the problem and the proposed fix.

hope you find the new version more useful. i did incorporate a small change so that one can see all products in sub-categories of a particular category. you can always select the sub-category to see only those products. sub-sub categories require selecting that category, or 1 level above. hopefully once approved, and you play with the changes you will see what i mean.

best.

new version is now available here:

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

makes better use of the ZC category tree structure.

constructive critiques are always welcome.

best.

Quote:

---

Originally Posted by carlwhat

thank you for that! i'm glad you find it useful. :smile:

as this plugin is a new page, it does not make use of any notifiers. it does make use of the existing ZC infrastructure, so it has the same look and feel.

i was thinking about adding another field for potential updating from this page; perhaps the base price. i was also thinking about adding a search field; so one could search for something, and then update the results. for example, if one had a lot of inventory from a specific manufacturer, you could search for that manufacturer and then update the inventory for those search results.

its a convenient way if one has to update inventory after taking a physical or spot check or perhaps after purchasing new stock without having to dig into each item individually.

---

I've been waiting for someone to write a module like this. Thankyou.
A field for updating the base price would be very useful.

version 1.2.0 has been submitted. i will post when approved and ready for download.

due to popular demand, base price can now be updated!

there is also some additional error checking so that item updated counts are more accurate.

@gernot, i gave some serious thought to changing models as well as product name; i thought about adding a selector so that an admin can select a field that they want to update. but i chose to not implement these things. as someone who has implemented a number of wine sites, i am of the firm opinion that a new vintage is a new product. and that vintage should be stored as a separate field in your database. perhaps vintage is not as crucial for the wines you sell; but i find it hard to go against my beliefs!

i will post when the new version is ready to download. all feedback is appreciated.

best.

I haven't tried v1.2.0 but one issue I'm having on the previous version is that after adding the Inventory admin page to a user profile other than Superuser, I get

...your security clearance does not allow you to access this resource.

I thought it might be related to the Admin Page Registration, not knowing much about the process I attempted different page key and menu choice but still the same error. Perhaps something in the code.

Edit: ZC v1.56c, plus plenty of mods which I probably should have listed.

Quote:

---

Originally Posted by simon1066

I haven't tried v1.2.0 but one issue I'm having on the previous version is that after adding the Inventory admin page to a user profile other than Superuser, I get

...your security clearance does not allow you to access this resource.

I thought it might be related to the Admin Page Registration, not knowing much about the process I attempted different page key and menu choice but still the same error. Perhaps something in the code.

Edit: ZC v1.56c, plus plenty of mods which I probably should have listed.

---

Found the answer, https://www.zen-cart.com/showthread....97#post1131197

admin/includes/extra_datafiles/inventory.php

Code:

---

define('FILENAME_INVENTORY', 'inventory.php');

---

to

Code:

---

define('FILENAME_INVENTORY', 'inventory');

---

Quote:

---

Originally Posted by simon1066

Found the answer, https://www.zen-cart.com/showthread....97#post1131197

admin/includes/extra_datafiles/inventory.php

Code:

---

define('FILENAME_INVENTORY', 'inventory.php');

---

to

Code:

---

define('FILENAME_INVENTORY', 'inventory');

---

---

man, what a bloody waste!

the idea that back in 2013, we had this error, and it was supposed to be corrected back then, and the correction does not fix the problem..... wow.

i digress....

your solution does work. the core ZC should have taken care of my error, but alas it does not....

feel free to implement that. i will do another submit shortly. as well as fix the base zen code. i hope.

thanks for pointing this out.

best.

@simon1066, version 1.2.1 removes the .php from the filename.

in addition, hopefully the ZC team will merge this PR that actually does fix this issue for other plugin authors like myself that make the same mistake:

https://github.com/zencart/zencart/pull/3653

best.

version 1.2.1 now available for download here:

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

update base price as well as inventory!

also, no modifications necessary to work within admin profile security.

best.

Inventory Updater v1.2.1
PHP v7.2.10

Upgrading to ZCv1.57, I get these myDEBUG logs notices when viewing the Inventory Updater page - I know the notices are not critical but if I don't address these undefined index notices (and many others unrelated to Inventory Updater, across the site) the number of log files will become unmanageable.

Code:

---

[08-Jul-2020 10:59:08 Europe/London] PHP Notice:  Undefined index: sort in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 73
[08-Jul-2020 10:59:08 Europe/London] PHP Stack trace:
[08-Jul-2020 10:59:08 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 10:59:08 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11
[08-Jul-2020 10:59:08 Europe/London] PHP Notice:  Undefined index: sort in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 285
[08-Jul-2020 10:59:08 Europe/London] PHP Stack trace:
[08-Jul-2020 10:59:08 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 10:59:08 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11

... followed by a line 285 entry for every product listed.

---

inventory.php line 71-76

Code:

---

$sort = (isset($_GET['sort']) ? $_GET['sort'] : '0');
        $order_by = " ";
        switch ($_GET['sort']) {
                case (0):
                        $order_by = " ORDER BY p.products_sort_order, pd.products_name";
                        break;

---

inventory.php line 284-286

Code:

---

<a href="<?= zen_href_link(FILENAME_INVENTORY,
        'action=tg_stat' . '&pid=' . $prod_list->fields['products_id'] . $cid_params . '&sort=' . $_GET['sort'] . '&active=' . $_GET['active'],
        'SSL'); ?>">

---

'PHP Notice: Undefined index:' seems to be a bit of a theme with my upgrade to ZCv1.57 - seems to be mainly caused by old mods and my crude hacking of php files, still trying to get my head around the whys and wherefores.

It strikes me that perhaps these notices are a result of the improved error logging in ZCv1.57. TBH I can't remember if ZCv1.56c showed notices or not. In any event I get too many of them.

Quote:

---

Originally Posted by simon1066

It strikes me that perhaps these notices are a result of the improved error logging in ZCv1.57. TBH I can't remember if ZCv1.56c showed notices or not. In any event I get too many of them.

---

simon,
can you please provide me the first line in your debug log. the one that has the url you are going to.

thanks.

Quote:

---

Originally Posted by carlwhat

simon,
can you please provide me the first line in your debug log. the one that has the url you are going to.

thanks.

---

Here are the first few lines of the debug, there is no url on the first line - but the link I followed to the Inventory Updater page is

mydomain.co.uk/myadmin/index.php?cmd=inventory

Code:

---

[08-Jul-2020 16:09:12 Europe/London] PHP Notice:  Undefined index: sort in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 73
[08-Jul-2020 16:09:12 Europe/London] PHP Stack trace:
[08-Jul-2020 16:09:12 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 16:09:12 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11
[08-Jul-2020 16:09:13 Europe/London] PHP Notice:  Undefined index: sort in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 285
[08-Jul-2020 16:09:13 Europe/London] PHP Stack trace:
[08-Jul-2020 16:09:13 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 16:09:13 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11
[08-Jul-2020 16:09:13 Europe/London] PHP Notice:  Undefined index: active in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 285
[08-Jul-2020 16:09:13 Europe/London] PHP Stack trace:
[08-Jul-2020 16:09:13 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 16:09:13 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11
[08-Jul-2020 16:09:13 Europe/London] PHP Notice:  Undefined index: sort in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 285
[08-Jul-2020 16:09:13 Europe/London] PHP Stack trace:
[08-Jul-2020 16:09:13 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 16:09:13 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11
[08-Jul-2020 16:09:13 Europe/London] PHP Notice:  Undefined index: active in D:\wamp64\www\mydomain.co.uk\myadmin\inventory.php on line 285
[08-Jul-2020 16:09:13 Europe/London] PHP Stack trace:
[08-Jul-2020 16:09:13 Europe/London] PHP  1. {main}() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:0
[08-Jul-2020 16:09:13 Europe/London] PHP  2. require() D:\wamp64\www\mydomain.co.uk\myadmin\index.php:11

---

These notices only appear on first entry to the Updater page, subsequent actions using the various dropdowns yield no notices.

BTW, the line numbers are different to your stock file because I added some custom lines to display product images - see a previous post for actual code.

Quote:

---

Originally Posted by simon1066

BTW, the line numbers are different to your stock file because I added some custom lines to display product images - see a previous post for actual code.

---

yeah, i have all of my own code, so i know where all of the problems are. thanks for pointing them out.

i will be submitting a new version shortly.

you have error_reporting set to E_ALL somewhere. if you turn that config to something to something like E_ALL & ~E_NOTICE; i think all of these notices, and hence the log files, will disappear.

it is a setting and not specifically related to v157.

best.

version 1.2.2 is now submitted for review by the ZC plugin moderator.

@simon1066

on your 2 lines in question, you can change the $_GET['sort'] to $sort. that should work...

or you could download the new file from my github repo here:

https://raw.githubusercontent.com/pr.../inventory.php

there are a few other changes.

obviously you will need to add your mods back into the file.

best.

That's great. Thank you.

v1.2.2 now available for download.

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

truely love this! makes it so much easier!
lol am waiting for extra options such as batch uploading :D
But seriously love it.

Quote:

---

extra options such as batch uploading

---

DBIO
https://www.zen-cart.com/showthread....Support-Thread

Quote:

---

Originally Posted by kernheimer

truely love this! makes it so much easier!
lol am waiting for extra options such as batch uploading :D
But seriously love it.

---

:thumbsup:

i would like to be able to update my barcodes as well. how or what code can i add to achieve this.
this is the field in products table.
products_barcode

Quote:

---

Originally Posted by jimmie

i would like to be able to update my barcodes as well. how or what code can i add to achieve this.
this is the field in products table.
products_barcode

---

sorry, jimmie, i currently do not have the time to provide support for something like this.

barcodes require a new class and validation to be done properly as one needs to validate check digits on them (at least for UPCs and EANs).

best.

v1.2.3 now available for download.

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

if you are using ZC 1.5.7, this new version makes use of the new ZC plugin manager. one folder to copy directly into the zc_plugins directory. makes installation a snap!

functionality remains same as it ever was. :D

FYI, i was able to add the barcodes into my version. so now as i get products in i can change qty,price and barcode

Quote:

---

Originally Posted by jimmie

FYI, i was able to add the barcodes into my version. so now as i get products in i can change qty,price and barcode

---

sweet! :thumbsup:

are you validating your barcodes? ie are they UPC or EAN numbers?

i actually did look into the ability to configure what other fields people may want to use; but it seemed to get too complex. and unfortunately my time is limited.

i do have a couple of functions for validating UPCs and EANs if u r interested.

best.

What does validating do. little label on side of product that i scan

Quote:

---

Originally Posted by jimmie

What does validating do. little label on side of product that i scan

---

what kind of label? did you put the label there? or the product manufacturer?

UPCs and EANS all have a check digit and use something known as a mod-10 algorithm to ensure that the number is valid. it is also used for credit cards. if interested you can read a little bit about here: https://en.wikipedia.org/wiki/Luhn_algorithm.

if you just have a bar code on your product that you generated from your label printer of your product number or model number that you scan afterwards, it probably does not need validating. but if you are entering UPC or EAN numbers into the database, it prevents data entry errors.

best.

how do i delete the price, if i wanted to. not really the price but my barcode field does not let me delete the barcode unless i put a zero in. i want to delete some of them.
also it doesnt let me it if there is a zero first in the number. ex this saves 7435666890 and this does not save 07435666890

Quote:

---

Originally Posted by jimmie

how do i delete the price, if i wanted to. not really the price but my barcode field does not let me delete the barcode unless i put a zero in. i want to delete some of them.
also it doesnt let me it if there is a zero first in the number. ex this saves 7435666890 and this does not save 07435666890

---

• this really has nothing to do with this module.
• my module, as packaged, does nothing with bar codes.
• my package as delivered updates 2 fields; both of which are numeric.
• that said, it sounds like you may have defined your bar code field as some sort of numeric integer field. perhaps, BIGINT. i really do not know, as this is not a field in a default ZC install.
• you can see some of the mysql integer data type fields here: https://dev.mysql.com/doc/refman/8.0...ger-types.html
• it looks like you would need to do an alter table command in mysql; i'm not sure how you access your database. some people use phpMyAdmin or something similar.
• for my clients, i have the barcode field set up as VARCHAR(20). i am not sure what your maximum length barcode might be.
• you can read about the differences between CHAR and VARCHAR here: https://dev.mysql.com/doc/refman/8.0/en/char.html
• i am not sure what will happen to your data when you convert a field from BIGINT (or something similar) to VARCHAR. i would definitely make a backup of that table prior to doing any ALTER TABLE commands.
• i am also not privy to the program you use to update your barcodes (other than the modified version of this program). and whether that program might need to get modified.
• if your field is already set to a character field, it is entirely possible that you might be casting that field to an integer value as i do for the inventory number.
• if you were to post the code for the update of the bar code, we could easily (hopefully) see what the problem might be.
• that situation would be much easier to fix, as it would not involve changing the field types of any table.

hope that helps!

best.

products_barcode varchar(32) is what i have there.
$products_barcode = '';

Code:

---

$products_barcode = '';

        if (isset($_POST['update_']) && is_array($_POST['new_barcode']) && is_array($_POST['old_barcode'])) {
                $old_barcode = $_POST['old_barcode'];
                foreach ($_POST['new_barcode'] as $item => $barcode) {
                        if (array_key_exists($item, $old_barcode) && $old_barcode[$item] !== $barcode) {
                                if (is_numeric($barcode) and is_numeric($item)) {
                                        $db->Execute("update " . TABLE_PRODUCTS . " set products_barcode = '" . convertToFloat($barcode) . "' where products_id = '" . intval($item) . "' and products_barcode = '" . (float)($old_barcode[$item]) . "' limit 0");
                                        if ($db->affectedRows() == 1) {
                                                $products_barcode++;
                                        }
                                }
                        } else {
                                //echo "old: $old_qty[$item] , new: $qty <br />";
                        }
                }
        }

---

get rid of the convertToFloat and the (float) in the update line. try that. leave everything else in. that should work.

let us know.

best.

Quote:

---

Originally Posted by carlwhat

get rid of the convertToFloat and the (float) in the update line. try that. leave everything else in. that should work.

---

Er, um, don't merely get rid of those. Instead, replace them with calling zen_db_input() on them. Otherwise you risk creating security issues.

ok changed line to this,

Code:

---

$db->Execute("update " . TABLE_PRODUCTS . " set products_barcode = '" . zen_db_input(($barcode)) . "' where products_id = '" . intval($item) . "' and products_barcode = '" . zen_db_input(($old_barcode[$item])) . "' limit 1");

---

and i can now save when a zero is the first number, but still doesnt let me delete a zero. let me explain, we have over 11000 products, once when messing with EP it changed all barcodes to the same number or a zero. easier for me to see which products need fixed from your module.

i also have the wholesale module installed and installed that into your module as well.
here is my complete file.

Code:

---

<?php
        /*  portions copyright by... zen-cart.com

                developed and brought to you by proseLA
                https://rossroberts.com

                released under GPU
                https://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

                06/2020  project: inventory v1.2.3 file: inventory.php
        */

        require('includes/application_top.php');

        require_once(DIR_WS_CLASSES . 'currencies.php');
        $currencies = new currencies();

        $cid = 0;
        $cid_params = '';
        if (isset($_GET['cid'])) {
                $cid = $_GET['cid'];
                $cid_params .= '&cid=' . $cid;
        }

        $action = isset($_GET['action']) ? $_GET['action'] : '';
        $sort =  isset($_GET['sort']) ? $_GET['sort'] : '0';
        $active = isset($_GET['active']) ? $_GET['active'] : '0';

        if ($action == 'tg_stat' && isset($_GET['pid']) && is_numeric($_GET['pid'])) {
                $rs_stat = $db->Execute("select products_status from " . TABLE_PRODUCTS . " where products_id=" . intval($_GET['pid']) . " LIMIT 1");
                $db->Execute("update " . TABLE_PRODUCTS . " set products_status = '" . ($rs_stat->fields['products_status'] == '1' ? '0' : '1') . "' where products_id=" . intval($_GET['pid']) . " LIMIT 1");
                zen_redirect(zen_href_link(FILENAME_INVENTORY, 'sort=' . $sort . '&active=' . $active . $cid_params,
                        'SSL'));
        }

        $update_qty = 0;

        if (isset($_POST['update_']) && is_array($_POST['new_qty']) && is_array($_POST['old_qty'])) {
                $old_qty = $_POST['old_qty'];
                foreach ($_POST['new_qty'] as $item => $qty) {
                        if (array_key_exists($item, $old_qty) && $old_qty[$item] !== $qty) {
                                if (is_numeric($qty) and is_numeric($item)) {
                                        $db->Execute("update " . TABLE_PRODUCTS . " set products_quantity = '" . intval($qty) . "' where products_id = '" . intval($item) . "' and products_quantity = '" . intval($old_qty[$item]) . "' limit 1");
                                        if ($db->affectedRows() == 1) {
                                                $update_qty++;
                                        }
                                }
                        } else {
                                //echo "old: $old_qty[$item] , new: $qty <br />";
                        }
                }
        }

        $updated_count_price = 0;

        if (isset($_POST['update_']) && is_array($_POST['new_price']) && is_array($_POST['old_price'])) {
                $old_price = $_POST['old_price'];
                foreach ($_POST['new_price'] as $item => $price) {
                        if (array_key_exists($item, $old_price) && $old_price[$item] !== $price) {
                                if (is_numeric($price) and is_numeric($item)) {
                                        $db->Execute("update " . TABLE_PRODUCTS . " set products_price = '" . convertToFloat($price) . "' where products_id = '" . intval($item) . "' and products_price = '" . (float)($old_price[$item]) . "' limit 1");
                                        if ($db->affectedRows() == 1) {
                                                $updated_count_price++;
                                        }
                                }
                        } else {
                                //echo "old: $old_qty[$item] , new: $qty <br />";
                        }
                }
        }

$products_barcode = '';

        if (isset($_POST['update_']) && is_array($_POST['new_barcode']) && is_array($_POST['old_barcode'])) {
                $old_barcode = $_POST['old_barcode'];
                foreach ($_POST['new_barcode'] as $item => $barcode) {
                        if (array_key_exists($item, $old_barcode) && $old_barcode[$item] !== $barcode) {
                                if (is_numeric($barcode) and is_numeric($item)) {
                                        $db->Execute("update " . TABLE_PRODUCTS . " set products_barcode = '" . zen_db_input(($barcode)) . "' where products_id = '" . intval($item) . "' and products_barcode = '" . zen_db_input(($old_barcode[$item])) . "' limit 1");
                                        if ($db->affectedRows() == 1) {
                                                $products_barcode++;
                                        }
                                }
                        } else {
                                //echo "old: $old_qty[$item] , new: $qty <br />";
                        }
                }
        }
       
$updated_count_price_w = 0;

        if (isset($_POST['update_']) && is_array($_POST['new_price_w']) && is_array($_POST['old_price_w'])) {
                $old_price_w = $_POST['old_price_w'];
                foreach ($_POST['new_price_w'] as $item => $price_w) {
                        if (array_key_exists($item, $old_price_w) && $old_price_w[$item] !== $price_w) {
                                if (is_numeric($price_w) and is_numeric($item)) {
                                        $db->Execute("update " . TABLE_PRODUCTS . " set products_price_w = '" . convertToFloat($price_w) . "' where products_id = '" . intval($item) . "' and products_price_w = '" . (float)($old_price_w[$item]) . "' limit 1");
                                        if ($db->affectedRows() == 1) {
                                                $updated_count_price_w++;
                                        }
                                }
                        } else {
                                //echo "old: $old_qty[$item] , new: $qty <br />";
                        }
                }
        }       

        $order_by = " ";
        switch ($sort) {
                case (0):
                        $order_by = " ORDER BY p.products_sort_order, pd.products_name";
                        break;
                case (1):
                        $order_by = " ORDER BY pd.products_name";
                        break;
                case (2);
                        $order_by = " ORDER BY p.products_model";
                        break;
                case (3);
                        $order_by = " ORDER BY p.products_quantity, pd.products_name";
                        break;
                case (4);
                        $order_by = " ORDER BY p.products_quantity DESC, pd.products_name";
                        break;
                case (5);
                        $order_by = " ORDER BY p.products_price_sorter, pd.products_name";
                        break;
                case (6);
                        $order_by = " ORDER BY p.products_price_sorter DESC, pd.products_name";
                        break;
                case (7);
                        $order_by = " ORDER BY p.products_barcode, pd.products_name";
                        break;
                case (8);
                        $order_by = " ORDER BY p.products_barcode DESC, pd.products_name";
                        break;       
                case (9);
                        $order_by = " ORDER BY p.products_price_w_sorter, pd.products_name";
                        break;
                case (10);
                        $order_by = " ORDER BY p.products_price_w_sorter DESC, pd.products_name";
                        break;       
        }

        $a_field = '';
        switch ($active) {
                case '1':
                        $a_field = '';
                        break;

                case '0':
                default:
                        $a_field = ' and p.products_status > 0';
                        break;
        }

        $categories = $db->Execute("select c.categories_id, cd.categories_name, c.sort_order "
                . " from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd "
                . " where c.categories_id = cd.categories_id and c.parent_id = " . $cid . " and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'"
                . " order by sort_order ");

        if ($categories->count() == 0) {
                $categories = $db->Execute("select c.categories_id, cd.categories_name, c.sort_order "
                        . " from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd "
                        . " where c.categories_id = cd.categories_id and c.parent_id = 0 and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'"
                        . " order by sort_order ");
        }

        if ($cid <> 0) {
                $prod_sql = "select p.products_id, p.products_type, p.products_date_available, p.products_status, p.products_quantity, p.products_barcode,
        p.products_price, p.products_price_w, p.products_model, pd.products_name,  pc.categories_id, p.product_is_call, p.master_categories_id as catId "
                        . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc "
                        . " left join " . TABLE_CATEGORIES . " ct on ct.categories_id = pc.categories_id"
                        . " where p.products_id = pd.products_id and p.products_id = pc.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'"
                        . " and (pc.categories_id = " . intval($cid) . " or ct.parent_id = " . intval($cid) . ")" . $a_field;
        } else {
                $prod_sql = "select p.products_id, p.products_type, p.products_date_available, p.products_status, p.products_quantity, p.products_barcode,
        p.products_price, p.products_price_w, p.products_model, pd.products_name, p.product_is_call, p.master_categories_id as catId "
                        . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd  "
                        . " where p.products_id = pd.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" . $a_field;
        }

        $prod_sql .= $order_by;

        $query_num_rows = 0;
        $page = intval((isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1));
        $products_page = new splitPageResults($page, MAX_DISPLAY_RESULTS_CATEGORIES, $prod_sql, $query_num_rows);
        $prod_list = $db->Execute($prod_sql);

        $query_string = '';
        foreach ($_GET as $k => $v) {
                if ($k != 'page') {
                        $query_string .= $k . '=' . $v . '&';
                }
        }

        $pager = $products_page->display_count($query_num_rows, MAX_DISPLAY_RESULTS_CATEGORIES, $page,
                TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
        $pager .= '&nbsp;-&nbsp;';
        $pager .= $products_page->display_links($query_num_rows, MAX_DISPLAY_RESULTS_CATEGORIES, MAX_DISPLAY_PAGE_LINKS, $page,
                $query_string);

        $categories_products_sort_order_array = array(
                array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME),
                array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME),
                array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL),
                array('id' => '3', 'text' => TEXT_SORT_PRODUCTS_QUANTITY),
                array('id' => '4', 'text' => TEXT_SORT_PRODUCTS_QUANTITY_DESC),
                array('id' => '5', 'text' => TEXT_SORT_PRODUCTS_PRICE),
                array('id' => '6', 'text' => TEXT_SORT_PRODUCTS_PRICE_DESC),
                array('id' => '7', 'text' => TEXT_SORT_PRODUCTS_BARCODE),
                array('id' => '8', 'text' => TEXT_SORT_PRODUCTS_BARCODE_DESC),
                array('id' => '9', 'text' => TEXT_SORT_PRODUCTS_PRICE_W),
                array('id' => '10', 'text' => TEXT_SORT_PRODUCTS_PRICE_W_DESC)
        );
?>
    <!doctype html>
    <html <?= HTML_PARAMS; ?>>
    <head>
                <?php require DIR_WS_INCLUDES . 'admin_html_head.php'; ?>
        <script src="includes/general.js"></script>
    </head>
    <body>
    <!-- header //-->
        <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
    <!-- header_eof //-->

    <!-- body //-->
    <div class="container-fluid" id="pageWrapper">
        <div class="col-md-11 alert-box alert alert-info">
            <h3><?= INVENTORY_PAGE; ?></h3>
                        <?php
                                $parent_name = zen_get_category_name($cid, (int)$_SESSION['languages_id']);
                                if ($cid > 0) {
                                        ?>
                    <h3><?= $parent_name; ?></h3>
                                <?php } ?>
        </div>
        <div class="col-md-11">
                <?php if (isset($update_barcode) && $update_barcode > '') { ?>
                <div class="alert alert-success fade in alert-dismissible show">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h4 class="center"><?= $update_barcode . PRODUCTS_BARCODE_UPDATED; ?></h4>
                </div>
                        <?php } ?>
               
                        <?php if (isset($update_qty) && $update_qty > 0) { ?>
                <div class="alert alert-success fade in alert-dismissible show">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h4 class="center"><?= $update_qty . PRODUCTS_UPDATED; ?></h4>
                </div>
                        <?php } ?>

                        <?php if (isset($updated_count_price) && $updated_count_price > 0) { ?>
                <div class="alert alert-success fade in alert-dismissible show">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h4 class="center"><?= $updated_count_price . PRODUCTS_PRICE_UPDATED; ?></h4>
                </div>
                        <?php } ?>
                        <?php if (isset($updated_count_price_w) && $updated_count_price_w > 0) { ?>
                <div class="alert alert-success fade in alert-dismissible show">
                    <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                    <h4 class="center"><?= $updated_count_price_w . PRODUCTS_PRICE_W_UPDATED; ?></h4>
                </div>
                        <?php } ?>

            <div>
                                <?= zen_draw_form('selection', FILENAME_INVENTORY, 'cid=' . $cid .'&cmd=' . FILENAME_INVENTORY, 'get', 'class="form-horizontal"'); ?>

                                <?= zen_draw_label(CATEGORY_SELECTOR, 'cid', 'class="col-sm-6 col-md-4 control-label"'); ?>
                <div class="col-sm-6 col-md-8">
                                        <?php
                                                echo zen_draw_pull_down_menu('cid', zen_get_category_tree(), $cid, 'onChange="this.form.submit()" class="form-control"');
                                        ?>
                </div>
                                <?= zen_draw_label(TEXT_CATEGORIES_PRODUCTS_SORT_ORDER_INFO, 'sort',
                                        'class="col-sm-6 col-md-4 control-label"'); ?>
                <div class="col-sm-6 col-md-8">
                                        <?= zen_draw_pull_down_menu('sort', $categories_products_sort_order_array, $sort,
                                                'onchange="this.form.submit();" class="form-control" id="sort"'); ?>
                </div>
                                <?= zen_draw_label(ACTIVE_STATUS, 'active', 'class="col-sm-6 col-md-4 control-label"'); ?>
                <div class="col-sm-6 col-md-8">
                    <select id="active" name="active" onChange="this.form.submit()" class="form-control">
                        <option value="0" <?= ($active == '0' ? 'SELECTED' : ''); ?>>Only Active
                        <option value="1" <?= ($active == '1' ? 'SELECTED' : ''); ?>>All Products
                    </select>&nbsp;
                </div>
                </form>
            </div>
            <hr/>
            <div>

                <div class="row">
                    <div class="configurationColumnLeft">
                        <form action="" method="post">
                            <table class="table table-striped table-hover table-bordered">
                                <thead>

                                <tr>
                                    <td colspan="7" class="text-right"><?= $pager; ?></td>
                                </tr>

                                <tr class="dataTableHeadingRow">
                                    <th class="dataTableHeadingContent"><?= TABLE_HEADING_ID; ?></th>
                                    <th class="dataTableHeadingContent text-center"><?= TABLE_HEADING_MODEL; ?></th>
                                    <th class="dataTableHeadingContent"><?= TABLE_HEADING_NAME; ?></th>
                                    <th class="dataTableHeadingContent text-center"><?= TABLE_HEADING_STATUS; ?></th>
                                                                        <th class="dataTableHeadingContent text-center"><?= TABLE_HEADING_BARCODE; ?></th>
                                    <th class="dataTableHeadingContent text-right"><?= TABLE_HEADING_QTY; ?></th>
                                    <th class="dataTableHeadingContent text-right"><?= TABLE_HEADING_BASE_PRICE; ?></th>
                                                                        <th class="dataTableHeadingContent text-right"><?= TABLE_HEADING_BASE_PRICE_W; ?></th>
                                </tr>
                                </thead>

                                                                <?php while ($prod_list && !$prod_list->EOF) {

                                                                        $type_handler = $zc_products->get_admin_handler($prod_list->fields['products_type']);
                                                                        if (isset($bad_sku) && array_key_exists($prod_list->fields['products_id'],
                                                                                        $bad_sku)) {
                                                                                $color = ' bgcolor="red" ';
                                                                        } else {
                                                                                $color = '';
                                                                        } ?>

                                    <tr class="dataTableRow" onmouseover="rowOverEffect(this)"
                                        onmouseout="rowOutEffect(this)">
                                        <td <?= $color; ?> class="dataTableContent"
                                                          onclick="document.location.href='<?= zen_href_link($type_handler,
                                                                                                          'page=1' . '&product_type=' . $prod_list->fields['products_type'] . '&pID=' . $prod_list->fields['products_id'] . '&action=new_product'); ?> '"><?= $prod_list->fields['products_id']; ?></td>
                                        <td class="dataTableContent text-center">
                                                                                        <?= $prod_list->fields['products_model']; ?>
                                        </td>
                                        <td class="dataTableContent"
                                            onclick="document.location.href='<?= zen_href_link(FILENAME_PRODUCT,
                                                                                            'product_type=' . $prod_list->fields['products_type'] . '&pID=' . $prod_list->fields['products_id'] . '&cPath=' . $prod_list->fields['catId'] . '&action=new_product'); ?> '">
                                                                                        <?php
                                                                                                echo zen_get_products_name($prod_list->fields['products_id']);
                                                                                        ?>
                                        </td>
                                        <td class="text-center">

                                            <a href="<?= zen_href_link(FILENAME_INVENTORY,
                                                                                                'action=tg_stat' . '&pid=' . $prod_list->fields['products_id'] . $cid_params . '&sort=' . $sort . '&active=' . $active,
                                                                                                'SSL'); ?>">
                                                                                                <?= ($prod_list->fields['products_status']
                                                                                                        ? zen_image(DIR_WS_IMAGES . 'icon_green_on.gif',
                                                                                                                IMAGE_ICON_STATUS_ON)
                                                                                                        : zen_image(DIR_WS_IMAGES . 'icon_red_on.gif',
                                                                                                                IMAGE_ICON_STATUS_OFF)) ?>
                                            </a>
                                        </td>
                                                                               
                                                                                <td class="dataTableContent text-right">
                                            <input type="text"
                                                  name="new_barcode[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_barcode']; ?>" size="15"/>
                                            <input type="hidden"
                                                  name="old_barcode[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_barcode']; ?>"/>
                                        </td>
                                                                               
                                        <td class="dataTableContent text-right">
                                            <input type="text"
                                                  name="new_qty[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_quantity']; ?>" size="5"/>
                                            <input type="hidden"
                                                  name="old_qty[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_quantity']; ?>"/>
                                        </td>

                                        <td class="dataTableContent text-right">
                                            <input type="text"
                                                  name="new_price[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_price']; ?>" size="7"/>
                                            <input type="hidden"
                                                  name="old_price[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_price']; ?>"/>
                                        </td>
                                                                               
                                                                                <td class="dataTableContent text-right">
                                            <input type="text"
                                                  name="new_price_w[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_price_w']; ?>" size="7"/>
                                            <input type="hidden"
                                                  name="old_price_w[<?= $prod_list->fields['products_id']; ?>]"
                                                  value="<?= $prod_list->fields['products_price_w']; ?>"/>
                                        </td>


                                                                        <?php $prod_list->MoveNext();
                                                                }
                                                                ?>
                                <tr>
                                    <td colspan="7" class="text-right"><?= $pager; ?></td>
                                </tr>
                            </table>
                            <div>
      <span class="floatButton text-right">
            <input type="reset" value="reset" class="btn btn-danger"/>
            <input type="submit" name="update_" value="<?= BUTTON_UPDATE; ?>" class="btn btn-primary"/>
      </span>
                            </div>
                        </form>

                    </div>

                </div>
            </div>
        </div>
    </div>

    <!-- body_eof //-->
    <!-- footer //-->
        <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    <br/>
    </body>
    </html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php');

---

Quote:

---

Originally Posted by DrByte

Er, um, don't merely get rid of those. Instead, replace them with calling zen_db_input() on them. Otherwise you risk creating security issues.

---

what he said.

jimmie, i'm guessing your problem is here:

PHP Code:

---

                if (is_numeric($barcode) and is_numeric($item)) { 


---

if you are trying to delete a '0' with a space, this if statement will fail, as a space is not numeric.

best.

Thanks for working on this module. It is a useful addition to Zen Cart. I'm considering using it to replace a stand-alone utility that I wrote years ago.

There is, however, the potential of a synchronization issue. For example, if an order for one or more of the products comes in while the admin is editing the quantities in the form then the quantity set when the form is submitted will not be correct.

A simple fix is to have the user enter a positive or negative number which is added to the existing product inventory in the SQL statement. I find this useful because it matches the workflow for handing off-site sales and incoming inventory where it is more natural to enter the amount of products sold or received.

A more robust fix would allow the user to enter either an absolute amount or a relative amount. For absolute quantities, you could include the current quantity for each product in hidden inputs in the form and when processing the updates add the difference to the quantity in the database.

When entering absolute quantities, there is the issue that there may be pending orders for some of the products. I don't think there's a right way to handle that situation (other than possibly displaying a warning message) because the software can't know if the products in the pending orders have been pulled from inventory or not.

Quote:

---

Originally Posted by jadebox

Thanks for working on this module. It is a useful addition to Zen Cart. I'm considering using it to replace a stand-alone utility that I wrote years ago.

There is, however, the potential of a synchronization issue. For example, if an order for one or more of the products comes in while the admin is editing the quantities in the form then the quantity set when the form is submitted will not be correct.

A simple fix is to have the user enter a positive or negative number which is added to the existing product inventory in the SQL statement. I find this useful because it matches the workflow for handing off-site sales and incoming inventory where it is more natural to enter the amount of products sold or received.

A more robust fix would allow the user to enter either an absolute amount or a relative amount. For absolute quantities, you could include the current quantity for each product in hidden inputs in the form and when processing the updates add the difference to the quantity in the database.

When entering absolute quantities, there is the issue that there may be pending orders for some of the products. I don't think there's a right way to handle that situation (other than possibly displaying a warning message) because the software can't know if the products in the pending orders have been pulled from inventory or not.

---

thank you for the useful review.

i agree that the situation you are describing is tricky. perhaps, instead of changing the user inputs on the screen, i could change the logic. one could run into a couple of tricky situations, ie:

product a -> system inventory = 10; actual inventory 8.

prior to doing the update with this plugin, an order comes in for 2, so the system inventory is now 8. when the plugin does the update, it could calculate 10 - 8; and subtract 2 from the system inventory. the tricky part could be if a customer orders all 10 or 9, and now the plugin would calculate 0 or -1, and need to turn the item off... or alternatively, if the admin was increasing the inventory from 10 to 15, and during that period an order came in for 10, which resulted in the items status now going to off. should the plugin turn the item back on?

little bit of food for thought.

again, thanks for the input.

I had it easier with my standalone utility since I was the only one using it! :-)

Great Module. How hard would it be to modify it to show inventory stock on attributes??

Quote:

---

Originally Posted by tedjmaines

Great Module. How hard would it be to modify it to show inventory stock on attributes??

---

thanks for the props! :thumbsup:

with regards to your question, i have no idea.

ZC does not come out of the box with an inventory stock with attributes. so now we are talking about a plugin. which plugin? i see a few different SBA plugins.... but its hard to tell which is the one that most people are using. or what it does.

i have not really played with attributes, as i chose to rely on the base ZC for inventory type functions.

i have a feeling that the bigger work is getting the SBA plugin working properly, and modifying this module should not be too hard, but i'm only guessing as i do not have a development site running any SBA plugin.

how's that for a waffle?

however, as i tell most people given enough time and money, anything is possible... :D

best.

Hello,
I am having problems with sitelock firewall when logged in to admin area and trying to add quantity to existing products or editing the listing itself. It gives me error 15.

I have 3 questions I think would help other users as well:

1] Using this inventory plugin will bypass sitelock firewall?

2] Would it be safe to use this possible bypass OR a VPN with a whitelisted IP?

3] Why does the sitelock firewall cause problems when it should realize that the admin is the one who brought forth the page that is to be altered in the first place?

I stay pretty angry at sitelock lately.

Thanks in advance

Quote:

---

Originally Posted by Mike Harmon

Hello,
I am having problems with sitelock firewall when logged in to admin area and trying to add quantity to existing products or editing the listing itself. It gives me error 15.

I have 3 questions I think would help other users as well:

1] Using this inventory plugin will bypass sitelock firewall?

2] Would it be safe to use this possible bypass OR a VPN with a whitelisted IP?

3] Why does the sitelock firewall cause problems when it should realize that the admin is the one who brought forth the page that is to be altered in the first place?

I stay pretty angry at sitelock lately.

Thanks in advance

---

Interesting in that I had sitelock for years on an older store and never had these types of issues.

Most all of these plugins work through the same admin interface so I do not see this helping nor do I see it making things worse. Are you accessing via HTTPS? This seems to be an issue not associated with this particular plugin unless I am totally missing the point. If you cannot edit items in the admin, then you have to solve that first.

Quote:

---

Originally Posted by g2ktcf

Interesting in that I had sitelock for years on an older store and never had these types of issues.

Most all of these plugins work through the same admin interface so I do not see this helping nor do I see it making things worse. Are you accessing via HTTPS? This seems to be an issue not associated with this particular plugin unless I am totally missing the point. If you cannot edit items in the admin, then you have to solve that first.

---

concur.

Hi,

I am not using any plugin at the moment but was asking if this inventory plugin would solve my problem.

I have had sitelock and my current hosting provider for years with no problem like this before. I also had Hughes satellite for about 3 years as well.

Sitelock says it is an issue with the firewall AND mentioned that my satellite provider has had issues with the IP and sitelock firewall like I am having now and cases seem to be increasing. Hughes net is my satellite provider. Just a few minutes ago the sitelock rep said simply whitelisting has not worked and he was going to try another approach which lowers the firewall strength [that is how he explained it to me who is partially dumb]. It has been past the time he said it would take to go into effect.

I am getting this error after pulling up a product to add inventory or edit:

Access Denied
Error 15
www.xxxxxxxxxxxxxxx.com
2022-05-24 23:50:57 UTC
logo
What happened?
This request was blocked by the security rules
Your IP: xxxxxxxxxxxxxxxxxxxxxxx
Proxy IP: xxxxxxxxxxxxxx (ID xxxxxxxxxx)
Incident ID: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[NOTE: Proxy address is staying the same but ID does change regardless what IP address I use by using my VPN]

I was hoping that this inventory script/plugin would help bypass the problem.
Regardless, once this problem is worked out, I am eager to try it! It sounds like a life and time saver.
The sitelock rep I just talked to seemed confident he could fix it. The first time this happened on 5-9-22 they resolved in withing 30 seconds by whitelisting. But that I am assuming did not stop the problem as my IP did change after that. I am a small company and do not alter our listing so I really have no clue when the problem started. I need to add inventory now and am at "-1" on the product that I was trying to restock to when I found the problem

I have never used this plugin so I cannot comment on it. I use EZ Populate and can do much more than "just" update qty.

Quote:

---

Originally Posted by g2ktcf

I have never used this plugin so I cannot comment on it. I use EZ Populate and can do much more than "just" update qty.

---

i have never used EZ populate. but last time i checked this was the support thread for my inventory updater...

as far as bypassing sitelock, i doubt it. but i have no idea, as i have never used sitelock...

it seems more valuable to figure out your sitelock issues as opposed to attempting to bypass them with my plugin... but you are more than welcome to try... this plugin has a very easy install and there are no core code scripts modified...

hope that helps.

@g2ktcf if you have never used this plugin and can not comment on it, then please tell what you are doing commenting on it?

If you can just delete my post please. I see no where to do it

Quote:

---

Originally Posted by carlwhat

i have never used EZ populate. but last time i checked this was the support thread for my inventory updater...

as far as bypassing sitelock, i doubt it. but i have no idea, as i have never used sitelock...

it seems more valuable to figure out your sitelock issues as opposed to attempting to bypass them with my plugin... but you are more than welcome to try... this plugin has a very easy install and there are no core code scripts modified...

hope that helps.

@g2ktcf if you have never used this plugin and can not comment on it, then please tell what you are doing commenting on it?

---

@Carlwhat, I did not even realize which forum this was in. Please accept my sincerest apologies. I did not even realize this was your plugin.

Using 1.5.6 zencart and php 7.3

Hello,
I downloaded this plugin and it works great. In my instance it is allowing me to have a semblance of normalcy as I have ongoing problems with a hacked site or server.
I am ignorant but stubborn so I would like to ask for patience.
I downloaded the zip file and can not figure the file structure.
I read them to be that upon unwrapping , I would be creating OR adding to the following folders for the zencart 1.5.6 version I am using:

admin: [ i have that naturally]
includes: [ I have that]I added inventory.php here and set permissions
Drilling down then
extra_datafiles = [I had that and added the inventory.php]
languages => English [I had those but didn't have folder "extra_definitions so I uploaded the folder extra_definitions] it installed inventory.php also

At this point it is working and I am loving it.

What should I do with the other files in the zip file like folders font_wesome-4.2.0,fonts. js, less and zc_plugins?

I opened a support thread pertaining to my ongoing problem and yes, I am using this to circumvent that problem and am not advising anyone to do that but am saying the plugin is remarkable and I will use it daily! It makes zencart fun again frankly.

Quote:

---

Originally Posted by Mike Harmon

Using 1.5.6 zencart and php 7.3

Hello,
I downloaded this plugin and it works great. In my instance it is allowing me to have a semblance of normalcy as I have ongoing problems with a hacked site or server.
I am ignorant but stubborn so I would like to ask for patience.
I downloaded the zip file and can not figure the file structure.
I read them to be that upon unwrapping , I would be creating OR adding to the following folders for the zencart 1.5.6 version I am using:

admin: [ i have that naturally]
includes: [ I have that]I added inventory.php here and set permissions
Drilling down then
extra_datafiles = [I had that and added the inventory.php]
languages => English [I had those but didn't have folder "extra_definitions so I uploaded the folder extra_definitions] it installed inventory.php also

At this point it is working and I am loving it.

What should I do with the other files in the zip file like folders font_wesome-4.2.0,fonts. js, less and zc_plugins?

I opened a support thread pertaining to my ongoing problem and yes, I am using this to circumvent that problem and am not advising anyone to do that but am saying the plugin is remarkable and I will use it daily! It makes zencart fun again frankly.

---

:thumbsup:

the zc_plugins folder is only for a v1.5.7 install. as you are running v1.5.6, it is completely unnnecessary.
the other folders are only part of the documentation and should NOT be uploaded to your server.

best.

carlwhat,
Awesome and many many thanks.
The plugin is really a timesaver for sure.
Thanks so much for the help and patience
Mike
PS: I can not find where to subscribe to this thread and eventually will lose it I fear!

1.57c, plugin install, echo $pager - one dropdown to select the page works, the other does not. Prev-Next works both top and bottom of the table.

Is there a fix already?

Quote:

---

Originally Posted by Mike Harmon

PS: I can not find where to subscribe to this thread and eventually will lose it I fear!

---

Mike, now that you have commented, you will get update notices (assuming your account is so configured).
Also you can get here from the plugin's home page:

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

(Click the Forum Support Thread button at the top.)

Quote:

---

Originally Posted by twitchtoo

1.57c, plugin install, echo $pager - one dropdown to select the page works, the other does not. Prev-Next works both top and bottom of the table.

Is there a fix already?

---

no, there is not.

use the bottom pager for now.

Quote:

---

Originally Posted by twitchtoo

1.57c, plugin install, echo $pager - one dropdown to select the page works, the other does not. Prev-Next works both top and bottom of the table.

Is there a fix already?

---

twitch, do you even use this plugin?

update submitted. couple of other changes.

new changes are ONLY for v157.

i suppose we can see how good the manifest update works!

best.

Approved.
I would suggest removing the 156 files from future versions if they're not being maintained; just select 157 in the Zen Cart version checkboxes and advise 1.5.6 users to use version 1.2.3 (or whatever the last 156 update version was).

Hi Guys,
I have installed the latest version 1.2.4 as per instructions and trying to test it, I realised that the reset and update items buttons are not working. ZC 1.5.7d, PHP 7.426Attachment 20091. Any suggestions? Thanks a lot.

Quote:

---

Originally Posted by Georgecy

Hi Guys,
I have installed the latest version 1.2.4 as per instructions and trying to test it, I realised that the reset and update items buttons are not working. ZC 1.5.7d, PHP 7.426Attachment 20091. Any suggestions? Thanks a lot.

---

good catch. change forth coming.... apologies.

Quote:

---

Originally Posted by twitchtoo

1.57c, plugin install, echo $pager - one dropdown to select the page works, the other does not. Prev-Next works both top and bottom of the table.

Is there a fix already?

---

@twitchtoo you have now made my async wiki list.

Quote:

---

Originally Posted by Georgecy

Hi Guys,
I have installed the latest version 1.2.4 as per instructions and trying to test it, I realised that the reset and update items buttons are not working. ZC 1.5.7d, PHP 7.426Attachment 20091. Any suggestions? Thanks a lot.

---

new version just submitted for release. thanks for pointing out this obvious bug.

if you do not want to wait, feel free to download from github.

Excellent work. Plug inn system is a real time saver.

Quote:

---

Originally Posted by Georgecy

Excellent work. Plug inn system is a real time saver.

---

:thumbsup:

Is this plugin compatible with SBA?

Quote:

---

Originally Posted by jodean

Is this plugin compatible with SBA?

---

Already asked - https://www.zen-cart.com/showthread....27#post1380927

Quote:

---

Originally Posted by carlwhat

:thumbsup:

---

Hi Guys,
Is this plugin compatible with ZC2.01 or is going to be soon?

Quote:

---

Originally Posted by Georgecy

Hi Guys,
Is this plugin compatible with ZC2.01 or is going to be soon?

---

On a first test it seems is working. We will test it further.