Schritt 2: <\/strong>Kopieren Sie den unten stehenden Code und f\u00fcgen Sie ihn in Ihre neu erstellte Datei ein.<\/p>\n\n\n\n Schritt 3: <\/strong>Nun m\u00fcssen Sie die Datei ausf\u00fchren, indem Sie sie \u00fcber eine URL \u00f6ffnen. Zum Beispiel https:\/\/localhost\/whitespaceSku.php<\/p>\n\n\n\n Schritt 4: <\/strong>Nachdem Sie die URL aufgerufen haben, sehen Sie ein Formular wie in der folgenden Abbildung.<\/p>\n\n\n\n Schritt 5: <\/strong>Klicken Sie dann auf die Schaltfl\u00e4che Trimmen. Dadurch wird der Leerraum aus der SKU entfernt. Ich empfehle, jeweils 100 Produkte zu trimmen, nicht mehr als 100.<\/p>\n\n\n\n Schritt 6: <\/strong>\u00dcberpr\u00fcfen Sie abschlie\u00dfend Ihre SKU im Backend. Zum Beispiel: Wenn Ihr Produkt SKU ist \u201eentfernen Leerzeichen\u201c<\/strong> nach getrimmt sku wird \u201eremovewhitespace\u201c.<\/strong><\/p>\n\n\n\n Bitte kontaktieren Sie uns unter manish@bay20.com<\/a><\/strong> oder rufen Sie uns unter +91-8800519180<\/a><\/strong> an, wenn Sie Unterst\u00fctzung f\u00fcr Magento 2 ben\u00f6tigen. Sie k\u00f6nnen auch die Magento2-Entwicklungsseite<\/strong><\/a> <\/strong>besuchen, um die von uns angebotenen Dienstleistungen zu \u00fcberpr\u00fcfen.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" We are going to remove white space from SKU using script. First we have to create a new file on the root path of your Magento 2 site. Like \u2018whitespaceSku.php\u2019<\/p>\n","protected":false},"author":27,"featured_media":9177,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[77,79],"tags":[],"class_list":["post-9166","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento2","category-magento-anleitung"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts\/9166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/comments?post=9166"}],"version-history":[{"count":17,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts\/9166\/revisions"}],"predecessor-version":[{"id":17253,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/posts\/9166\/revisions\/17253"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/media\/9177"}],"wp:attachment":[{"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/media?parent=9166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/categories?post=9166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bay20.com\/de\/wp-json\/wp\/v2\/tags?post=9166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<!DOCTYPE unspecified PUBLIC \"-\/\/W3C\/\/DTD HTML 4.01 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/html4\/loose.dtd\">\n<?php\nuse Magento\\Framework\\App\\Bootstrap;\n\nrequire __DIR__ . '\/app\/bootstrap.php';\n$params = $_SERVER;\n$bootstrap = Bootstrap::create(BP, $params);\n$objectManager = $bootstrap->getObjectManager();\n$state = $objectManager->get('Magento\\Framework\\App\\State');\n$state->setAreaCode('global');\n?>\n<html>\n<head>\n <title>Trim Product SKU<\/title>\n<\/head>\n<body>\n <h1>Trim Product SKU<\/h1>\n <div class=\"main-div\">\n <form action=\"\" method=\"post\">\n <table>\n <tr>\n <td>\n <label><?php echo \"Product from\";?><\/label>\n <td>\n <input type=\"text\" name=\"from\" id=\"from\" value=\"<?php echo (isset($_POST['from']))?$_POST['from']:\"\" ?>\"\/>\n <label class=\"suggestion-from\">Product From<\/label>\n <\/td>\n <\/tr>\n <tr>\n <td>\n <label><?php echo \"Product to\";?><\/label>\n <td>\n <input type=\"text\" name=\"to\" id=\"to\" value=\"<?php echo (isset($_POST['to']))?$_POST['to']:\"\" ?>\"\/>\n <label class=\"suggestion-from\">Product To<\/label>\n <\/td>\n <\/tr>\n <tr><\/tr>\n <tr>\n <td colspan=\"2\"><input class=\"search-button\" type=\"submit\" title=\"Trim\" value=\"Trim\"\/>\n <\/td>\n <\/tr>\n <\/table>\n <\/form>\n <\/div>\n<\/body>\n<\/html> \n<?php \nif($_POST){\n $from = $_POST['from'];\n $to = $_POST['to'];\n echo \"<table border='1' class='result-table'><thead><tr><td colspan='3'>Import Data<\/td><\/tr><\/thead><tbody><tr><td>Product Id<\/td><td>Trimmed SKU<\/td><\/tr>\";\n trimSKU($from, $to);\n echo \"<\/tbody><\/table>\";\n}\n\nfunction trimSKU($from, $to){\n $objectManager = \\Magento\\Framework\\App\\ObjectManager::getInstance();\n $productCollection = $objectManager->create('Magento\\Catalog\\Model\\ResourceModel\\Product\\CollectionFactory');\n $collection = $productCollection->create()\n ->addAttributeToSelect('*')\n ->addAttributeToFilter('entity_id',\n array(\n 'from'=>$from,\n 'to'=>$to\n ))\n ->load();\n $i = 0;\n foreach($collection as $product){\n $i++;\n if($i > $to || $i < $from) { continue; };\n $arr_string=explode(\" \", $product->getSku());\n $string='';\n foreach($arr_string as $str){\n $string.=$str;\n }\n $sku=$string;\n\n if($product->getId()){\n $product->setSku($sku)->save();\n echo \"<tr><td>\". $product->getId().\"<\/td><td>\".$product->getSKU().\"<\/td><\/tr>\";\n }\n } \n }\n\n?><\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/www.bay20.com\/wp-content\/uploads\/2021\/08\/image.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.bay20.com\/wp-content\/uploads\/2021\/08\/image-2.png\")
<\/figure>\n\n\n\n