[FONT=Times New Roman]I have a strong understanding of relational databases. I would like to use a smart numbering system for my products (i.e. each digit in a product number nnnnnnnn has meaning that ultimately describes the product/SKU).[/FONT]

[FONT=Times New Roman]I know that I can go directly into myPHPadmin and change products_id to the new number in zen_products, but where else is the products_id used? Is there an "easy" way to update every instance at once? [/FONT]

[FONT=Times New Roman]To better explain, I want to change my products_id "1" to be “12345678.” I can update it manually in the DB in the zen_products table, but where else will I need to update it? (What other tables?)[/FONT]

[FONT=Times New Roman]I have never used EasyPopulate, but I plan on using something like it (or develop it myself) to do a mass upload of products and the smart numbers. Any advice?[/FONT]

[FONT=Times New Roman]I guess the other question is…what updates are made to which tables when a new product is added in Zen Cart Admin? I was thinking that if I could find the update queries (where are they?), I could simply keep the original products_id values and map them to the smart numbers in any unused field in the zen_products table.[/FONT]

[FONT=Times New Roman]Thanks for any help you may be able to provide.[/FONT]

[FONT=Times New Roman]-David[/FONT]