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!
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!
You're kidding - you expect your customers to choose from a list of 1100 options?
Please do not PM for support issues: a private solution doesn't benefit the community.
Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.
Or do you perhaps use only a subset of those option values for any given product?
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.
20 years a Zencart User
anyone can offer any help?
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')"
Bookmarks