Changing product prices to “from £x” / bulk buy prices

  • Resolved innocentcandles

    (@innocentcandles)


    3 years, 5 months ago

    Hello there

    I searched this forum to find an answer to my problem, unfortunately to no avail. Maybe you could help me?

    You will find the woocommerce status report at the bottom of this message.

    I would like to sell products in bulk. The more products you buy, the cheaper the price for each individual item. For example: one candle costs £5, two candles £8 (or £4 per candle) etc.

    The problem: I am not able to change the product price to “from £X”, whereby X would be the cheapest item price in a bulk sale (in my example: “from £4”). What I get is the price range (from £5 to £8), distorting the actual pricing.

    Is it possible to change the price to “from £X”, whereby x represents the cheapest price of one item in a bulk sale?

    Thanks so much in advance for your answers.

    ### WordPress Environment ###

    WordPress address (URL): http://innocent-candles.co.uk
    Site address (URL): http://innocent-candles.co.uk
    WC Version: 6.9.3
    REST API Version: ✔ 6.9.3
    WC Blocks Version: ✔ 8.3.2
    Action Scheduler Version: ✔ 3.4.0
    Log Directory Writable: ✔
    WP Version: 6.0.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –

    ### Server Environment ###

    Server Info: LiteSpeed
    PHP Version: 7.4.30
    PHP Post Max Size: 512 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 5000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.5.15-MariaDB-cll-lve
    Max Upload Size: 512 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    WC Database Version: 6.6.1
    WC Database Prefix: wp_
    Total Database Size: 20.47MB
    Database Data Size: 17.26MB
    Database Index Size: 3.21MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wp_aioseo_cache: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    wp_aioseo_notifications: Data: 0.03MB + Index: 0.06MB + Engine InnoDB
    wp_aioseo_posts: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
    wp_cartflows_ca_cart_abandonment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_scheduled_tasks: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 10.52MB + Index: 0.13MB + Engine InnoDB
    wp_postmeta: Data: 0.41MB + Index: 0.16MB + Engine InnoDB
    wp_posts: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
    wp_rafflepress_contestants: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rafflepress_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rafflepress_giveaways: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 112
    custom_css: 4
    customize_changeset: 51
    elementor_library: 2
    mailpoet_page: 1
    nav_menu_item: 13
    oembed_cache: 2
    page: 17
    post: 2
    product: 7
    product_variation: 10
    revision: 117
    seedprod: 1
    wp_block: 1
    wp_global_styles: 4
    wpforms: 2

    ### Security ###

    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔

    ### Active Plugins (22) ###

    Hostinger: by Hostinger – 1.0
    All in One SEO: by All in One SEO Team – 4.2.5.1
    All-in-One WP Migration: by ServMask – 7.65
    Starter Templates: by Brainstorm Force – 3.1.16
    Checkout Plugins – Stripe for WooCommerce: by Checkout Plugins – 1.4.6
    Coming Soon Page, Maintenance Mode, Landing Pages & WordPress Website Builder by SeedProd: by SeedProd – 6.15.4
    Easy Google Fonts: by Titanium Themes – 2.0.4
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.9.0
    Jetpack: by Automattic – 11.3.2
    LiteSpeed Cache: by LiteSpeed Technologies – 5.2.1
    MailPoet: by MailPoet – 3.98.1
    OptinMonster: by OptinMonster Popup Builder Team – 2.10.0
    RafflePress Lite: by RafflePress – 1.11.0
    Simple Banner: by Ryan Petersen – 2.12.1
    TrustPulse API: by – 1.0.6
    Spectra: by Brainstorm Force – 2.0.12
    WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.19
    WooCommerce Payments: by Automattic – 4.7.2 (update to version 4.8.1 is available)
    WooCommerce Shipping & Tax: by WooCommerce – 1.26.3
    WooCommerce: by Automattic – 6.9.3 (update to version 7.0.0 is available)
    Yoast SEO: by Team Yoast – 19.7.2
    WPForms Lite: by WPForms – 1.7.6

    ### Inactive Plugins (3) ###

    Akismet Anti-Spam: by Automattic – 5.0
    Google Listings and Ads: by WooCommerce – 2.1.2
    Hello Dolly: by Matt Mullenweg – 1.7.2

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)

    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)

    Connected to WooCommerce.com: –
    Enforce Approved Product Download Directories: ✔

    ### WC Pages ###

    Shop base: #3604 – /?page_id=3604
    Cart: #3605 – /?page_id=3605
    Checkout: #3606 – /?page_id=3606
    My account: #3607 – /?page_id=3607
    Terms and conditions: ❌ Page not set

    ### Theme ###

    Name: Rife Free
    Version: 2.4.14
    Author URL: https://apollo13themes.com/
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔

    ### Templates ###

    Overrides: rife-free/woocommerce/archive-product.php
    rife-free/woocommerce/loop/loop-start.php

    ### Admin ###

    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    wc-pay-promotion
    wc-pay-welcome-page

    Disabled Features: minified-js
    new-product-management-experience
    settings

    Daily Cron: ✔ Next scheduled: 2022-10-17 16:07:22 +00:00
    Options: ✔
    Notes: 72
    Onboarding: completed

    ### WooCommerce Payments ###

    Version: 4.7.2
    Connected to WPCOM: Yes
    Blog ID: 208593046
    Account ID: –

    ### Action Scheduler ###

    Complete: 248
    Oldest: 2022-09-17 15:18:50 +0000
    Newest: 2022-10-17 13:41:19 +0000

    Failed: 1
    Oldest: 2022-09-19 15:59:59 +0000
    Newest: 2022-09-19 15:59:59 +0000

    Pending: 11
    Oldest: 2022-10-17 13:56:13 +0000
    Newest: 2022-10-22 15:33:26 +0000

    ### Status report information ###

    Generated at: 2022-10-17 13:51:48 +00:00
    `

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Kaavya Iyer

    (@kaavyaiyer)

    3 years, 5 months ago

    Hi @innocentcandles,

    Thanks for reaching out!

    You can try using the Variation Price Display Range for WooCommerce plugin to customise how you want the price ranges to be displayed.

    I hope this helps!

    xue28 (woo-hc)

    (@xue28)

    3 years, 5 months ago

    Hi @innocentcandles

    Thanks for reaching out!

    The problem: I am not able to change the product price to “from £X”, whereby X would be the cheapest item price in a bulk sale (in my example: “from £4”). What I get is the price range (from £5 to £8), distorting the actual pricing.

    Is it possible to change the price to “from £X”, whereby x represents the cheapest price of one item in a bulk sale?

    Can you please share with us a clear screenshot of what you are referring to here exactly so that we could check this further?

    If you don’t already have a screenshot service installed, you can try https://snipboard.io or http://skitch.com/. You can share the direct link to the image as a response to this topic.

    Thread Starter innocentcandles

    (@innocentcandles)

    3 years, 5 months ago

    Thanks so much for your helpful replies!
    I have tried the Variation plugin and got a little closer to what I tried to achieve but it didn’t quite do the trick. However, the plugin woo commerce price title did. It is still a bit of a workaround but works fine at the moment.
    Thanks again!

    anastas10s

    (@anastas10s)

    3 years, 5 months ago

    Hi there @innocentcandles 👋

    However, the plugin woo commerce price title did. It is still a bit of a workaround but works fine at the moment.

    I see. I understand you are referring to the Change Price Title for WooCommerce plugin. Correct?

    I’d suggest looking into the Tiered Pricing Table for WooCommerce plugin, as it appears to perfectly fit your use case.

    Furthermore, I recommend updating the WooCommerce database to the latest version.
    The site’s report currently mentions:
    WC Database Version: 6.6.1

    You can find the “Update Database” button under WooCommerce > Status > Tools.

    I hope that helps!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Changing product prices to “from £x” / bulk buy prices’ is closed to new replies.