Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Lee Willis


    I’m not sure exactly what your setup is, but it’s probably not that simple. The config is a serialised array in the database, and you’d need to be very careful to make the serialisation correct.

    The easiest way would probably be to write a small PHP script that pulled the data out, iterated over it making the changes, and then re-saved it.


    The problem is to insert the shipping price for every state of the USA.
    I resolved with many patient: Inserted it for 52 times 🙂
    But I would to know if it’s possible to do a mass update via SQL.


    Plugin Author Lee Willis


    No, there’s no easy way to do that via pure SQL except with an intermediate PHP script to generate the data as I advised earlier.

    If you have the same rate for all 52 states (Or bunches of them have the same rate) then this plugin might be useful. That will allow you to set up a rate and apply it to multiple states at once rather than having to set up individual prices for each state.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Mass cost modification’ is closed to new replies.