aclm Posted August 28, 2008 Posted August 28, 2008 Ok here is the situation. Client needs to have all customers, products, and categories from multiple OSC sites consolidated into one OSC site. We are using multiple store add on so we do NOT want to just copy the whole database. The point of this is so current customers do not have create a new account when they go to the new site. They will be able to use the same user /pass as they did on the old site. Same goes for the products, we would rather transfer what they have instead of manually having to type them all in again. So I figure: 1. That I would have to copy each table from the old database into the new site. 2. This is a list I believe are all the DB tables I need to transfer. products products_attributes products_attributes_download products_description products_discount_quantity products_notifications products_options products_options_types products_options_values products_options_values_to_products_options products_to_categories product_music_extra product_types product_types_to_category product_type_layout project_version project_version_history customers customers_basket customers_basket_attributes customers_info customers_wishlist categories categories_description Am I correct in my assumption that if I wanted to transfer all customer data, products and categories that those database tables are all I would need? I am asking b/c I want to be sure before I go ahead and do this since it will take some time. Thank you, aclm Building sand castles since 2000.
aclm Posted August 29, 2008 Author Posted August 29, 2008 UPDATE I have figured out how to transfer the products, categories, and customers from an existing and much older form of OSC to a new install of OSC. Make sure you back up your existing database of your new install before implimenting an old database. There are some columns that may be missing so keep that in mind. OSC admin will tell you what columns are missing. Most columns if not all are easy to insert directly into the database since they resort to a default value. Products products_options_values.sql products_options_types.sql products_options_values_to_products_options.sql products_options.sql product_types.sql products_attributes.sql product_type_layout.sql products_to_categories.sql products_description.sql products.sql categories.sql categories_description.sql Customers customers_basket_attributes.sql customers.sql customers_basket.sql customers_info.sql address_book.sql address_format.sql There are other tables that I did not include because they had no values entered. Everyone is different so keep that in mind and check everything. Enjoy. aclm Building sand castles since 2000.
fabian2005 Posted October 14, 2008 Posted October 14, 2008 Hey i am new to escommerce and i would like to know where exactly did you go in order to get the following below: because i want to transfer my data also products_options_values.sql products_options_types.sql products_options_values_to_products_options.sql products_options.sql product_types.sql products_attributes.sql product_type_layout.sql products_to_categories.sql products_description.sql products.sql categories.sql categories_description.sql Customers customers_basket_attributes.sql customers.sql customers_basket.sql customers_info.sql address_book.sql address_format.sql There are other tables that I did not include because they had no values entered. Everyone is different so keep that in mind and check everything. Enjoy. aclm Building sand castles since 2000.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.