Jump to content

Matching CSV column names and database tables/fields


Recommended Posts

Hi to everyone,

 

I'm quite new to Prestashop, using version 1.5.4.1. I would like to write my own PHP script to import large CSV files on a batch process. So far I have written it, but I have some questions. I'm using a csv with 39 columns, I have read that with this format I can update all data needed (taking into account that I have already loaded manufacturers, categories, features and other lookup data inside database).

 

So, these are my doubts:

 

1) How can I upload images? I have a column called 'Images URLs', but I can't find inside database a table/column where to load the relationship between a product and its images.

 

2) I have a column call 'Percentage of discount', where is it mapped? It is in ps_product.unit_price_ratio?

 

Thanks a lot.

Marcos

Link to comment
Share on other sites

×
×
  • Create New...