Set new regular and sale price via MYSQL

  • In my new shop there are only regular_prices for the products and the variations.
    I like to do following with prices:
    -higher regular_price with 15% for all products in specific main categories
    -higher regular_price with 5% for other categories
    -set sale_price = regular_price -/- 25% for all products in specific main categories
    -set sale_price = regular_price -/- 25% for all variant products in specific main categories
    -set sale_price = regular_price -/- 12.5% for all products in specific main categories
    -set sale_price = regular_price -/- 12.5% for all variant all products in specific main categories
    Till now I did not found a plugin or mysql query to do above.

    Does anyone of you have an idea how to solve this?
    Thanks in advance.

Viewing 1 replies (of 1 total)

  • Prices are stored in postmeta (wp_postmeta) table with meta_key values _sale_price and _regular_price.

Viewing 1 replies (of 1 total)
  • The topic ‘Set new regular and sale price via MYSQL’ is closed to new replies.