Database and New Plugin

I am working on a new plug-in and I need to store "last reported inventory values." The easiest thing to do is to add a field to the products table (SBA is another consideration for later). Is that considered the best practice? I guess as long as I include both field creation in the install script and deletion in the uninstall script I should be okay, right?

g2ktcf:

I am working on a new plug-in and I need to store "last reported inventory values." The easiest thing to do is to add a field to the products table (SBA is another consideration for later). Is that considered the best practice? I guess as long as I include both field creation in the install script and deletion in the uninstall script I should be okay, right?
FWIW, adding that field to the **products **table would be the approach I'd use. Just name the field 'appropriately' so that it's not likely to be overwritten by a Zen Cart upgrade that adds such a field.

lat9:

FWIW, adding that field to the **products **table would be the approach I'd use. Just name the field 'appropriately' so that it's not likely to be overwritten by a Zen Cart upgrade that adds such a field.

Good Point, I never considered that another upgrade would overwrite it! Thanks!