find order entries in database

  • Resolved Art

    (@theart8)


    4 years, 2 months ago

    Dear devs,

    I installed the free version of your Woo Delivery plugin and I find it very useful, I am planning to buy the Pro before going live with my website.

    However I did not find in the phpMyAdmin interface any wordpress table of your plugin, so I am unable to extract the order time & date info in order to further process it in a datasheet.

    So I am asking where I can find the data stored of time and date of a woocommerce order made with your plugin?

    Or if you have any other way to export these data.

    thank you

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

    (@shoroar)

    Hello,

    You can easily call the delivery date and time without going to the database.

    just use the following code to get the delivery date and time.

    get_post_meta( $order_id, 'delivery_date', true );
get_post_meta( $order_id, 'delivery_time', true );
    Thread Starter Art

    (@theart8)

    Thank you, sorry for my ignorance. Where precisely do I have to put this code to output the date & time?

    I explain why I need this info. I have to group the orders by the date they are due to and then see how many quantities of products are ordered to be delivered in that particular day. That’s why I was asking how to pull the data in order to put in a Google Sheet and process it.

    But now you are making me think that maybe I can do this on a webpage of my site, making it private.

    BTW, can you also tell me where in the database the date is located? thank you

    Plugin Author coderockz

    (@shoroar)

    Hello,

    The data is saved in the postmeta table.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘find order entries in database’ is closed to new replies.