helpme:( Posted December 21, 2009 Posted December 21, 2009 So, we are moving customers and products from one catalog to a new one. What parts of our database will need to be imported to our new database in order to retain our current products and customers without having to re-upload hundreds of products and have customers create new accounts. Thanks In Advance for the help. :)
FIMBLE Posted December 21, 2009 Posted December 21, 2009 This depends on the addons installed, if you have and tax zones set up, shipping, newsletters.... the question is general for a precise answer J Why not add the whole DB to the new store? Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
helpme:( Posted December 21, 2009 Author Posted December 21, 2009 Nic, thanks for your response. The new site has a lot of new addons that the older website doesn't. The new website is completely resigned from the older one and we just need to move over the products so we don't need to re-upload the hundreds of products we have. We also would prefer that our customers be moved to the newer site so they don't need to create a new account, just a hassle for some. Thanks again for responding and would appreciate suggestions. Thanks. :)
FIMBLE Posted December 21, 2009 Posted December 21, 2009 you can import the information from the products tables, customer tables, address tables, orders tables, dont know if you have tax differences, or Zones, be very cautious as you can loose records or mess up if you are not. I could not give you a total list as like i said it depends on the addons effecting the Dbas is you old store. When you upload only add the records not the table structure as there well may be differencies especially if your new DB has a lot of addons that places extra columns in your DB or change existing ones. Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
helpme:( Posted December 21, 2009 Author Posted December 21, 2009 dont know if you have tax differences, or Zones, be very cautious as you can loose records or mess up if you are not. We don't have any tax differences, or Zones, installed in the old database. If your referring to shipping modules, the old website went off the flat rate shipping pre-installed in osc, so there was not any shipping mods installed nor any taxes or zones were used. When you upload only add the records not the table structure as there well may be differencies especially if your new DB has a lot of addons that places extra columns in your DB or change existing ones. >_< Sry, but were going to have to be honest, were not experts at php and sql, so when you say "only add the records not the table structure" what might you be referring to. We will be backing up before any alterations, but we just want to do this right the first time without any trouble so we can get going on the next redesign. Thanks again for the help :)
FIMBLE Posted December 21, 2009 Posted December 21, 2009 We don't have any tax differences, or Zones, installed in the old database. If your referring to shipping modules, the old website went off the flat rate shipping pre-installed in osc, so there was not any shipping mods installed nor any taxes or zones were used. >_< Sry, but were going to have to be honest, were not experts at php and sql, so when you say "only add the records not the table structure" what might you be referring to. We will be backing up before any alterations, but we just want to do this right the first time without any trouble so we can get going on the next redesign. Thanks again for the help :) Informaton from the following tables you need to import via phpmyadmin address_book categories categories_description customers *optional* customers_basket *optional*customer_basket_info manufacurers manufacurers_info orders orders_products orders_products_attributes orders_download (if you sell downloads) orders_status orders_status_history order_total products products_attributes (if you have any) products_attributes_download (if you have any) products_description products_notifications products_options products_options_values products_option_values_to_products_options products_to_categories Possibly reviews reviews_description newsletters Hope this helps Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
helpme:( Posted December 23, 2009 Author Posted December 23, 2009 Nic. .¤*¨Thanks¨*¤*¨for¨*¤*¨the¨*¤*¨help¨*¤*¨That's¨*¤*¨just¨*¤*¨what¨*¤*¨we¨*¤*¨needed¨*¤...:)
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.