Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Sep 2019
    Location
    Montana
    Posts
    12
    Plugin Contributions
    0

    Default How hard is it to change a template when you have SQL patches in the system?

    Hi all!

    The business I work for uses a Zen Cart page that looks... well, like it's from 2001.

    We hired a guy who manages it and hosts it on his server. I asked him if he could change the template to something more modern, but he says it's extremely difficult; it's a wholesale business, so the business paid him to write patches that would make price breaks when a person buys more. (Like if you buy 24 of something it's 5.99 each, if you by 60 of something, you get them for 4.99.) He says that changing it would make the site go screwy.

    I've seen the template we have installed looking much nicer than it does on our site. It's "##########" theme. It looks great on sample pages I've seen - responsive, makes good use of space, has a carousel banner, etc. However, ours looks like an old Geocities site and is *somewhat* responsive, but when you shrink your window, some things awkwardly overlap.

    Is it really as hard to update as he says it is? I'm just a designer and know very little about SQL... Like, I don't even know enough to know what I don't know.

    Are we stuck with our embarrassingly bad website for all eternity?

    Thanks so much! I really appreciate any input on this!!

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

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    We hired a guy who manages it and hosts it on his server.
    First thing is to get it 100% under your control...then allow him access as necessary.
    Next make a copy on another server, delete your customer and order data and get another developer to do what you want.
    Steve
    github.com/torvista: Spanish Language Pack, Image Checker, Structured Data, BackupMySQL Admin/Auto, Product Listing Sorter, Redsys payment module...

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,696
    Plugin Contributions
    262

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Steve is correct. Hire someone to move your site to another server and do the changes. There are lots of people on this forum that do that kind of work all the time without "making the site go screwy."
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  4. #4
    Join Date
    Sep 2019
    Location
    Montana
    Posts
    12
    Plugin Contributions
    0

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Quote Originally Posted by torvista View Post
    First thing is to get it 100% under your control...then allow him access as necessary.
    Next make a copy on another server, delete your customer and order data and get another developer to do what you want.
    Thanks for the response! That seems like the best way to go about it. Can you use Google Drive or something like that instead of a server? Or, do I absolutely need my own server?

  5. #5
    Join Date
    Sep 2019
    Location
    Montana
    Posts
    12
    Plugin Contributions
    0

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Quote Originally Posted by swguy View Post
    Steve is correct. Hire someone to move your site to another server and do the changes. There are lots of people on this forum that do that kind of work all the time without "making the site go screwy."
    Yeah, that's what I was thinking. Thanks for the confirmation!

  6. #6
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,696
    Plugin Contributions
    262

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Quote Originally Posted by Clover View Post
    Thanks for the response! That seems like the best way to go about it. Can you use Google Drive or something like that instead of a server? Or, do I absolutely need my own server?
    To be clear, when people say "your own server" they mean an account on a commercial hosting service. There are any number of companies that provide Zen Cart hosting; you can see one list by clicking the Services link at the top of the forum page. It takes you here: https://www.zen-cart.com/content.php?3-services
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  7. #7
    Join Date
    Sep 2019
    Location
    Montana
    Posts
    12
    Plugin Contributions
    0

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Quote Originally Posted by swguy View Post
    To be clear, when people say "your own server" they mean an account on a commercial hosting service. There are any number of companies that provide Zen Cart hosting; you can see one list by clicking the Services link at the top of the forum page. It takes you here: https://www.zen-cart.com/content.php?3-services
    oh, okay. I set up a zen cart on cPanel through namecheap a few months ago (just to try to wrap my head around zen cart without messing up the company's site.) I guess I just thought that wasn't the typical way; When I asked the guy we hired where our zen cart files were actually located, he said "my own server" so, I wasn't super sure what he meant by that. I thought it was on his own physical server.

  8. #8
    Join Date
    Jan 2014
    Location
    Ontario, Canada
    Posts
    251
    Plugin Contributions
    3

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Clover,

    Working with a highly customized zen cart can be a bit tricky. Hopefully 'your guy' coded with proper use of the template overwrite system. That will make it easier to find your custom information. There's a great wholesale module in the plugins section - Twitch Wholesale with Twitch Wholesale Attributes that doesn't require SQL scripts to make the site work.

    You can have a great responsive AND current website without compromise.

    You or the business you work for should have access to the website files on 'your guys' server. If you make a copy of the files, you can use them on your own 'testing' server.

    Let us know if you need more help.

  9. #9
    Join Date
    Jul 2012
    Posts
    14,697
    Plugin Contributions
    17

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    While not every single plugin requires some sort of sql to support operation, if something has settings (on/off, display this or not, apply to this characteristic, etc.) there is some amount of sql involved. How that is incorporated (separate sql file or as some part of an install/remove script) can be different. Also, if the software is to interface with the database in any way (get a price, set a price, identify information about something) then sql will be involved. As trinity14 called out about use of the override system, there are other coding aspects that should have been implemented at least after initial development to streamline use and reusability where those things may have involved sql statements.

    Long and short, sql will most likely be involved and should not be a "selling" point and would say involved some amount of miscommunication/understanding related to the current developer.

    As pointed out earlier, it certainly is important to have/regain full access to all things related to the site and to make backups both in case something happens and to support independent development.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  10. #10
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,696
    Plugin Contributions
    262

    Default Re: How hard is it to change a template when you have SQL patches in the system?

    Quote Originally Posted by Clover View Post
    When I asked the guy we hired where our zen cart files were actually located, he said "my own server" so, I wasn't super sure what he meant by that. I thought it was on his own physical server.
    He might well have his own physical server. You don't need to - you can get a hosting company to provide that as a service to you. You want a managed Linux hosting account (with CPanel) so they take care of the details of server upgrades and management for you.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. How do you increase the large image pop-up window when you have an image border?
    By Sawhorse in forum Templates, Stylesheets, Page Layout
    Replies: 12
    Last Post: 15 Apr 2009, 06:03 PM
  2. How do I change the contents of the Sponsors, Have You Seen, and other side boxes
    By agentx in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 28 Dec 2008, 11:26 AM
  3. Replies: 1
    Last Post: 5 Jul 2008, 09:06 PM
  4. Replies: 2
    Last Post: 3 Jul 2007, 06:39 PM
  5. How do I run the stock_attribute.sql via Install SQL Patches in admin
    By vivaraquel in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 9 Apr 2007, 01:55 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