DUAL Pricing v2

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.

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.:no:

Any idea..?

Thanks!

I got it working.

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.

immortalitea:

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

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?

immortalitea:

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":frusty:

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

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/showthread.php?t=35450&highlight=Dual+Pricing&page=69 Post #687 and the following change to the new install.sql

http://www.kiamawebdesign.com.au/Zencart/dp1.7_bugsfixed.zip

Might save someone a bit of time. Thanks Twitch!

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.

missta:

Twitch have you done an update on Dual Pricing for Attribute Controls yet? :D
I am developing it as we speak!

Twitch.

twitchtoo:

I am developing it as we speak!

Twitch.

Update, I have found a number of spelling typos in the variable names, as well the _w variables were not added to all the necessary locations. That being said the single largest problem I am having right now is isolating the price that is being passed on to the shopping cart. I can make the price show up beside the attribute when you are logged in as a wholesale customer :).

Twitch.

twitchtoo:

Update, I have found a number of spelling typos in the variable names, as well the _w variables were not added to all the necessary locations. That being said the single largest problem I am having right now is isolating the price that is being passed on to the shopping cart. I can make the price show up beside the attribute when you are logged in as a wholesale customer :).

Twitch.

I got it. 4:48am I finally cracked it. Attribute prices will now move from the product page to the shopping cart in both retail and wholesale!

Dual Pricing - Wholesale Attributes Pricing Bug Fix - Instructions to follow!

Twitch.

The fix for the error in the admin product preview is in

admin/includes/modules/product/preview_info.php around line 19

p.products_model, p.products_image, p.products_price, p.product_price_w, p.products_virtual,

and change that to

p.products_model, p.products_image, p.products_price, p.products_price_w, p.products_virtual,

that solved, off to the next issue :) YAYYYY
http://www.zen-cart.com/forum/showthread.php?t=175574

I am so grateful to all of you helping here and spending time to make this cart what it is..

twitchtoo:

I got it. 4:48am I finally cracked it. Attribute prices will now move from the product page to the shopping cart in both retail and wholesale!

Dual Pricing - Wholesale Attributes Pricing Bug Fix - Instructions to follow!

Twitch.

One last update, I've fixed the sub-total calculation for retail and wholesale in the shopping cart, and found that my personalizing code is not passing to the cart in wholesale only. Once this is corrected tonight I'll be applying all of the changes to the live site pen in hand. Hang in there the fix is closer than ever!!!

I also noticed that the wholesale invoice in admin loads the original retail price just below the product description. I intend to leave this code the way it is, seems like a simple way to show the retail price! In the future I'm sure I could muster up a 'list' column but that's not my direction at this time besides this module has already cost a pile of $$$ to fix!

Twitch.

I am using Ver. 1.3.9bp1

1. If I install the Dual Pricing add-on so I can offer wholesale pricing, will I be able to set the free shipping minimum to a different amount to the Retail Priced area? eg. $50.00 for retail and $200.00 for wholesale.
2. Also, will I be able to have a minimum order of say, $100.00 for the wholesale area?
   Thanks

Roy

to my knowledge, you can't do that.

BC_Roy:

Also, will I be able to have a minimum order of say, $100.00 for the wholesale area?
I would also love if we could make the wholesale area have a minimum amount. For the time being, I have a note stating that wholesale orders for less than $100 will be canceled unless prior arrangements have been made. This seems to work most of the time.

craftzombie:

I would also love if we could make the wholesale area have a minimum amount. For the time being, I have a note stating that wholesale orders for less than $100 will be canceled unless prior arrangements have been made. This seems to work most of the time.

I do the same, i.e. state a minimum order size policy for wholesale. I also use the different pricing levels. New resellers get a courtesy discount only. When I know they are serious I upgrade their price level to receive better pricing. This seems to weed out the people who are not serious and the serious wholesale customers are thrilled to be upgraded.

BC_Roy:

I am using Ver. 1.3.9bp1

2. If I install the Dual Pricing add-on so I can offer wholesale pricing, will I be able to set the free shipping minimum to a different amount to the Retail Priced area? eg. $50.00 for retail and $200.00 for wholesale.

3. Also, will I be able to have a minimum order of say, $100.00 for the wholesale area?

Thanks

Roy

stevefriedman71:

to my knowledge, you can't do that.

It would work something like this:
The site needs to see you are a wholesale customer, then you would need a wholesale shipping module and finally a wholesale minimum qty/value.

I am working on the first two, the last one might be on the shelf for a couple weeks.

Twitch.