MySQL update

  • Resolved michaelsz

    (@michaelsz)


    6 years, 2 months ago

    Hi,

    Thank you for this plugin. It works really nice and convinient.

    I wonder where I can find the tier price values in MySQL Woocommerce database?

    I’m trying to build a Visual Basic macro that updates the tier price values directly from Excell spreadsheet.

    It can be useful to do that when you have few hundred product and 8 tier prices each and the prices changes in a weekly manner.

    I was looking for WordPress plugin that allows bulk price update. There are a few of them but none of them works with your tier prices. Only standard price. The same story goes with import/export csv plugins (they do not see the tier prices).

    So I thought why not to write some VBA in Excell that bulk updates every tier price in one button click. I can handle that. But I really don’t know WordPress MySQL structure and where the tier price values are.

    It would be great if you could help me with MySQL query that updates price and tier price of the product where SKU is provided? (or some hints where I can find your tier price values in the database and figure things out myself).

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mykola Lukin

    (@bycrik)

    Hi! Rules are stored in postmeta and have key – ‘_price_rules’, so if you need to handle it yourself – you must follow this structure: 

    array(
 'quantity' => 'price',
 'quantity' => 'price'
)

    for example: 

    array(
2 => 10,
10 => 8
)

    If you need some help with that – write here [email protected] and I will provide estimate for your task.

    Thank you!

    Thread Starter michaelsz

    (@michaelsz)

    Thank you so much. That helps me a lot.
    In this task just want to help a friend (and learn as a side effect), it will make his work so much easier.
    Thank you ??

    Plugin Author Mykola Lukin

    (@bycrik)

    Glad to help! If you like the plugin I will be happy if you leave a review. Thanks!

    • This reply was modified 6 years, 2 months ago by Mykola Lukin.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL update’ is closed to new replies.