Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2010
    Posts
    328
    Plugin Contributions
    0

    Default MSRP Display Mod / phpMyAdmin edit problem

    Installing the MSRP Display Mod, the first step is as follows:

    1. Add a new field to the products table to hold the MSRP value.

    ALTER TABLE products ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;


    First, I can't find the field products_price in the database list to add the new products_msrp field after it.

    Second, I can't seem to add the new products_msrp field anywhere.

    Any ideas what I'm doing wrong ?

    Thanks for any help,
    Bob
    I await your thoughtful response.
    Thank you

  2. #2
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    It's in the products table, but it doesn't matter. Copy that SQL patch

    ALTER TABLE products ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;

    and Paste it into the big box in Admin - Tools - Install SQL Patches and click Send.

  3. #3
    Join Date
    Feb 2010
    Posts
    328
    Plugin Contributions
    0

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    Quote Originally Posted by stevesh View Post
    It's in the products table, but it doesn't matter. Copy that SQL patch

    ALTER TABLE products ADD `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER `products_price` ;

    and Paste it into the big box in Admin - Tools - Install SQL Patches and click Send.
    Thank you and well done, but while in the admin's add product to a given category, there is no MSRP fields showing?
    I await your thoughtful response.
    Thank you

  4. #4
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    I just installed it on one of my test sites, and it works fine.

    A couple of things to check:

    Did you rename the includes/languages/english/extra_definitions/your_template folder in the mod to the name of your custom template before uploading ?

    Did you rename the admin folder in the mod to the name of your admin folder before uploading ?

  5. #5
    Join Date
    Feb 2010
    Posts
    328
    Plugin Contributions
    0

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    Quote Originally Posted by stevesh View Post
    I just installed it on one of my test sites, and it works fine.

    A couple of things to check:

    Did you rename the includes/languages/english/extra_definitions/your_template folder in the mod to the name of your custom template before uploading ?

    Did you rename the admin folder in the mod to the name of your admin folder before uploading ?
    But there's only the includes to upload, so what do you mean? And yes on the renaming the template folder.
    I await your thoughtful response.
    Thank you

  6. #6
    Join Date
    Feb 2010
    Posts
    328
    Plugin Contributions
    0

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    oopz, hold on
    I await your thoughtful response.
    Thank you

  7. #7
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    No, there's also an 'admin' folder in the mod that needs to be renamed to the name of your admin folder and uploaded to the root of your site.

  8. #8
    Join Date
    Feb 2010
    Posts
    328
    Plugin Contributions
    0

    Default Re: MSRP Display Mod / phpMyAdmin edit problem

    Quote Originally Posted by stevesh View Post
    No, there's also an 'admin' folder in the mod that needs to be renamed to the name of your admin folder and uploaded to the root of your site.
    PERFECT !

    Thank you for so much help...and thank God for Zen Cart !
    I await your thoughtful response.
    Thank you

 

 

Similar Threads

  1. v151 MSRP Display Mod
    By Larry0652 in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 26 Oct 2017, 12:36 PM
  2. v151 Problem installing MSRP display
    By SilverHD in forum All Other Contributions/Addons
    Replies: 13
    Last Post: 17 Oct 2017, 04:06 AM
  3. v150 MSRP Display edit
    By timhersh in forum All Other Contributions/Addons
    Replies: 24
    Last Post: 1 Nov 2012, 05:32 AM
  4. Problem with Edit Orders Mod
    By alistever in forum General Questions
    Replies: 0
    Last Post: 13 Mar 2010, 04:13 AM
  5. MSRP Mod Help Please!
    By CRYSTALDOLL in forum All Other Contributions/Addons
    Replies: 10
    Last Post: 5 Aug 2009, 06:58 PM

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