Un-do SQL Patch for MAP Pricing addon?

Hi, I'm using Zen V1.5.0 with abagon red template. I have NOT installed this add-on yet because It doesn't have uninstall instructions, and it is written for V1.3.6. .. I can easily back up my database files, and re-install them for a back-up, but I don't know how to reverse the SQL change.. the add-on is "MAP Pricing ( m.a.p ) : Add to Cart to See Price" which I REALLY need. The install just requires a few database uploads, and THIS SQL patch.

ALTER TABLE products ADD map_enabled TINYINT NOT NULL DEFAULT '0' AFTER products_priced_by_attribute ,
ADD map_price DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.00' AFTER map_enabled ;

If I install this add-on and it jacks up my website, I want to make sure that I can reverse it. What do I do to un-install this patch in the event that I need to???? Thanks oh, my website is https://www.stageandtheaterlighting.com if you need that info..

Strictly speaking, based ONLY on the SQL statement you quoted, this would undo THAT STATEMENT ONLY:```
alter table products drop map_enabled;
alter table products drop map_price;

Do be mindful that if the addon has ANY admin-side controls, and isn't designed for v1.5.0 yet, then installing it on v1.5.0 is going to leave you WITHOUT any of its menu options, so you will have no control over its operation.

hmmmm. well it does have admin side controls... I mean, just to make sure that you and I are talking about the same thing,, I will post the information about the different versions, and if you don't mind, tell me what you think.... I need to be able to choose if the product will be "m.a.p. pricing" AT the time I add the product.. Thanks!!!!

v 0.1 Jun 10 2006
M.A.P. pricing - manual file-edit instructions based on ZC 1.2.0

v 1.0 Oct 26 2006
You no longer have to do the manual file edits. Just add an SQL patch and edit the function_prices.php file included in this download and then you can just ftp directly to your store. Much less messy that v0.1

v. 1.1 Oct 31 2006
Updated for v1.3.6, and also made the code more modular, and removed the need to hardcode database credentials into the scripts.
Still could use some improvements ... ie: if product is already in cart, price could be displayed, rather than "sorry" text.

v 2.0 Update added on Feb 07 2007
designed for Zen 1.3.6

I've updated the version number in order to reflect a change to the functionality.

In the admin you can now input a display price if you choose to. Called "The MAP Price". If your supplier forces you to display the price they say, instead of just some text like "Add to cart for price", then use this version.

In the language file you can set it up so, it's something like "250.99, but add to cart for an even lower price."

Please note though, that you still have the ability to not display any price by simply leaving the "MAP Price" in the admin to zero. In which case instead of a price you can separately edit the language file to display, "Priced so low, it can't be advertised."

Thank you to the people who made some updates, I've built upon them so that the install is just as easy, and not text based like my original.

something to add.. I was looking at another add-on that was for an earlier version of Zen (v 1.3.8) and I was told by more than one person that it would work with my current v1.5.0 ..(didn't use it because I found SNAF, and I am using that)
The add-on is called "Column Layout / Grid Layout for Products Listing (Add On Module for Zen Cart v1.3.8)" .. it has admin controls... this is from the description of it...

"Open up the admin section of your running cart in your browser
Go to Admin -> Configuration -> Product Listing.

Set the following settings:

A. Product Listing - Layout Style Set the type of layout you want to use. By default, the current Zen Cart layout will be used.
It is called "rows". If you want to use the column and row layout, choose "columns".

B. Product Listing - Columns Per Row If you choose to use the column layout, type in the number of columns you want to show on each row. The default is 3 columns."

My Question (assuming that the people that said this would work with v1.5.0 are correct),, why would this add-on HAVE admin controls in v1.5.0, and the M.A.P. add-on will not have admin controls? I mean, is it an ACROSS-THE-BOARD thing that add-on's for earlier versions have NO admin controls, or is it an individual add-on basis, and you happen to know that the M.A.P. add-on won't have the admin controls.. or none of the above? the reason that I am so persistent is that some of my products ARE M.A.P. products.... and I really need this add-on, and I can't seem to find it anywhere else.. like I said, any help would be greatly appreciated!! Thanks!!
ps. I contacted the author and he basically said (very politely) that he isn't planning on updating this one.. at least not for free.

Johnnycopilot:

something to add.. I was looking at another add-on that was for an earlier version of Zen (v 1.3.8) and I was told by more than one person that it would work with my current v1.5.0 ..(didn't use it because I found SNAF, and I am using that)
The add-on is called "Column Layout / Grid Layout for Products Listing (Add On Module for Zen Cart v1.3.8)" .. it has admin controls... this is from the description of it...

"Open up the admin section of your running cart in your browser
Go to Admin -> Configuration -> Product Listing.

Set the following settings:

A. Product Listing - Layout Style Set the type of layout you want to use. By default, the current Zen Cart layout will be used.
It is called "rows". If you want to use the column and row layout, choose "columns".

B. Product Listing - Columns Per Row If you choose to use the column layout, type in the number of columns you want to show on each row. The default is 3 columns."

My Question (assuming that the people that said this would work with v1.5.0 are correct),, why would this add-on HAVE admin controls in v1.5.0, and the M.A.P. add-on will not have admin controls? I mean, is it an ACROSS-THE-BOARD thing that add-on's for earlier versions have NO admin controls, or is it an individual add-on basis, and you happen to know that the M.A.P. add-on won't have the admin controls.. or none of the above? the reason that I am so persistent is that some of my products ARE M.A.P. products.... and I really need this add-on, and I can't seem to find it anywhere else.. like I said, any help would be greatly appreciated!! Thanks!!
ps. I contacted the author and he basically said (very politely) that he isn't planning on updating this one.. at least not for free.

Easy, the "Column Layout / Grid Layout for Products Listing" mod adds entries to an EXISTING page.
As the page already exists the new entries will also show.

It doesn't try to ADD a NEW PAGE to the admin
This is where other older mods will have problems.
If they add a new page to the admin then this will no longer work, and they will have to use a new method to add the new page.

ok thanks.. so now, here is a list of the pages that are to be uploaded with the M.A.P. add-on. if you look at them, you will see that there is only one file that is to be replaced, and it is not in the admin folder. The rest of the upload doesn't exist. So when you said that " "and they will have to use a new method to add the new page" ", what exactly does that mean? please see below, I have another question about the page to be overwritten.

admin/includes/modules/update_product.php -MY CURRENT DOESN'T HAVE ; admin/includes/modules/product/collect_info.php - MY CURRENT VERSION DOESN'T EVEN HAVE THAT "PRODUCT" FOLDER; and
admin/includes/modules/product/preview_info.php - CURRENT DOESN'T HAVE THE "PRODUCT" FOLDER

and in the Includes folder

includes/functions/functions_prices.php ; MY CURRENT VERSION DOES HAVE THIS FILE... DOES
includes/functions/languages/english/extra definitions/map_pricing; MY CURRENT VERSION DOE NOT EVEN HAVE THIS "ENGLISH" FOLDER
; and includes/functions/custom/css/stylesheet_map_additions MY CURRENT VERSION DOES NOT EVEN HAVE THIS "CUSTOM" FOLDER

ps.... the one file that is to be replaced is includes/functions/languages/english/extra definitions/map_pricing
(QUESTION.. can I, or someone that knows what they are doing "look" or "compare" or whatever at the two pages [my current one, and the one that is supposed to replace it from the M.A.P. upload] and tell me if it will mess anything up.??? and if it is going to, perhaps I can just take the code that I need out of that one page and)? or is this necessary,, assuming that I can get the rest of the upload to work..

Thanks!!!!! ps.. some of my products are M.A.P. , so if i don't have a M.A.P. mod, I will have to list full retail on my items, and they will not sell like that...

Johnnycopilot:

ok thanks.. so now, here is a list of the pages that are to be uploaded with the M.A.P. add-on. if you look at them, you will see that there is only one file that is to be replaced, and it is not in the admin folder. The rest of the upload doesn't exist. So when you said that " "and they will have to use a new method to add the new page" ", what exactly does that mean? please see below, I have another question about the page to be overwritten.

I have never used this mod so am not familiar with it.
In your old admin is there a page devoted exclusively to M.A.P or does it have entries in other pages

Even it does NOT have its own page it will require merging of the old and the new code.

As it hasn't been listed here yet Confirmed Working Mods in 1.5.0

I am assuming that the work required is NOT trivial, otherwise it would have been updated by now, or there hasn't been enough demand for anybody to do it.

If this mod is essential for you you may need to stay with 1.3.9h until someone updates it.
or
You could hire someone to do the modifictions for you.

ok thanks, ,,, I think I better not fool with this one.. Is there something in Zen Cart that will allow me to do this? display something (a message for example) other than price? and then the price show up in the shopping cart?? thanks..

Hi, I am using Zen Cart V1.5.0, with abagon red template. Several of the manufacturers of the products that I sell have M.A.P. Pricing (Manufacturers Advertised Price),, which means that I can not display any price lower than the Manufacturers Suggested Retail Price (or a predetermined price they tell me). No one sells these items at MSRP, so if I display the full suggested retail price in the product description, the items will not sell, as this price is usually much higher price point than I need to sell the item for. Many websites have "add to cart to see price",,, etc.. circuitcity.com, walmart.com,, lots of places.. it is very common,, however, I can't seem to find a way to do this in my Zen Cart. There is an add-on that does this, it's called "MAP pricing add to cart v1.3.8" but it apparently will not work on Zen V1.5.0. I have tried the forum to get help with making the already existing add-on work with no luck. So I was wondering if I can use the attributes to do this? Can someone please help?? Thanks!!!

Johnnycopilot:

Is there something in Zen Cart that will allow me to do this? display something (a message for example) other than price? and then the price show up in the shopping cart??
Not in v1.x
While attributes allow for a "starting at" price, I'm pretty sure they calculate it from the lowest available price, not a Minimum Advertised Price.
You need custom code, or an addon.
If you can't wait for someone to update an existing addon, then hire someone to write one that suits your specific needs.

Thanks, I found this through your other link.. I couldn't find where I typed this because I was searching all threads started by me,, not posts.. thought I typed it as a new thread.. sorry... well anyway,, do you know who/where I would look toward for someone to custom write some code for me? thanks.