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
    19,723
    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
    19,723
    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
    19,723
    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. MSRP Addon Problem?
    By AirsoftOutfitter in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 7 Jun 2011, 08:08 PM
  2. MSRP Color Problem Solved
    By Little Red Crane in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 10 May 2010, 08:07 PM
  3. Msrp display issue
    By CRYSTALDOLL in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 10 Aug 2009, 02:40 PM
  4. Anyone successful make the "Group Pricing (Per Item)" & "MSRP Display" togther?
    By explorer1979 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 12 Dec 2008, 08:37 AM
  5. phpMyAdmin/mySQL data export problem
    By isaacr25 in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 13 Nov 2007, 05:45 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
  •