RRP Along side product price?

[NathanielB]

Hello,

I would like to add the RRP along side product price on the home page, category pages and product pages, but...

I can't use the salemaker or specials in admin as I already use these for sales and month specials. So I am in need of an extra files in the admin area where I can input the RRP price as well as Net and Gross price for each product because I also have to add VAT on some products so cant use that.

So in short, could someone link me to a module that will add an RRP price field in admin which will display the RRP site wide next to each product please?

Kind Regards,
Nathaniel

[schoolboy]

http://www.zen-cart.com/index.php?ma...oducts_id=1140

[NathanielB]

Thanks for the uber fast reply schoolboy!

I had a look at that just before I started the thread but wasn't sure if that was the best option as you have to make changes to the main files (If I read it correctly?) so I wasn't sure if that was my best option because wouldnt I need to keep making those same edits each time and update/patch comes out for zen cart? Or have I read the instructions a little wrong on that mod?

Just let me know if thats a safe option that shouldnt need editing each time zen is patch, if it is ok, then I will install and use that :)

[schoolboy]

Some modules have to OVER-WRITE core files in order to work. It can't be helped.

When you install a module that replaces core files (ie: files for which there is no over-ride mechanism) it is best practice to MAKE NOTES and archive those notes, of the files involved.

We have used MSRP on several sites on ZC 1.3.9h and have not experienced problems with it.

What you SHOULD do, is, rather than OVER-WRITE the core files involved, you should RE-NAME the core files by changing their file extension from .php to .BAK.

Just go through the module's directories, find all the files that have no over-ride (ie: those that would otherwise be over-written), and on the server, give their server counterpart files the .BAK extension.

Then, when you have "BAKed up" all the files on the server, load the module's files to the server.

If there are SQL patches, BACKUP the database before you run any SQL patches.

After backing up the database, run any sql via: admin >>> tools >>> install sql patches.

[NathanielB]

kk thanks, just want to the reassurance I think :)

i always take a full backup of my files and db before adding any mods or making changes to files and the db so I know if something does go wrong I can simple delete and replace everything with my backups. Thanks again for the extra details and reassurance I was looking for to let me know this is the right and best script for what Im after.

[NathanielB]

Thanks schoolboy, I got it installed just fine in a couple of minuets :)

Now I just need to get adding the RRP to each products. Do you know if there is a way for telling zen to put -15% in the RRP price box on all product in xyz category?

[NathanielB]

Cant edit the above, but if I cant tell zen to - the 15% from the RRP, would it be easier if I was to do that in my csv before uploading it to my store? IE I would now download my store cvs and make the sum in that to re-do the pricing and re-upload.

*edit*
Lol now its given me the option to edit this post and the latest one above, sorry for multi posts, but I couldnt see the edit button here until now

[schoolboy]

Thanks schoolboy, I got it installed just fine in a couple of minuets :)

Now I just need to get adding the RRP to each products. Do you know if there is a way for telling zen to put -15% in the RRP price box on all product in xyz category?

Your RRP will be HIGHER than your selling price, so you don't want to SUBTRACT 15%... You want to ADD 15% to the value held in the MSRP field.

If your price is $10.00

Then...

Your MSRP should be higher... $11.50 (10 + 15%).

It's a while since I used this module, but I think it create a field in the products table of the database, called "products_msrp".

PLEASE CHECK YOUR DATABASE to see if indeed this field is present. (You can see it using phpMyAdmin via your cPanel for your webhost.)

If there is a field called products_msrp, you can run a short piece of SQL to add a value to that field:

BACKUP YOUR DATABASE BEFORE RUNNING THIS SCRIPT!

UPDATE `products` SET `products_msrp`=`products_price`*1.15

*1.15 is the mathematical way of saying "add fifteen percent" to another value. In our case, it t means "MULTIPLY the products_price value by 1.15, and put the result into the products_msrp field."

The best place to run this script is in your zencart admin panel, under TOOLS >>> INSTALL SQL PATCHES.

BACKUP THE DBASE FIRST!

[NathanielB]

Thanks for the db code for that, but I found a tut on how to add it to my csv file and done it that way :)

i have to do it around that way as I start with the RRP prices in my csv, so I made a new column "v_product_msrp" to the right of "v_products_price", moved the prices to this new column and then need took 15% off all the prices in excel.

Along with that, I had to edit easypopulate.php to add to tell it about the new column.

Here is the tut I followed if anyone else ever needs to do this: http://www.zen-cart.com/forum/showthread.php?t=116061