How to access data?

Hi,

You can see your custom field values by following below steps,

Step 1: Get order_item_ids from wp_woocommerce_order_items table where order_id is your order id.

Step 2: Check your custom field name in wp_woocommerce_order_itemmeta table for the order_item_ids that you got it from Step 1

Thanks,
Support – ThemeHigh

Hi,
ThemeHigh

I already did that.
This gives me the product name, it doesn’t give me the product options that the user selected.

I have a product called “PDAX”
The plugin allows to define Options and Values.
Example:
Option CPU:
values:

A
B
C
D

What I want to get is the option that the user has choosen.
Meaning if he choose A I want to get:
CPU A

https://s31.postimg.org/nrnyzkbgb/image.png
I want to get the information listed under the value column – red/black arrow. Not the name of product (PDAX)

Hi,

The steps provided in my previous message will give you the user choosen value for the custom fields.

I have created a custom select field’cpu’ (name:cpu and label: CPU) with options A,B,C,D. And I choose option ‘B’ when adding the product to cart, and the placed the order. I can see the selected value ‘B’ for the field ‘cpu’ in database using the steps provided in my last comment. Please see the below screens shots for the same,

https://prnt.sc/ax8ccs
https://prnt.sc/ax8bu8

Hi,
I don’t have these fields in wp_woocommerce_order_itemmeta table.
This is the query:
https://s32.postimg.org/ens33p9ol/fff.png
This is what I see in the dashboard. as you can see there are many options selected for this (one) item.
https://s32.postimg.org/gttbocrph/fff2.png

I should also say that this query:
select *
from wp_woocommerce_order_items
where order_id=13225

gives me 2 rows:
order_item_id order_item_name order_item_type order_id
95 PDAX line_item 13225
96 shipping EU shipping 13225

Like I said, it doesn’t show me the options.

still looking for a solution…

Closing this old thread.

Can’t this be added somewhere on the Order page itself, so that when the order comes through we can see it on the order page along with all the other relevant data?

Instead of having to go running SQL queries to bring it up somehow?

And I don’t see any of this stored in the SQL anywhere either, as per your suggestions above.

This plugin just doesn’t seem to work properly or at all.

Hi,
I am having a similiar issue. I have the latest free version, and just started using it. The selection (color of ink in my case) is not showing on any order information and not going to Paypal or shipstation. This is quite inconvenient! Please help! I dont want to buy new update version in case this doesnt work.
n