What DB fields are used when adding a product

[kelbyuk]

I want to be able to inject full products into my shop using a script that takes a new products file daily from my supplier.
The file will be processed by my script and the results added to my shop.

What fields/tables are used in adding a product to prestashop?

[kelbyuk]

No-one got an answer to this?

[MrBaseball34]

I've got one that has been modified to work with out vendor file. Are you up to modifying the PHP code to make it work with yours?
Do you understand the architecture of the PS database because it helps.

[kelbyuk]

I'd be interested in giving it a try, bit sketchy on the db architecture but hopefully will find my way around better with experience.

[MrBaseball34]

I started out with no Prestashop experience and about 8 yrs PHP/mySQL.

It won't take long when you look at the code. This code does not use any Prestashop hooks so
you aren't babied. It will teach you where each thing goes when it is imported.

I need to fix the image import portion, we currently use a custom one, before I can release it.

[kelbyuk]

Cool, Look forward to seeing it when its ready Only got a little PHP experience but been using mysql with ASP for a few years so should be able to find my way round the code.