Inventory Updater...

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