{"id":188350,"date":"2021-03-05T10:21:30","date_gmt":"2021-03-05T09:21:30","guid":{"rendered":"https:\/\/guide.jtl-software.com\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/"},"modified":"2024-04-04T11:47:48","modified_gmt":"2024-04-04T09:47:48","slug":"transferring-customer-data-from-shopware","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/","title":{"rendered":"Transferring customer data from Shopware"},"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=\"transferring-customer-data-from-shopware\">Transferring customer data from Shopware <span id='anchor-transferring-customer-data-from-shopware' data-href='#transferring-customer-data-from-shopware' class='far fa-link' data-anchor><\/span><\/h1><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<strong>Hinweis:<\/strong> Bitte beachten Sie die allgemeinen Hinweise zum Kundendatenimport:<span style=\"color: #5cbcf6;\"> <a class=\"JTL-Shop-color\" style=\"color: #5cbcf6;\" title=\"Kunden in JTL-Shop importieren\" href=\"https:\/\/guide.jtl-software.com\/jtl-shop\/jtl-shop-kauf-editionen\/kunden-in-jtl-shop-importieren\/\">Kundenimport<\/a><\/span>\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>If you want to migrate the data records of your customers from your Shopware shop to JTL-Shop, you must carry out the following steps:<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tExport of customer data as CSV file from Shopware<\/li><li class=\"media-single-line\">\n\tConversion of CSV file into a format readable by JTL-Shop<\/li><li class=\"media-single-line\">\n\tImport of CSV file into JTL-Shop<\/li><\/ol>\t<p>In the following, we will go through the individual steps.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"step-1-exporting-customer-data-from-shopware-as-a-csv-file\">Step 1: Exporting customer data from Shopware as a CSV file <span id='anchor-step-1-exporting-customer-data-from-shopware-as-a-csv-file' data-href='#step-1-exporting-customer-data-from-shopware-as-a-csv-file' 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-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<strong>Please note:<\/strong> The following instructions refer to Shopware 5. The current version of Shopware&#8217;s own documentation can be found under <a href=\"https:\/\/docs.shopware.com\/en\/shopware-5-en\/import-export\/import-export-customers?category=shopware-5-en\/import-export\"  target='_blank' rel='noopener noreferrer' rel=\"noopener\">Import\/Export of Customers in Shopware<\/a>.\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\tLog in to the Shopware admin section with your access data.<\/li><li class=\"media-single-line\">\n\tOpen the <span class=\"highlight\">Import\/Export<\/span> menu item in the <span class=\"highlight\">Content<\/span> menu.<\/li><li class=\"media-single-line\">\n\tIf necessary, install the <span class=\"highlight\">Import\/export plug-in<\/span> via the next window.<\/li><li class=\"media-single-line\">\n\tIn the next window, go to the <span class=\"highlight\">Export tab<\/span>, select <span class=\"highlight\">CSV<\/span> as the<span class=\"highlight\">\u00a0export format<\/span> and <span class=\"highlight\">default_customers<\/span> as the profile.<\/li><li class=\"media-single-line\">\n\tStart the export.<\/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\/import-customer-data-from-shopware-for-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\/import-customer-data-from-shopware-for-jtl-shop-5-1-1024x621.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/import-customer-data-from-shopware-for-jtl-shop-5-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/import-customer-data-from-shopware-for-jtl-shop-5-1-1024x621.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/import-customer-data-from-shopware-for-jtl-shop-5-1-768x465.png 640w\" width=\"1024\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"621\" alt=\"Exporting customer data as a CSV from the Shopware back end\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/import-customer-data-from-shopware-for-jtl-shop-5-1.png&quot;,&quot;w&quot;:1269,&quot;h&quot;:769}\" 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\t<p>You will now receive a CSV file containing your Shopware customer data.<\/p>\n<h2 class=\"d-flex align-items-center\" id=\"step-2-converting-the-csv-file-into-a-format-readable-by-jtl-shop\">Step 2: Converting the CSV file into a format readable by JTL-Shop <span id='anchor-step-2-converting-the-csv-file-into-a-format-readable-by-jtl-shop' data-href='#step-2-converting-the-csv-file-into-a-format-readable-by-jtl-shop' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tOpen the CSV file in an editor, e.g. Microsoft Excel.<\/li><li >\n\tReplace the column headings using the following table to get the correct formats for JTL-Shop.<\/li><\/ol>[vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true, &#8220;bg-#{value}&#8220;: &#8220;rysywhite&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div class=\"pt-2\">\n\t<p style=\"text-align: center;\"><strong>Old name (Shopware)<\/strong><\/p>\n<\/div>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;bg-#{value}&#8220;: &#8220;rysywhite&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div class=\"pt-2\">\n\t<p style=\"text-align: center;\"><strong>New name (JTL shop)<\/strong><\/p>\n<\/div>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>email<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cMail<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>md5_password<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cPasswort<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_company<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cFirma<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_salutation<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cAnrede (please note step 3)<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_firstname<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cVorname<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_lastname<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cNachname<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_street<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cStrasse (please note step 4)<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_zipcode<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cPLZ<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_city<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cOrt<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>phone<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cTel<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>fax<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cFax<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_additional_address_line1<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cAdressZusatz<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_countryID<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cLand<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>billing_stateID<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cBundesland<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-left&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>ustid<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cUSTID<\/p>\n[\/vc_column_inner][\/vc_row_inner][vc_row_inner min_height=&#8221;{&#8220;min_height&#8220;: &#8220;&#8220;, &#8220;min_height-xs&#8220;: &#8220;&#8220;, &#8220;min_height-sm&#8220;: &#8220;&#8220;, &#8220;min_height-md&#8220;: &#8220;&#8220;, &#8220;min_height-lg&#8220;: &#8220;&#8220;, &#8220;min_height-xl&#8220;: &#8220;&#8220;}&#8221; utilities=&#8221;{&#8220;pt&#8220;: &#8220;0&#8220;, &#8220;pb&#8220;: &#8220;0&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][vc_column_inner responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; width=&#8221;1\/2&#8243; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-bottom&#8220;: true, &#8220;border-left&#8220;: true, &#8220;mb&#8220;: &#8220;5&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>newsletter<\/p>\n[\/vc_column_inner][vc_column_inner width=&#8221;1\/2&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;6&#8220;}&#8221; utilities=&#8221;{&#8220;border-#{value}&#8220;: &#8220;defaultgray&#8220;, &#8220;border-w&#8220;: &#8220;2&#8220;, &#8220;border-top&#8220;: true, &#8220;border-right&#8220;: true, &#8220;border-bottom&#8220;: true, &#8220;mb&#8220;: &#8220;5&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]\t<p>cNewsletter<\/p>\n[\/vc_column_inner][\/vc_row_inner]<ol start=\"3\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tPerform a search\/replace action for the column \u201ccAnrede\u201d (or billing_salutation in Shopware). Replace \u201cmr\u201d with \u201cm\u201d and \u201cms\u201d with \u201cw\u201d.<\/li><li >\n\tInsert the column \u201ccHausnummer\u201d after the column \u201ccStrasse\u201d. Copy the house numbers from \u201ccStrasse\u201d to \u201ccHausnummer\u201d.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\t\t<span class=\"mt-1 mr-3 fa-stack flex-shrink-0 fa-1x columnsize-fa-2x\">\n\t\t<span class=\"far fa-circle fa-stack-2x text-shop\"><\/span>\n\t\n\t\t<span class=\"fas fa-cog text-shop fa-stack-1x\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\tDazu k\u00f6nnen Sie zum Beispiel die Funktion \u201eTextkonvertierungs-Assistent\u201c von Excel verwenden. Dort geben Sie als Trennzeichen das Leerzeichen ein. Beachten Sie bei diesem Automatismus jedoch bitte, dass manche Stra\u00dfennamen aus mehr als einem Wort bestehen (z. B. Berliner Platz, Auf dem Damm usw.). Um ein \u00dcberschreiben sp\u00e4terer Zeilen zu vermeiden sollten Sie also lieber noch 2 bis 3 weitere leere Spalten hinter cHausnummer einf\u00fcgen und anschlie\u00dfend manuell alle Eintr\u00e4ge korrigieren, die Stra\u00dfennamen aus mehreren W\u00f6rtern beinhalten.\r\n\r\n<strong><span style=\"color: #5cbcf6;\">Alternative:<\/span><\/strong> Ggf. funktioniert f\u00fcr Sie auch dieser alternative Weg, den uns ein Benutzer vorgeschlagen hat: Markieren Sie die Stra\u00dfennamen und suchen Sie nach \u201e 1\u201c (Leerzeichen1) und ersetzen Sie den Ausdruck durch \u201e;1\u201c. Gehen Sie so f\u00fcr alle Nummern von 1 bis 9 vor. So umgehen Sie das Problem der Stra\u00dfennamen, die aus mehreren W\u00f6rtern bestehen.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"5\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tDelete all columns whose names you did not replace.<\/li><li class=\"media-single-line\">\n\tSave the CSV file.<\/li><\/ol><h2 class=\"d-flex align-items-center\" id=\"step-3-importing-the-csv-file-into-jtl-shop\">Step 3: Importing the CSV file into JTL-Shop <span id='anchor-step-3-importing-the-csv-file-into-jtl-shop' data-href='#step-3-importing-the-csv-file-into-jtl-shop' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tIn the back end of JTL-Shop, go to <span class=\"highlight\">Administration &gt; Import &gt; Customers<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img sizes=\"(max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" data-pswp=\"[]\" 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<ol start=\"2\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tSelect your file under <span class=\"highlight\">CSV file with customer data<\/span>.<\/li><li class=\"media-single-line\">\n\tClick on <span class=\"highlight\">Import<\/span>.<\/li><\/ol>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"Contents Contents Transferring customer data from Shopware Hinweis: Bitte beachten Sie die allgemeinen Hinweise zum Kundendatenimport: Kundenimport If you want <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/\">[...]<\/a>","protected":false},"author":2,"featured_media":0,"parent":187912,"menu_order":735,"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-188350","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Transferring customer data from Shopware &#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\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transferring customer data from Shopware &#8211; JTL-Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-04T09:47:48+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=\"15 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\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/\",\"name\":\"Transferring customer data from Shopware &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2021-03-05T09:21:30+00:00\",\"dateModified\":\"2024-04-04T09:47:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Shop\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JTL-Shop\/Fee-based editions\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Transferring customer data from Shopware\"}]},{\"@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":"Transferring customer data from Shopware &#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\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/","og_locale":"en_US","og_type":"article","og_title":"Transferring customer data from Shopware &#8211; JTL-Guide","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/","og_site_name":"JTL-Guide","article_modified_time":"2024-04-04T09:47:48+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/","name":"Transferring customer data from Shopware &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2021-03-05T09:21:30+00:00","dateModified":"2024-04-04T09:47:48+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/transferring-customer-data-from-shopware\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Shop","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/"},{"@type":"ListItem","position":2,"name":"JTL-Shop\/Fee-based editions","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/"},{"@type":"ListItem","position":3,"name":"Transferring customer data from Shopware"}]},{"@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\/188350","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=188350"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/188350\/revisions"}],"predecessor-version":[{"id":252043,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/188350\/revisions\/252043"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/187912"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=188350"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=188350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}