Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author teastudio.pl

    (@teastudiopl)

    This plugin allows you to display only products from the store WooCommerce.
    No commercial support solutions.
    If you are interested in this functionality you can order it.
    Contact me by email [email protected] for details.

    Hello,love your plugin ??
    In the: “…by selected IDs: Please enter Product IDs with comma separated. ” each week i need o change these ids. Can you tell me the Mysql command to update just these IDs for the plugin?
    I tried:
    REPLACE INTO sd_options (option_id, option_name, option_value, autoload) VALUES
    (994370, ‘widget_woocommerce_products_carousel_all_in_one’, ‘a:2:{i:2;a:33:{s:5:”title”;s:42:”Recently Released DVD & Blu-Ray Movies…”;s:8:”template”;s:10:”simple.css”;s:9:”all_items”;s:2:”55″;s:9:”show_only”;s:6:”newest”;s:8:”products”;s:384:”713371,713331,713508″;

    ETC…..But it says OK, when i go back to widget it has disappeared !?
    Can you tell me way of doing this please?
    Thank you
    rob

    Plugin Author teastudio.pl

    (@teastudiopl)

    I think that you should use UPDATE instead of REPLACE, maybe this is the problem?

    ok thanks, but whats the correct syntax ?
    Is it:
    UPDATE nsvideo_nvmain.sd_options SET option_value = ‘a:2:{i:2;a:33:{s:5:”title”;s:42:”Recently Released.. ECT..ECT.. ??
    I tried this and had to restore my DB lol. Sorry, just not sure.
    I think i supposed to put WHERE option_id= field.?
    Thanks
    Rob

    ps: usually i’d click in a field change it then hit enter. But i want to send a command each week to just update the option value field with automation script.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Include Other Custom Post Types’ is closed to new replies.