Results 1 to 10 of 12

Hybrid View

  1. #1
    Join Date
    Dec 2011
    Posts
    13
    Plugin Contributions
    0

    Default Importing new customers and orders since original database upgrade

    Since I originally installed v1.5, completed the database upgrade and installed the necessary mods for my new v1.5 cart I have had several orders and new customer registrations on my live 1.3.9 site.

    If I run the DB upgrade again will this cause any issues with the mods that have been installed since I originally ran the upgrade?

    Or should I somehow import only the customers and orders from my 1.3.9 DB to my 1.5 DB? (this post makes me think that's a very bad idea http://www.zen-cart.com/showthread.p...mport-Database)


    Any help would be greatly appreciated, I have read the FAQs and searched this forum but I can't seem to find this specific question... Please point me in the right direction if I have missed something!
    Last edited by jwduke3d; 20 Apr 2012 at 06:25 PM.

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: Importing new customers and orders since original database upgrade

    Fiddling with the database via phpMyAdmin is NOT recommended for the purpose you describe. There are just too many relationships between tables, ID's and fields, for your "fix" to work. It would be easier to:

    1. Put your 1.3 AND your 1.5 stores into maintenance mode. (Stops any more writing to dbase while you fix things)
    2. Link the OLD database with the new install. Put into maintenance mode too. Upgrade dbase. Reconfig any addons.
    3. leave 1.3 store in maintenance mode.
    19 years a Zencart User

  3. #3
    Join Date
    Dec 2011
    Posts
    13
    Plugin Contributions
    0

    Default Re: Importing new customers and orders since original database upgrade

    Quote Originally Posted by schoolboy View Post
    Fiddling with the database via phpMyAdmin is NOT recommended for the purpose you describe. There are just too many relationships between tables, ID's and fields, for your "fix" to work. It would be easier to:

    1. Put your 1.3 AND your 1.5 stores into maintenance mode. (Stops any more writing to dbase while you fix things)
    2. Link the OLD database with the new install. Put into maintenance mode too. Upgrade dbase. Reconfig any addons.
    3. leave 1.3 store in maintenance mode.
    Thanks for the reply schoolboy!

    I made this bed and it looks like I will have to lay in it!

    Just so i'm clear as a very last step to my upgrade process (in an attempt to limit downtime) I should (while both carts are in Mx mode)...

    1. link the old DB to the new v1.5 cart
    2. run the upgrade
    3. Run each of the SQL patches for the mods I have installed? and configure for use again.


    Thanks again for the quick response!

  4. #4
    Join Date
    Nov 2006
    Location
    Dartmouth, NS Canada
    Posts
    2,378
    Plugin Contributions
    0

    Default Re: Importing new customers and orders since original database upgrade

    Something I like to do in this circumstance... while in the 1.3.9h admin, print out the several key Configure screens -- such as Layout Settings, Index Listing, Product Info, as well as any from the Modules, Localization, and other menus -- so you can quickly reset everything once you've got your old database into your new 1.5.0 install. You don't need to waste a lot of paper doing this, just print to PDF, or even copy and paste to your text editor -- anything just so you have a convenient way to recover all those little settings you may need. Somebody (who knows what they're doing better than I) could perhaps make a mod for this. Easy for me to say.

    Rob

  5. #5
    Join Date
    Dec 2011
    Posts
    13
    Plugin Contributions
    0

    Default Re: Importing new customers and orders since original database upgrade

    Thanks for the tip rob. I'm will certainly be doing something along those lines. I think the biggest issue im going to run into is the move from SSU to CEON. I had to manually input about 75 URIs into phpMyAdmin as to avoid tons of 301 redirects. I will attempt to save the CEON uri table before changing over databases. Hopefully it will import without problems.

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Importing new customers and orders since original database upgrade

    If it were me, I'd treat your 1.5.0 site that you've been staging as just that: a staging and testing area, which you throw away after you REDO your upgrade on your live site. The "redo" is way simpler because you've already done it and have detailed notes of all that you've done to prepare and test it.

    Always safer to do it that way than to import data the opposite direction, especially since the structures are different etc.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Importing and exporting: Orders, reviews, and customers list
    By shortysclimbin in forum General Questions
    Replies: 2
    Last Post: 20 Jun 2011, 06:29 PM
  2. importing customers and orders
    By volkswest in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 15 Feb 2010, 05:43 AM
  3. Replies: 0
    Last Post: 27 Aug 2008, 02:22 PM
  4. Importing old customers and orders into new cart
    By Siren Sub in forum Basic Configuration
    Replies: 0
    Last Post: 29 Nov 2006, 09:46 PM
  5. New Orders not displaying since upgrade
    By eschwenke in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 21 Oct 2006, 04:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR