Support » Plugin: Order Export & Order Import for WooCommerce » About your plug-in export / import “_order_items” in “wp_postmeta”

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author webtoffee

    (@webtoffee)

    Hi @xikitstore,

    1) Currently, there is no column named “_order_items” in our CSV export file or wp_postmeta of the database.
    2) Regarding “In the design of WooCommerce, please tell me why they are duplicated on the database”, Maybe you need to check this with Woocommerce.
    3) As we are not aware of the _order_item you have mentioned, it is difficult for us to explain.
    4) Our way of exporting/importing the order details is different because we handle the order items and their metadata in a single column named line_item for simplicity.

    Please let us know if any query.

    Thank you very much.
    I understood your words.

    I was wrong.
    “_Order_items” of “wp_postmeta” is a field created by other software instead of WooCommerce.

    I guess your plugin imports and exports “wp_woocommerce_order_items” and “wp_woocommerce_order_itemmeta”.

    I want to rewrite data easily using your plug-in.
    Please tell me the detailed specification of “Iine_item”.
    The back of “Iine_item” is complicated.
    For example, I think that this part is written with the price and the tax amount, but there are other letters and numbers and it is complicated.

    total:8000.00|sub_total:8000.00|tax:640.00|tax_data:a:2:{s:5:”total”;a:1:{i:0;s:3:”640″;}s:8:”subtotal”;a:1:{i:0;s:3:”640″;}}

    Plugin Author webtoffee

    (@webtoffee)

    Hi @xikitstore,

    You may please just provide the ordered item details and tax data in the line_item column. It is not necessary to provide the data that comes after the tax details. You can import item details to the order by just providing the basic details like item name, product id, SKU, quantity, total, and the tax data.
    Eg:name:Shirt|product_id:|sku:B1|quantity:1|total:7.00|sub_total:7.00|tax:0.00

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.