{"id":15,"date":"2026-05-11T05:33:35","date_gmt":"2026-05-11T05:33:35","guid":{"rendered":"https:\/\/software.codepusher.dk\/?p=15"},"modified":"2026-05-11T06:11:54","modified_gmt":"2026-05-11T06:11:54","slug":"woocommerce-order-sql-merge","status":"publish","type":"post","link":"https:\/\/software.codepusher.dk\/index.php\/2026\/05\/11\/woocommerce-order-sql-merge\/","title":{"rendered":"WooCommerce Order SQL Merge"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Intro<\/h2>\n\n\n\n<p>WooCommerce Order SQL Merge er et avanceret WordPress-plugin udviklet til sikker eksport og import af WooCommerce-ordrer \u2013 uden at \u00e6ndre de originale ordre-ID\u2019er.<\/p>\n\n\n\n<p>Pluginet er udviklet til situationer hvor man arbejder med:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>staging\/dev-sites<\/li>\n\n\n\n<li>redesign af webshop<\/li>\n\n\n\n<li>migrering mellem servere<\/li>\n\n\n\n<li>kloning af WooCommerce-butikker<\/li>\n\n\n\n<li>udvikling p\u00e5 testmilj\u00f8er<\/li>\n\n\n\n<li>synkronisering af ordrer mellem to installationer<\/li>\n<\/ul>\n\n\n\n<p>Normale WooCommerce import\/export plugins opretter typisk nye ordrer med nye ordre-ID\u2019er. Dette plugin arbejder derimod direkte med SQL-data, s\u00e5 eksisterende ordre-ID\u2019er bevares korrekt.<\/p>\n\n\n\n<p>Det g\u00f8r pluginet s\u00e6rligt velegnet til shops som arbejder med:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>e-conomic<\/li>\n\n\n\n<li>Dinero<\/li>\n\n\n\n<li>Billy<\/li>\n\n\n\n<li>ERP\/integrationssystemer<\/li>\n\n\n\n<li>fragtintegrationer<\/li>\n\n\n\n<li>regnskabssystemer<\/li>\n\n\n\n<li>eksterne ordreflows<\/li>\n<\/ul>\n\n\n\n<p>\u2026hvor ordre-ID\u2019er er kritiske.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"589\" src=\"https:\/\/software.codepusher.dk\/wp-content\/uploads\/2026\/05\/Skaermbillede-fra-2026-05-11-07-43-26-1024x589.png\" alt=\"\" class=\"wp-image-34\" srcset=\"https:\/\/software.codepusher.dk\/wp-content\/uploads\/2026\/05\/Skaermbillede-fra-2026-05-11-07-43-26-980x563.png 980w, https:\/\/software.codepusher.dk\/wp-content\/uploads\/2026\/05\/Skaermbillede-fra-2026-05-11-07-43-26-480x276.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Funktioner<\/h2>\n\n\n\n<p>Pluginet indeholder blandt andet:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Eksport af WooCommerce-ordrer<\/li>\n\n\n\n<li>Direkte SQL-import af ordrer<\/li>\n\n\n\n<li>Bevaring af originale ordre-ID\u2019er<\/li>\n\n\n\n<li>HPOS-underst\u00f8ttelse<\/li>\n\n\n\n<li>Dry-run funktion<\/li>\n\n\n\n<li>Konfliktdetektering<\/li>\n\n\n\n<li>Automatisk rollback ved fejl<\/li>\n\n\n\n<li>Reparation af ordrelinjer<\/li>\n\n\n\n<li>Konfliktanalyse af wp_posts IDs<\/li>\n\n\n\n<li>Frig\u00f8relse af konflikter p\u00e5 staging-sites<\/li>\n\n\n\n<li>Ordre-sammenligning mellem to shops<\/li>\n\n\n\n<li>Import af manglende ordrer<\/li>\n\n\n\n<li>Beskyttelse mod dubletter<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Brugervejledning<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">1. Installer pluginet<\/h2>\n\n\n\n<p>Installer pluginet p\u00e5 begge WordPress\/WooCommerce installationer:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Live webshop<\/li>\n\n\n\n<li>Staging\/test webshop<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">2. Eksport\u00e9r ordrer<\/h2>\n\n\n\n<p>P\u00e5 live-webshoppen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>G\u00e5 til:<br>WooCommerce \u2192 QKI Order SQL Merge<\/li>\n\n\n\n<li>V\u00e6lg:<br>\u201cExport Orders\u201d<\/li>\n\n\n\n<li>Download eksportfilen<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">3. Import\u00e9r p\u00e5 staging<\/h2>\n\n\n\n<p>P\u00e5 staging-webshoppen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>G\u00e5 til:<br>WooCommerce \u2192 QKI Order SQL Merge<\/li>\n\n\n\n<li>Upload eksportfilen<\/li>\n\n\n\n<li>Start altid med:<br>\u201cDry-run\u201d<\/li>\n<\/ul>\n\n\n\n<p>Pluginet analyserer nu:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ordre-konflikter<\/li>\n\n\n\n<li>manglende data<\/li>\n\n\n\n<li>eksisterende IDs<\/li>\n\n\n\n<li>HPOS-data<\/li>\n\n\n\n<li>ordrelinjer<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">4. L\u00f8s eventuelle konflikter<\/h2>\n\n\n\n<p>Hvis pluginet finder konflikter, kan du:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>rense eksisterende testordrer<\/li>\n\n\n\n<li>frig\u00f8re auto-genererede WordPress IDs<\/li>\n\n\n\n<li>slette revisions\/changesets<\/li>\n\n\n\n<li>analysere konflikter direkte i admin<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">5. K\u00f8r den rigtige import<\/h2>\n\n\n\n<p>N\u00e5r dry-run viser gr\u00f8nt lys:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>sl\u00e5 Dry-run fra<\/li>\n\n\n\n<li>start importen<\/li>\n<\/ul>\n\n\n\n<p>Pluginet vil nu:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>importere ordrer<\/li>\n\n\n\n<li>bevare originale ordre-ID\u2019er<\/li>\n\n\n\n<li>importere ordrelinjer<\/li>\n\n\n\n<li>opdatere WooCommerce lookup-tabeller<\/li>\n\n\n\n<li>underst\u00f8tte HPOS<\/li>\n\n\n\n<li>rollbacke automatisk ved fejl<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Intro WooCommerce Order SQL Merge er et avanceret WordPress-plugin udviklet til sikker eksport og import af WooCommerce-ordrer \u2013 uden at \u00e6ndre de originale ordre-ID\u2019er. Pluginet er udviklet til situationer hvor man arbejder med: Normale WooCommerce import\/export plugins opretter typisk nye ordrer med nye ordre-ID\u2019er. Dette plugin arbejder derimod direkte med SQL-data, s\u00e5 eksisterende ordre-ID\u2019er bevares [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[22,23,21,19,20],"class_list":["post-15","post","type-post","status-publish","format-standard","hentry","category-plugin","tag-migrering","tag-ordre","tag-sql","tag-woocommerce","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/posts\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":4,"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":35,"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/posts\/15\/revisions\/35"}],"wp:attachment":[{"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/software.codepusher.dk\/index.php\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}