How to use provided methods in my own script

[shifty]

Hello,

I would like to make a script, which will be launched every day by cron. This script should update information about availability of product according to XML feed. If new products were added into feed, it will add them.

So, I can make SQL which update/insert into all tables, but i dont want to do this using this way.

My question is, how can I use provided methods and classes from Prestashop in my own script ? What files should I include ? Or how can I add product using my own script ?

Please, give me advice. Thanks.

[vekia]

i think that the best thing in this case is to create own module, then you can easily disable / enable this feature, moreover - this method in my opinion is the best and easiest

[shifty]

Thanks. And what if I want to add product, using SQL command without using povided methods ? In which tables i have to insert lines ? I can`t find it in PrestaShop source.

[vekia]

here is database model: (mysql workbench)

http://docs.prestashop.com/download/attachments/9961497/pdm-1.5.mwb

 

if you haven't got access to mysql workbench, or if you don't know how to use it - here is an image:

http://doc.prestashop.com/download/attachments/9961497/pdm-1.5.png

 

you can check which tables are related to the products