{"id":19236,"date":"2022-11-05T23:00:48","date_gmt":"2022-11-05T17:30:48","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/"},"modified":"2022-11-05T23:00:48","modified_gmt":"2022-11-05T17:30:48","slug":"solved-get-woocommerce-last-order-id-from-database-using-php","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/","title":{"rendered":"[Solved] Get Woocommerce last order id from database using php"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

It seems that you would like to get the next usable POST ID<\/strong> (Order Id)<\/em>, to save it, for example, as new Order in database with some related data. <\/p>\n

This is absolutely not the way<\/strong> to do it and you need to think it different<\/strong>… Now you can use one of the 3 following ways:<\/p>\n

    \n
  1. \n

    Using the WordPress<\/strong> dedicated function wp_insert_post()<\/code> that returns the post ID (Order ID).<\/p>\n<\/li>\n

  2. \n

    Using the Woocommerce<\/strong> dedicated function wc_create_order()<\/code> that returns the WC_Order<\/code> Object.<\/p>\n

    Then from the the order object, you can get the order ID using $order->get_id()<\/code>.<\/p>\n<\/li>\n

  3. \n

    Using the Woocommerce<\/strong> empty WC_Order<\/code> object instance and the save()<\/code> method:<\/p>\n

    \/\/ Get an empty instance of the `WC_Order` Object\n$order = new WC_Order();\n\n\/\/ Save the order to the database\n$order->save();\n\n\/\/ Get the Order ID\n$order_id = $order->get_id();\n<\/code><\/pre>\n<\/li>\n<\/ol>\n
    \n
    Addition<\/strong> – Get the last Order ID in Woocommerce:<\/p>\n
    To get and display the last order ID in woocommerce use a WC_Order_Query<\/code><\/a> in this two simple line:<\/p>\n
    <?php\n    $last_order_id = wc_get_orders(array('limit' => 1, 'return' => 'ids')); \/\/ Get last Order ID (array)\n    echo (string) reset($last_order_id); \/\/ Displaying last order ID\n?>\n<\/code><\/pre>\n
    Tested and works<\/p>\n<\/p><\/div>\n
    <\/div>\n<\/div>\n
                <\/span> <\/p><\/div>\n<\/div>\n
    [ad_2]<\/p>\n
    solved Get Woocommerce last order id from database using php <\/p>\n","protected":false},"excerpt":{"rendered":"
    [ad_1] It seems that you would like to get the next usable POST ID (Order Id), to save it, for example, as new Order in database with some related data. This is absolutely not the way to do it and you need to think it different… Now you can use one of the 3 following … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[546,4594,339,1302,597],"class_list":["post-19236","post","type-post","status-publish","format-standard","hentry","category-solved","tag-database","tag-orders","tag-php","tag-woocommerce","tag-wordpress"],"yoast_head":"\n[Solved] Get Woocommerce last order id from database using php - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Get Woocommerce last order id from database using php - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] It seems that you would like to get the next usable POST ID (Order Id), to save it, for example, as new Order in database with some related data. This is absolutely not the way to do it and you need to think it different… Now you can use one of the 3 following ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-05T17:30:48+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Get Woocommerce last order id from database using php\",\"datePublished\":\"2022-11-05T17:30:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\"},\"wordCount\":148,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"database\",\"orders\",\"php\",\"woocommerce\",\"wordpress\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\",\"name\":\"[Solved] Get Woocommerce last order id from database using php - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-05T17:30:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Get Woocommerce last order id from database using php\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Get Woocommerce last order id from database using php - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Get Woocommerce last order id from database using php - JassWeb","og_description":"[ad_1] It seems that you would like to get the next usable POST ID (Order Id), to save it, for example, as new Order in database with some related data. This is absolutely not the way to do it and you need to think it different… Now you can use one of the 3 following ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/","og_site_name":"JassWeb","article_published_time":"2022-11-05T17:30:48+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Get Woocommerce last order id from database using php","datePublished":"2022-11-05T17:30:48+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/"},"wordCount":148,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["database","orders","php","woocommerce","wordpress"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/","url":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/","name":"[Solved] Get Woocommerce last order id from database using php - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-05T17:30:48+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-get-woocommerce-last-order-id-from-database-using-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Get Woocommerce last order id from database using php"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/19236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=19236"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/19236\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=19236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=19236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=19236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}