DUAL Pricing v2

[kteluv]

[QUOTE=kteluv;988393]

Ok, here it is, step by step installation, bug fix and testing!

DO NOT use the install.sql.
Instead use the following SQL patch:
----------

ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_wholesale`;

Hello there,
This module is exactly what I've been looking for, thanks! I'm trying to install this module and have encountered a problem. I've been following the instructions & did not install the install.sql. Instead I went into the admin>install SQL patch & pasted the above patch. It does not 'take' and I end up with an error message:

"1054 Unknown column 'customers_wholesale' in 'kldcustomers'
in:
[ALTER TABLE kldcustomers ADD customers_wholesale VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER customers_wholesale;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

Also, when I go to customers in Admin, I get this message:

"1054 Unknown column 'c.customers_wholesale' in 'field list'
in:"

Did I not add the patch properly? I left off trying to install at step 13.

Thanks for help!