Inventory Updater...

[carlwhat]

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

[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

[carlwhat]

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.

[carlwhat]

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.

[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

[carlwhat]

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!

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.

[jimmie]

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

[carlwhat]

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.

[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

[carlwhat]

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.