set hex of colour directly on the import csv combinations

[wayann]

Hi there,

 

can someone point me where I should hook my mod so I can import colours with

value:position:hex 

for example

White:0:#ffffff

who's in charge for that task? the AttributeGroup class? the Attribute class? the Combination class? I've looked in there and 

 

I can hack a quick sql query but I was wondering if there is a more elegant way to do it... and which class I should override.

 

that would be very handy for my purpose,

Edited January 30, 2015 by wayann (see edit history)

[wayann]

I see you can upload texture also, but wouldn't be wicked to have

White:0:#ffffff, Texture:1:http://localhost/prestashop/p/texture.jpg

and once defined on the first product others just need the specify the name value.

[jorozco]

Hi Guys!

 

I was wondering, there exist an easy way to add and import hexadecimal colors in product combinations from a CSV file?

 

Thanks for your help!

[Evgenii Pavlov]

up plz

[Evgenii Pavlov]

my own python code

import csv
field_names = ['color_name', 'hex']

start_id = 946

with open('colors_hex.csv', mode='r') as infile:
    reader = csv.reader(infile, delimiter=';')
    next(reader, None)  # skip the headers
    for i, rows in enumerate(reader):
      print("INSERT INTO `ps_attribute_lang` (`id_attribute`, `id_lang`, `name`) VALUES ('{1}', '1', '{0}'), ('{1}', '2', \"{0}\");".format(rows[0], i+start_id))
      print("INSERT INTO `ps_attribute` (`id_attribute`, `id_attribute_group`, `color`, `position`) VALUES ('{2}', '3', '{0}', '{1}');".format(rows[1], i, i+start_id))
      print("INSERT INTO `ps_attribute_shop` (`id_attribute`, `id_shop`) VALUES ('{0}', '1');".format(i+start_id))

 

[fancy|modules]

for import color codes in color attribute group via csv file you can use this module:

https://addons.prestashop.com/en/combinaisons-customization/46318-bulk-colors-import.html