shahnawazsibi Posted July 10, 2012 Share Posted July 10, 2012 Hi how to import color codes via csv or mysql ?i have very long list of colors Link to comment Share on other sites More sharing options...
phrasespot Posted July 12, 2012 Share Posted July 12, 2012 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 Link to comment Share on other sites More sharing options...
shahnawazsibi Posted July 12, 2012 Author Share Posted July 12, 2012 yes but how to import these codes for color picker ? i can enable color group by mysql... Link to comment Share on other sites More sharing options...
phrasespot Posted July 12, 2012 Share Posted July 12, 2012 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 Link to comment Share on other sites More sharing options...
fancy|modules Posted August 29, 2019 Share Posted August 29, 2019 (edited) hello, you can try this module https://addons.prestashop.com/en/combinaisons-customization/46318-bulk-colors-import.html Edited March 4, 2020 by fancy|modules (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now