missing from above:
1. /ecommerce/www/admin/products/add*
It looks like present_p is explicitly referenced during the insert[2], and thus empty is null.
I guess, there should be a check for null and replace with 't' before inserting products.
2. /ecommerce/www/admin/products/upload