DUAL Pricing v2

[jmoya]

My problem is that it is displaying the same price for wholesale as it is for retail. Everything else seems to work. I looked in the DB and it has different prices in the price table for retail and wholesale.

I know this must be in the file tpl_product_info_display.php but I couldn't figure it out, so far.

Any idea..?

Thanks!

[jmoya]

I got it working.

[stevefriedman71]

i just found this error in the admin section when you pre-view the product:

1054 Unknown column 'p.product_price_w' in 'field list'
in:
[select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.product_price_w, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '932']
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.

Any ideas? i even tried the SQL install again but all statements where ignored, saying the tables and field already exist. i know they exist b/c the mod works... i just found this now in the admin preview.

[twitchtoo]

I recently upgraded to 1.3.9h. Initially I just installed this mod following the download instructions. When things didn't work I read through this thread. I tried to carefully follow all the fix instructions. However, now everything works fine except that when I update a customer's wholesale pricing level the 'customers_wholesale' field in my DB get set to null.

If I go into the DB manually and change it, everything seems to work. So I'm guessing I missed some critical variable change in one of the files. But darned if i can find it. Can someone please point me at the file that does this and the relevant code I need to fix? Thanks.

The switch you are 'manually changing' is not being called correctly in the code. I would focus on admin/customers.php first. Follow closely post #687 and #695, you may have missed something or a file was not uploaded correctly.

Twitch

[immortalitea]

I resolved my earlier problem with the DB not updating when I changed the customers wholesale authorization level. For folks with similar problems, I just used the developers tool to search for instances of, "customer_whole", "customers_whole" and "customer_wholesale" and changed all to "customers_wholesale"

However, now I am able to identify a second problem. I have some products that are priced by attribute. The correct wholesale prices are displayed. However, when the item is placed in the shopping cart, the price reverts to the retail price. This only happens with products that are priced by attribute. I did download and install the revised attributes_controller.php (and reinstalled it this morning just in case).

This time, I don't think I have missed a variable change. Any other suggestions where to look for this one?

[stevefriedman71]

However, now I am able to identify a second problem. I have some products that are priced by attribute. The correct wholesale prices are displayed. However, when the item is placed in the shopping cart, the price reverts to the retail price. This only happens with products that are priced by attribute. I did download and install the revised attributes_controller.php (and reinstalled it this morning just in case).

This time, I don't think I have missed a variable change. Any other suggestions where to look for this one?

Yea. seems to be an issue i just realized too. all products just work fine with the mod except if the product is "priced-by-attribute"

[missta]

Twitch have you done an update on Dual Pricing for Attribute Controls yet?

[marknew]

Hi all,


here are the dual pricing files with the bug fixes from twitch applied.
Bug fixes applied as per thread - http://www.zen-cart.com/forum/showth...ricing&page=69 Post #687 and the following change to the new install.sql

http://www.kiamawebdesign.com.au/Zen..._bugsfixed.zip


Might save someone a bit of time. Thanks Twitch!

[MetallicA25]

Hello,

I've installed this mod...it's working perfectly for me...i have one question...is there a way to make this mod working automatically? I mean i want to have on my login page an option(phisycal person or company), and if the client is choosing company and creates an account, the wholesale prices would appear to him automatically.

[twitchtoo]

Twitch have you done an update on Dual Pricing for Attribute Controls yet?

I am developing it as we speak!

Twitch.