Orders with size variations are sold at incorrect prices

  • Resolved doug262

    (@doug262)


    5 years, 9 months ago

    I’m a woodworker and sell difference size pieces of wood with WooCommerce. Product variations are listed in inches. A customer ordered a 4″ diameter circle priced at $9.50. However, when I received the order, the size came in (on the order page that WooCommerce emailed to me, AND on the WooCommerce order page) as 4\” but sold for $6.75, which is the price for the 2.5″ diameter instead!

    On May 25th, another customer order a different type of wood (1/2″ oak circles) and the order came in as 3\” but sold for the price for a 2.5″ diameter.

    I do not have any sales price reductions on these items. They are all listed as enabled. I do not use inventory stock management.

    Obviously, I’m losing money with this issue. And what is the \” backslash in the order’s variation size? It is not in the attributes, variations, nor the diameter options that customers see and select.

    I have compared all the product settings in these 2 orders with a prior successful order, and the only thing that appeared different is that in the PDF packing slip, neither of these 2 orders had the product’s SKU listed, while on the successful order, the SKU was listed. All these products have SKU’s set-up in product’s variatons pages and each size has a different SKU.

    So it seems that WooCommerce is not placing a correct order for the size that the customer ordered, but is substituting the lowest priced size instead! This is a serious issue! Unacceptable!

    I recently did a WooCommerce database update, as recommended by WooCommerce, thinking that would fix this problem that occurred on May 6th. Apparently it didn’t, since it happened again on May 25th.

    Mac Safari web browser, iOS 10.14.4, MacMini late 2012, WooCommerce version 3.6.4, default storefront.

    Can anyone help with this?

    Thanks in advance!
    Doug

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

Viewing 13 replies - 1 through 13 (of 13 total)
  • Stef

    (@serafinnyc)

    Hi Doug,

    Can you please post a system report for us? Goto woocommerce > status > get system report and paste that here.

    If you could also post a screenshot of that one variable product that would be great too. Use something like snag.gy or imgur to post that.

    Thanks

    Thread Starter doug262

    (@doug262)

    Thanks Stef.

    ### WordPress Environment ###

    WordPress address (URL): https://actioncraftworks.com
    Site address (URL): https://actioncraftworks.com
    WC Version: 3.6.4
    Log Directory Writable: ?
    WP Version: 5.2.1
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 5.6.39 – We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 128 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 4000
    cURL Version: 7.45.0
    OpenSSL/1.0.1e

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.2.12-MariaDB-log
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 3.6.4
    WC Database Prefix: wpb8_
    MaxMind GeoIP Database: ?
    Total Database Size: 12.91MB
    Database Data Size: 10.88MB
    Database Index Size: 2.03MB
    wpb8_woocommerce_sessions: Data: 1.37MB + Index: 0.08MB
    wpb8_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_order_itemmeta: Data: 0.08MB + Index: 0.02MB
    wpb8_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wpb8_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wpb8_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wpb8_commentmeta: Data: 0.00MB + Index: 0.01MB
    wpb8_comments: Data: 0.02MB + Index: 0.02MB
    wpb8_failed_jobs: Data: 0.00MB + Index: 0.00MB
    wpb8_links: Data: 0.00MB + Index: 0.00MB
    wpb8_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    wpb8_options: Data: 2.08MB + Index: 0.12MB
    wpb8_postmeta: Data: 1.53MB + Index: 0.81MB
    wpb8_posts: Data: 1.62MB + Index: 0.13MB
    wpb8_queue: Data: 0.00MB + Index: 0.00MB
    wpb8_termmeta: Data: 0.02MB + Index: 0.02MB
    wpb8_terms: Data: 0.01MB + Index: 0.04MB
    wpb8_term_relationships: Data: 0.03MB + Index: 0.08MB
    wpb8_term_taxonomy: Data: 0.01MB + Index: 0.02MB
    wpb8_usermeta: Data: 0.01MB + Index: 0.02MB
    wpb8_users: Data: 0.00MB + Index: 0.01MB
    wpb8_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB
    wpb8_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wpb8_wc_product_meta_lookup: Data: 0.02MB + Index: 0.04MB
    wpb8_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wpb8_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB
    wpb8_wfBlocks7: Data: 0.01MB + Index: 0.00MB
    wpb8_wfConfig: Data: 1.28MB + Index: 0.02MB
    wpb8_wfCrawlers: Data: 0.00MB + Index: 0.00MB
    wpb8_wfFileChanges: Data: 0.00MB + Index: 0.00MB
    wpb8_wfFileMods: Data: 1.20MB + Index: 0.25MB
    wpb8_wfHits: Data: 0.65MB + Index: 0.13MB
    wpb8_wfHoover: Data: 0.00MB + Index: 0.00MB
    wpb8_wfIssues: Data: 0.00MB + Index: 0.01MB
    wpb8_wfKnownFileList: Data: 0.60MB + Index: 0.08MB
    wpb8_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB
    wpb8_wfLocs: Data: 0.00MB + Index: 0.00MB
    wpb8_wfLogins: Data: 0.12MB + Index: 0.03MB
    wpb8_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB
    wpb8_wfls_settings: Data: 0.02MB + Index: 0.00MB
    wpb8_wfNotifications: Data: 0.01MB + Index: 0.00MB
    wpb8_wfPendingIssues: Data: 0.00MB + Index: 0.00MB
    wpb8_wfReverseCache: Data: 0.00MB + Index: 0.00MB
    wpb8_wfSNIPCache: Data: 0.00MB + Index: 0.00MB
    wpb8_wfStatus: Data: 0.15MB + Index: 0.06MB
    wpb8_wfTrafficRates: Data: 0.00MB + Index: 0.00MB
    wpb8_wpforms_lite: Data: 0.02MB + Index: 0.00MB

    ### Post Type Counts ###

    amn_wpforms-lite: 1
    attachment: 203
    jetpack_migration: 2
    jp_img_sitemap: 1
    jp_sitemap: 1
    jp_sitemap_master: 1
    jp_vid_sitemap: 1
    nav_menu_item: 11
    page: 14
    post: 2
    product: 61
    product_variation: 411
    revision: 137
    scheduled-action: 19
    shop_coupon: 3
    shop_order: 19
    wpforms: 1

    ### Security ###

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

    ### Active Plugins (16) ###

    Share Buttons by AddThis: by The AddThis Team – 6.2.3
    BoldGrid Backup: by BoldGrid – 1.9.3
    BoldGrid Easy SEO: by BoldGrid – 1.6.2
    FedEx WooCommerce Shipping with Print Label: by PluginHive – 4.2.1
    Jetpack by WordPress.com: by Automattic – 7.3.1
    Limit Login Attempts Reloaded: by WPChef – 2.8.1
    Lockdown WP Admin: by Sean Fisher – 2.3.2
    Mailchimp for WooCommerce: by Mailchimp – 2.1.15 – Not tested with the active version of WooCommerce
    Post and Page Builder: by BoldGrid – 1.10.3
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.14
    WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.2.12
    WooCommerce Product Fees: by Caleb Burks – 1.3.0 – Not tested with the active version of WooCommerce
    WooCommerce Services: by Automattic – 1.20.0
    WooCommerce: by Automattic – 3.6.4
    Wordfence Security: by Wordfence – 7.3.2
    WPForms Lite: by WPForms – 1.5.2.3

    ### Inactive Plugins (1) ###

    Akismet Anti-Spam: by Automattic – 4.1.2

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    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: ?

    ### WC Pages ###

    Shop base: #32 – /shop/
    Cart: #33 – /cart/
    Checkout: #34 – /checkout/
    My account: #35 – /my-account/
    Terms and conditions: #276 – /terms-and-conditions/

    ### Theme ###

    Name: Storefront
    Version: 2.5.0
    Author URL: https://woocommerce.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: –

    ### Action Scheduler ###

    Complete: 18
    Oldest: 2019-05-01 10:54:20 -0700
    Newest: 2019-05-22 11:16:16 -0700

    Pending: 1
    Oldest: 2019-05-29 11:16:16 -0700
    Newest: 2019-05-29 11:16:16 -0700

    Canceled: 0
    Oldest: –
    Newest: –

    In-progress: 0
    Oldest: –
    Newest: –

    Failed: 0
    Oldest: –
    Newest: –

    `

    Thread Starter doug262

    (@doug262)

    Thanks Stef. I posted the system report and it is being held by for review by a moderator…screenshots coming soon…

    Stef

    (@serafinnyc)

    You’re welcome. I’ll get it approved now.

    Hi I have being testing this a bit… this is my finding:

    If I click the Add to Cart, it add it to the cart on the correct price but if I click the PayPal it will pop up a window and give me a message that if PayPal is not launching to “Click to Continue”… after I do then I find the product added to the cart with the incorrect price… Whatever you are using for that paypal button… there is the cause of your problem.

    Thread Starter doug262

    (@doug262)

    Here is the screen shot. Below it is just FedEx settings which should be irrelevant.

    https://snag.gy/t7JxiS.jpg

    Thread Starter doug262

    (@doug262)

    webmasterhouston, you are correct! Somehow, PayPal is showing the price for the smallest variation instead! Thank-you for discovering that. Now to find out why and fix it…I’m using WooCommerce Payal Checkout Payment Gateway, version 1.6.14 that was last updated 3 weeks ago…

    Thread Starter doug262

    (@doug262)

    Thank-you so much webmasterhouston for testing and finding that the Paypal button was causing this issue. I really appreciate it!

    I’ve checked all the settings in the WooCommerce Paypal plugin and everything seems to match the help files, but the issue still exists. So I’ve reposted in the Woocommerce Paypal forum at https://www.ads-software.com/support/topic/paypal-checkout-is-changing-customers-variation-and-price/

    Stef

    (@serafinnyc)

    If this is truly the cause why don’t you try using the built in PayPal to WC? Why use the plugin?

    Thread Starter doug262

    (@doug262)

    Good question. I’m trying to remember what’s the difference and found these:

    PayPal Standard takes customers from your site to PayPal’s secure site to finish paying for their order.

    An integrated payment gateway connects to your eCommerce website via the gateway’s provided API. The biggest advantage of this is that customers never have to leave your store to input payment information and submit orders — it’s a smooth, seamless experience.

    However, since the gateway is currently not working properly, reverting back to the standard is an option. I wish it would work properly again, for the benefit of customers.

    Stef

    (@serafinnyc)

    True. I love using that too but if I have a flat tire I’m going to use the spare ??

    Hi @doug262,

    I’ll close this thread since per https://www.ads-software.com/support/topic/paypal-checkout-is-changing-customers-variation-and-price you’ll create a ticket with us where we can look into the issue further.

    You are welcome.

    I have being considering to install this paypal option as you have it, for one of my costumers… Now there is something I need to be aware off, before I do…

    This kind of problems can potentially add up to thousands per month.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Orders with size variations are sold at incorrect prices’ is closed to new replies.