Importing databases in prestashop

Question

I have a big database in Access with products I want to insert in Prestashop! I've read about the database import in prestashop but didnt find anything about access db import. Is there a way to import this database in prestashop? Or am I supposed to write sql queries to add these products. I have read the source code of prestashop like Products.php or ObjectModel.phplike said here:http://stackoverflow.com/questions/16068141/prestashop-insert-products-script. So is the only way to write sql queries? Thanks!

Answer 1

PrestaShop have tools to import products from CSV, you can check it in BO > Advanced Parameters > CSV Import. You can choose what you want to import, products, categories, attributes etc. If your file is too big you supposed to split it to few small files.