WordPress.org

Ready to get started?Download WordPress

Forums

WP E-Commerce Weight & Destination Shipping Modules
Mass cost modification (4 posts)

  1. ruge75
    Member
    Posted 1 year ago #

    Hi,
    How can I modify all price for the USA with a single SQL instruction?
    They have all the same price.

    Best
    Ruggero

    http://wordpress.org/extend/plugins/wp-e-commerce-weightregion-shipping/

  2. Lee Willis
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. ruge75
    Member
    Posted 1 year ago #

    Hi,

    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.

    Thanks
    Best

  4. Lee Willis
    Member
    Plugin Author

    Posted 1 year ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.