Modified Shop auf UTF-8 migrieren

Dieser Artikel zeigt, wie sich ein bestehender Modified Shop auf UTF-8 in nur 4 Schritten migrieren lässt. In einem anderen Beitrag habe ich bereits beschrieben, wie ihr von einem alten Shop in einer 1.x Version auf die aktuellste Version migrieren könnt.

In meinem Fall kam zu der allgemeinen Migration hinzu, dass der alte Shop schlecht konfiguriert war, was seit jeher zu Anzeigefehlern geführt hat und zusätzlich auch Fehlerhafte Einträge in der Datenbank verursacht hat.

Wenn wir die Sprache in einem Shop richtig Einstellen wollen, müssen wir drei Punkte betrachten:

  1. Welche Kodierung zeige ich meinem User an?
  2. Welche Kodierung verwendet das Shopsystem um mit der Datenbank zu sprechen?
  3. Welche Kodierung ist auf der Datenbank eingestellt?

Um das neue System nun einheitlich zu bekommen und alte Einträge soweit dies noch möglich ist in die neue Kodierung zu überführen werde ich im folgenden verschiedene Skripte verwenden deren Herkunft im Artikel auch verlinkt ist. Diese sind zum Teil Modified Shop spezifisch, zum Teil lassen sie sich auch für ganz andere Projekte verwenden.

Modified Shop Datenbank in UTF-8 konvertieren

Nachdem die Daten aus der alten Datenbank emigriert waren, beginnt die Konvertierung der Datenbank und der darin enthaltenen Einträge in UTF-8.

Datenbank Tabellen auf UTF-8 umstellen

Zunächst werden alle Tabellen der Datenbank in UTF-8 umgewandelt. Dazu habe ich das Skript aus diesem Beitrag verwendet. Dieses Skript ist Modified Shop spezifisch und müsste für die allgemeine Verwendung umgeschrieben werden.

<?php
include 'includes/application_top.php';

//BOC set all tables to collation utf8_general_ci and convert contents to utf8, noRiddle
$query = xtc_db_query("SHOW TABLES");
while ($result = xtc_db_fetch_array($query)) {
    foreach ($result as $key => $table) {
        if(xtc_db_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci")) {
            echo $key . ' &raquo; ' . $table . ': - converted to UTF-8 and collation utf8_general_ci <br />';
        } else {
            echo $key . ' &raquo; ' . $table . ': - conversion to UTF-8 and collation utf8_general_ci failed <br />';
        }
    }
}
//EOC set all tables to collation utf8_general_ci and convert contents to utf8, noRiddle
?>
ables_in_MeineDatenbank » address_book: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » address_format: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » admin_access: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » banktransfer: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » banktransfer_blz: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » banners: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » banners_history: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » campaigns: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » campaigns_ip: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » categories: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » categories_description: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » cm_file_flags: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » configuration: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » configuration_group: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » content_manager: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » counter: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » counter_history: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » countries: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » coupon_email_track: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » coupon_gv_customer: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » coupon_gv_queue: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » coupon_redeem_track: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » coupons: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » coupons_description: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » currencies: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_basket: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_basket_attributes: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_info: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_ip: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_memo: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_status: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » customers_status_history: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » database_version: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_adminsession: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_einstellungen: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_martikel: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_mbestellpos: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_mkategorie: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_mvariation: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_mvariationswert: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_sentorders: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » eazysales_sync: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » geo_zones: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » languages: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » manufacturers: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » manufacturers_info: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » media_content: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » module_newsletter: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » newsletter_recipients: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » newsletters: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » newsletters_history: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_products: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_products_attributes: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_products_download: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_recalculate: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_status: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_status_history: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » orders_total: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » payment_moneybookers: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » payment_moneybookers_countries: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » payment_moneybookers_currencies: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » paypal: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » paypal_status_history: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » personal_offers_by_customers_status_0: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » personal_offers_by_customers_status_1: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » personal_offers_by_customers_status_2: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » personal_offers_by_customers_status_3: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_attributes: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_attributes_download: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_content: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_description: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_graduated_prices: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_images: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_notifications: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_options: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_options_values: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_options_values_to_products_options: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_to_categories: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_vpe: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_xsell: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » products_xsell_grp_name: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » reviews: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » reviews_description: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » sessions: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » shipping_status: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » shop_configuration: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » specials: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » tax_class: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » tax_rates: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » whos_online: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » zones: - converted to UTF-8 and collation utf8_general_ci
Tables_in_MeineDatenbank » zones_to_geo_zones: - converted to UTF-8 and collation utf8_general_ci

Umlaute in UTF-8 konvertieren

Nachdem die Tabellen umgestellt sind, würden wir auf der Oberfläche des Shops noch etliche Fehler sehen, nämlich überall dort, wo Umlaute auftauchen.

Daher lassen wir ein Skript über die Daten Laufen und alle Umlaute ersetzen, welche noch in den einzelnen Einträgen der Datenbank stecken. Dazu verwenden wir das folgende Skript von GitHub: https://gist.github.com/CodeBrauer/99f8b268892d54a55e27dc21d1bb3f63

<?php  
/**  
* Alle kaputten Umlaute reparieren bei Umstellung von ISO->UTF8  
* Source: http://xhtmlforum.de/66480-kleines-skript-alle-umlaute-der-datenbank.html 
*  
* @project        -  
* @author        Boris Bojic <[email protected]>  
* @copyright    Copyright (c) 2011, Boris Bojic (DevShack)  
* @version        Fri, 23 Dec 2011 13:47:11 +0100  
* @updated        -  
*  
*/  

// === [ Content / Charset ] ==============================================  
header('Content-Type: text/html; charset=utf-8');  

// PHP auch explizit auf UTF-8 setzen  
mb_internal_encoding('UTF-8');  

$db = array();  

$db['host']     = "localhost";
$db['uname']    = "";
$db['password'] = "";
$db['database'] = "";



$dbconnect = ($GLOBALS["___mysqli_ston"] = mysqli_connect($db['host'],  $db['uname'],  $db['password'])) or die ("Konnte keine Verbindung zur Datenbank aufnehmen!");  
mysqli_select_db($dbconnect, $db['database']) or die ("Fehler beim Auswählen der Datenbank!");  

((bool)mysqli_set_charset($GLOBALS["___mysqli_ston"], "utf8"));  


echo '<pre>';  


function getTables($db){  

    $result = mysqli_query($GLOBALS["___mysqli_ston"], "SHOW TABLES FROM " . $db['database']);  

    while($row = mysqli_fetch_row($result)){  
        $res[] = $row[0];  
    }  

    return $res;  

}  

function getColumns($table){  

    $table = mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $table);  

    $mysqlres = mysqli_query($GLOBALS["___mysqli_ston"], "SHOW COLUMNS FROM " . $table);  
    while($row = mysqli_fetch_row($mysqlres)){  
        $res[] = $row[0];  
    }  

    return $res;  
}  

// Alle Tabellen ermitteln  
$tablesArray = getTables($db);  

// Alle Spalten pro Tabelle ermitteln und durcharbeiten  
foreach($tablesArray AS $table){  

    $affectedRows = 0;  
    $spalten = getColumns($table);  

    echo "Tabelle: " . $table . "<br />";  


    foreach($spalten AS $spalte){  

        echo "...Spalte: " . $spalte . "<br />";  

        $query = '  
        UPDATE `' . $table . '` SET  
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ü", "ü"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ä", "ä"), 
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ö", "ö"), 
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ö", "Ö"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ß", "ß"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ã ", "à"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"á", "á"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"â", "â"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ã", "ã"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ù", "ù"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ú", "ú"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"û", "û"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ù", "Ù"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ú", "Ú"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Û", "Û"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ãœ", "Ü"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ò", "ò"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ó", "ó"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ô", "ô"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"è", "è"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"é", "é"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ê", "ê"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ë", "ë"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"À", "À"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Â", "Â"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Â","Ã"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ä", "Ä"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ã…", "Å"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ç", "Ç"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"È", "È"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"É", "É"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ê", "Ê"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ë", "Ë"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ÃŒ", "Ì"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ÃŽ", "Î"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ñ", "Ñ"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ã’", "Ò"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ó", "Ó"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ô", "Ô"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Õ", "Õ"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ø", "Ø"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"Ã¥", "å"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"æ", "æ"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ç", "ç"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ì", "ì"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"í" , "í"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"î", "î"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ï", "ï"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ð", "ð"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ñ", "ñ"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"õ", "õ"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ø", "ø"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ý", "ý"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"ÿ", "ÿ"),
        `' . $spalte . '` = REPLACE(`' . $spalte . '`,"€","€") 
        ';  

        mysqli_query($GLOBALS["___mysqli_ston"], $query) OR die(mysqli_error($GLOBALS["___mysqli_ston"]) . $query);  
        $affectedRows += mysqli_affected_rows($GLOBALS["___mysqli_ston"]);  

    }  


    echo "Tabelle " . $table . " aktualisiert, Datensätze: " . $affectedRows . "<br /><br />";  

}

Der Output wenn das Skript aufgerufen wird sieht wie folgt aus:

Tabelle: address_book
...Spalte: address_book_id
...Spalte: customers_id
...Spalte: entry_gender
...Spalte: entry_company
...Spalte: entry_firstname
...Spalte: entry_lastname
...Spalte: entry_street_address
...Spalte: entry_suburb
...Spalte: entry_postcode
...Spalte: entry_city
...Spalte: entry_state
...Spalte: entry_country_id
...Spalte: entry_zone_id
...Spalte: address_date_added
...Spalte: address_last_modified
...Spalte: address_class
Tabelle address_book aktualisiert, Datensätze: 19

Tabelle: address_format
...Spalte: address_format_id
...Spalte: address_format
...Spalte: address_summary
Tabelle address_format aktualisiert, Datensätze: 0

Tabelle: admin_access
...Spalte: customers_id
...Spalte: configuration
...Spalte: modules
...Spalte: countries
...Spalte: currencies
...Spalte: zones
...Spalte: geo_zones
...Spalte: tax_classes
...Spalte: tax_rates
...Spalte: accounting
...Spalte: backup
...Spalte: cache
...Spalte: server_info
...Spalte: whos_online
...Spalte: languages
...Spalte: define_language
...Spalte: orders_status
...Spalte: shipping_status
...Spalte: module_export
...Spalte: customers
...Spalte: create_account
...Spalte: customers_status
...Spalte: customers_group
...Spalte: orders
...Spalte: campaigns
...Spalte: print_packingslip
...Spalte: print_order
...Spalte: popup_memo
...Spalte: coupon_admin
...Spalte: listproducts
...Spalte: listcategories
...Spalte: gv_queue
...Spalte: gv_mail
...Spalte: gv_sent
...Spalte: validproducts
...Spalte: validcategories
...Spalte: mail
...Spalte: categories
...Spalte: new_attributes
...Spalte: products_attributes
...Spalte: manufacturers
...Spalte: reviews
...Spalte: specials
...Spalte: products_expected
...Spalte: stats_products_expected
...Spalte: stats_products_viewed
...Spalte: stats_products_purchased
...Spalte: stats_customers
...Spalte: stats_sales_report
...Spalte: stats_campaigns
...Spalte: banner_manager
...Spalte: banner_statistics
...Spalte: module_newsletter
...Spalte: start
...Spalte: content_manager
...Spalte: content_preview
...Spalte: credits
...Spalte: blacklist
...Spalte: orders_edit
...Spalte: popup_image
...Spalte: csv_backend
...Spalte: products_vpe
...Spalte: cross_sell_groups
...Spalte: fck_wrapper
...Spalte: econda
...Spalte: cleverreach
...Spalte: sofortueberweisung_install
...Spalte: shop_offline
...Spalte: xajax
...Spalte: blz_update
...Spalte: removeoldpics
...Spalte: janolaw
...Spalte: haendlerbund
...Spalte: safeterms
...Spalte: easymarketing
...Spalte: it_recht_kanzlei
...Spalte: payone_config
...Spalte: payone_logs
...Spalte: backup_db
...Spalte: paypal
...Spalte: module_paypal_install
Tabelle admin_access aktualisiert, Datensätze: 0

Tabelle: banktransfer
...Spalte: orders_id
...Spalte: banktransfer_owner
...Spalte: banktransfer_number
...Spalte: banktransfer_bankname
...Spalte: banktransfer_blz
...Spalte: banktransfer_iban
...Spalte: banktransfer_bic
...Spalte: banktransfer_status
...Spalte: banktransfer_prz
...Spalte: banktransfer_fax
...Spalte: banktransfer_owner_email
Tabelle banktransfer aktualisiert, Datensätze: 0

Tabelle: banktransfer_blz
...Spalte: blz
...Spalte: bankname
...Spalte: prz
Tabelle banktransfer_blz aktualisiert, Datensätze: 0

Tabelle: banners
...Spalte: banners_id
...Spalte: banners_title
...Spalte: banners_url
...Spalte: banners_image
...Spalte: banners_group
...Spalte: banners_html_text
...Spalte: expires_impressions
...Spalte: expires_date
...Spalte: date_scheduled
...Spalte: date_added
...Spalte: date_status_change
...Spalte: status
Tabelle banners aktualisiert, Datensätze: 1

Tabelle: banners_history
...Spalte: banners_history_id
...Spalte: banners_id
...Spalte: banners_shown
...Spalte: banners_clicked
...Spalte: banners_history_date
Tabelle banners_history aktualisiert, Datensätze: 0

Tabelle: campaigns
...Spalte: campaigns_id
...Spalte: campaigns_name
...Spalte: campaigns_refID
...Spalte: campaigns_leads
...Spalte: date_added
...Spalte: last_modified
Tabelle campaigns aktualisiert, Datensätze: 0

Tabelle: campaigns_ip
...Spalte: user_ip
...Spalte: time
...Spalte: campaign
Tabelle campaigns_ip aktualisiert, Datensätze: 0

Tabelle: categories
...Spalte: categories_id
...Spalte: categories_image
...Spalte: parent_id
...Spalte: categories_status
...Spalte: categories_template
...Spalte: group_permission_0
...Spalte: group_permission_1
...Spalte: group_permission_2
...Spalte: group_permission_3
...Spalte: listing_template
...Spalte: sort_order
...Spalte: products_sorting
...Spalte: products_sorting2
...Spalte: date_added
...Spalte: last_modified
Tabelle categories aktualisiert, Datensätze: 0

Tabelle: categories_description
...Spalte: categories_id
...Spalte: language_id
...Spalte: categories_name
...Spalte: categories_heading_title
...Spalte: categories_description
...Spalte: categories_meta_title
...Spalte: categories_meta_description
...Spalte: categories_meta_keywords
Tabelle categories_description aktualisiert, Datensätze: 2

Tabelle: cm_file_flags
...Spalte: file_flag
...Spalte: file_flag_name
Tabelle cm_file_flags aktualisiert, Datensätze: 0

Tabelle: configuration
...Spalte: configuration_id
...Spalte: configuration_key
...Spalte: configuration_value
...Spalte: configuration_group_id
...Spalte: sort_order
...Spalte: last_modified
...Spalte: date_added
...Spalte: use_function
...Spalte: set_function
Tabelle configuration aktualisiert, Datensätze: 0

Tabelle: configuration_group
...Spalte: configuration_group_id
...Spalte: configuration_group_title
...Spalte: configuration_group_description
...Spalte: sort_order
...Spalte: visible
Tabelle configuration_group aktualisiert, Datensätze: 0

Tabelle: content_manager
...Spalte: content_id
...Spalte: categories_id
...Spalte: parent_id
...Spalte: group_ids
...Spalte: languages_id
...Spalte: content_title
...Spalte: content_heading
...Spalte: content_text
...Spalte: sort_order
...Spalte: file_flag
...Spalte: content_file
...Spalte: content_status
...Spalte: content_group
...Spalte: content_delete
...Spalte: content_meta_title
...Spalte: content_meta_description
...Spalte: content_meta_keywords
Tabelle content_manager aktualisiert, Datensätze: 3

Tabelle: counter
...Spalte: startdate
...Spalte: counter
Tabelle counter aktualisiert, Datensätze: 0

Tabelle: counter_history
...Spalte: month
...Spalte: counter
Tabelle counter_history aktualisiert, Datensätze: 0

Tabelle: countries
...Spalte: countries_id
...Spalte: countries_name
...Spalte: countries_iso_code_2
...Spalte: countries_iso_code_3
...Spalte: address_format_id
...Spalte: status
Tabelle countries aktualisiert, Datensätze: 0

Tabelle: coupon_email_track
...Spalte: unique_id
...Spalte: coupon_id
...Spalte: customer_id_sent
...Spalte: sent_firstname
...Spalte: sent_lastname
...Spalte: emailed_to
...Spalte: date_sent
Tabelle coupon_email_track aktualisiert, Datensätze: 0

Tabelle: coupon_gv_customer
...Spalte: customer_id
...Spalte: amount
Tabelle coupon_gv_customer aktualisiert, Datensätze: 0

Tabelle: coupon_gv_queue
...Spalte: unique_id
...Spalte: customer_id
...Spalte: order_id
...Spalte: amount
...Spalte: date_created
...Spalte: ipaddr
...Spalte: release_flag
Tabelle coupon_gv_queue aktualisiert, Datensätze: 0

Tabelle: coupon_redeem_track
...Spalte: unique_id
...Spalte: coupon_id
...Spalte: customer_id
...Spalte: redeem_date
...Spalte: redeem_ip
...Spalte: order_id
Tabelle coupon_redeem_track aktualisiert, Datensätze: 0

Tabelle: coupons
...Spalte: coupon_id
...Spalte: coupon_type
...Spalte: coupon_code
...Spalte: coupon_amount
...Spalte: coupon_minimum_order
...Spalte: coupon_start_date
...Spalte: coupon_expire_date
...Spalte: uses_per_coupon
...Spalte: uses_per_user
...Spalte: restrict_to_products
...Spalte: restrict_to_categories
...Spalte: restrict_to_customers
...Spalte: coupon_active
...Spalte: date_created
...Spalte: date_modified
Tabelle coupons aktualisiert, Datensätze: 0

Tabelle: coupons_description
...Spalte: coupon_id
...Spalte: language_id
...Spalte: coupon_name
...Spalte: coupon_description
Tabelle coupons_description aktualisiert, Datensätze: 0

Tabelle: currencies
...Spalte: currencies_id
...Spalte: title
...Spalte: code
...Spalte: symbol_left
...Spalte: symbol_right
...Spalte: decimal_point
...Spalte: thousands_point
...Spalte: decimal_places
...Spalte: value
...Spalte: last_updated
Tabelle currencies aktualisiert, Datensätze: 0

Tabelle: customers
...Spalte: customers_id
...Spalte: customers_cid
...Spalte: customers_vat_id
...Spalte: customers_vat_id_status
...Spalte: customers_warning
...Spalte: customers_status
...Spalte: customers_gender
...Spalte: customers_firstname
...Spalte: customers_lastname
...Spalte: customers_dob
...Spalte: customers_email_address
...Spalte: customers_default_address_id
...Spalte: customers_telephone
...Spalte: customers_fax
...Spalte: customers_password
...Spalte: customers_newsletter
...Spalte: customers_newsletter_mode
...Spalte: member_flag
...Spalte: delete_user
...Spalte: account_type
...Spalte: password_request_key
...Spalte: payment_unallowed
...Spalte: shipping_unallowed
...Spalte: refferers_id
...Spalte: customers_date_added
...Spalte: customers_last_modified
Tabelle customers aktualisiert, Datensätze: 6

Tabelle: customers_basket
...Spalte: customers_basket_id
...Spalte: customers_id
...Spalte: products_id
...Spalte: customers_basket_quantity
...Spalte: final_price
...Spalte: customers_basket_date_added
Tabelle customers_basket aktualisiert, Datensätze: 0

Tabelle: customers_basket_attributes
...Spalte: customers_basket_attributes_id
...Spalte: customers_id
...Spalte: products_id
...Spalte: products_options_id
...Spalte: products_options_value_id
Tabelle customers_basket_attributes aktualisiert, Datensätze: 0

Tabelle: customers_info
...Spalte: customers_info_id
...Spalte: customers_info_date_of_last_logon
...Spalte: customers_info_number_of_logons
...Spalte: customers_info_date_account_created
...Spalte: customers_info_date_account_last_modified
...Spalte: global_product_notifications
Tabelle customers_info aktualisiert, Datensätze: 0

Tabelle: customers_ip
...Spalte: customers_ip_id
...Spalte: customers_id
...Spalte: customers_ip
...Spalte: customers_ip_date
...Spalte: customers_host
...Spalte: customers_advertiser
...Spalte: customers_referer_url
Tabelle customers_ip aktualisiert, Datensätze: 0

Tabelle: customers_memo
...Spalte: memo_id
...Spalte: customers_id
...Spalte: memo_date
...Spalte: memo_title
...Spalte: memo_text
...Spalte: poster_id
Tabelle customers_memo aktualisiert, Datensätze: 0

Tabelle: customers_status
...Spalte: customers_status_id
...Spalte: language_id
...Spalte: customers_status_name
...Spalte: customers_status_public
...Spalte: customers_status_min_order
...Spalte: customers_status_max_order
...Spalte: customers_status_image
...Spalte: customers_status_discount
...Spalte: customers_status_ot_discount_flag
...Spalte: customers_status_ot_discount
...Spalte: customers_status_graduated_prices
...Spalte: customers_status_show_price
...Spalte: customers_status_show_price_tax
...Spalte: customers_status_add_tax_ot
...Spalte: customers_status_payment_unallowed
...Spalte: customers_status_shipping_unallowed
...Spalte: customers_status_discount_attributes
...Spalte: customers_fsk18
...Spalte: customers_fsk18_display
...Spalte: customers_status_write_reviews
...Spalte: customers_status_read_reviews
Tabelle customers_status aktualisiert, Datensätze: 0

Tabelle: customers_status_history
...Spalte: customers_status_history_id
...Spalte: customers_id
...Spalte: new_value
...Spalte: old_value
...Spalte: date_added
...Spalte: customer_notified
Tabelle customers_status_history aktualisiert, Datensätze: 0

Tabelle: database_version
...Spalte: version
Tabelle database_version aktualisiert, Datensätze: 0

Tabelle: eazysales_adminsession
...Spalte: cSessionId
...Spalte: nSessionExpires
...Spalte: cSessionData
Tabelle eazysales_adminsession aktualisiert, Datensätze: 0

Tabelle: eazysales_einstellungen
...Spalte: currencies_id
...Spalte: languages_id
...Spalte: mappingEndkunde
...Spalte: mappingHaendlerkunde
...Spalte: shopURL
...Spalte: tax_class_id
...Spalte: tax_zone_id
...Spalte: tax_priority
...Spalte: shipping_status_id
...Spalte: versandMwst
...Spalte: cat_listing_template
...Spalte: cat_category_template
...Spalte: cat_sorting
...Spalte: cat_sorting2
...Spalte: prod_product_template
...Spalte: prod_options_template
...Spalte: StatusAbgeholt
...Spalte: StatusVersendet
Tabelle eazysales_einstellungen aktualisiert, Datensätze: 0

Tabelle: eazysales_martikel
...Spalte: products_id
...Spalte: kArtikel
Tabelle eazysales_martikel aktualisiert, Datensätze: 0

Tabelle: eazysales_mbestellpos
...Spalte: kBestellPos
...Spalte: orders_products_id
Tabelle eazysales_mbestellpos aktualisiert, Datensätze: 0

Tabelle: eazysales_mkategorie
...Spalte: categories_id
...Spalte: kKategorie
Tabelle eazysales_mkategorie aktualisiert, Datensätze: 0

Tabelle: eazysales_mvariation
...Spalte: kEigenschaft
...Spalte: products_options_id
...Spalte: kArtikel
Tabelle eazysales_mvariation aktualisiert, Datensätze: 0

Tabelle: eazysales_mvariationswert
...Spalte: products_attributes_id
...Spalte: kEigenschaftsWert
...Spalte: kArtikel
Tabelle eazysales_mvariationswert aktualisiert, Datensätze: 0

Tabelle: eazysales_sentorders
...Spalte: orders_id
...Spalte: dGesendet
Tabelle eazysales_sentorders aktualisiert, Datensätze: 0

Tabelle: eazysales_sync
...Spalte: cName
...Spalte: cPass
Tabelle eazysales_sync aktualisiert, Datensätze: 0

Tabelle: geo_zones
...Spalte: geo_zone_id
...Spalte: geo_zone_name
...Spalte: geo_zone_description
...Spalte: last_modified
...Spalte: date_added
Tabelle geo_zones aktualisiert, Datensätze: 0

Tabelle: languages
...Spalte: languages_id
...Spalte: name
...Spalte: code
...Spalte: image
...Spalte: directory
...Spalte: sort_order
...Spalte: language_charset
...Spalte: status
Tabelle languages aktualisiert, Datensätze: 0

Tabelle: manufacturers
...Spalte: manufacturers_id
...Spalte: manufacturers_name
...Spalte: manufacturers_image
...Spalte: date_added
...Spalte: last_modified
Tabelle manufacturers aktualisiert, Datensätze: 0

Tabelle: manufacturers_info
...Spalte: manufacturers_id
...Spalte: languages_id
...Spalte: manufacturers_meta_title
...Spalte: manufacturers_meta_description
...Spalte: manufacturers_meta_keywords
...Spalte: manufacturers_url
...Spalte: url_clicked
...Spalte: date_last_click
Tabelle manufacturers_info aktualisiert, Datensätze: 0

Tabelle: media_content
...Spalte: file_id
...Spalte: old_filename
...Spalte: new_filename
...Spalte: file_comment
Tabelle media_content aktualisiert, Datensätze: 0

Tabelle: module_newsletter
...Spalte: newsletter_id
...Spalte: title
...Spalte: bc
...Spalte: cc
...Spalte: date
...Spalte: status
...Spalte: body
Tabelle module_newsletter aktualisiert, Datensätze: 0

Tabelle: newsletter_recipients
...Spalte: mail_id
...Spalte: customers_email_address
...Spalte: customers_id
...Spalte: customers_status
...Spalte: customers_firstname
...Spalte: customers_lastname
...Spalte: mail_status
...Spalte: mail_key
...Spalte: date_added
Tabelle newsletter_recipients aktualisiert, Datensätze: 2

Tabelle: newsletters
...Spalte: newsletters_id
...Spalte: title
...Spalte: content
...Spalte: module
...Spalte: date_added
...Spalte: date_sent
...Spalte: status
...Spalte: locked
Tabelle newsletters aktualisiert, Datensätze: 0

Tabelle: newsletters_history
...Spalte: news_hist_id
...Spalte: news_hist_cs
...Spalte: news_hist_cs_date_sent
Tabelle newsletters_history aktualisiert, Datensätze: 0

Tabelle: orders
...Spalte: orders_id
...Spalte: customers_id
...Spalte: customers_cid
...Spalte: customers_vat_id
...Spalte: customers_status
...Spalte: customers_status_name
...Spalte: customers_status_image
...Spalte: customers_status_discount
...Spalte: customers_name
...Spalte: customers_firstname
...Spalte: customers_lastname
...Spalte: customers_company
...Spalte: customers_street_address
...Spalte: customers_suburb
...Spalte: customers_city
...Spalte: customers_postcode
...Spalte: customers_state
...Spalte: customers_country
...Spalte: customers_telephone
...Spalte: customers_email_address
...Spalte: customers_address_format_id
...Spalte: delivery_name
...Spalte: delivery_firstname
...Spalte: delivery_lastname
...Spalte: delivery_company
...Spalte: delivery_street_address
...Spalte: delivery_suburb
...Spalte: delivery_city
...Spalte: delivery_postcode
...Spalte: delivery_state
...Spalte: delivery_country
...Spalte: delivery_country_iso_code_2
...Spalte: delivery_address_format_id
...Spalte: billing_name
...Spalte: billing_firstname
...Spalte: billing_lastname
...Spalte: billing_company
...Spalte: billing_street_address
...Spalte: billing_suburb
...Spalte: billing_city
...Spalte: billing_postcode
...Spalte: billing_state
...Spalte: billing_country
...Spalte: billing_country_iso_code_2
...Spalte: billing_address_format_id
...Spalte: payment_method
...Spalte: cc_type
...Spalte: cc_owner
...Spalte: cc_number
...Spalte: cc_expires
...Spalte: cc_start
...Spalte: cc_issue
...Spalte: cc_cvv
...Spalte: comments
...Spalte: last_modified
...Spalte: date_purchased
...Spalte: orders_status
...Spalte: orders_date_finished
...Spalte: currency
...Spalte: currency_value
...Spalte: account_type
...Spalte: payment_class
...Spalte: shipping_method
...Spalte: shipping_class
...Spalte: customers_ip
...Spalte: language
...Spalte: afterbuy_success
...Spalte: afterbuy_id
...Spalte: refferers_id
...Spalte: conversion_type
...Spalte: orders_ident_key
...Spalte: ibn_billnr
...Spalte: ibn_billdate
Tabelle orders aktualisiert, Datensätze: 149

Tabelle: orders_products
...Spalte: orders_products_id
...Spalte: orders_id
...Spalte: products_id
...Spalte: products_model
...Spalte: products_name
...Spalte: products_price
...Spalte: products_discount_made
...Spalte: products_shipping_time
...Spalte: final_price
...Spalte: products_tax
...Spalte: products_quantity
...Spalte: allow_tax
...Spalte: products_order_description
Tabelle orders_products aktualisiert, Datensätze: 0

Tabelle: orders_products_attributes
...Spalte: orders_products_attributes_id
...Spalte: orders_id
...Spalte: orders_products_id
...Spalte: products_options
...Spalte: products_options_values
...Spalte: options_values_price
...Spalte: price_prefix
...Spalte: orders_products_options_id
...Spalte: orders_products_options_values_id
Tabelle orders_products_attributes aktualisiert, Datensätze: 0

Tabelle: orders_products_download
...Spalte: orders_products_download_id
...Spalte: orders_id
...Spalte: orders_products_id
...Spalte: orders_products_filename
...Spalte: download_maxdays
...Spalte: download_count
Tabelle orders_products_download aktualisiert, Datensätze: 0

Tabelle: orders_recalculate
...Spalte: orders_recalculate_id
...Spalte: orders_id
...Spalte: n_price
...Spalte: b_price
...Spalte: tax
...Spalte: tax_rate
...Spalte: class
Tabelle orders_recalculate aktualisiert, Datensätze: 0

Tabelle: orders_status
...Spalte: orders_status_id
...Spalte: language_id
...Spalte: orders_status_name
Tabelle orders_status aktualisiert, Datensätze: 0

Tabelle: orders_status_history
...Spalte: orders_status_history_id
...Spalte: orders_id
...Spalte: orders_status_id
...Spalte: date_added
...Spalte: customer_notified
...Spalte: comments
...Spalte: comments_sent
Tabelle orders_status_history aktualisiert, Datensätze: 2

Tabelle: orders_total
...Spalte: orders_total_id
...Spalte: orders_id
...Spalte: title
...Spalte: text
...Spalte: value
...Spalte: class
...Spalte: sort_order
Tabelle orders_total aktualisiert, Datensätze: 0

Tabelle: payment_moneybookers
...Spalte: mb_TRID
...Spalte: mb_ERRNO
...Spalte: mb_ERRTXT
...Spalte: mb_DATE
...Spalte: mb_MBTID
...Spalte: mb_STATUS
...Spalte: mb_ORDERID
Tabelle payment_moneybookers aktualisiert, Datensätze: 0

Tabelle: payment_moneybookers_countries
...Spalte: osc_cID
...Spalte: mb_cID
Tabelle payment_moneybookers_countries aktualisiert, Datensätze: 0

Tabelle: payment_moneybookers_currencies
...Spalte: mb_currID
...Spalte: mb_currName
Tabelle payment_moneybookers_currencies aktualisiert, Datensätze: 0

Tabelle: paypal
...Spalte: paypal_ipn_id
...Spalte: xtc_order_id
...Spalte: txn_type
...Spalte: reason_code
...Spalte: payment_type
...Spalte: payment_status
...Spalte: pending_reason
...Spalte: invoice
...Spalte: mc_currency
...Spalte: first_name
...Spalte: last_name
...Spalte: payer_business_name
...Spalte: address_name
...Spalte: address_street
...Spalte: address_city
...Spalte: address_state
...Spalte: address_zip
...Spalte: address_country
...Spalte: address_status
...Spalte: payer_email
...Spalte: payer_id
...Spalte: payer_status
...Spalte: payment_date
...Spalte: business
...Spalte: receiver_email
...Spalte: receiver_id
...Spalte: txn_id
...Spalte: parent_txn_id
...Spalte: num_cart_items
...Spalte: mc_gross
...Spalte: mc_fee
...Spalte: mc_shipping
...Spalte: payment_gross
...Spalte: payment_fee
...Spalte: settle_amount
...Spalte: settle_currency
...Spalte: exchange_rate
...Spalte: notify_version
...Spalte: verify_sign
...Spalte: last_modified
...Spalte: date_added
...Spalte: memo
...Spalte: mc_authorization
...Spalte: mc_captured
Tabelle paypal aktualisiert, Datensätze: 30

Tabelle: paypal_status_history
...Spalte: payment_status_history_id
...Spalte: paypal_ipn_id
...Spalte: txn_id
...Spalte: parent_txn_id
...Spalte: payment_status
...Spalte: pending_reason
...Spalte: mc_amount
...Spalte: date_added
Tabelle paypal_status_history aktualisiert, Datensätze: 0

Tabelle: personal_offers_by_customers_status_0
...Spalte: price_id
...Spalte: products_id
...Spalte: quantity
...Spalte: personal_offer
Tabelle personal_offers_by_customers_status_0 aktualisiert, Datensätze: 0

Tabelle: personal_offers_by_customers_status_1
...Spalte: price_id
...Spalte: products_id
...Spalte: quantity
...Spalte: personal_offer
Tabelle personal_offers_by_customers_status_1 aktualisiert, Datensätze: 0

Tabelle: personal_offers_by_customers_status_2
...Spalte: price_id
...Spalte: products_id
...Spalte: quantity
...Spalte: personal_offer
Tabelle personal_offers_by_customers_status_2 aktualisiert, Datensätze: 0

Tabelle: personal_offers_by_customers_status_3
...Spalte: price_id
...Spalte: products_id
...Spalte: quantity
...Spalte: personal_offer
Tabelle personal_offers_by_customers_status_3 aktualisiert, Datensätze: 0

Tabelle: products
...Spalte: products_id
...Spalte: products_ean
...Spalte: products_quantity
...Spalte: products_shippingtime
...Spalte: products_model
...Spalte: group_permission_0
...Spalte: group_permission_1
...Spalte: group_permission_2
...Spalte: group_permission_3
...Spalte: products_sort
...Spalte: products_image
...Spalte: products_price
...Spalte: products_discount_allowed
...Spalte: products_date_added
...Spalte: products_last_modified
...Spalte: products_date_available
...Spalte: products_weight
...Spalte: products_status
...Spalte: products_tax_class_id
...Spalte: product_template
...Spalte: options_template
...Spalte: manufacturers_id
...Spalte: products_manufacturers_model
...Spalte: products_ordered
...Spalte: products_fsk18
...Spalte: products_vpe
...Spalte: products_vpe_status
...Spalte: products_vpe_value
...Spalte: products_startpage
...Spalte: products_startpage_sort
Tabelle products aktualisiert, Datensätze: 0

Tabelle: products_attributes
...Spalte: products_attributes_id
...Spalte: products_id
...Spalte: options_id
...Spalte: options_values_id
...Spalte: options_values_price
...Spalte: price_prefix
...Spalte: attributes_model
...Spalte: attributes_stock
...Spalte: options_values_weight
...Spalte: weight_prefix
...Spalte: sortorder
...Spalte: attributes_ean
Tabelle products_attributes aktualisiert, Datensätze: 0

Tabelle: products_attributes_download
...Spalte: products_attributes_id
...Spalte: products_attributes_filename
...Spalte: products_attributes_maxdays
...Spalte: products_attributes_maxcount
Tabelle products_attributes_download aktualisiert, Datensätze: 0

Tabelle: products_content
...Spalte: content_id
...Spalte: products_id
...Spalte: group_ids
...Spalte: content_name
...Spalte: content_file
...Spalte: content_link
...Spalte: languages_id
...Spalte: content_read
...Spalte: file_comment
Tabelle products_content aktualisiert, Datensätze: 0

Tabelle: products_description
...Spalte: products_id
...Spalte: language_id
...Spalte: products_name
...Spalte: products_description
...Spalte: products_short_description
...Spalte: products_keywords
...Spalte: products_meta_title
...Spalte: products_meta_description
...Spalte: products_meta_keywords
...Spalte: products_url
...Spalte: products_viewed
...Spalte: products_order_description
Tabelle products_description aktualisiert, Datensätze: 2

Tabelle: products_graduated_prices
...Spalte: products_id
...Spalte: quantity
...Spalte: unitprice
Tabelle products_graduated_prices aktualisiert, Datensätze: 0

Tabelle: products_images
...Spalte: image_id
...Spalte: products_id
...Spalte: image_nr
...Spalte: image_name
Tabelle products_images aktualisiert, Datensätze: 0

Tabelle: products_notifications
...Spalte: products_id
...Spalte: customers_id
...Spalte: date_added
Tabelle products_notifications aktualisiert, Datensätze: 0

Tabelle: products_options
...Spalte: products_options_id
...Spalte: language_id
...Spalte: products_options_name
...Spalte: products_options_sortorder
Tabelle products_options aktualisiert, Datensätze: 0

Tabelle: products_options_values
...Spalte: products_options_values_id
...Spalte: language_id
...Spalte: products_options_values_name
Tabelle products_options_values aktualisiert, Datensätze: 0

Tabelle: products_options_values_to_products_options
...Spalte: products_options_values_to_products_options_id
...Spalte: products_options_id
...Spalte: products_options_values_id
Tabelle products_options_values_to_products_options aktualisiert, Datensätze: 0

Tabelle: products_to_categories
...Spalte: products_id
...Spalte: categories_id
Tabelle products_to_categories aktualisiert, Datensätze: 0

Tabelle: products_vpe
...Spalte: products_vpe_id
...Spalte: language_id
...Spalte: products_vpe_name
Tabelle products_vpe aktualisiert, Datensätze: 0

Tabelle: products_xsell
...Spalte: ID
...Spalte: products_id
...Spalte: products_xsell_grp_name_id
...Spalte: xsell_id
...Spalte: sort_order
Tabelle products_xsell aktualisiert, Datensätze: 0

Tabelle: products_xsell_grp_name
...Spalte: products_xsell_grp_name_id
...Spalte: xsell_sort_order
...Spalte: language_id
...Spalte: groupname
Tabelle products_xsell_grp_name aktualisiert, Datensätze: 0

Tabelle: reviews
...Spalte: reviews_id
...Spalte: products_id
...Spalte: customers_id
...Spalte: customers_name
...Spalte: reviews_rating
...Spalte: date_added
...Spalte: last_modified
...Spalte: reviews_read
Tabelle reviews aktualisiert, Datensätze: 0

Tabelle: reviews_description
...Spalte: reviews_id
...Spalte: languages_id
...Spalte: reviews_text
Tabelle reviews_description aktualisiert, Datensätze: 0

Tabelle: sessions
...Spalte: sesskey
...Spalte: expiry
...Spalte: value
...Spalte: flag
Tabelle sessions aktualisiert, Datensätze: 0

Tabelle: shipping_status
...Spalte: shipping_status_id
...Spalte: language_id
...Spalte: shipping_status_name
...Spalte: shipping_status_image
Tabelle shipping_status aktualisiert, Datensätze: 0

Tabelle: shop_configuration
...Spalte: configuration_id
...Spalte: configuration_key
...Spalte: configuration_value
Tabelle shop_configuration aktualisiert, Datensätze: 0

Tabelle: specials
...Spalte: specials_id
...Spalte: products_id
...Spalte: specials_quantity
...Spalte: specials_new_products_price
...Spalte: specials_date_added
...Spalte: specials_last_modified
...Spalte: expires_date
...Spalte: date_status_change
...Spalte: status
Tabelle specials aktualisiert, Datensätze: 0

Tabelle: tax_class
...Spalte: tax_class_id
...Spalte: tax_class_title
...Spalte: tax_class_description
...Spalte: last_modified
...Spalte: date_added
Tabelle tax_class aktualisiert, Datensätze: 0

Tabelle: tax_rates
...Spalte: tax_rates_id
...Spalte: tax_zone_id
...Spalte: tax_class_id
...Spalte: tax_priority
...Spalte: tax_rate
...Spalte: tax_description
...Spalte: last_modified
...Spalte: date_added
Tabelle tax_rates aktualisiert, Datensätze: 0

Tabelle: whos_online
...Spalte: customer_id
...Spalte: full_name
...Spalte: session_id
...Spalte: ip_address
...Spalte: time_entry
...Spalte: time_last_click
...Spalte: last_page_url
...Spalte: http_referer
Tabelle whos_online aktualisiert, Datensätze: 0

Tabelle: zones
...Spalte: zone_id
...Spalte: zone_country_id
...Spalte: zone_code
...Spalte: zone_name
Tabelle zones aktualisiert, Datensätze: 0

Tabelle: zones_to_geo_zones
...Spalte: association_id
...Spalte: zone_country_id
...Spalte: zone_id
...Spalte: geo_zone_id
...Spalte: last_modified
...Spalte: date_added
Tabelle zones_to_geo_zones aktualisiert, Datensätze: 0

Nachdem diese beiden Skripte gelaufen sind, sollte die einzelnen Tabellen, wie auch deren Inhalt in UTF-8 vorliegen. In meinem Fall gab es durch die vorherige Fehlkonfiguration jedoch Fälle, in denen sich die Umlaute nicht mehr eindeutig umstellen ließen und dies nur noch als ABM Maßnahme manuell gemacht werden konnte, da die Worte im Kontext interpretiert werden mussten.

.htaccess Datei anpassen

Der erste Schritt bei der Konfiguration des Shops ist es die .htaccess Datei anzupassen. Dazu wird der Standard Zeichensatz von ISO-8859-15 auf UTF-8 umgestellt. Der Eintrag sieht dann aus wie unten dargestellt.

##-- Default charset
AddDefaultCharset UTF-8
#AddDefaultCharset ISO-8859-15

Configure.php anpassen

Im Includes Verzeichnis befindet sich die Datei „configure.php“. In dieser sind viele technische Einstellungen rund um den Shop zu finden, darunter auch die Einstellung für den verwendeten Zeichensatz. Falls nicht schon richtig eingetragen bitte hier den Standard Zeichensatz auf UTF-8 umstellen.

define('DB_SERVER_CHARSET', 'utf8'); // set db charset 'utf8' or 'latin1'

Shop Backend anpassen

Damit nun auch noch der Modified Shop selbst weiß, dass er zukünftig auf UTF-8 läuft ist dies im Backend einzustellen. Hierzu logt ihr euch mit dem Admin User in den Shop ein und geht in die Einstellungen. Dort Wählt ihr den Reiter Land/Steuer und dort den Eintrag „-Sprachen“.

Die Fehlermeldung im Hintergrund wurde auf dem Testsystem nicht bereinigt. Wir wählen hier im Reiter Land/Steuer den Eintrag -Sprachen.

Auf dem nun geöffneten Reiter sehen wir hier zwei Sprachen: Deutsch und Englisch. Im Beispiel ist nur die Deutsche Sprache aktiviert. Entsprechend wird auch nur dieser Eintrag angepasst. Dazu wird auf bearbeiten geklickt.

Der Logik folgend würde ich bei mehreren Sprachen auch für jede Sprache einzeln die Umstellung auf UTF-8 vornehmen, um Fehlern vorzubeugen.

In der Eingabemaske Sprachen bearbeiten wird nun der Zeichensatz (Charset) wie unten angezeigt auf „utf-8“ geändert und die Änderung durch einen Klick auf Aktualisieren abgespeichert.

Voilà, nun ist alles auf UTF-8 umgestellt. Viel Spaß mit eurem Shop.

Leave a Comment

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.