Help. installed Dual Pricing - Wholesale Pricing

[lcarlo1507]

I installed Dual Pricing - Wholesale Pricing. I followed the directions and I can't get it to work.

this is what I did.

I copied

ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
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`;

this into my "Install SQL Patches" in the admin section like it told me to and copied the supplied files for admin and includes.

Told me to go to a customer go to edit and i should see a new text box under the email address box.

There's nothing there.

Any advice

thanks

[scientific_anomaly]

Bump - same problem. First the install.sql does not work, (some problem with altering a column that does not exist in the database).

Someone reported an edit to get round that problem, so tried that and now it says column aready exists instead. Anyway it simply fails to function. PM'd alias 'Dr Byte' who appears is on the documentation. It's a week now and no response. Oh Well never mind, can't complain if free software fails to provide value for money or customer service guarantees, or even in fact if it wastes endless amounts of one's precious time like a sick joke.

Anyway, Dr Byte now you lookin a little shady don't you, like gimme my money back dude, like all of it. Now.
What you got to say? nothin' ain't it?

[DrByte]

Ha! Just because I touched a file at one time doesn't mean I know the thing inside and out.

I will tell you that many people have mixed experiences with that addon. I can't vouch for its suitability for any purpose. It's an ugly hack to all kinds of core components. Definitely a use-at-your-own risk sort of thing.

As for the PM, I don't see it. It must have been lost in the mass of messages I get every day. If you were asking for consultation or paid assistance, please post in the Commercial Help Wanted section to have someone respond with a quote for the work you wish done.

[carilivia]

Here is the correct mysql coding to use...I figured it out by carefully going through it.

I'm posting the fix with and without the zen_ prefix (my database has the zen prefix and this one is tricky with the prefix)

Hope this helps! =0)

********************REGULAR

ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
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_whole`;


*********************WITH THE ZEN_ PREFIX

ALTER TABLE `zen_customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `zen_products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `zen_products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `zen_products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `zen_customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;