Import Product Attributes Via phpMyAdmin?

[Andor1211]

Hi all,

What tables do I have to save, to import product attributes (color, size, etc.) to a second store? I can work in PHP, but I couldn't solve this problem.

Thanks for the help in advance.

[schoolboy]

Are the products in the second store exactly the same as those in the first store? And I mean EXACTLY the same...

[Andor1211]

Yes, they are exactly the same, the ID, the description, everything.
My problem is, for example if you can choose from more colors with a dropdownlist (red, green, blue etc.) then only red appears with a radio button. I even copied the special prizes without problems, I have only problem with this one.

Is there a software that makes this easier? Money doesn't matter.

[schoolboy]

My problem is, for example if you can choose from more colors with a dropdownlist (red, green, blue etc.) then only red appears with a radio button. I even copied the special prizes without problems, I have only problem with this one.

Before you try to copy stuff, this needs to be sorted out. It seems like you have mis-configured that particular OPTION NAME/OPTION VALUE data-set.

There is no "commercial program" that achieves what you want. The method I was going to suggest was to CLONE the relevant database tables and insert them into the second site's database. That's why I asked if all the products are identical, because you will need to copy all relevant categories/product tables as well.

But there are other considerations... Such as current and archived customer activity. You may need to copy some of this data as well...

All will depend on the degree to which your SECOND SITE must mimic the condition of the FIRST SITE.

But if you do the clone at this point, you will simply import errors too... such as the one you describe.