{"id":186448,"date":"2021-04-12T15:16:26","date_gmt":"2021-04-12T13:16:26","guid":{"rendered":"https:\/\/guide.jtl-software.com\/restoring-jtl-shop-database-backups\/"},"modified":"2024-03-21T10:19:19","modified_gmt":"2024-03-21T09:19:19","slug":"restoring-jtl-shop-database-backups","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/","title":{"rendered":"Restoring JTL-Shop database backups"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-shop\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-shop\" id=\"restoring-jtl-shop-database-backups\">Restoring JTL-Shop database backups <span id='anchor-restoring-jtl-shop-database-backups' data-href='#restoring-jtl-shop-database-backups' class='far fa-link' data-anchor><\/span><\/h1><div class=\"custom-box\">\n\t<div class=\"d-flex align-items-center mb-4\">\n\t\t\t\t\t\t\t<span class=\"mr-3 fa-stack flex-shrink-0 fa-1x\">\n\t\t\t<span class=\"fas fa-circle fa-stack-2x text-shaftblue\"><\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 fas fa-clipboard-list text-white fa-stack-1x\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\n\t\t<h3 class=\"mb-0 \" id=\"your-task-initial-situation\">Your task\/initial situation <span id='anchor-your-task-initial-situation' data-href='#your-task-initial-situation' class='far fa-link' data-anchor><\/span><\/h3>\t<\/div>\n\t<div class=\"box-content\">\n\t\tYou have created a backup for JTL Shop, for example before an update. Since an error has occurred, you now want to restore the backup.\t<\/div>\n<\/div>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important: <\/b> Please read these instructions beforehand:<span style=\"color: #5cbcf6;\"> <a class=\"JTL-Shop-color\" style=\"color: #5cbcf6;\" title=\"Creating a database backup of JTL-Shop\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\">Creating database backups<\/a><\/span>.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important:<\/b> If you need to import a backup that was created before an update (or attempted update), please note the following: With updates, it often happens that new tables are created. Of course, these did not exist at the time the backup was created and can therefore not be taken into account in the backup! In that case, the very first step before importing a backup is to delete all tables. This means that the database must be empty before the backup is imported. <b>Please note:<\/b> If the same database is also used by other software, for example WordPress, Piwik or others (i.e. no JTL-Shop plug-ins), their tables must of course not be deleted.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"option-1-backup-is-up-to-date\">Option 1: Backup is up to date <span id='anchor-option-1-backup-is-up-to-date' data-href='#option-1-backup-is-up-to-date' class='far fa-link' data-anchor><\/span><\/h2><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note:<\/b> A backup is not necessarily up to date just because it was created recently! Please also read the section \u201cBackup is not up to date\u201d! If the backup has been made according to the description under \u201cCreating database backups\u201d, you do not need to pay attention to anything else.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tNow proceed as described under <span style=\"color: #5cbcf6;\"> <a class=\"JTL-Shop-color\" style=\"color: #5cbcf6;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/#backup-einspielen\">Restoring a backup<\/a><\/span>.<\/li><\/ol><h2 class=\"d-flex align-items-center hl-wawi\" id=\"option-2-backup-is-not-up-to-date\">Option 2: Backup is not up to date <span id='anchor-option-2-backup-is-not-up-to-date' data-href='#option-2-backup-is-not-up-to-date' class='far fa-link' data-anchor><\/span><\/h2>\t<p>If the backup is not up to date, additional steps are necessary. A backup is considered out of date if:<\/p>\n<ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tchanges have been made in the back end since the backup.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\ta synchronisation between JTL-Shop and JTL-Wawi has been carried out after the backup.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tthe maintenance mode was not active after the backup (i.e. when orders could have come in).\t<\/li><\/ul><h3 class=\"d-flex align-items-center hl-wawi\" id=\"changes-in-the-back-end\">Changes in the back end <span id='anchor-changes-in-the-back-end' data-href='#changes-in-the-back-end' class='far fa-link' data-anchor><\/span><\/h3>\t<p>If you have made changes in the back end of JTL-Shop after the backup, proceed as follows:<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tMake all changes that have been made since the time of the backup again after importing the backup.<\/li><li >\n\tDepending on the changes made, check whether further individual measures are required. If you made changes to standard features of JTL-Shop, you are welcome to ask us for help via ticket in the JTL-Customer Centre. For additional features (e.g. plug-ins), please contact the respective developer.<\/li><\/ol><h3 class=\"d-flex align-items-center hl-wawi\" id=\"synchronisation-with-jtl-wawi-after-the-backup\">Synchronisation with JTL-Wawi after the backup <span id='anchor-synchronisation-with-jtl-wawi-after-the-backup' data-href='#synchronisation-with-jtl-wawi-after-the-backup' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Every change in JTL-Wawi and JTL-Shop that is relevant for the other system is automatically reconciled during synchronisation. Once this change has been transmitted, the respective system assumes that the other system knows of the change. If a backup is imported into JTL-Shop that is missing a change that was transmitted via synchronisation, neither JTL-Wawi nor JTL-Wawi can know this.<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note:<\/b> The following steps are based on the assumption that JTL-Shop is still in maintenance mode. If this is not the case, please also note the section \u201cMaintenance mode was not active after backup\u201d before carrying out one of the following steps.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tAll changes to the item master data that have been synchronised after the backup will no longer be available in JTL-Shop after the backup has been restored (the databases are asynchronous).<\/li><\/ol>\t<p>It is therefore possible that items, categories, characteristics, etc. will no longer be up to date. There are two ways to remedy this:<\/p>\n\t<p><b>Option 1 (not recommended, usually only an option for recent backups):<\/b> You know exactly what has been changed and is not up to date. Trigger the synchronisation again manually for these objects.<\/p>\n\t<p><b>Option 2 (recommended):<\/b> Transfer the relevant data to JTL-Shop again using the complete synchronisation.<\/p>\n\t<p>You can, for example, determine that no categories are sent. This is useful when you know that no categories were changed since the backup but are not sure whether changes were made to items or stock levels. You could trigger a synchronisation for everything but categories or for items and nothing else.<\/p>\n\t<p>In most cases, a complete synchronisation will be more appropriate since it also covers data that has been deleted in JTL-Shop. If, for example, you deleted items after the backup was created, then these items will also be back in JTL-Shop again after the backup has been imported.<\/p>\n\t<p>If you know which items you deleted and the inactive items still exist in JTL-Wawi, you can reactivate the items. Afterwards, carry out a complete synchronisation and then deactivate the items again to delete them in JTL-Shop.<\/p>\n\t<p>If the deleted elements no longer exist in JTL-Wawi, it is not possible to delete or deactivate them again in JTL-Shop.<\/p>\n\t<p>In that case, you need to delete all item data in JTL-Shop before the complete synchronisation.<\/p>\n\t<p>Learn how to do this in the following<span style=\"color: #5cbcf6;\"> <a class=\"JTL-Shop-color\" style=\"color: #5cbcf6;\" title=\"Resetting the online shop\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/resetting-the-shop\/\">description<\/a><\/span>.<\/p>\n<ol start=\"2\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tChanges made to customer data and\/or settings such as the payment and shipping status will no longer be available after the restoring the backup. Unfortunately, there is no automated solution. You need to manually update the data.<\/li><\/ol>\t<p><b>Customer data:<\/b> If you know which customer data has been changed, you can click on <span class=\"highlight\">In allen Onlineshops aktualisieren<\/span>\u00a0(Update in all online shops) again in JTL-Wawi (see<span style=\"color: #f68b25;\"> <a class=\"JTL-Wawi-color\" style=\"color: #f68b25;\" title=\"Updating data in online shops\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/customers\/updating-customer-data-in-online-shops\/\">Updating data in online shops<\/a><\/span>) or switch the customer groups back and forth in order to update them and possibly send credit again (see<span style=\"color: #f68b25;\"> <a class=\"JTL-Wawi-color\" style=\"color: #f68b25;\" title=\"Increasing a customer's online shop credit\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/customers\/increasing-credit-for-an-online-shop\/\">Increasing the online shop credit of a customer<\/a><\/span>).<\/p>\n\t<p><b>Order data:<\/b> If you know which orders have been changed, you can use the option <span class=\"highlight\">Bestellung im Webshop aktualisieren<\/span>\u00a0(Update order in online shop).<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note<\/b>: If you update customer or order data in the online shop again in this way, emails may also be sent to the customers again.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"maintenance-mode-was-not-active-after-backup\">Maintenance mode was not active after backup <span id='anchor-maintenance-mode-was-not-active-after-backup' data-href='#maintenance-mode-was-not-active-after-backup' class='far fa-link' data-anchor><\/span><\/h3>\t<p>In this case, it is possible that there were new customer accounts and\/or orders in JTL-Shop that still exist in JTL-Wawi but are no longer present in JTL-Shop. Unfortunately, it is not possible to send orders from JTL-Wawi back to JTL-Shop again.<\/p>\n\t<p>Take the following steps if JTL-Shop was no longer in maintenance mode after the backup:<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note:<\/b> Without these steps, there will be problems with new orders!\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tPut JTL-Shop into maintenance mode. Under no circumstances must customers become active in the online shop before the following steps have been carried out!<\/li><\/ol><h4 class=\"d-flex align-items-center hl-wawi\" id=\"order-ids\">Order IDs <span id='anchor-order-ids' data-href='#order-ids' class='far fa-link' data-anchor><\/span><\/h4>\t<p>The order IDs of JTL-Shop are no longer up to date. In JTL-Wawi, check the most recent order from this online shop for its <span class=\"highlight\">External sales order ID<\/span> (the shop order ID) and compare it to the most current order ID in JTL-Shop under <span class=\"highlight\">Orders<\/span>. The missing IDs (i.e. the missing orders) in between must<\/p>\n<ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\teither be added in the <span class=\"highlight\">View<\/span> menu under <span class=\"highlight\">Standard views &gt; Order process<\/span>&nbsp;in the setting <span class=\"highlight\">Order ID \u2013 start number<\/span>\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tor increased in the database. For this, increase <span class=\"highlight\">nNummer<\/span> under <span class=\"highlight\">nArt=1<\/span> in the table <span class=\"highlight\">tnummern<\/span> by the respective value.\t<\/li><\/ul>\t<p>This ensures that the next order number assigned is consecutive to the last one in JTL-Wawi.<\/p>\n<h4 class=\"d-flex align-items-center hl-wawi\" id=\"internal-counters\">Internal counters <span id='anchor-internal-counters' data-href='#internal-counters' class='far fa-link' data-anchor><\/span><\/h4>\t<p>There are internal counters (database table keys) which are also not up to date and would create a conflict when transferring new orders\/customer accounts to JTL-Wawi. It would also be possible for customer accounts of different customers to become mixed up.<\/p>\n\t<p>These internal counters are automatically updated during the synchronisation. This means that ff you have carried out all other necessary steps, the first synchronisation will increase these internal keys in JTL-Shop accordingly. It is therefore important that at least one synchronisation is carried out before you deactivate the maintenance mode and customers register and\/or order.<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Please note:<\/b> Should there be issues with orders that cannot be sent to JTL-Wawi under <span class=\"highlight\">Onlineshop &gt; Bestellungen<\/span>\u00a0(Online Shop &gt; Orders), please read \u201cOrders cannot be sent\u201d.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"restoring-backups\">Restoring backups <span id='anchor-restoring-backups' data-href='#restoring-backups' class='far fa-link' data-anchor><\/span><\/h2><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note on importing backups of older versions of JTL-Shop:<\/b> If you import a backup of an older shop version, for example the backup of a 5.00 version after an update attempt to 5.01, the update files may still be in the <span class=\"highlight\">update\/migrations<\/span> folder! This would be the case if the backup files were simply transmitted again. The folder should be emptied and only refilled with the original files from the 5.00 backup.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>Otherwise, after importing the older shop database, you will be prompted in the back end to carry out an update to the new database even though its is already the right version. If you carry out the migrations, you end up with a newer database version that does not match the shop files.<\/p>\n\t<p>As a rule, you should leave the import of backups to a system administrator or your hosting provider. Should you nevertheless (have to) import a backup yourself, we will briefly explain your options via phpMyAdmin here.<\/p>\n\t<p>We will not go into detail about phpMyAdmin itself in the description. When in doubt, consult an expert or access training materials available online.<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important information:<\/b> Due to server configuration and script runtimes, large databases can lead to problems when PHPMyAdmin is used, and the backup may not be restored correctly. Please contact your hosting provider to restore the backup in that case! With a database size of more than 200MB, unusable results are to be expected with this method.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tOpen phpMyAdmin and in the <span class=\"highlight\">Databases<\/span> section, select the database for which you want to import a backup.<\/li><li class=\"media-single-line\">\n\tSwitch to the <span class=\"highlight\">Import<\/span> tab.<\/li><li >\n\tWhen importing via phpMyAdmin, there is not too much to consider. Click on <span class=\"highlight\">Browse<\/span> and select the file to be imported from your local hard drive.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note:<\/b> The <span class=\"highlight\">character encoding of the file<\/span> must be the same as the one of the backup. By default, this setting is always set to UTF-8 in phpMyAdmin. This is also the correct setting.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"4\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tKeep the default selections for all other settings and click <span class=\"highlight\">OK<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-phpmyadmin-jtl-shop-5-1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-phpmyadmin-jtl-shop-5-1.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-phpmyadmin-jtl-shop-5-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-phpmyadmin-jtl-shop-5-1-1024x567.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-phpmyadmin-jtl-shop-5-1-768x426.png 640w\" width=\"1366\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"757\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/maintenance-db-recover-backup-phpmyadmin-jtl-shop-5-1.png&quot;,&quot;w&quot;:1366,&quot;h&quot;:757}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<h2 class=\"d-flex align-items-center hl-wawi\" id=\"troubleshooting\">Troubleshooting <span id='anchor-troubleshooting' data-href='#troubleshooting' class='far fa-link' data-anchor><\/span><\/h2><h3 class=\"d-flex align-items-center hl-wawi\" id=\"orders-cannot-be-sent\">Orders cannot be sent <span id='anchor-orders-cannot-be-sent' data-href='#orders-cannot-be-sent' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Sometimes it can happen that orders are not correctly transferred after the backup has been imported and are stuck in JTL-Wawi under <span class=\"highlight\">Onlineshop &gt; Bestellungen<\/span> (Online shop &gt; Orders). The respective error message reads something like:<\/p>\n\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-order-not-transmitted-jtl-shop-5-1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-order-not-transmitted-jtl-shop-5-1.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-order-not-transmitted-jtl-shop-5-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-order-not-transmitted-jtl-shop-5-1.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-recover-backup-order-not-transmitted-jtl-shop-5-1.png 640w\" width=\"585\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"224\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/maintenance-db-recover-backup-order-not-transmitted-jtl-shop-5-1.png&quot;,&quot;w&quot;:585,&quot;h&quot;:224}\" class=\"img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tCheck whether the orders are old or new.<\/li><\/ol>\t<p><b>Old orders:<\/b> Orders with the same customers, line items and order IDs already exist in JTL-Wawi as sales orders.<\/p>\n\t<p><b>Solution before JTL-Wawi 1.3:<\/b> Do not delete these orders under <span class=\"highlight\">Onlineshop &gt; Bestellungen<\/span> (Online shop &gt; Orders). This would also delete them in JTL-Shop.<\/p>\n\t<p>Deleting these twice-sent orders is only possible directly via the JTL-Wawi database. Please contact the JTL-Wawi Support team by opening a ticket.<\/p>\n\t<p><b>Solution as of JTL-Wawi 1.3:<\/b> Select the affected orders and click on the <span class=\"highlight\">L\u00f6schen nur in JTL-Wawi<\/span> (Delete only in JTL-Wawi) button. The orders are now only removed from JTL-Wawi.<\/p>\n\t<p><b>New orders:<\/b> These are orders with other customers, line items and the same or different order IDs.<\/p>\n\t<p>Do not delete these orders under <span class=\"highlight\">Onlineshop &gt; Bestellungen<\/span> (Online shop &gt; Orders). This would also delete them in JTL-Shop. Since they are not saved in JTL-Wawi, they would be gone completely.<\/p>\n\t<p>The correct transfer of these orders is only possible after direct intervention in the databases of JTL-Shop and JTL-Wawi. Please contact the JTL-Shop Support team by opening a ticket.<\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"special-requirements-for-jtl-shop-when-a-backup-is-imported-into-jtl-wawi\">Special requirements for JTL-Shop when a backup is imported into JTL-Wawi <span id='anchor-special-requirements-for-jtl-shop-when-a-backup-is-imported-into-jtl-wawi' data-href='#special-requirements-for-jtl-shop-when-a-backup-is-imported-into-jtl-wawi' class='far fa-link' data-anchor><\/span><\/h3>\t<p>For various reasons it may be necessary to <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\">restore a backup of JTL-Wawi<\/a><\/span>.<\/p>\n\t<p>Basically, there are two possible scenarios. Either the backup is up to date or not up to date.<\/p>\n<h4 class=\"d-flex align-items-center hl-wawi\" id=\"backup-is-up-to-date\">Backup is up to date <span id='anchor-backup-is-up-to-date' data-href='#backup-is-up-to-date' class='far fa-link' data-anchor><\/span><\/h4><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note:<\/b> A backup is not necessarily up to date just because it was created recently. It is important that none of the points listed under \u201cBackup is not up to date\u201d apply.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>If the backup is up to date, nothing further needs to be considered with regard to JTL-Shop.<\/p>\n<h4 class=\"d-flex align-items-center hl-wawi\" id=\"backup-is-not-up-to-date\">Backup is not up to date <span id='anchor-backup-is-not-up-to-date' data-href='#backup-is-not-up-to-date' class='far fa-link' data-anchor><\/span><\/h4>\t<p>If the backup is not up to date, additional steps are necessary. In relation to JTL-Shop, a backup of JTL-Wawi is not considered up to date if JTL-Wawi has been synchronised with JTL-Shop after the backup was created.<\/p>\n\t<p>Please note the following:<\/p>\n\t<p><b>Orders:<\/b> Orders are the most critical factor in that case. In JTL-Wawi, check the most recent order from this shop for its External sales order ID (the shop order ID) and compare it to the most current order ID under <span class=\"highlight\">Orders<\/span> in JTL-Shop. All orders that are missing in JTL-Wawi can be selected here via the check box and then pencilled in for the next synchronisation. This allows you to get the orders back into JTL-Wawi.<\/p>\n<div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important note:<\/b> Of course, the orders arrive back in JTL-Wawi unprocessed. Unfortunately, you have to manually check which of the orders actually still need to be processed in what way and which are in fact already complete. Also be aware that this could result in new emails being sent to customers.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p><b>Item master data:<\/b> If the backup is not up to date, this means that the item master data in JTL-Shop is newer than in JTL-Wawi. However, the data is also asynchronous and JTL-Wawi is in charge. This means that the old data (e.g. item stocks and prices) will overwrite the more current data as soon as it is transferred to the shop. There is only one thing you can do about it: update the data in JTL-Wawi again.<\/p>\n[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"Contents Contents Restoring JTL-Shop database backups Your task\/initial situation You have created a backup for JTL Shop, for example before <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\">[...]<\/a>","protected":false},"author":2,"featured_media":0,"parent":187831,"menu_order":476,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-186448","page","type-page","status-publish","hentry","search_categorie-jtl-shop"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Restoring JTL-Shop database backups &#8211; JTL-Guide<\/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:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restoring JTL-Shop database backups &#8211; JTL-Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T09:19:19+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"21 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\",\"name\":\"Restoring JTL-Shop database backups &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2021-04-12T13:16:26+00:00\",\"dateModified\":\"2024-03-21T09:19:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Shop\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Maintenance\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/wartung\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Restoring JTL-Shop database backups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Restoring JTL-Shop database backups &#8211; JTL-Guide","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:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/","og_locale":"en_US","og_type":"article","og_title":"Restoring JTL-Shop database backups &#8211; JTL-Guide","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/","og_site_name":"JTL-Guide","article_modified_time":"2024-03-21T09:19:19+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"21 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/","name":"Restoring JTL-Shop database backups &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2021-04-12T13:16:26+00:00","dateModified":"2024-03-21T09:19:19+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Shop","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/"},{"@type":"ListItem","position":2,"name":"Maintenance","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/wartung\/"},{"@type":"ListItem","position":3,"name":"Restoring JTL-Shop database backups"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=186448"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186448\/revisions"}],"predecessor-version":[{"id":250147,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186448\/revisions\/250147"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/187831"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=186448"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=186448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}