One reason why the imported data couldn't be shown is because of the hierarchy. Make sure to map the hierarchies properly and include it in the module as well for G3 Location and P2 products. Also, make sure to verify the children - parent relationship in the list. (Eg: New York under US and Nutzo Bar under Chocolates). Try uploading this way setting summary as 'SUM'.
I found my error after your prompts. It seems like I've missed a step on the hierarchy part under lists. The countries in G3 location weren't tagged properly to their parents ( eg. New York-> Parent: US; Code: G001).