Query orders in database

MetalMario

30 Mar, 2013 01:42 AM

Hi, i’m looking to create an XML containing all the orders of my customers in Jigoshop. How can i easily write a query to do the job? Is there a native function that i can use? Thank you very much.

P.S. I’ll format the XML on my own, i just need an easy way to fetch orders.

  1. Support Staff 2 Posted by chriscct7 on 30 Mar, 2013 02:26 PM

    chriscct7's Avatar

    You can just use the wp_query to grab all the postmeta from posttype of “order”

    -Chris

  2. 3 Posted by MetalMario on 30 Mar, 2013 02:44 PM

    Perfect, looking into the database i noticed that all order’s information is kept inside an unique attribute. Is there a fast way to “parse” the postmeta?

  3. Support Staff 4 Posted by chriscct7 on 30 Mar, 2013 03:13 PM

    chriscct7's Avatar

    http://codex.wordpress.org/Class_Reference/WP_Query

    Use Post type= orders and it should return all of htem

Reply to this discussion

Internal reply

Formatting help or Preview

Attached Files

You can attach files up to 10MB

If you don’t have an account yet, we need to confirm you’re human and not a machine trying to post spam.