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
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.
Re: MSRP Display Mod / phpMyAdmin edit problem
Quote:
Originally Posted by
stevesh
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?
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 ?
Re: MSRP Display Mod / phpMyAdmin edit problem
Quote:
Originally Posted by
stevesh
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.
Re: MSRP Display Mod / phpMyAdmin edit problem
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.
Re: MSRP Display Mod / phpMyAdmin edit problem
Quote:
Originally Posted by
stevesh
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 !
:smartalec:Thank you for so much help...and thank God for Zen Cart !