Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2006
    Location
    Worcester, MA
    Posts
    453
    Plugin Contributions
    0

    Default rolling out new design/config options

    Hello,

    I've been working on a customized version of responsive classic template in a testing copy of my client's store. I've got everything just about how they want it and I'm planning to bring the new design over into their live store. I'm pretty confident on what I need to do as far as the template files and other customized php files and css files.

    However, in addition to file customizations, I've made a number of changes to config options (images sizes, columns, sort order of fields in product listings etc). I'm really hoping I don't have to comb through every admin setting and re-do all of these in the live store. Of course I also can't bring over the entire database from the testing store because the products, customers and order info is old. Can I just import certain tables from the testing/redesigned store? If so, which ones would I need?

    Thanks for any advice on this.
    Ellie Armsby

  2. #2
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    Default Re: rolling out new design/config options

    >Can I just import certain tables from the testing/redesigned store? If so, which ones would I need?
    No, that is the road to madness.

    What I would do is make list of SQL queries for all the changes, to run in the SQL patch tool/phpMYadmin all at once:
    #increase listing
    UPDATE configuration SET configuration_value = '20' WHERE configuration_key = 'MAX_ROW_LISTS';

    It is possible to show the name of the constant (
    configuration_key) you are editing, to help you build your query:
    https://github.com/zencart/zencart/issues/3293
    Steve
    github.com/torvista: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  3. #3
    Join Date
    Oct 2006
    Location
    Worcester, MA
    Posts
    453
    Plugin Contributions
    0

    Default Re: rolling out new design/config options

    So, sounds like yes I will need to go through all the config menus to see where I made changes?
    Ellie Armsby

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,622
    Plugin Contributions
    123

    Default Re: rolling out new design/config options

    You can automate this - SELECT configuration_key, configuration_value FROM configuration on both databases, and then compare. That will tell you what you need to update.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  5. #5
    Join Date
    Oct 2006
    Location
    Worcester, MA
    Posts
    453
    Plugin Contributions
    0

    Default Re: rolling out new design/config options

    Quote Originally Posted by swguy View Post
    You can automate this - SELECT configuration_key, configuration_value FROM configuration on both databases, and then compare. That will tell you what you need to update.
    Ah great. That makes sense and much easier than poking through each menu trying to compare.
    Ellie Armsby

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,622
    Plugin Contributions
    123

    Default Re: rolling out new design/config options

    also remember that if you create a csv in the opposite order

    configuration_value, configuration_key

    You can build SQL Updates statements from this easily.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  7. #7
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    2,668
    Plugin Contributions
    11

    Default Re: rolling out new design/config options

    Quote Originally Posted by earmsby View Post
    Ah great. That makes sense and much easier than poking through each menu trying to compare.
    i love sql...

    if you put your test configuration with the new values in a table called configuration_new, you can use something like this to find the changed values:

    Code:
    select cn.configuration_key, cn.configuration_value, c.configuration_value from configuration_new cn
    left join configuration c
    on cn.configuration_key = c.configuration_key
    where cn.configuration_value <> c.configuration_value
    of course you could just import the whole configuration table, but i'm not sure if there are values in your test side that you do not want.
    author of square Webpay.
    mxWorks has premium plugins. donations: venmo or paypal accepted.
    premium consistent excellent support. available for hire.

 

 

Similar Threads

  1. Config options question
    By sofasurfer in forum Basic Configuration
    Replies: 2
    Last Post: 2 Apr 2011, 02:47 AM
  2. Rolling out abroad
    By ink in forum General Questions
    Replies: 0
    Last Post: 27 Dec 2009, 10:24 PM
  3. New install no includes/dist-config or admin/dist-config files?
    By retroboutiques in forum Installing on a Linux/Unix Server
    Replies: 9
    Last Post: 7 Dec 2007, 07:54 AM
  4. Config > Product Listing > Missing options 1.3.6
    By inksale in forum Basic Configuration
    Replies: 2
    Last Post: 18 Dec 2006, 04:41 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