Creloaded database to Zencart database 1.3.8a

I was looking in the forum and found a script I will include down of this text. I did work like a charm but one big problem! it somehow broken the multi Languages support! In creloaded and zen-cart I got the same Languages settings (English (Site default) en and Español es).

Now when I go to Categories / Products I see all my categories and products without problem that is till I change the language tap to Español what does not show any product or categorie.... Also when I am in the English part and try edit in the Español part it does not save!! Please help me!

Here is the SQL code I use to clear out the zencart tables and then populate it with the data from the osc/cre tables.

TRUNCATE TABLE zencart.customers;
INSERT INTO zencart.customers (customers_id, customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_default_address_id, customers_telephone, customers_fax, customers_password, customers_newsletter) SELECT customers_id, customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_default_address_id, customers_telephone, customers_fax, customers_password, customers_newsletter from creloaded.customers;

TRUNCATE TABLE zencart.categories;
INSERT INTO zencart.categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) SELECT categories_id, categories_image, parent_id, sort_order, date_added, last_modified from creloaded.categories;

TRUNCATE TABLE zencart.categories_description;
INSERT INTO zencart.categories_description (categories_id, language_id, categories_name, categories_description) SELECT categories_id, language_id, categories_name, categories_description from creloaded.categories_description;

TRUNCATE TABLE zencart.products;
INSERT INTO zencart.products (products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered) SELECT products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered from creloaded.products;

TRUNCATE TABLE zencart.products_description;
INSERT INTO zencart.products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) SELECT products_id, language_id, products_name, products_description, products_url, products_viewed from creloaded.products_description;

TRUNCATE TABLE zencart.products_to_categories;INSERT INTO zencart.products_to_categories (products_id, categories_id) SELECT products_id, categories_id from creloaded.products_to_categories;TRUNCATE TABLE zencart.customers_info;INSERT INTO zencart.customers_info (customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified, global_product_notifications) SELECT customers_info_id, customers_info_date_of_last_logon, customers_info_number_of_logons, customers_info_date_account_created, customers_info_date_account_last_modified, global_product_notifications from creloaded.customers_info;TRUNCATE TABLE zencart.manufacturers;INSERT INTO zencart.manufacturers (manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified) SELECT manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from creloaded.manufacturers;

TRUNCATE TABLE zencart.orders;
INSERT INTO zencart.orders (orders_id, customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, last_modified, date_purchased, orders_status, orders_date_finished, currency, currency_value, paypal_ipn_id) select orders_id, customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, last_modified, date_purchased, orders_status, orders_date_finished, currency, currency_value, paypal_ipn_id from creloaded.orders;

TRUNCATE TABLE zencart.address_book;
INSERT INTO zencart.address_book (address_book_id, customers_id, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id ) SELECT address_book_id, customers_id, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id from creloaded.address_book;TRUNCATE TABLE zencart.customers_basket;INSERT INTO zencart.customers_basket (customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added) SELECT customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added from creloaded.customers_basket;TRUNCATE TABLE zencart.orders_products;INSERT INTO zencart.orders_products (orders_products_id, orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity) SELECT orders_products_id, orders_id, products_id, products_model, products_name, products_price, final_price, products_tax, products_quantity from creloaded.orders_products;

TRUNCATE TABLE zencart.orders_status_history;
INSERT INTO zencart.orders_status_history (orders_status_history_id, orders_id, orders_status_id, date_added, customer_notified, comments) SELECT orders_status_history_id, orders_id, orders_status_id, date_added, customer_notified, comments from creloaded.orders_status_history;TRUNCATE TABLE zencart.orders_total;INSERT INTO zencart.orders_total (orders_total_id, orders_id, title, text, value, class, sort_order) SELECT orders_total_id, orders_id, title, text, value, class, sort_order from creloaded.orders_total;

Like no one answer... I found the problem my self it was all about the Language ID!

my creloaded lang ID was set to 1 and 5 and my Zencart Lang ID was set to 1 and 2.:oops:

I did restore my backup database for Zen-cart and make the quick Id change in the Language table. And import the data again and this time everything did work out great!! :smartalec:

:clap::clap::clap::clap::clap:

Thanks for the update and for sharing the solution!! :smile:

were can i find this add on
thanks
henry

Hi,

I also have to transfer a CREloaded database to Zencart. Is somebody know if there is a tool to do that or have the procedure to do it without loosing data between both:blink:

Thanks in advance for your help

I am working on CRE to ZEN but the time frame is out a bit. I have 5 or 6 more osc sites to do before I start on the cre sites. It will work the same as OsCommerce Data Importer.

Hi,

Is somebody have or can explain the process to move from Creloaded to Zencart 1.3.8

I read many post about this subject but it's still confused for me.

A small step by step should be useful and help people like me :unsure:

thanks in advance for your help

Greg

mtgt:

Hi,

Is somebody have or can explain the process to move from Creloaded to Zencart 1.3.8

Greg

1. Install your new Zen Cart
   You can find help here for this Tutorials
   and Wiki

2. You now backup all your CRE Loaded and all Zen Cart data.

3. Once you have completed all your backups. You can use this mod to move your old CRE data CRE Loaded to Zen Cart Data Importer to your new Zen Cart.

Skip

Thanks Skipwater,

I try that and I tell you if it's work well for me :smile:
when you write data, you mean whole website r the database s enough ?

Thanks again

Greg

mtgt:

when you write data, you mean whole website r the database s enough ?

Thanks again

Greg

the database s

Skip

thanks for your quick answer

you are the man :thumbsup: