Shipping profiles keeps adding amount even though it has changed

  • Resolved Heyme

    (@heyme)


    8 years ago

    Hey all,

    On https://www.petitplat.com there is too much shipping added.
    We made new shipping zones, all using flat rates, and below figures are put in as cost.
    Nothing is entered in Shipping class cost.
    France 2,50
    Guadeloupe, French Guinea 4
    Belgium, Denmark, FInland, Germandy, Lux, Norway, Portugal, Republic of Ireland, Spain, Sweden, Switzerland, UK 5
    Italy, Greece 7,20
    Hong Kong, Israel, Japan, Malaysia, Singapore, United States (US), Australia, New Zealand 5,5
    Bahrain, China 8
    Rest of the world 20

    We did have Shipping class costs entered earlier, 7 euro, but removed this.
    It kept adding this 7 euro everywhere though.
    Updated all plugins and tested last Sunday, and everything was working fine after that, but today’s orders that came in were again charged the extra 7 euro on top.
    I’ll be happy to check the tables and remove the 7 euro in the shipping, but what table should I be looking at?

    ‘`
    ### WordPress Environment ###

    Home URL: https://www.petitplat.fr
    Site URL: https://www.petitplat.fr/wp
    WC Version: 2.6.7
    Log Directory Writable: ?
    WP Version: 4.6.1
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 5.6.27
    PHP Post Max Size: 128 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 2000
    cURL Version: 7.38.0
    OpenSSL/1.0.1e

    SUHOSIN Installed: –
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 2.6.7
    :
    woocommerce_sessions: ?
    woocommerce_api_keys: ?
    woocommerce_attribute_taxonomies: ?
    woocommerce_downloadable_product_permissions: ?
    woocommerce_order_items: ?
    woocommerce_order_itemmeta: ?
    woocommerce_tax_rates: ?
    woocommerce_tax_rate_locations: ?
    woocommerce_shipping_zones: ?
    woocommerce_shipping_zone_locations: ?
    woocommerce_shipping_zone_methods: ?
    woocommerce_payment_tokens: ?
    woocommerce_payment_tokenmeta: ?
    MaxMind GeoIP Database: ?

    ### Active Plugins (32) ###

    Polylang: by Frédéric Demarle – 2.0.7
    Akismet: by Automattic – 3.2
    amr shortcode any widget: by anmari – 3.3
    Blogger 301 Redirect: by Sudipto Pratap Mahato – 2.5.2
    Contact Form 7: by Takayuki Miyoshi – 4.5.1
    Content Views: by PT Guy – 1.9.2.1
    Cookie Law Info: by Richard Ashby – 1.5.3
    Crafty Social Buttons: by Sarah Henderson – 1.5.5
    Display Widgets: by Strategy11 – 2.05
    Header and Footer: by Stefano Lissa – 2.0.3
    Image Widget: by Modern Tribe
    Inc. – 4.2.2

    Login Security Solution: by Daniel Convissor – 0.56.0
    Login Widget With Shortcode: by aviplugins.com – 5.5.4
    MailChimp for WordPress: by ibericode – 4.0.7
    My Custom CSS: by DarkWolf – 3.1
    Photo Gallery: by WebDorado – 1.3.15
    Pretty Link Lite: by Caseproof – 1.7.2
    Content Views Pro: by PT Guy – 4.0
    Optimize Database after Deleting Revisions: by CAGE Web Design | Rolf van Gelder
    Eindhoven
    The Netherlands – 4.2.1

    Slider WD: by WebDorado – 1.1.57
    Tiled Galleries Carousel Without Jetpack: by Raja CRN – 2.1
    W3 Total Cache: by Frederick Townes – 0.9.5.1
    Hyyan WooCommerce Polylang Integration: by Hyyan Abo Fakher – 0.28
    WooCommerce Currency Converter: by WooThemes – 1.6.3
    WooCommerce Extra Product Sorting Options: by SkyVerge – 2.5.0
    Booster Plus for WooCommerce: by Algoritmika Ltd – 1.0.5
    Booster for WooCommerce: by Algoritmika Ltd – 2.5.6
    WooCommerce: by WooThemes – 2.6.7
    WooCommerce Helper: by WooCommerce – 1.7.2
    Wordfence Security: by Wordfence – 6.2.3
    Yoast SEO: by Team Yoast – 3.7.1
    WP Crontrol: by John Blackbourn & Edward Dale – 1.3.1

    ### Settings ###

    Force SSL: –
    Currency: EUR (€)
    Currency Position: right
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2

    ### API ###

    API Enabled: ?

    ### WC Pages ###

    Shop Base: #5 – /shop/
    Cart: #6 – /cart/
    Checkout: #1699 – /check-out/
    My Account: #1692 – /my-account-2/

    ### Taxonomies ###

    Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)

    ### Theme ###

    Name: Spacious Pro Child
    Version: 0.1
    Author URL: https://heyme.nl/webdesign
    Child Theme: ?
    Parent Theme Name: Spacious Pro
    Parent Theme Version: 1.0.3
    Parent Theme Author URL: https://themegrill.com
    WooCommerce Support: ?

    ### Templates ###

    Overrides: spacious-pro-child/woocommerce/archive-product.php
    `’

Viewing 2 replies - 1 through 2 (of 2 total)
  • anphira

    (@anphira)

    @heyme it sounds like an old rate is hiding somewhere. Most likely you’re right that you’ll need to look in the database. I’d look through the woocommerce_shipping_… tables. Also I’d compare the tables in your database for WooCommerce to those which are officially listed with the latest version.

    https://github.com/woocommerce/woocommerce/wiki/Database-Description

    If you find a table that’s not in that list, it may be the offender.

    And as always, make sure to make a full backup of your database before modifying anything.

    Thread Starter Heyme

    (@heyme)

    Thanks Anphira!

    As a workaround, since it is all flat rates, we now removed the earlier categories (small, medium, large), which had the required effect as well.
    It is maddening as I was testing, and all was correct, and then an order came in next day with again the higher shipping!
    May also have been the W3 Cache keeping the tariffs? I’ll not know as now all is working!

    The database description will come in very handy, thank you again!

    Heyme

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Shipping profiles keeps adding amount even though it has changed’ is closed to new replies.