Export Taxonomy & Custom field Issue

I’m trying to export order details to a json because i need to reuse this data in another tool, but there are a problem to export estimation delivery date, i tried many times with many tools to find this value and its key but its not there its not sent with the data. please check this json code and the screen shot…

{
  "id": 29637,
  "parent_id": 0,
  "status": "processing",
  "currency": "AED",
  "version": "9.7.1",
  "prices_include_tax": false,
  "date_created": "2025-03-22T20:53:21",
  "date_modified": "2025-03-22T20:53:22",
  "discount_total": "0.00",
  "discount_tax": "0.00",
  "shipping_total": "30.00",
  "shipping_tax": "0.00",
  "cart_tax": "0.00",
  "total": "240.00",
  "total_tax": "0.00",
  "customer_id": 1,
  "order_key": "wc_order_2AflvvzSj4lAG",
  "billing": {
    "first_name": "Mostafa",
    "last_name": "Roro",
    "company": "",
    "address_1": "- Al - Dubai - United Arab Emirates",
    "address_2": "",
    "city": "Dubai",
    "state": "Dubai",
    "postcode": "",
    "country": "AE",
    "email": "**********",
    "phone": "777777"
  },
  "shipping": {
    "first_name": "Mostafa",
    "last_name": "Roro",
    "company": "",
    "address_1": "- Al - Dubai - United Arab Emirates",
    "address_2": "",
    "city": "Dubai",
    "state": "Dubai",
    "postcode": "",
    "country": "AE",
    "phone": ""
  },
  "payment_method": "cod",
  "payment_method_title": "Cash on delivery",
  "transaction_id": "",
  "customer_ip_address": "*********",
  "created_via": "checkout",
  "customer_note": "",
  "date_completed": null,
  "date_paid": null,
  "cart_hash": "*******",
  "number": "29637",
  "meta_data": [
    {
      "id": 355,
      "key": "_lpac_places_autocomplete",
      "value": "0"
    },
    {
      "id": 365,
      "key": "_wc_order_attribution_device_type",
      "value": "Desktop"
    },
    {
      "id": 357,
      "key": "_wc_order_attribution_referrer",
      "value": "https://www.google.com/"
    },
    {
      "id": 363,
      "key": "_wc_order_attribution_session_count",
      "value": "88"
    },
    {
      "id": 360,
      "key": "_wc_order_attribution_session_entry",
      "value": "https://krtag.com/product/demo-product-two/"
    },
    {
      "id": 362,
      "key": "_wc_order_attribution_session_pages",
      "value": "8"
    },
    {
      "id": 361,
      "key": "_wc_order_attribution_session_start_time",
      "value": "2025-02-15 00:21:49"
    },
    {
      "id": 356,
      "key": "_wc_order_attribution_source_type",
      "value": "organic"
    },
    {
      "id": 359,
      "key": "_wc_order_attribution_utm_medium",
      "value": "organic"
    },
    {
      "id": 358,
      "key": "_wc_order_attribution_utm_source",
      "value": "google"
    },
    {
      "id": 349,
      "key": "is_vat_exempt",
      "value": "no"
    },
    {
      "id": 353,
      "key": "lpac_latitude",
      "value": "11.7769873"
    },
    {
      "id": 354,
      "key": "lpac_longitude",
      "value": "22.967393"
    },
    {
      "id": 350,
      "key": "wpml_language",
      "value": "en"
    }
  ],
  "line_items": [
    {
      "id": 44,
      "name": "High Waist Skinny Jean",
      "product_id": 29608,
      "variation_id": 29609,
      "quantity": 1,
      "tax_class": "",
      "subtotal": "210.00",
      "subtotal_tax": "0.00",
      "total": "210.00",
      "total_tax": "0.00",
      "taxes": [],
      "meta_data": [
        {
          "id": 367,
          "key": "pa_color",
          "value": "blueberry",
          "display_key": "Color",
          "display_value": "Blueberry"
        },
        {
          "id": 368,
          "key": "pa_size",
          "value": "s",
          "display_key": "Size",
          "display_value": "S"
        }
      ],
      "sku": "SK54321",
      "price": 210,
      "image": {
        "id": 29589,
        "src": "https://krtag.com/wp-content/uploads/2025/03/1.jpg"
      },
      "parent_name": "High Waist Skinny Jean"
    }
  ],
  "tax_lines": [],
  "shipping_lines": [
    {
      "id": 45,
      "method_title": "Flat rate",
      "method_id": "flat_rate",
      "instance_id": "2",
      "total": "30.00",
      "total_tax": "0.00",
      "taxes": [],
      "tax_status": "taxable",
      "meta_data": [
        {
          "id": 374,
          "key": "Items",
          "value": "High Waist Skinny Jean - Blueberry, S × 1",
          "display_key": "Items",
          "display_value": "High Waist Skinny Jean - Blueberry, S × 1"
        }
      ]
    }
  ],
  "fee_lines": [],
  "coupon_lines": [],
  "refunds": [],
  "payment_url": "https://krtag.com/checkout/order-pay/29637/?pay_for_order=true&key=wc_order_2AflvvzSj4lAG",
  "is_editable": false,
  "needs_payment": false,
  "needs_processing": true,
  "date_created_gmt": "2025-03-22T20:53:21",
  "date_modified_gmt": "2025-03-22T20:53:22",
  "date_completed_gmt": null,
  "date_paid_gmt": null,
  "currency_symbol": "د.إ",
  "_links": {
    "self": [
      {
        "href": "https://krtag.com/wp-json/wc/v3/orders/29637",
        "targetHints": {
          "allow": [
            "GET",
            "POST",
            "PUT",
            "PATCH",
            "DELETE"
          ]
        }
      }
    ],
    "collection": [
      {
        "href": "https://krtag.com/wp-json/wc/v3/orders"
      }
    ],
    "customer": [
      {
        "href": "https://krtag.com/wp-json/wc/v3/customers/1"
      }
    ]
  }
}

Attachments:

You must be logged in to view attached files.

Hi m.rehab,

Thanks for reaching to us and appreciate your patience.

I’ve passed this topic to one of our developers, and I will let you know once get an answer.

Thanks for your patience.

Best Regards,

Hi m.rehab,

Please let me know how did you generate the JSONs?

Best Regards,

I have created a rest api in to my wocomerce and i grapped this info details with this api by postman tool

Hello, still no updates regarding my issue ??

Hi m.rehab,

Thanks for details.

Having checked this in more detail, we see that unfortunately it is not possible to add this field to JSON.

Regards,

Ok at least it should be saved in database but its not there anywhere also , so if i need to use this data key and its value what shall i do ??
All delivery dates plugins can attach the value to the json file and also add this value in the database , but your plugin it is not possible so what is the benefit of using it ?

Hi m.rehab,

This functionality is intended for users to understand when they can receive their goods. There is no need to store this information in the product meta data, since this value is dynamic and changes relative to the rules that are set for the same for this or that delivery zone. But you can figure out how this functionality works by looking at the code in this file inc/integrations/woocommerce/modules/estimate-delivery/class-frontend.php

Regards,

[Author]

Posts