Quote Originally Posted by BlessIsaacola View Post
It would be great and cleaner to provide update SQL for this mod (especially since you took it over from where Andrew left off). The current SQL doesn't take into account that other mods your provided already created the UPC/ISBN fields in products table.

Not providing a cleaner upgrade path definitely leads to too many DB errors and makes using mod more complicated than it needs to be.

Thanks!
An error will not be produced, the SQL will ignore those lines. If an upgrade to the SQL is needed, an upgrade SQL file is provided. If one is not provided, the update merely requires file overwrites. The installation documentation has been greatly lengthened to avoid any issues.

There is an undesired effect that is happening with this mod that didn't exist with the version that was created by Andrew. This version 1.4.8 is generating duplicate products if a product is linked. Previous version on generated one product no matter how many category the product is linked to. It would be great if this can be fixed. Thanks!
Which version were you using before? Andrew's latest version was v1.3.3. This mod works by going through each productID until it reaches the end of the DB file. Unless your links are creating brand new productID's in the database, it will not include a duplicate of your product.