CWR electronics data and Prestashop import

We want to import a db from our supplier into our website done with prestashop 1.4.0.17 and a theme bought from them. One of the difficulties is to import the categories ID separated with a * and categories names separated with a |. there are 12000 products, 20 categories and many sub-categories. Ideally, we are also looking for a weekly update of our own db with supplier's. We need someone already trained on prestashop db and we also have other projects of the kind.