Totally Zenned
- Join Date:
- Jan 2007
- Posts:
- 1,514
- Plugin Contributions:
- 1
My Add-On for MAP (minimum advertised price).
webskipper:
I do not. I am using the Map price contribution though. There must be a way to use MAP price as the default.
To change the product creation MAP field to always ON when you are adding a new product through the admin you can make a small change in the database, changing the MAP setting from 0 (off) to 1 (on). It is in the table products and the column to edit is map_enabled. Click the pencil icon in the map_enabled row and change the value from 0 to 1.
You can also change this for existing products by running this sql command in phpmyadmin or a similar database control program:
UPDATE TABLE products SET map_enabled=1;
This will change all products to map being on. If you only want some products to have map enabled you need to run this:
UPDATE TABLE products SET map_enabled=1 WHERE manufacturer_id=(whatever manufacturer you want);
If you are using prefixes you would need to change the table name, for instance zen_products.
you can change manufacturer_id to any of the other columns in the products table that will help you filter the products you want to change. For instance, if you use an identifying code as part of the model number you could put WHERE products_model=(whatever)
As always, you should back up the table before doing any modifications to it!
