Jump to content

Bulk import of color codes

Recommended Posts

Colors are nothing other than attributes. I.e. 'Color' is an attribute group and each color is an attribute in that group. They are referred to as Combinations under Back Office > Tools > CSV Import

Share this post

Link to post
Share on other sites

There is no import for a single attribute group. If you have access to DB, then easiest way is to do it there, if you don;t want to use the back office.


Find the id of color attribute group in PREFIX_attribute_group_lang table, then insert attribute (color) values into PREFIX_attribute table as desired using that id.


something like:


INSERT INTO PREFIX_attribute(`id_attribute`, `id_attribute_group`, `color`) VALUES (`x`, `y`, `z`)...


where y is the value you got from PREFIX_attribute_group_lang

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More