justaquestion

still looking for a solution…

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.

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

?

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)

anyone?

anyone?

Mike I don’t want to change the data in the table..
I want to copy it somewhere else (other database)
but I want to copy the full country name not just the code.

My question was if the conversion table exists in WC, as in databse the code is saved but in dashboard I see the whole country name. How does it do the conversion?