Database tables used to store price calculation values

  • Resolved Snehal Volvoikar

    (@snehalvolvoikar29)


    3 years, 10 months ago

    Hi! I need to change some fixed values/constants used in the price calculation formula. I have some 300 products in my store. At first I had created only product and then duplicated the product multiple times so now the same price calculation is included for all the products. I need to change a specific constant used in the formula. And the value will be the same for all the products. How can I do bulk editing to change specific values in the formula? Is there a DB table that stores the price calculation values so that I can edit from phpmyadmin and get my job done? Please help.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author moomooagency

    (@moomooagency)

    Hi,

    In general there is no such functionality.
    However, check our fb group Builderius community, there is a snippet of how to pair NOV to custom field. If you do this, then such value would be controlled from custom meta field.

    Thread Starter Snehal Volvoikar

    (@snehalvolvoikar29)

    I didnt find the snippet on your FB group. Do I need to join the community? If you could provide the snippet here. Also, I have paid version of the plugin, so I’m wondering if there’s a live chat support.

    Thread Starter Snehal Volvoikar

    (@snehalvolvoikar29)

    How do I Bulk edit non option variables

    Plugin Author moomooagency

    (@moomooagency)

    Hi,

    Could you explain how did you search for snippet in the group without joining? Just curious)) Yes, you have to join, obviously.

    There is no live chat support. But there is email support. Please, check the docs as well.

    Thread Starter Snehal Volvoikar

    (@snehalvolvoikar29)

    We’ve joined the group. Would you help me with the issue? I’ve even sent a submit ticket through wp dashboard. I received this repsonse :
    https://www.myeasydecor.com/wp-content/uploads/2021/04/uni-cpo-response.png
    Please Help!

    Thread Starter Snehal Volvoikar

    (@snehalvolvoikar29)

    How do I find the entries for non option variables in DB?

    Plugin Author moomooagency

    (@moomooagency)

    Hi,

    I don’t think you have to search for records related to NOVs directly in DB.

    Which issue do you have?

    Thanks!

    Thread Starter Snehal Volvoikar

    (@snehalvolvoikar29)

    I have this calculation formula:
    {uni_cpo_widthlabpaper}*{uni_cpo_heightlabpaper}/10000*547

    I need to change the no. ‘547’ to something else for eg. 400. Now this calculation formula is there for all the products, I wanted to know how we can bulk edit this number instead of manually going through each and every product to edit. Because I have some 400 products in my store.

    screenshot: https://www.myeasydecor.com/wp-content/uploads/2021/04/nov-01.png

    Plugin Author moomooagency

    (@moomooagency)

    I would suggest you putting that value into NOV paired with post custom field. An example of code of how to pair these two entities is given in our fb group. Then you will be able to change that value in custom meta and automatically use in the formula.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database tables used to store price calculation values’ is closed to new replies.