Totally Zenned
- Join Date:
- Jun 2008
- Posts:
- 629
- Plugin Contributions:
- 0
Bulk add attributes to all products
I have one option name/option value that I would like to add to 5,000+ products. Can this code be altered so I can run it in phpmyadmin so it will this same option name/option value to all products?
INSERT INTO username_zen2.zen_products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) VALUES ('1074', '8368', '1', '1', '0.0000', '+', '0', '1', '0', '+', '0', '0', '1', NULL, '1', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, '0.0000', '0', '0.0000', '0', '0');[...]";