New Zenner
- Join Date:
- Jan 2007
- Posts:
- 50
- Plugin Contributions:
- 0
Dual Pricing Not showing in admin
I have the latest version of zen cart and installed dual pricing... but when i go to the admin under customers it still shows group pricing.
Here is the text from the text file that was included in the download:
Dual Pricing Change for Zen Cart
By Andrew Benbow
THIS REPLACES GROUP PRICING. IF YOU USE GROUP PRICING THEN DON'T USE THIS.
Please back up your files BEFORE you add the new ones
Please back up your database BEFORE you make any changes
Making these changes WILL make upgrading your store to new versions harder.
Its fairly straight forward
Database changes
Thanks to DanTheMan you can paste the following into your "Install SQL Patches" in the admin section
ALTER TABLE customers ADD customers_whole VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD products_price_w DECIMAL( 15, 4 ) DEFAULT '0' AFTER products_price;
ALTER TABLE products_attributes ADD options_values_price_w DECIMAL( 15, 4 ) DEFAULT '0' AFTER options_values_price;
Now copy all the files over and go to your admin section.
In customers you will see that the group pricing option has been replaced by 'wholesale'