transform datatypes, include shops in product