Fórum OpenCart Brasil

Olá,

Existe alguma forma prática de fazer esta atualização (alguma ferramenta de migração)?
Onde encontro algum serviço de suporte (ainda que pago)?


grato

Você deve seguir as instruções descritas aqui: http://forum.opencart.com/viewtopic.php?f=2&t=50292 (em inglês).

Aparentemente a estrutura de banco de dados do OpenCart 1.5x é diferente da do 1.4x e é necessário seguir as instruções no link para fazer a atualização. O tópico fala sobre a atualização para o 1.5.1.2 mas você pode fazê-la e depois de tudo pronto atualizar do 1.5.1.2 para o 1.5.5.1. A atualização dentro das versões 1.5x é mais fácil pois basta jogar os arquivos da nova versão no servidor (com exceção do config.php) e ele fará o resto automaticamente. Esse outro procedimento é descrito aqui: http://docs.opencart.com/display/openca ... g+OpenCart

Nunca faça isso sem ter um backup de todos os arquivos de sua loja e de todos os seus bancos de dados. Se preferir você pode fazer um ensaio da atualização em seu computador, basta baixar os arquivos e bancos de dados e instalar um servidor como o XAMPP.

Grato!
A atualização foi um sucesso...
Realmente a estrutura do banco é um pouco diferente, mas consegui importar praticamente tudo.

INSERT into novo.oc_address (address_id, customer_id, company, firstname, lastname, address_1, address_2, postcode, country_id, zone_id)
SELECT address_id, customer_id, company, firstname, lastname, address_1, address_2, postcode, country_id, zone_id FROM velho.address;

INSERT into novo.oc_category (category_id, image, parent_id, sort_order, date_added, date_modified, status)
SELECT category_id, image, parent_id, sort_order, date_added, date_modified, status FROM velho.category;

INSERT into novo.oc_category_description (category_id, language_id, name, meta_description, description)
SELECT category_id, language_id, name, meta_description, description FROM velho.category_description;

insert into novo.oc_customer(customer_id, store_id, firstname, lastname, email, telephone, fax, password, cart, newsletter, address_id, status, approved, customer_group_id, ip, date_added)
SELECT customer_id, store_id, firstname, lastname, email, telephone, fax, password, cart, newsletter, address_id, status, approved, customer_group_id, ip, date_added FROM velho.customer;

INSERT into novo.oc_manufacturer (manufacturer_id, name, image, sort_order)
SELECT manufacturer_id, name, image, sort_order FROM velho.manufacturer;

INSERT into novo.oc_news (news_id, news_date, image, display_image, status)
SELECT news_id, news_date, image, display_image, status FROM velho.news;

INSERT into novo.oc_news_description (news_id, language_id, title, description)
SELECT news_id, language_id, title, description FROM velho.news_description;

INSERT into novo.oc_news_to_store (news_id, store_id)
SELECT news_id, store_id FROM velho.news_to_store;

INSERT into novo.oc_order(order_id, invoice_no, invoice_prefix, store_id, store_name, store_url, customer_id, customer_group_id, firstname, lastname, telephone, fax, email, shipping_firstname, shipping_lastname, shipping_company, shipping_address_1, shipping_address_2, shipping_city, shipping_postcode, shipping_zone, shipping_zone_id, shipping_country, shipping_country_id, shipping_address_format, shipping_method, payment_firstname, payment_lastname, payment_company, payment_address_1, payment_address_2, payment_city, payment_postcode, payment_zone, payment_zone_id, payment_country, payment_country_id, payment_address_format, payment_method, comment, total, order_status_id, language_id, currency_id, currency_code, currency_value, date_modified, date_added, ip)
SELECT order_id, invoice_id, invoice_prefix, store_id, store_name, store_url, customer_id, customer_group_id, firstname, lastname, telephone, fax, email, shipping_firstname, shipping_lastname, shipping_company, shipping_address_1, shipping_address_2, shipping_city, shipping_postcode, shipping_zone, shipping_zone_id, shipping_country, shipping_country_id, shipping_address_format, shipping_method, payment_firstname, payment_lastname, payment_company, payment_address_1, payment_address_2, payment_city, payment_postcode, payment_zone, payment_zone_id, payment_country, payment_country_id, payment_address_format, payment_method, comment, total, order_status_id, language_id, currency_id, currency, value, date_modified, date_added, ip FROM velho.order;

INSERT into novo.oc_order_history (order_history_id, order_id, order_status_id, notify, comment, date_added)
SELECT order_history_id, order_id, order_status_id, notify, comment, date_added FROM velho.order_history LIMIT 0, 10000;

INSERT into novo.oc_order_status (order_status_id, language_id, name)
SELECT order_status_id, language_id, name FROM velho.order_status;

INSERT into novo.oc_product (product_id, model, sku, location, quantity, stock_status_id, image, manufacturer_id, shipping, price, tax_class_id, date_available, weight, weight_class_id, length, width, height, length_class_id, status, date_added, date_modified, viewed, sort_order, subtract, minimum)
SELECT product_id, model, sku, location, quantity, stock_status_id, image, manufacturer_id, shipping, price, tax_class_id, date_available, weight, weight_class_id, length, width, height, length_class_id, status, date_added, date_modified, viewed, sort_order, subtract, minimum FROM velho.product WHERE product_id = 49;

INSERT into novo.oc_product_description(product_id, language_id, name, meta_keyword, meta_description, description)
SELECT product_id, language_id, name, meta_keywords, meta_description, description FROM velho.product_description;

INSERT into novo.oc_user (user_id, user_group_id, username, password, firstname, lastname, email, status, ip, date_added)
SELECT user_id, user_group_id, username, password, firstname, lastname, email, status, ip, date_added FROM velho.user;

INSERT into novo.oc_user_group (user_group_id, name, permission)
SELECT user_group_id, name, permission FROM velho.user_group;