• Resolved zhuzh1

    (@zhuzh1)


    I looked into the order data in woocommerce’s order_itemmeta table.

    For each order item, there are a few lines for taxes which look like this:

    meta_id order_item_id meta_key meta_value
    ——- ————- ————– ————
    9 1 _line_tax_data a:2:{s:5:”total”;a:1:{i:1;s:8:”0.659188″;}s:8:”subtotal”;a:1:{i:1;s:8:”0.659188″;}}

    Here is a screenshot of mysql console: https://drive.google.com/file/d/1IFn5cadMkPLvi1es94gfKwzQp9ZYFma-/

    Question: how should I interpret the meta_value field? Is there any documentation for this?

    Thanks

    John Z

Viewing 1 replies (of 1 total)
  • Thread Starter zhuzh1

    (@zhuzh1)

    I think this is how to read it:

    a:2 means an array of 2 elements
    s:5 means a string of 5-char
    i:1 means an integer of 1-digit

    so on and so forth

Viewing 1 replies (of 1 total)
  • The topic ‘What does this mean?’ is closed to new replies.