Jump to content

prestashop DB scheme. where put info about products?


mamandis

Recommended Posts

Hello,

 

I want to ask you to which DB tables I need to put information about products?

I use 1.4.3 version

DB is very large.. I saw data base schema of prestashop..

do I need to look to 'product' section?

does these all table names is correct?

 

Thanks for answers

post-271606-0-79731500-1334742363_thumb.png

Link to comment
Share on other sites

If you plan to import products by SQL, focus on these tables:

 

product -- the main leading info a bout products

product_lang -- language-specific info like description (connects product and language specs)

 

As you can see there are much more tables so you probably won't be able to export&import all data efficiently and will need to do some connections in back office "by hand" (eg. categories, manufacturers, suppliers, product images...).

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...