I have 1100 option values to import, how to do it in batch?

[mybiz9999]

Hi,I have 1100 option values to import, how to do it in batch?

the 1100 option values are for a single option (style of clothes).

No luck with Easypopulate or apsona.
Can I do it with the Sql?

Please help. Thank you!

[Kim]

You're kidding - you expect your customers to choose from a list of 1100 options?

[gjh42]

Or do you perhaps use only a subset of those option values for any given product?

[mybiz9999]

5000 products, 1100 option values.

each product has 4 or 5 option values.

anything wrong?

You're kidding - you expect your customers to choose from a list of 1100 options?

[mybiz9999]

thank you.
yes,that's right. firstly, what I need to do is import all option values.

any ideas ?

Or do you perhaps use only a subset of those option values for any given product?

[schoolboy]

We had a similar issue, needing to load about 1500 option values. We used Apsona... but one has to get the initial csv file right. This took a bit of time.

Follow Apsona tutorial on attribute loading.

[mybiz9999]

anyone can offer any help?

[mybiz9999]

I have got the method to add option value quickly.

"INSERT INTO `dac_zc01`.`products_options_values` (`products_options_values_id`,
`language_id` ,
`products_options_values_name` ,
`products_options_values_sort_order`
)
VALUES ('164','1', 'R5-5C_YellowishLight_OrangePeel_1-7ModeCircuit', '67')" "INSERT INTO `dac_zc01`.`products_options_values_to_products_options` (
`products_options_values_to_products_options_id` ,
`products_options_id` ,
`products_options_values_id`
)
VALUES (
'190', '20', '164')"