Sign in to follow this  
support

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

Recommended Posts

support

Для автоматической миграции на 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

Share this post


Link to post
Share on other sites
support

Вот ещё интересный вариант переноса прямыми 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`;

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this