The problem occurs in between these transition:

#WORKING FINE - No sales module installed

#ERROR OCCURS - Sales Module installed, deleted product category - all product, created custom product categories (parent and regular products)

If I roll back to the working fine snapshot and install the sales module and go on from there it works fine. But I've made a lot of changes to the system, I prefer to fix it instead of doing it from ground up again