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.

Code:
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;