WordPress.org

Forums

WooCommerce
[resolved] Bulk Edit Download Limit & Expiry (2 posts)

  1. mass501
    Member
    Posted 2 years ago #

    Hi,

    Is there any way one can bulk edit the download limit & expiry for virtual products? In which DB is this info found?

    Thanks,

    http://wordpress.org/plugins/woocommerce/

  2. mass501
    Member
    Posted 2 years ago #

    Solved it myself,

    if you're looking for a solution here's the MySQL query:

    UPDATE wp_postmeta SET meta_value = "10" WHERE meta_key = "_download_limit" and post_id IN ( SELECT * from (SELECT post_id FROM wp_postmeta WHERE meta_key = "_downloadable" AND meta_value="yes") T)

    needless to say, backup your DB before running any queries....

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WooCommerce
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic