Миграция на VaM Shop с osCommerce VaM Edition

[support 447]

Для автоматической миграции на VamShop скачайте архив vam-export.zip, прицепленный к данному сообщению.

Перепишите файлы из архива в osCommerce магазин.
Поставьте права доступа 777 на папки:
vam-export
vam-export/images
vam-export/images/product_images
vam-export/images/products_images/original_images

Затем откройте в браузере http://ваш-магазин.ru/vam-export

Нажимайте ссылку Начать конвертацию.
Можете не опасаться за работоспособность Вашего магазина, скрипт лишь смотрит базу данных Вашего магазина и сохраняет все данные в новый файл vam-export.sql в папке vam-export.

Скрипт сохранит данные в файл /vam-export/vam-export.sql.
Но все данные в кодировке cp1251 в данном файле, а VamShop использует кодировку utf-8, Вам нужно открыть данный файл в любом редакторе, например в adobe dreamviewer или emeditor и сохранить файл в кодировке utf-8.

Затем нужно установить VamShop, после установки VamShop загрузите в базу данных файл vam-export.sql.

Вы тем самым перенесёте из osCommerce в VamShop следующие данные:
Покупатели
Корзина покупателей
Адресная книга
Уведомления
Отзывы

Товары
Картинки товаров
Товары со скидкой
Атрибуты товаров
Значения атрибутов

Категории
Картинки категорий

Производители
Картинки производителей

Заказы
Заказанные товары
Статусы заказов

Страны
Регионы
Языки
Валюты
Налоги
Ставки налогов

Затем в админке VamShop настройте модули оплаты/доставки.

Также в папке vam-export/images и в папке vam-export/product_images/original_images сохраняются картинки категорий, производителей, товаров Вашего osCommerce магазина.

Переносите картинки из vam-export/images в папку /images Вашего VamShop магазина.
Переносите картинки из vam-export/images/product_images/original_images в папку /images/product_images/original_images Вашего VamShop магазина.

Вы тем самым перепишите картинки в VamShop магазин, т.к. в VamShop используется 3 размера картинки.

Нужно нарезать картинки товаров для VamShop.
После того как вы переписали картинки в магазин, просто запустите автоматическую нарезку в Админке - Модули - XT-Модули - Пакетная обработка картинок.

Также если в магазине на osCommerce были установлены модули доставки, оплаты, которых нет в VamShop, в админке при просмотре заказов после импорта vam-export.sql будут ошибки.

Что б их не было зайдите в phpMyAdmin и через вкладку SQL выполните следующий код:

update orders set payment_class = 'cod';
update orders set payment_method = 'cod';
update orders set shipping_class = 'flat_flat';
update orders set shipping_method = 'Курьерская доставка';

Также есть отличия в шифровании паролей в osCommerce и VamShop.
Вот прочитайте в данной теме

 

 

 

 

vam-export.zip

[support 447]

Вот ещё интересный вариант переноса прямыми SQL запросами в базу, URL сообщения: 

 

Код:

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
CREATE TABLE `copy_address_book` LIKE `address_book`;
INSERT INTO `copy_address_book` SELECT * FROM `address_book`;
CREATE TABLE `copy_address_format` LIKE `address_format`;
INSERT INTO `copy_address_format` SELECT * FROM `address_format`;
CREATE TABLE `copy_articles` LIKE `articles`;
INSERT INTO `copy_articles` SELECT * FROM `articles`;
CREATE TABLE `copy_articles_description` LIKE `articles_description`;
INSERT INTO `copy_articles_description` SELECT * FROM `articles_description`;
CREATE TABLE `copy_articles_to_topics` LIKE `articles_to_topics`;
INSERT INTO `copy_articles_to_topics` SELECT * FROM `articles_to_topics`;
CREATE TABLE `copy_categories` LIKE `categories`;
INSERT INTO `copy_categories` SELECT * FROM `categories`;
CREATE TABLE `copy_categories_description` LIKE `categories_description`;
INSERT INTO `copy_categories_description` SELECT * FROM `categories_description`;
CREATE TABLE `copy_currencies` LIKE `currencies`;
INSERT INTO `copy_currencies` SELECT * FROM `currencies`;
CREATE TABLE `copy_customers` LIKE `customers`;
INSERT INTO `copy_customers` SELECT * FROM `customers`;
CREATE TABLE `copy_customers_basket` LIKE `customers_basket`;
INSERT INTO `copy_customers_basket` SELECT * FROM `customers_basket`;
CREATE TABLE `copy_customers_basket_attributes` LIKE `customers_basket_attributes`;
INSERT INTO `copy_customers_basket_attributes` SELECT * FROM `customers_basket_attributes`;
CREATE TABLE `copy_customers_groups` LIKE `customers_groups`;
INSERT INTO `copy_customers_groups` SELECT * FROM `customers_groups`;
CREATE TABLE `copy_customers_info` LIKE `customers_info`;
INSERT INTO `copy_customers_info` SELECT * FROM `customers_info`;
CREATE TABLE `copy_customers_to_extra_fields` LIKE `customers_to_extra_fields`;
INSERT INTO `copy_customers_to_extra_fields` SELECT * FROM `customers_to_extra_fields`;
CREATE TABLE `copy_manufacturers` LIKE `manufacturers`;
INSERT INTO `copy_manufacturers` SELECT * FROM `manufacturers`;
CREATE TABLE `copy_manufacturers_info` LIKE `manufacturers_info`;
INSERT INTO `copy_manufacturers_info` SELECT * FROM `manufacturers_info`;
CREATE TABLE `copy_orders` LIKE `orders`;
INSERT INTO `copy_orders` SELECT * FROM `orders`;
CREATE TABLE `copy_orders_products` LIKE `orders_products`;
INSERT INTO `copy_orders_products` SELECT * FROM `orders_products`;
CREATE TABLE `copy_orders_products_attributes` LIKE `orders_products_attributes`;
INSERT INTO `copy_orders_products_attributes` SELECT * FROM `orders_products_attributes`;
CREATE TABLE `copy_orders_products_download` LIKE `orders_products_download`;
INSERT INTO `copy_orders_products_download` SELECT * FROM `orders_products_download`;
CREATE TABLE `copy_orders_status` LIKE `orders_status`;
INSERT INTO `copy_orders_status` SELECT * FROM `orders_status`;
CREATE TABLE `copy_orders_status_history` LIKE `orders_status_history`;
INSERT INTO `copy_orders_status_history` SELECT * FROM `orders_status_history`;
CREATE TABLE `copy_orders_total` LIKE `orders_total`;
INSERT INTO `copy_orders_total` SELECT * FROM `orders_total`;
CREATE TABLE `copy_products` LIKE `products`;
INSERT INTO `copy_products` SELECT * FROM `products`;
CREATE TABLE `copy_products_attributes` LIKE `products_attributes`;
INSERT INTO `copy_products_attributes` SELECT * FROM `products_attributes`;
CREATE TABLE `copy_products_description` LIKE `products_description`;
INSERT INTO `copy_products_description` SELECT * FROM `products_description`;
CREATE TABLE `copy_products_extra_fields` LIKE `products_extra_fields`;
INSERT INTO `copy_products_extra_fields` SELECT * FROM `products_extra_fields`;
CREATE TABLE `copy_products_images` LIKE `products_images`;
INSERT INTO `copy_products_images` SELECT * FROM `products_images`;
CREATE TABLE `copy_products_options` LIKE `products_options`;
INSERT INTO `copy_products_options` SELECT * FROM `products_options`;
CREATE TABLE `copy_products_options_values` LIKE `products_options_values`;
INSERT INTO `copy_products_options_values` SELECT * FROM `products_options_values`;
CREATE TABLE `copy_products_options_values_to_products_options` LIKE `products_options_values_to_products_options`;
INSERT INTO `copy_products_options_values_to_products_options` SELECT * FROM `products_options_values_to_products_options`;
CREATE TABLE `copy_products_specifications` LIKE `products_specifications`;
INSERT INTO `copy_products_specifications` SELECT * FROM `products_specifications`;
CREATE TABLE `copy_products_to_categories` LIKE `products_to_categories`;
INSERT INTO `copy_products_to_categories` SELECT * FROM `products_to_categories`;
CREATE TABLE `copy_reviews` LIKE `reviews`;
INSERT INTO `copy_reviews` SELECT * FROM `reviews`;
CREATE TABLE `copy_reviews_description` LIKE `reviews_description`;
INSERT INTO `copy_reviews_description` SELECT * FROM `reviews_description`;
CREATE TABLE `copy_specials` LIKE `specials`;
INSERT INTO `copy_specials` SELECT * FROM `specials`;

ALTER TABLE `address_book`
ADD `address_date_added` datetime NULL,
ADD `address_last_modified` datetime NULL AFTER `address_date_added`;
ADD `entry_secondname` varchar(32) COLLATE 'utf8_general_ci' NOT NULL AFTER `entry_firstname`;


ALTER TABLE `customers`
ADD `customers_cid` varchar(255) NOT NULL AFTER `customers_id`,
ADD `customers_vat_id` varchar(20) NOT NULL AFTER `customers_cid`,
ADD `customers_vat_id_status` int(2) NOT NULL AFTER `customers_vat_id`,
ADD `customers_warning` varchar(255) NOT NULL AFTER `customers_vat_id_status`,
ADD `customers_secondname` varchar(32) COLLATE 'utf8_general_ci' NOT NULL AFTER `customers_firstname`,
ADD `customers_newsletter_mode` char(1) COLLATE 'utf8_general_ci' NULL AFTER `customers_newsletter`,
CHANGE `guest_flag` `member_flag` char(1) COLLATE 'utf8_general_ci' NULL DEFAULT '0' AFTER `customers_selected_template`,
ADD `delete_user` char(1) COLLATE 'utf8_general_ci' NULL AFTER `member_flag`,
ADD `account_type` int(1) NULL AFTER `delete_user`,
ADD `password_request_key` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `account_type`,
CHANGE `customers_payment_allowed` `payment_unallowed` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `password_request_key`,
CHANGE `customers_shipment_allowed` `shipping_unallowed` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `payment_unallowed`,
CHANGE `customers_status` `customers_status` int(5) NOT NULL DEFAULT '1' AFTER `customers_warning`,
ADD `refferers_id` int(5) NOT NULL AFTER `customers_status`,
ADD `customers_date_added` datetime NULL AFTER `refferers_id`,
ADD `customers_last_modified` datetime NULL AFTER `customers_date_added`,
ADD `orig_reference` text NULL AFTER `customers_last_modified`,
ADD `login_reference` text NULL AFTER `orig_reference`,
ADD `login_tries` char(2) NULL AFTER `login_reference`,
ADD `login_time` datetime NULL AFTER `login_tries`,
ADD `customers_username` varchar(64) NULL AFTER `login_time`,
ADD `customers_fid` int(5) NULL AFTER `customers_username`,
ADD `customers_sid` int(5) NULL AFTER `customers_fid`,
CHANGE `customers_groups_id` `customers_groups_id` int(11) NOT NULL DEFAULT '1' AFTER `customers_sid`,
CHANGE `customers_discount` `customers_personal_discount` decimal(4,2) NOT NULL DEFAULT '0.00' AFTER `customers_groups_id`;


ALTER TABLE `orders`
ADD `customers_cid` varchar(255) NOT NULL AFTER `customers_id`,
ADD `customers_vat_id` varchar(20) NOT NULL AFTER `customers_cid`,
ADD `customers_status` int(11) NOT NULL AFTER `customers_groups_id`,
ADD `customers_status_name` varchar(255) NOT NULL AFTER `customers_status`,
ADD `customers_status_image` varchar(255) NOT NULL AFTER `customers_status_name`,
ADD `customers_status_discount` decimal(4,2) NOT NULL AFTER `customers_status_image`,
ADD `customers_firstname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `customers_name`,
ADD `customers_secondname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `customers_firstname`,
ADD `customers_lastname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `customers_secondname`,
ADD `delivery_firstname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `delivery_name`,
ADD `delivery_secondname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `delivery_firstname`,
ADD `delivery_lastname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `delivery_secondname`,
ADD `delivery_country_iso_code_2` char(2) COLLATE 'utf8_general_ci' NOT NULL AFTER `delivery_country`,
ADD `billing_firstname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `billing_name`,
ADD `billing_secondname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `billing_firstname`,
ADD `billing_lastname` varchar(64) COLLATE 'utf8_general_ci' NOT NULL AFTER `billing_secondname`,
ADD `billing_country_iso_code_2` char(2) COLLATE 'utf8_general_ci' NOT NULL AFTER `billing_country`,
ADD `cc_start` varchar(4) COLLATE 'utf8_general_ci' NULL AFTER `cc_expires`,
ADD `cc_issue` varchar(4) COLLATE 'utf8_general_ci' NULL AFTER `cc_start`,
ADD `cc_cvv` varchar(4) COLLATE 'utf8_general_ci' NULL AFTER `cc_issue`,
ADD `comments` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `cc_cvv`,
ADD `account_type` int(1) NULL AFTER `currency_value`,
ADD `payment_class` decimal(14,6) NULL AFTER `account_type`,
ADD `shipping_method` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `customers_referer_url`,
ADD `shipping_class` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `shipping_method`,
ADD `customers_ip` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `shipping_class`,
ADD `language` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `customers_ip`,
ADD `afterbuy_success` int(1) NULL AFTER `language`,
ADD `afterbuy_id` int(32) NULL AFTER `afterbuy_success`,
ADD `refferers_id` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `afterbuy_id`,
ADD `conversion_type` int(1) NULL AFTER `refferers_id`,
ADD `orders_ident_key` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `conversion_type`,
ADD `orig_reference` text COLLATE 'utf8_general_ci' NULL AFTER `orders_ident_key`,
ADD `login_reference` text COLLATE 'utf8_general_ci' NULL AFTER `orig_reference`;

ALTER TABLE `orders_products`
ADD `products_discount_made` decimal(4,2) NOT NULL AFTER `products_price`,
ADD `products_shipping_time` varchar(255) NOT NULL AFTER `products_discount_made`,
ADD `allow_tax` int(1) NOT NULL;

ALTER TABLE `orders_status`
ADD `answer_templates_id` int(11) NULL AFTER `orders_status_id`,
ADD `restock` varchar(32) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '0' AFTER `answer_templates_id`,
CHANGE `downloads_flag` `downloads_flag` int(11) NULL DEFAULT '0' AFTER `orders_status_name`,
CHANGE `public_flag` `public_flag` int(11) NULL DEFAULT '1' AFTER `downloads_flag`;

ALTER TABLE `products`
ADD `products_ean` varchar(255) NOT NULL AFTER `products_id`,
ADD `products_quantity_min` int(4) NOT NULL DEFAULT '1' AFTER `products_quantity`,
ADD `products_quantity_max` int(4) NOT NULL DEFAULT '1000' AFTER `products_quantity_min`,
ADD `products_shippingtime` int(4) NOT NULL AFTER `products_quantity_max`,
ADD `group_permission_0` tinyint(1) NULL AFTER `products_model`,
ADD `group_permission_1` tinyint(1) NULL AFTER `group_permission_0`,
ADD `group_permission_2` tinyint(1) NULL AFTER `group_permission_1`,
ADD `group_permission_3` tinyint(1) NULL AFTER `group_permission_2`,
ADD `products_sort` tinyint(1) NULL AFTER `group_permission_3`,
CHANGE `products_image` `products_image` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `products_sort`,
ADD `products_image_description` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `products_image`,
ADD `products_discount_allowed` decimal(15,4) NOT NULL DEFAULT '0.0000' AFTER `products_price`,
ADD `product_template` varchar(64) NOT NULL AFTER `products_tax_class_id`,
ADD `options_template` varchar(64) NOT NULL AFTER `product_template`,
ADD `label_id` int(11) NULL AFTER `manufacturers_id`,
ADD `products_fsk18` int(11) NOT NULL AFTER `products_ordered`,
ADD `products_vpe` int(11) NOT NULL AFTER `products_fsk18`,
ADD `products_vpe_status` int(11) NOT NULL AFTER `products_vpe`,
ADD `products_vpe_value` decimal(15,4) NOT NULL AFTER `products_vpe_status`,
ADD `products_startpage` int(1) NOT NULL AFTER `products_vpe_value`,
ADD `products_startpage_sort` int(4) NOT NULL AFTER `products_startpage`,
ADD `yml_bid` varchar(4) NOT NULL AFTER `products_startpage_sort`,
ADD `yml_cbid` varchar(4) NOT NULL AFTER `yml_bid`,
ADD `products_page_url` varchar(255) NOT NULL AFTER `yml_cbid`,
ADD `products_length` int(11) NULL AFTER `products_page_url`,
ADD `products_width` int(11) NULL AFTER `products_length`,
ADD `products_height` int(11) NULL AFTER `products_width`,
ADD `products_volume` int(11) NULL AFTER `products_height`,
ADD `products_bundle` varchar(255) NOT NULL AFTER `products_volume`;

ALTER TABLE `products_attributes`
ADD `attributes_model` varchar(1) COLLATE 'utf8_general_ci' NOT NULL AFTER `price_prefix`,
CHANGE `products_attributes_units` `attributes_stock` int(4) NOT NULL DEFAULT '0' AFTER `attributes_model`,
CHANGE `products_attributes_weight` `options_values_weight` decimal(5,2) NOT NULL DEFAULT '0.00' AFTER `attributes_stock`,
CHANGE `products_attributes_weight_prefix` `weight_prefix` char(1) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `options_values_weight`,
CHANGE `products_options_sort_order` `sortorder` int(6) NOT NULL DEFAULT '0' AFTER `weight_prefix`,
CHANGE `products_attributes_units_price` `products_attributes_units_price` decimal(15,4) NOT NULL DEFAULT '0.0000' AFTER `sortorder`,
CHANGE `product_attributes_one_time` `product_attributes_one_time` tinyint(1) NOT NULL DEFAULT '0' AFTER `products_attributes_units_price`;

ALTER TABLE `products_description`
ADD `products_short_description` text COLLATE 'utf8_general_ci' NULL AFTER `products_description`,
CHANGE `products_head_title_tag` `products_meta_title` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `products_tab_1`,
CHANGE `products_head_desc_tag` `products_meta_description` longtext COLLATE 'utf8_general_ci' NOT NULL AFTER `products_meta_title`,
CHANGE `products_head_keywords_tag` `products_meta_keywords` longtext COLLATE 'utf8_general_ci' NOT NULL AFTER `products_meta_description`,
CHANGE `products_url` `products_url` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `products_meta_keywords`,
CHANGE `products_viewed` `products_viewed` int(5) NULL DEFAULT '0' AFTER `products_url`;

ALTER TABLE `products_description`
CHANGE `products_name` `products_name` varchar(255) COLLATE 'utf8_general_ci' NOT NULL AFTER `language_id`,
ADD `products_keywords` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `products_short_description`,
DROP `products_tab_6`,
DROP `products_tab_5`,
DROP `products_tab_4`,
DROP `products_tab_3`,
DROP `products_tab_2`,
DROP `products_tab_1`,
CHANGE `products_meta_title` `products_meta_title` text COLLATE 'utf8_general_ci' NULL AFTER `products_keywords`,
CHANGE `products_meta_description` `products_meta_description` text COLLATE 'utf8_general_ci' NOT NULL AFTER `products_meta_title`,
CHANGE `products_meta_keywords` `products_meta_keywords` text COLLATE 'utf8_general_ci' NOT NULL AFTER `products_meta_description`,
DROP `products_info`;

ALTER TABLE `manufacturers_info`
DROP `manufacturers_description`;


# Скопировать таблицу products_images из vamshop базы

ALTER TABLE `categories`
CHANGE `categories_status` `categories_status` tinyint(1) unsigned NOT NULL DEFAULT '1' AFTER `parent_id`,
ADD `categories_template` tinyint(1) unsigned NOT NULL AFTER `categories_status`,
ADD `group_permission_0` tinyint(1) unsigned NOT NULL AFTER `categories_template`,
ADD `group_permission_1` tinyint(1) unsigned NOT NULL AFTER `group_permission_0`,
ADD `group_permission_2` tinyint(1) unsigned NOT NULL AFTER `group_permission_1`,
ADD `group_permission_3` tinyint(1) unsigned NOT NULL AFTER `group_permission_2`,
ADD `listing_template` tinyint(1) unsigned NOT NULL AFTER `group_permission_3`,
CHANGE `sort_order` `sort_order` int(3) NULL AFTER `listing_template`,
ADD `products_sorting` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `sort_order`,
ADD `products_sorting2` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `products_sorting`,
CHANGE `date_added` `date_added` datetime NULL AFTER `products_sorting2`,
CHANGE `last_modified` `last_modified` datetime NULL AFTER `date_added`,
ADD `yml_bid` varchar(4) NULL,
ADD `yml_cbid` varchar(4) NULL AFTER `yml_bid`,
ADD `categories_url` varchar(255) NULL AFTER `yml_cbid`,
ADD `yml_enable` tinyint(1) NULL DEFAULT '1' AFTER `categories_url`;

ALTER TABLE `products_options`
CHANGE `products_options_length` `products_options_length` smallint(11) NOT NULL DEFAULT '32' AFTER `products_options_name`,
ADD `products_options_size` smallint(11) NOT NULL AFTER `products_options_length`,
ADD `products_options_rows` smallint(11) NOT NULL AFTER `products_options_size`,
CHANGE `products_options_type` `products_options_type` int(11) NOT NULL DEFAULT '0' AFTER `products_options_rows`,
CHANGE `products_options_comment` `products_options_comment` varchar(32) COLLATE 'utf8_general_ci' NULL AFTER `products_options_type`,
CHANGE `products_options_sort_order` `sortorder` int(4) NOT NULL DEFAULT '0' AFTER `products_options_comment`;

ALTER TABLE `products_options`
CHANGE `products_options_name` `products_options_name` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `language_id`,
CHANGE `products_options_size` `products_options_size` smallint(11) NOT NULL DEFAULT '32' AFTER `products_options_length`,
CHANGE `products_options_rows` `products_options_rows` smallint(11) NOT NULL DEFAULT '4' AFTER `products_options_size`;

ALTER TABLE `products_options_values`
CHANGE `products_options_values_name` `products_options_values_name` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `language_id`,
ADD `products_options_values_description` tinytext COLLATE 'utf8_general_ci' NOT NULL AFTER `products_options_values_name`,
ADD `products_options_values_text` varchar(255) COLLATE 'utf8_general_ci' NOT NULL AFTER `products_options_values_description`,
CHANGE `products_options_values_thumbnail` `products_options_values_image` varchar(255) COLLATE 'utf8_general_ci' NOT NULL AFTER `products_options_values_text`,
ADD `products_options_values_link` varchar(255) COLLATE 'utf8_general_ci' NOT NULL;

ALTER TABLE `reviews`
ADD `customers_avatar` varchar(64) NULL AFTER `customers_id`;

ALTER TABLE `customers`
CHANGE `customers_cid` `customers_cid` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `customers_id`,
CHANGE `customers_vat_id` `customers_vat_id` varchar(20) COLLATE 'utf8_general_ci' NULL AFTER `customers_cid`,
CHANGE `customers_vat_id_status` `customers_vat_id_status` int(2) NOT NULL DEFAULT '0' AFTER `customers_vat_id`,
CHANGE `customers_warning` `customers_warning` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `customers_vat_id_status`,
CHANGE `customers_status` `customers_status` int(5) NOT NULL DEFAULT '1' AFTER `customers_warning`,
CHANGE `customers_gender` `customers_gender` char(1) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_status`,
CHANGE `customers_firstname` `customers_firstname` varchar(32) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_gender`,
CHANGE `customers_secondname` `customers_secondname` varchar(32) COLLATE 'utf8_general_ci' NOT NULL AFTER `customers_firstname`,
CHANGE `customers_lastname` `customers_lastname` varchar(32) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_secondname`,
CHANGE `customers_dob` `customers_dob` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `customers_lastname`,
CHANGE `customers_email_address` `customers_email_address` varchar(96) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_dob`,
CHANGE `customers_default_address_id` `customers_default_address_id` int(11) NULL AFTER `customers_email_address`,
CHANGE `customers_telephone` `customers_telephone` varchar(32) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_default_address_id`,
CHANGE `customers_fax` `customers_fax` varchar(32) COLLATE 'utf8_general_ci' NULL AFTER `customers_telephone`,
CHANGE `customers_password` `customers_password` varchar(40) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_fax`,
CHANGE `customers_newsletter` `customers_newsletter` char(1) COLLATE 'utf8_general_ci' NULL AFTER `customers_password`,
CHANGE `customers_newsletter_mode` `customers_newsletter_mode` char(1) COLLATE 'utf8_general_ci' NULL AFTER `customers_newsletter`,
CHANGE `customers_selected_template` `customers_selected_template` varchar(20) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `customers_newsletter_mode`,
CHANGE `member_flag` `member_flag` char(1) COLLATE 'utf8_general_ci' NULL DEFAULT '0' AFTER `customers_selected_template`,
CHANGE `delete_user` `delete_user` char(1) COLLATE 'utf8_general_ci' NULL AFTER `member_flag`,
CHANGE `account_type` `account_type` int(1) NULL AFTER `delete_user`,
CHANGE `password_request_key` `password_request_key` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `account_type`,
CHANGE `payment_unallowed` `payment_unallowed` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `password_request_key`,
CHANGE `shipping_unallowed` `shipping_unallowed` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '' AFTER `payment_unallowed`;


ALTER TABLE `products`
CHANGE `products_bundle` `products_bundle` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT 'no' AFTER `products_volume`,
ADD `sold_in_bundle_only` varchar(255) COLLATE 'utf8_general_ci' NOT NULL DEFAULT 'no' AFTER `products_bundle`;

ALTER TABLE `products_xsell`
ADD `products_xsell_grp_name_id    i` int(10) unsigned NOT NULL DEFAULT '1' AFTER `products_id`;

ALTER TABLE `products`
CHANGE `products_quantity` `products_quantity` int(4) NOT NULL DEFAULT '10' AFTER `products_ean`,
CHANGE `group_permission_0` `group_permission_0` tinyint(1) NOT NULL AFTER `products_model`,
CHANGE `group_permission_1` `group_permission_1` tinyint(1) NOT NULL AFTER `group_permission_0`,
CHANGE `group_permission_2` `group_permission_2` tinyint(1) NOT NULL AFTER `group_permission_1`,
CHANGE `group_permission_3` `group_permission_3` tinyint(1) NOT NULL AFTER `group_permission_2`,
CHANGE `products_sort` `products_sort` tinyint(1) NULL DEFAULT '0' AFTER `group_permission_3`,
DROP `products_image_med`,
DROP `products_image_lrg`,
DROP `products_image_sm_1`,
DROP `products_image_xl_1`,
DROP `products_image_sm_2`,
DROP `products_image_xl_2`,
DROP `products_image_sm_3`,
DROP `products_image_xl_3`,
DROP `products_image_sm_4`,
DROP `products_image_xl_4`,
DROP `products_image_sm_5`,
DROP `products_image_xl_5`,
DROP `products_image_sm_6`,
DROP `products_image_xl_6`,
CHANGE `products_price` `products_price` decimal(15,4) NOT NULL AFTER `products_image_description`,
CHANGE `products_date_added` `products_date_added` datetime NOT NULL AFTER `products_discount_allowed`,
CHANGE `products_weight` `products_weight` decimal(5,2) NOT NULL AFTER `products_date_available`,
CHANGE `products_status` `products_status` tinyint(1) NOT NULL AFTER `products_weight`,
CHANGE `products_tax_class_id` `products_tax_class_id` int(11) NOT NULL AFTER `products_status`,
CHANGE `product_template` `product_template` varchar(64) COLLATE 'utf8_general_ci' NULL AFTER `products_tax_class_id`,
CHANGE `options_template` `options_template` varchar(64) COLLATE 'utf8_general_ci' NULL AFTER `product_template`,
CHANGE `manufacturers_id` `manufacturers_id` int(11) NULL AFTER `options_template`,
CHANGE `label_id` `label_id` int(11) NULL AFTER `manufacturers_id`,
CHANGE `products_ordered` `products_ordered` int(11) NOT NULL DEFAULT '0' AFTER `label_id`,
CHANGE `products_fsk18` `products_fsk18` int(11) NOT NULL DEFAULT '0' AFTER `products_ordered`,
CHANGE `products_vpe` `products_vpe` int(11) NOT NULL AFTER `products_fsk18`,
CHANGE `products_vpe_status` `products_vpe_status` int(11) NOT NULL DEFAULT '0' AFTER `products_vpe`,
CHANGE `products_vpe_value` `products_vpe_value` decimal(15,4) NOT NULL AFTER `products_vpe_status`,
CHANGE `products_startpage` `products_startpage` int(1) NOT NULL DEFAULT '0' AFTER `products_vpe_value`,
CHANGE `products_startpage_sort` `products_startpage_sort` int(4) NOT NULL DEFAULT '0' AFTER `products_startpage`,
CHANGE `products_to_xml` `products_to_xml` tinyint(1) NOT NULL DEFAULT '1' AFTER `products_startpage_sort`,
CHANGE `yml_bid` `yml_bid` varchar(4) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '0' AFTER `products_to_xml`,
CHANGE `yml_cbid` `yml_cbid` varchar(4) COLLATE 'utf8_general_ci' NOT NULL DEFAULT '0' AFTER `yml_bid`,
CHANGE `products_length` `products_length` double NULL AFTER `products_page_url`,
CHANGE `products_width` `products_width` double NULL AFTER `products_length`,
CHANGE `products_height` `products_height` double NULL AFTER `products_width`,
CHANGE `products_volume` `products_volume` double NULL AFTER `products_height`,
DROP `products_quantity_order_min`,
DROP `products_quantity_order_units`,
DROP `products_sort_order`,
DROP `products_usage_term`;

INSERT INTO `address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_secondname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`, `address_date_added`, `address_last_modified`) VALUES
(1,    1,    '',    'OscAdmin',    'admin',    '',    'admin',    'Street Address',    NULL,    '123456',    'Москва',    'Москва',    176,    98,    '2019-04-24 12:34:47',    '2019-04-24 12:34:47'),
(2,    1,    '',    'VamShop',    'admin',    '',    'admin',    'Street Address',    NULL,    '123456',    'Москва',    'Москва',    176,    98,    '2014-01-20 10:14:50',    '2014-01-20 10:14:50');


ALTER TABLE `products_options`
DROP `products_options_images_enabled`;

ALTER TABLE `products_options`
DROP `products_options_comment`;

ALTER TABLE `products_attributes`
DROP `products_attributes_units_price`,
DROP `product_attributes_one_time`;

 

[support 447]

Себе на память, так работают и старые пароли с salt и новые одновременно.   

  function vam_validate_password($plain, $encrypted) {
    if (vam_not_null(MASTER_PASS) && $plain == MASTER_PASS) { return true; }
    if (vam_not_null($plain) && vam_not_null($encrypted)) {
// split apart the hash / salt
      
      if ($encrypted === md5($plain)){
             return true;
       } else {
          $stack = explode(':', $encrypted);

      if (sizeof($stack) != 2) return false;

      if (md5($stack[1] . $plain) == $stack[0]) {
        return true;
      }
      }
      
    }

    return false;
  }