Data fields for import

[AlexBotkin]

Hi,

In preparing my database for uploading I find the instructions a little confusing. On this page:

http://www.prestashop.com/wiki/Importing_Product_Data/

1) there is listed ID and Product_ID; are these the same? If not how do they link.

2) there are: Name, Short description, Description, features; how do they differ?

3) How does reference# differ from ID

[ChrisLNZ]

Hi,

In preparing my database for uploading I find the instructions a little confusing. On this page:

http://www.prestashop.com/wiki/Importing_Product_Data/

1) there is listed ID and Product_ID; are these the same? If not how do they link.

2) there are: Name, Short description, Description, features; how do they differ?

3) How does reference# differ from ID

Hi
1) ID and Product_ID are not the same - ID is the field used as a unique identifier for the table - Product_ID is the unique identifier for a product. ID is used to refer in relational tables.

2) e.g.Name: IPod, S Desc: portable MP3 player, Desc: Apple product and popular portable MP3 player etc etc, features: 6hours play time, stores 100 million songs etc ect

3) ref # could be your own code or a supplier code etc

[AlexBotkin]

But why do the instructions on that page have Name, Price, Weight, description etc, all of which are very specific to a single product with ID, while the Product_ID attributes in the section below also include product specific attributes including price?

Why would they be imported separately?

Can anyone develop a concrete example?

[ChrisLNZ]

It would appear to me that you perhaps need to do some reading about relational tables in a database.
These links may help :
http://computer.howstuffworks.com/question599.htm
http://www.wisegeek.com/what-is-a-relational-database.htm

[AlexBotkin]

I'm beginning to suspect that you did not read the original post ChrisLNZ.

[ChrisLNZ]

I did read it and answer it.

Have you actually had a look at the tables in your database?
The wiki guide tells you what may be imported - doesn't mean you have to, but some fields will be necessary.

The first section covers importing into the products table, the second section the attributes table and they are linked by ID_product.

[AlexBotkin]

they are linked by ID_product.

Yes indeed... but the documentation in one case says:

ID

and the other

Product ID

That was the question. Apparently they are the same but the documentation is inadequate.

Page 153 of the User manual, where this information is alleged to be located, is clearly missing images and text. I am rethinking using Prestashop.

[ChrisLNZ]

they are linked by ID_product.

Yes indeed... but the documentation in one case says:

ID

and the other

Product ID

That was the question. Apparently they are the same but the documentation is inadequate.

Page 153 of the User manual, where this information is alleged to be located, is clearly missing images and text. I am rethinking using Prestashop.

Alex Product_ID and ID are NOT the same - the ID is the unique field for the table. There may be occasions when the number in the field is tha same but they do different things - as I answered right at the beginning to your first post

[liane]

If Product ID and id are not the same, then how do you import the product iDs and match them up to the right products? on the combinations CSV there is no ID field, only product ID. What field links the two separate imports? Product name?