Options not showing in Cart or on Orders

  • Resolved mikep13

    (@mikep13)


    4 years, 1 month ago

    I’m having a problem getting options to display on the cart page, on order emails or in WC-orders.

    It was working fine, however I was finding out which plugin is best for us to go ahead with in future, and I had both FPF and ‘WooCommerce Custom Product Addons (Free)’ installed alongside and after removing that, and adding customisations via FPF (it’s much better), I think I’ve broken this on a deeper level.

    I created a new product from scratch for testing purposes as I thought there might be a link between having variable products setup with FPF, and me removing them before changing the FPF product fields, might have gotten something stuck somewhere.

    Following on from this theory, I removed the plugin from the WP dashboard, connected via FTP to see that it’d completely gone from [~/public_html/wp-content/plugins], re-added and the same issue was present (and my data was still there).
    I repeated the process of removing it, only this time I dropped into phpMyAdmin to find any remaining traces of it thinking that it might just need completely setting up again from fresh (and my existing data removing), but I couldn’t find anything relating to it in the DB, where would (should) it be [by default]? I think if I can find that, then I might be able to solve this one myself.

    Here’s a screenshot of the currently active plugins (on the staging site [live is different]) – https://i.ibb.co/KVYKq3S/Active-Plugins.png
    (Image is self-deleting after 25th Feb 2021)

    Here’s a login for the staging copy to take a look at the problem.

    User – [email protected]
    Pass – oE$UGryLUw8zzub13l*I*F&n

    I’ve removed all sensitive data and disabled all payment methods, you’ll still be able to view the cart and continue almost to the end of the checkout process though. There’s absolutely no sensitive data remaining in the staging instance, it’s purely there for looking at this problem, so I’m OK with those credentials being live on the internet.

    Frustratingly, I already know I’m after the pro version of this plugin due to needing additional fees for fields and conditional logic, but I loathe to drop the ￡59 on a licence if I can’t get it to work! If you could please help me to get it working, I’d be eternally grateful, and immediately paying for it!

    If a colleague needs access to the live, then I can make that happen, just say the words.

    Thanks in advance!

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Tomasz WP Desk

    (@tomaszwp)

    Hello @mikep13

    The field group definitions are stored in the posts table as fpf_fields. This post type has its additional data in the postmeta table where information about the field name and what can be entered there is contained. The record in postmeta will have the value _fields in the meta_key field and the post ID of the field group in the post_id field.

    Values ??of specific fields are stored in the table wp_woocommerce_order_itemmeta. The values ??are related to a specific product in the order using order_item_id and the definition of a specific meta_id field.

    I hope it helps.

    Thread Starter mikep13

    (@mikep13)

    Thanks for your prompt response @tomaszwp, so an empty wp_woocommerce_order_itemmeta table would almost certainly be a problem, correct?

    If that’s the case, then well I imagine I’ve found the issue – https://i.ibb.co/tCy3yNL/wp-woocommerce-order-itemmeta.png

    Many thanks!

    Thread Starter mikep13

    (@mikep13)

    Would that empty database table be the cause of the problem then, or should I be looking elsewhere?

    I now have the problem on the live site – https://www.oxfordboutiquestudio.com/, currently I have products which are unpublished since I can’t get this working.

    Do I need to go pro to get support for this, @tomaszwp ? I’m happy to do that!

    Thread Starter mikep13

    (@mikep13)

    I’ve gone premium to expidite the support as I really like the product and we’re extremely keen to get it working ASAP :o)

    [email protected], via WPDesk

    Plugin Support Tomasz WP Desk

    (@tomaszwp)

    Hello @mikep13

    Please write to us using this form. We will need more information that I cannot ask here. Use the email address mentioned.
    wpdesk.net/get-support/

    Thread Starter mikep13

    (@mikep13)

    Hi @tomaszwp

    I’ve managed to fix it with a little help from a developer!

    I’m extremely pleased, it was actually my theme not allowing the meta to move through to the cart for some reason (Neve), but after I’d removed all my customisations (reinstalled the theme), it all works well, phew!

    Thanks again for the DB info, that’s how we identified and resolved it!

    Best, Mike.

    Plugin Support Tomasz WP Desk

    (@tomaszwp)

    Hello @mikep13

    I am glad that we helped at least a little.

    I noted the name of the template. We will have our first suspect if there are similar issues in the future.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Options not showing in Cart or on Orders’ is closed to new replies.