Import product data directly

[arnab]

Hi All


I'm trying to write a script which will be importing product information into PrestaShop database directly. I don't want to use its in built csv import. Because I'll be getting product information as xml feed from my supplier.

Could anybody please help me in understanding the table structure of PrestaShop so that I would be able to know what information to be inserted where.

Is there any class/package of the Prestashop application which are uploading the datas.


Thanks & Regards,

Arnab

[Camille Frisch]

What your asking is, IMHO, not specific enough. If your really want to import data 'from the scratch', you need to look at those tables :

ps_product_*
ps_attribute_*
ps_features_*
ps_tag_*

and prolly a bunch of others i'm not familiar with. Asking to detail what each of these tables do is a full time job ... IMHO

Why don't you convert your xml to a nice csv that the importer wll anderstand ?

mika

[arnab]

Sir,

I understand that. But my requirement is to import directly. I've tested the csv import, its great. I've to somehow write a script to upload data directly.

Even though it may be tedious, could you guide me where to dig out the information.

Prestashop's in build csv import is uploading the data, so could it be helpful if I could find out their functionality or get some documentation regarding that.


Thanks

[Camille Frisch]

I sincerely hope you'll find someone to explain you the internal magic of prestashop, but that good samaritain isn't me.

Maybe you'd be luckier trying to automate the csv importer, but you'd still have to convert your data. Other than that I'm running out of ideas.

Good luck with it