MSRP contrib

[EAPerformanceParts]

Tried to download this mod and some jibberish code pops up, any ideas?

I was able to download the earlier version but it says there was a bug.

[EAPerformanceParts]

Also I dont quite understand the the first thing to do. Help please.

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

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

(If you have not chosen a Table Prefix in your zencart installation, then change the 'tableprefix_products' to 'products'. If you have a Table Prefix, then replace 'tableprefix' with your custom one. If you are unsure, try just putting in 'products', and if it fails view your SQL Table and you should be able to find 'yourprefix_products'.)

[EAPerformanceParts]

Anyone?

[smoke133]

All you do is copy and paste that line into Admin / Tools / Install SQL Patches inside your store admin.

If you created a prefix when you set up your store, something like zencart, then the line would look like this:

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

If you don't have a prefix then it would look like this:

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

[EAPerformanceParts]

TUVM

It took a little while to enter everything, but I actually did it right and it worked!!

Thanks again!

[BoutiqueMusic]

All you do is copy and paste that line into Admin / Tools / Install SQL Patches inside your store admin.

If you created a prefix when you set up your store, something like zencart, then the line would look like this:

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

If you don't have a prefix then it would look like this:

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

How would I do this in phpMyAdmin? I added the "zen_products_msrp" field but I dont understand where to add the "AFTER `products_price` ;" bit

A created the "zencard_products_msrp" field with the type being a decimal and added the 15,4 length/value and selected not null and that is where i got stuck.

[BoutiqueMusic]

How would I do this in phpMyAdmin? I added the "zen_products_msrp" field but I dont understand where to add the "AFTER `products_price` ;" bit

A created the "zencard_products_msrp" field with the type being a decimal and added the 15,4 length/value and selected not null and that is where i got stuck.

I also tried adding the table in the Install SQL Patches thing and apparently I don't have a `products_price` field.....

Help.....

[BoutiqueMusic]

Nevermind...I'm an idiot.

I got it to work by taking the "zencart_" out of the statement and the Admin tool worked perfectly.

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

[neboztik]

Hi, thx for your contribution. I need your help. I'd really appreciate if I could display MSRP only on product listing page. Would you mind to make this code for me?

[CnTGifts]

Is it possible to not have the section that says You save: so much %

I just want it to lsit the MSRP price