Inventory Updater...

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.

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.

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

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

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/proseLA/inventory/master/admin/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.

extra options such as batch uploading

DBIO
https://www.zen-cart.com/showthread.php?220569-Database-I-O-Manager-%28DbIo%29-Support-Thread

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

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

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

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

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/en/integer-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.