DUAL Pricing v2

[ZL Conquistador]

when I went to Admin->customers->customers: I get this page : "Parse error: syntax error, unexpected T_STRING in /home/xxx/xxx/Admin/customers.php on line 91



Line 91 reads: sale = zen_db_prepare_input($_POST['customers_wholesalesale']);

wholesalesale?

[townsend2009]

I think I may wait for the mod to be updated. LOL I'm a bit confused ;)

[Hollywood691]

ZL Conquistador - I didnt even notice that LOL. I reverted all my files back to the files I downloaded with the Mod. It was working ok for me I guess......I didn't do anything more than log in and look at it with me set as a wholesale customer.

I would like to see products Retail Price AND wholesale price which is what I thought would happen by doing all this with Twitchs update. The sql patch gave errors installing it, along with this one, that ooks like an easy fix for me now that you brought it to my attention.

The only thing I found that I had to do was replace the Attributes_controller_php like recommended cause the one in the Mod package didnt allow me to define my attributes.

I have 1.39h

[twitchtoo]

when installing the sql patch I got this:

1054 Unknown column 'customers_wholesale' in 'zen_customers'
in:
[ALTER TABLE zen_customers 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.

apply this SQL patch:

ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL;

and let me know if it resolves your issue.
Thanks
Twitch.

[twitchtoo]

wholesalesale?

This is a result of using find/replace without reading each line BEFORE replacing the text string.

OR incorrectly following step 7 and 8.

Thanks
Twitch.

[ZL Conquistador]

Will this mod allow me to assign a group discount and display the original price along with the discounted price?

Like this:
http://www.zen-cart.com/index.php?ma...roducts_id=333

[Hollywood691]

apply this SQL patch:

ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL;

and let me know if it resolves your issue.
Thanks
Twitch.

Thanks twitch! Mod works perfect so far as well as I can see.

The problems I had with

when I went to Admin->customers->customers: I get this page : "Parse error: syntax error, unexpected T_STRING in /home/xxx/xxx/Admin/customers.php on line 91
Line 91 reads: sale = zen_db_prepare_input($_POST['customers_wholesalesale']);

was exactly like you said. I did not Read, and just did the find and replace. I see how that happened now.

Thank you very much!

Hollywood~

[missmobtown]

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

Install instructions for Dual Pricing - Wholesale Pricing v1.9t

This version works on ZenCart 1.3.9.h as of Jan 15th 2011

...

twitchtoo,

I'm on version 1.3.9h.
I am SO SO close I can taste it, but I can't figure out what this issue is. I followed all your instructions to the letter, but I'm not sure where the last problem is coming from.

I can set up new accounts with no problem, and administer them from Customers/Admin, but I now get this error when I try to log in on the front ened:

1054 Unknown column 'customers_whole' in 'field list'
in:
[SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral, customers_whole FROM customers WHERE customers_email_address = 'missmobtown######################']

I do seem to be able to add wholesale prices to the products in my catalog, so that part is working fine. Hopefully this is a quick fix, any ideas?

Thanks!
CG

[twitchtoo]

twitchtoo,

I'm on version 1.3.9h.
I am SO SO close I can taste it, but I can't figure out what this issue is. I followed all your instructions to the letter, but I'm not sure where the last problem is coming from.

I can set up new accounts with no problem, and administer them from Customers/Admin, but I now get this error when I try to log in on the front ened:

1054 Unknown column 'customers_whole' in 'field list'
in:
[SELECT customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral, customers_whole FROM customers WHERE customers_email_address = 'missmobtown######################']

I do seem to be able to add wholesale prices to the products in my catalog, so that part is working fine. Hopefully this is a quick fix, any ideas?

Thanks!
CG

the error is in your very first line:
'customers_whole'.

AFTER this bug is fixed following my instructions you should have ONLY 'customers_wholesale'.

If you installed the wholesale module THEN applied my fix you need to pm me for the reversal instructions.

I repeat, change all:

- customer_whole
- customer_wholesale and
- customers_whole

to only 'customers_wholesale'.

Please let me know if you encounter any further issues.

Twitch.

[missmobtown]

Yes, that did it for fixing the error message. Now logging in on the front side works fine.

But, it looks like I'm left with a lingering problem; in Admin/Customers, I can edit customers and try to change their Wholesale Pricing level, but it seems like that info isn't being saved. Even I try to switch my fake wholesale customers to 0 (retail), it doesn't show a number in the Request Wholesale column in my customers table. Any thoughts on this, or do I need to PM you for reversal instructions and...sigh... start from scratch?

BTW, your debugging of this mod for this version of Zen Cart is pretty brilliant. Well done, and thanks.

CG