Printable View
I'm pretty amazed no one has had any response to any of the places I've posted this issue. Does just no one know what the problem is? Or do they just need some monetary encouragement? If someone can help me with this problem I might be able to pay them for their time. Our site is being held back only by this one issue.
Thanks.
When you download and install this mod, you are installing files that go with Zen version 1.3.8. (because the creator of this mod has not updated it).Quote:
Originally Posted by dermit
When we talk about Win Merge, we mean we are comparing the 1.3.8 files with the new 1.3.9 files, taking the proper Dual Pricing code out of the 1.3.8 files and placing them into the 1.3.9 files. Hope that makes sense.
Now to answer your other question.... I'm sorry, I do not know the cause of your problem or how to fix it, but I can guess that it doesn't help when you are using old 1.3.8 files in your 1.3.9 Zencart.
I am offering my Dual Pricing files if anyone wants to try them. Dual Pricing has been working great for me ever since 1.3.9 came out and I Winmerged everything. I am using Zen Cart version 1.3.9c by the way (haven't had a chance to update yet).Quote:
Originally Posted by craftzombie
Use at YOUR OWN RISK... and I mean it. I will slap you across the face if you do not back up your files before you try mine. I have several mods running (Dual Pricing, Super Orders, COWOA, Quick Updates, and many more I can't even think of right now, and I have made all kinds of tweaks to the appearance of my site, etc. So...... once again, don't make me go all Chuck Norris on you if you don't backup your files.
dual_pricing_craftzombiesFiles_1.3.9.zip
I would like to thank craftzombie for her upload. I have taken the files she posted, and can confirm that they are working with my 1.3.9f version of ZC which is running COWOA. I backed up the replacement files, and uploaded the posted attachment contents.
When logged in as a wholesale user, I am able to see the correct wholesale pricing in all locations where it should be displayed (categories and product info pages), as well as showing them the retail pricing beside the appropriate "Retail Price" heading. When I add the product to my cart, the price remains correct, clear up to checkout via paypal.
Thanks again for the upload and saving my bacon! This issue was about to make me switch carts, because my wholesale customers wouldn't make it to the end of the shopping cart process to see their discount if I used group pricing. Switching carts was something I didn't want to do not only due to the amount of time invested thus far to get it setup and working, but also because I don't feel like any of the other carts offered the support or contributions which ZC offers, even the paid versions. Once again, the ZC community has pulled through with a great contribution! (and update to the contribution in this case) :clap: Thank you everyone for getting the DUAL Pricing this far, and thank you craftzombie for getting it 1.3.9f compatible! :yes:
dermit,
I would try making sure you got the files all uploaded into the correct folders. Specifically, if you changed the name of your admin folder as suggested by ZC on your hosting company, make sure you rename your admin folder appropriately before uploading craftzombies files. I have installed a small handful of contributions, but in regards to products I am running a stock 1.3.9f zen cart. I went through each of my folders, cut the files out which craftzombie would be replacing, and pasted them into a separate backup folder, retaining the structure (IE putting in an english folder or admin folder or includes folder as needed). If you do this, then rename the admin folder in the zip she uploaded, you should be able to just upload the two folders (the admin-equivalent and includes folders) and everything should be fine and upload to the correct places.
Also make sure you have set up your wholesale pricing correctly. Go in and verify you have the wholesale pricing set with hyphens between them on your products. 0.00-0.00-0.00-0.00 if you do not want to offer a wholesale price for a particular item, or 9.99-8.99-7.99-6.99 for instance if you wanted to offer 4 different wholesale price levels for an item.
Finally, make sure your customer account is set up with a 1-4 number to achieve the desired pricing level. This is set by a box underneath of the customer's email address. By default they are set to 0 which is a retail-only price level.
If you are still having problems, I can try to give you a hand and look over things/try to fix it, but it is my opinion if you are running a new ZC install, that it has to be a problem with the files not uploading correctly (as some FTP clients will do) or a setting within the admin area that needs adjusting since I am running a nearly stock ZC at the moment and it worked perfectly for me. Double check my suggestions, and then try re-uploading the two main folders in the attachment and see if it clears up your problem. If not, the contact page on my ZC will email me, feel free to contact me and I will see what I can do to help.
Thanks,
Joey Phillips
http://www.leatherbyjean.com/catalog -my ZenCart
What is COWOA? and do I need that in order for this to work?Quote:
I would like to thank craftzombie for her upload. I have taken the files she posted, and can confirm that they are working with my 1.3.9f version of ZC which is running COWOA.
Hi, I am doing this. I guess my one question is since I am pricing by attribute I will obviously set 0.00-0.00-0.00-0.00 in my product pricing. But for the Attributes themselves do I do the 9.99,8.99,7.99,6.99 thing in the TRADE field?Quote:
Also make sure you have set up your wholesale pricing correctly. Go in and verify you have the wholesale pricing set with hyphens between them on your products. 0.00-0.00-0.00-0.00 if you do not want to offer a wholesale price for a particular item, or 9.99-8.99-7.99-6.99 for instance if you wanted to offer 4 different wholesale price levels for an item.
Finally, make sure your customer account is set up with a 1-4 number to achieve the desired pricing level. This is set by a box underneath of the customer's email address. By default they are set to 0 which is a retail-only price level.
I just want to double check that I am doing it correctly before I start getting developers involved or before I try to reinstall it.
Any confirmation would be a huge help!
Also craftzombie It seems your download link isn't working anymore. Possible to get it reuploaded? Thanks.
Dermit,
COWOA is what enables users to Check Out With Out Account. The users do not have to make an account with your store to purchase products from your site. The files craftzombie uploaded have the necessary code in them to enable this feature, but you will have to look at the contributions page to get the remaining files/installation instructions. I would say you either need to fully install and utilize this feature or go through the code on the uploaded files and remove any references to the COWOA.
I am not using any attributes in my store, just listing options as a separate item, so I am not exactly sure how they work, but if I remember right, they changed how the pricing for the attributes needed to be entered because it interfered with excel and comma separated values, try using the hyphenated prices in the attributes as well. This is just me going off of memory......
The files craftzombie has uploaded appear to be working correctly for me, may have just been a glitch at the time you tried to download them. Give it another go...
Thanks for your responses Cooljoe04.
Can anyone just confirm if I am doing it correctly with the Priced by attribute using the TRADE Field only ?
Hi,
Does anyone know how this module will affect the layout of the attributes file created by ezpopulate 2.5.5.4?
Will the wholesale prices have to be given their very own model numbers?
Also, I made some changes to the attributes grid and the product display grid, which part of these new files can i take and add to my modified files?
Thx.
I've installed this, does anyone have any steps on how to set it up? My products are currently priced using attributes.
How do I do the same with the wholesale price?
anyone? :dontgetit
Can someone please explain this module to me?
I have installed dual pricing into my version 1.3.9d zen cart and it works as long as I do not use attributes to price. Using attributes the client sees the proper wholesale price when viewing the product but retail shows in the cart and at checkout.
Anyone have any ideas as to how this can be corrected or what code might be affecting this that I might be able to perhaps change.
:(
Is this mod still supported ? If not such a shame it's a great mod !! Anyways I'm going to be upgrading this over the next few weeks for my store and would like to submit the changes with the author's permission ?
What I already have done ..
Added a wholesale application form to register. When a customer has clicked yes to applying for a wholesale account the store owner is notified in admin and then can switch the customer over to wholesale status if they decide to.
Also added wholesale prices to bulk discount's so you can set a separate price for bulk discounts wholesale / retail.
To do ...
Fix attributes ? I haven't tried using wholesale prices for attributes yet.
I'm sure there is more to do but it's friday and I'm in weekend mode so a bit brain dead lol I'l submit the patches when complete.
Cool, that sounds like a great fix. If you can, could you make it work when all prices are priced by attributes?
@ drgr33n - feel free to improve upon any of the free modules so long as you do thorough testing before releasing a newer version.
If you could get the attributes portion working, that would be fantastic. The mod on the whole is a great idea but with the changes in the zen cart shopping basket I guess a few calls have been changed so it brings up the retail price instead of the wholesale price. The wholesale prices show when looking at the product but they just don't get transferred to the basket. Now I am using zen cart 1.3.9d. I'm new to this and not sure if I want to try to upgrade just yet. Thanks for any and all help in this area.
Hey again ! ,
I will take a look at the attributes problem sometime this week if I'm not too busy :unsure: lol I doubt it will be that much wrong with it.
Here's some screen shots of the other mod's I've implemented. I've just merged the changes into one of my clients websites for now I will type up the patch after looking into these attributes on a fresh zen install.
http://img97.imageshack.us/img97/2776/slacker6.png
Uploaded with ImageShack.us
http://img6.imageshack.us/img6/5708/slacker7.png
Uploaded with ImageShack.us
http://i56.tinypic.com/2dbtj4x.png
http://i51.tinypic.com/os7uq0.png
I just installed Dual Pricing but I am not getting any additional pricing boxes in the product page. Could another mod be blocking it. I have map pricing installed also.
Thanks
When I first started pricing by attributes I had the problem where the attributes prefix '+' doubled the price. I fixed this by following instructions here:
http://www.zen-cart.com/forum/showthread.php?t=115073
However when I install dual pricing this problem arises again. Has anyone any idea how to fix it? Also, where do I put the wholesale prices? I update my attributes using a system of spreadsheets in EZ Populate, does anyone know how this module may affect that?
You just have to love the support you get from this site :censored:
moesoap this is a very old module and the author may not even be active on this forum. I would suggest you hold your tongue because if a moderator see's that you may be banned and you won't get support full stop.
Just an update I've fixed attributes and updated all the files to 1.3.9g. This mod had some serious security flaws so if you have this mod installed on your site I'd suggest upgrading to my version lol.
Over the weekend I just want to add an additional feature for invoicing. Then I will upload the new version. :clap:
Scrap that I'l sort the invoices out another time. I can't upload changes here on my 3g dongle so I've added a link to v1.7 below.
Changes I made are stated in my first post here and I've fixed the attributes shopping cart issue and updated all the files to 1.3.9.
I'll upload the file changes to the contribution page when I get a decent connection :D
Hope you like it !
http://rapidshare.com/files/42782098...ricing_1.7.zip
You can see my frustration, it's been nearly two weeks since I asked for help. I couldn't be the only person to encounter this particular problem with dual pricing.Quote:
Originally Posted by drgr33n
Thanks for this btw, I'll give it a go. :bigups:
Moe.
Ok my changes have been acepted and the new version is available to download .
http://www.zen-cart.com/index.php?ma...roducts_id=166
I've not finished yet I've still got a couple of idea's in mind but ran out of time on this one :D So if anyone has any good idea's etc on how to improve this further but don't fancy the challenge of hacking it up yourself post em here and I'l see what I can do.
I installed dual pricing v1.7 updated by drgr33n using Winmerge onto my zencart v1.3.9h. Everything looks fine except that where I have products with "Specials" prices the special discounted price is shown instead the wholesale price. If a product does not have a special discount off the retail price then the wholesale price is correctly shown for the logged in customer. Any help in resolving this issue is appreciated. ThanksQuote:
Originally Posted by drgr33n
Specials was never included to this addon. And to add it would be another totally new feature. I will take a look and see what I can do. I've had to modify a couple of things because the cart total was always showing 0.Quote:
Originally Posted by Ragareb
Thanks drgr33n I appreciate all you efforts.Quote:
Originally Posted by drgr33n
Thanks drgr33n I too appreciate all you efforts!
I am running on an up-to-date Linux LAMP system.
I installed and verified a fresh 1.3.9g with demo data.
I then installed dual_pricing__wholesale_pricing_1-7a.zip as follows:
a. hand altered the database using the alter stmts in install.sql.
Note one line is invalid:
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price_w`;
since you cannot add a column after itself. I changed it to add after the last col in the table:
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
Is this a clue?
b. I then placed the two directories CONTROL(a new directory) and includes (overwriting existing files) into my zen root).
I see no changes at all.
I do not see a new text box under the email address box.
I do not see a place for wholesale price on any product.
No differences from pre-installation.
I am puzzled!
If I have missed some vital step, please point me to where in the README that step is documented.
lol sorry control should be the admin directory. I will update it all when I've finished the mod.
Sorry I didn't realize I'd left it at control :smile:
OK - I will move it's contents to admin!Quote:
Originally Posted by drgr33n
AHH - waaay more better!Quote:
Originally Posted by brandon
shoulda realized that control was your name for admin.
should fix that sql error too.
zen has always been so easy to understand....
tidying up the code and adding specials tonight ;) There are a couple of short falls with this mod like if you have discounts set the retail price displayed also gets displayed with the wholesale discount. It would be a major overall of this code to fix I'm afraid unless I just disable retail prices being displayed when a wholesale customer is logged in ? I will take a look at all this tonight.
The spirit of this mod would point to disabling retail when wholesale cust is logged in. That is for sure what my client wants. Basically he wants a customer to see "their" price. Period.Quote:
Originally Posted by drgr33n
He actually wants to supress product display when the customer band has no price (so retail customers cannot see wholesale products, let alone wholesale prices.
I will probably just set the retail price band to some special value and hack at it at display time.
There's another mod for that if you do a search on the contributions page for dual price the second one down is a add on for this hack to allow you to hide wholesale products. Maybe I can merge it into this one aswell ? I'm a bit pushed for time at the mo so might take me a few days to a week to complete these mods so be patient and I'l come up with the goods soon hehehe !
Patient?? When has a receiver of the benefit of code ever been patient? Anything I don't understand is easy... :)Quote:
Originally Posted by drgr33n
With how fragile the zen addon install precess is, I certainly vote for consolidation but it is your code.
I would offer to help but (1) I am under the gun and (2) adding folks to a project makes it take longer (Thanks Fred, we really owe you).
I think I have what I need on pricing with your mod alone.
1. Retail custs see only retail price.
2. Wholesale custs see retail and wholesale.
The other addon, which I installed after testing and verifying 1 and 2, has the further effect of allowing me to keep retail customers from seeing wholesale products.
Is this what you expected?
I like it.
I am not so sure the two addons should be combined though.
Cheers - BOS
I have an issue with dual pricing and 1.3.9h
When I try to add an attribute value I get bounced to the admin home screen and no change is made to the item.
When I restore the admin/attributes_controller.php to pre-addon state, I do not get bounced and the attribute value gets added.
This suggests that the dual pricing version of attributes_controller.php is involved in the problem.
comments?
btw, i am not great at apache logs but i think i am getting a 302 error...
i have moved stuff in control to my admin folder, but still get the error when install sql:Quote:
Originally Posted by brandon
1054 Unknown column 'discount_price_w' in 'products_discount_quantity'
in:
[ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;]
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.
[ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;]
when doing your sql patch
Change:
ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;
to:
ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price;
Cheers
thanks a lot , i just found it out.Quote:
Originally Posted by Ragareb
Any one know how to fix that subtotal is 0 when applied wholesale price.?
I have a client who has started doing some holiday markdowns using Sale Make, This appears to by pass the dual pricing setting and so she has all kinds of explaining to do to her wholesale customers. I saw some discussion about updating tis module to take the sale pricing into account, was anything ever advanced.
failing that has any on developed a separate strategy for sale pricing for wholesale customers
I have merged the security token changes (diff the file version 1.3.9g to 1.3.9h to see) and it seems to work now.Quote:
Originally Posted by brandon
looks like dual_pricing__wholesale_pricing_1-7a, file includes/classes/shopping_cart.php is missing the 1.3.9h changes (diff shows about 8 small changes relating to cart management).
I can certainly merge the changes but i am in no position to run the regression testing that I am sure a conscientious maintainer would have. But at least I will know if i have a suspected fix.
Hey drgr33n,
First thank you very much for you work on the Dual Pricing module. I look forward to getting it working properly on our cart.
I am getting a bit of a strange behavior and hoping you may be able to shed some light on it for me.
We are using v1.3.9d
I have a product with retail price of $69 and wholesale of $49 and one Attribute which is for -$12 (minus 12). Haven't figured out where you are entering comma separated for Attributes - if you could help on this it would be great too.
However, in the backend when previewing the product before saving it displays as $69, $49, and $57 (which appears to be correct as the $57 is retail with attribute)
On the site when I log in as a Wholesale I see Retail with attribute as $81 and Wholesale with attribute as $37. When I add the item to my cart I get the original retail price showing in the cart whether I check the attribute or not: $69.
If you can shed any light on this behavior it would be great.
Thanks,
Pat
I have installed the mod with no problems BUT I am not seeing the radio button for customers to request wholesale on the register page...I also am not being notified so I have no idea who I am suppose to upgrade to wholesale and who I'm not unless I manually go through each new customer's profile any suggestions on where I might have gone wrong?
For everyone that is having problems with this mod and the sql problem here is the correct code without the zen_ prefix and also the code WITH the zen prefix. Use the code WITHOUT the prefix if you are running this through the Tools>>Install SQL patches in the admin of your website:
WITHOUT THE ZEN PREFIX:
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 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`;
I also had problem running this with 1.3.9h because of changes in the INCLUDES>>CLASSES>>shopping_cart.php file that happened in 1.3.9h. It was causing a time out error when you logged in and tried to checkout, from either a wholesale or retail account.
The only glitch I have not been able to solve is that for Wholesale customers the TOTAL price in the CART shows up at $0.00 BUT it shows up correctly in checkout and through the rest of the process. If anyone knows the fix for this feel free to add...but this is the best I could do and still have the cart and this mod work. ****BE SURE TO BACK UP THE FILE BEFORE UPLOADING THIS FILE... JUST IN CASE*** this new file is only for VERSION 1.3.9h if you are using a prior version the file included in the mod download should work!
Hi,
I'm using Zen Cart 1.3.9d with COWOA 2.0c1 and Dual Pricing 1.7a. I'm currently fiddling with CraftZombie's files to merge the two. (thanks for that!)
Here are some issues that I'm having.
1. I have no radio button for people signing up to request to be wholesalers. Anybody know how to solve this? Or, can you direct me to the area of code to look at? :huh:
2. Is there a way to pre-approve a customer as a wholesaler based on a coupon code that they use? I am sending postcards to businesses that qualify and it would be great if they could check out immediately at wholesale pricing. I'd hate for them to bounce away from my website because they don't want to wait for me to respond to their request...
Thanks so much for the help! :wink:
We are having the same problem with the radio button, I'm wondering if it is because of a custom theme
zen cart 1.3.9h
dual pricing 1.7a
I am having 2 bugs with the dual pricing addon,
1. shopping cart shows a sub-total of $0.00
2. No radio for wholseller option at the registration.
Can anyone help please?
I have been working on this as well. Before I installed Dual Pricing, I installed, COWOA to allow quick checkout. Craftzombie did a nice merge of the files for Dual Pricing with COWOA and she also solved the issue you are having with #1, the sub-total issue. Once I changed over to her files my $0.00 sub-total problem went away.Quote:
Originally Posted by scorcher
-I will note however that I saw this issue: The original retail price disappeared from view. Only the distributor pricing would then show up...
Also, it appears that Craftzombie's changes were made before the radio button addition... so. I think when I wrote over the Dual Pricing 1.7a files with the Craftzombie files this "un-did" the new feature.
I'm currently trying to align all of the Craftzombie files with the corresponding 1.7a files so that we can see which code should be inserted. Anybody want to help?
So, my question for you: Do you have Craftzombie's files installed or COWOA installed?
Also, after I did all of this I changed over from PayPal IPN to PayPal Express. Now, all of the COWOA options have disappeared and when I tried to hide Configuration->Layout Settings->Categories Box it doesn't work. I have no idea if this has anything to do with the aforementioned things if someone can help I would be very appreciative!:unsure:
I found the solution for bug #1. shopping cart shows a sub-total of $0.00
on includes>classes>shopping_cart.php
locate
and replace forPHP Code:// products price
$product_query = "select products_id, products_price, products_tax_class_id, products_weight,
products_price_w is missing from 1.7PHP Code:// products price
$product_query = "select products_id, products_price, products_price_w, products_tax_class_id, products_weight,
The solution for the free shipping problem in dual price is easily solved with Free Shipping Options assuming you request a minimum order amount for wholesale customers. Go to Modules>Shipping modules>Free shipping options and enter values for Total >= and Total <=
These below are the settings for one of my stores, so I offer free shipping for orders above $35 but I charge shipping for orders above $200. Wholesale and regular clients won't receive free shipping above $200. I use the USPS shipping module with these settings and it works like a charm :smile:
Total >=
Free Shipping when Total >=
35
Total <=
Free Shipping when Total <=
200
I would totally help but there is no way I can until after xmas. I am swamped.Quote:
Originally Posted by Adam371
Yes, it only shows the wholesale price once the wholesale customer is logged in. That's the way the original Dual Pricing worked and I never edited any code to make it show retail pricing (although didn't someone post how to do that???). Also, my files do not have the radio button thing. I provided my files before that feature came along. I may add it, although I personally don't have a use for it (I like that my customers have to email for a wholesale account because that means they actually read my rules!).
I know 3-4 weeks is a bit long to wait, but I really barely have time to eat or sleep during December! I barely had time to write this post! :wink:
One of the big issues with dual pricing is the lack of configuration when it comes to hide the coupon and gift cert. boxes during checkout. The last thing as we want as wholesalers is give more discounts in the form of coupons or for wholesale accounts to pay with gift certificates. We've been trying to find a way around this without modifying core files and I think we just came up with a good way, at least it works for me, and I wanted to share it.
On includes>templates>YOUR TEMPLATE>templates>tpl_checkout_payment_default.php locate the following piece of code:
and replace by this onePHP Code:<?php
$selection = $order_total_modules->credit_selection();
if (sizeof($selection)>0) {
for ($i=0, $n=sizeof($selection); $i<$n; $i++) {
if ($_GET['credit_class_error_code'] == $selection[$i]['id']) {
?>
<div class="messageStackError"><?php echo zen_output_string_protected($_GET['credit_class_error']); ?></div>
<?php
}
for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) {
?>
<div id="shippingcoupongift"><fieldset>
<legend><?php echo $selection[$i]['module']; ?></legend>
<?php echo $selection[$i]['redeem_instructions']; ?>
<div class="gvBal larger"><?php echo $selection[$i]['checkbox']; ?></div>
<label class="inputLabel"<?php echo ($selection[$i]['fields'][$j]['tag']) ? ' for="'.$selection[$i]['fields'][$j]['tag'].'"': ''; ?>><?php echo $selection[$i]['fields'][$j]['title']; ?></label>
<?php echo $selection[$i]['fields'][$j]['field']; ?>
</fieldset>
</div>
<?php
}
}
?>
<?php
}
?>
This code will prevent the block of boxes (coupon code, gift cert., plastic gift card and insurance optional) to show for wholesale accounts only but shows and works fine for retail.PHP Code:<?php
$selection = $order_total_modules->credit_selection();
if (sizeof($selection)>0) {
for ($i=0, $n=sizeof($selection); $i<$n; $i++) {
if ($_GET['credit_class_error_code'] == $selection[$i]['id']) {
?>
<div class="messageStackError"><?php echo zen_output_string_protected($_GET['credit_class_error']); ?></div>
<?php
}
for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) {
?>
<!-- bof don't show if customer wholesale -->
<?php if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) { ?>
<?php } else { ?>
<!-- closing tag for this above bellow -->
<div id="shippingcoupongift"><fieldset>
<legend><?php echo $selection[$i]['module']; ?></legend>
<?php echo $selection[$i]['redeem_instructions']; ?>
<div class="gvBal larger"><?php echo $selection[$i]['checkbox']; ?></div>
<label class="inputLabel"<?php echo ($selection[$i]['fields'][$j]['tag']) ? ' for="'.$selection[$i]['fields'][$j]['tag'].'"': ''; ?>><?php echo $selection[$i]['fields'][$j]['title']; ?></label>
<?php echo $selection[$i]['fields'][$j]['field']; ?>
</fieldset>
</div>
<?php } ?>
<!-- bof don't show if customer wholesale -->
<?php
}
}
?>
<?php
}
?>
The problem, for us at least, is that it would also remove the optional insurance module, but we solved it by adding insurance mandatory for orders over $200 which is the same amount we use as minimum order for wholesale accounts, so we made it work.
We've tested it in one of my live stores www.byvalenti.com and it works great.
I hope this hack will be useful for somebody else :smile: at least until there is a better way :P
cheers! :D
Does anyone know what version of easy populate I should use. I have dual pricing and stock by attributes. I have a number of other modules but I think these are the main ones that involve the products.
Oh and I want to ensure it is PHP5.3 ready too and for zencart 1.3.9h!
Thanks
I have h installed now and am using the latest version b. I have noticed another possible bug in that taxes are still being added to the wholesale customer.
Also, Trying to hunt down the actual cause but I came across another user who has both H and using Dual Pricing, when adding an attribute to a product it fails to add and kicks us to the admin home screen.
Anybody know the cause of this or how to fix this?
Too simple but should be noted, the admin/attribute.php file in this mod was to blame. I cant recall any difference with dual price when it involved attributes, but simply reverting back to the original does the trickQuote:
Originally Posted by richphitzwell
I have fixed an error that caused this problem for kcarl; I would post the update here while the mods check it but the ZIP was too big for the forum, even on the highest compression settings.
I have a problem where the wholsale customer is charged the retail amount when quantity discounts are reached.
I'm testing with ZC V1.3.9h and Dual Pricing V1-7b
Example:
Product is Retail: $29.40, Wholesale: $23.00
Quantity discounts are 4 or more = $24.50
If wholesale customer orders 1 - 3 price is $23.00 each which is correct
If wholesale customer orders 4 or more price is $24.50 each which is inccorrect
Problem is Whoelsale customer will need to order 10 or more of each product which is possible to implement but only if I can overcome this problem.
To test please see this product with a wholesale price
http://shop.adventure11.com/index.ph...roducts_id=201
Then login with...
[email protected]
test123
I will be very thankful if anyone can help me with this problem.
I fixed the problem after another look I found a field wasn't added to the products_discount_quantity table due to an error with the install sql. Once this was loaded I was able to change the quantity discounts to work :)
Change:
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price_w`;
To:
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
I spoke too soon, I was able to edit the quantity discounts in admin so it display correctly on product info page but still show insorrect amount in shopping cart
Running into this too. It looks as if the cart is calculating using the discount amount value under "Discount Value" and ignoring the value input under "TEXT_PRODUCTS_DISCOUNT_PRICE_W," even if the customer is designated as a Wholesaler. The discount values are displayed correctly on the product info page, though.Quote:
Originally Posted by adam2020
Any help with this would be greatly appreciated!
I have posted a job on scriptlance.com so should have a solution soon.
Have you tried group pricing mod? I use that and it gives 5 levels of "retail/wholesale price and 5 levels of discount price which is huge for me as 2 is not nearly enough. Doing loads of volume with it with thousands of SKU's no problems ever.
Just a thought...
Hi Jimmy
Thanks but as far as I know the price is the same using groups and the discount is provided at the end.
This project is a bit complicated as all customers need to see only one price (the price they will pay) plus a few other issues so I decided to go with Multisite and try and get Dual Pricing to work with it.
NOPE Gp 1.3.3 that David Simmons wrote retains the basic pricing level call that retail... plus adds 4 more levels which could be more than four but it's plenty for me. So I can list the same product using the same everything with 5 diffrent prices to 5 different customers and 5 different discounted prices or not discounted it all your choice.
I muddled with DP and it is about a 1 compared to GP being a 100. No offense to the creator it just has been surpassed IMO
Sorry to bump this up, but does the new version work? I ran the SQL instructions, and uploaded the files, and nothing changed. I can't input wholesale pricing, and I can't edit customers to add them to have the wholesale group pricing.
ANyone got any ideas?
I just tested GV 1.3.3 and it has the exact same problem.Quote:
Originally Posted by JimmyV
Scenario:
A product is $100 and quantity discount for 4+ is $80 for normal customers.
Wholesale Group A is charged $50 for same product. If the wholesale Group A customer purchases less than 4 he is charged $50 but if he purchases 4 or more he is charged $80.
The big problem is the wholesale customer must order 6 or more which is easy to implement but only worthwhile if I can get either Dual Pricing or GP to work correctly for a wholesale customer.
You must have done something wrong with the install as I have done it a few times in the past week and each install including theQuote:
Originally Posted by Mediaslave
recent V1.7c works. (besides the quantity discounts problem)
I have to try that out to see what happens. My first thought is that buying that way would conflict with both these modules as these are setting flat prices for a given group of purchasers.Quote:
Scenario:
A product is $100 and quantity discount for 4+ is $80 for normal customers.
Wholesale Group A is charged $50 for same product. If the wholesale Group A customer purchases less than 4 he is charged $50 but if he purchases 4 or more he is charged $80.
Obviously you can do a workaround (which I actually do but for a different reason) by creating a "special" which is a pre-pack at a reduced price. You then cross-sell it so even if the person bypasses the product listing they still see it cross-sold on the product page before ordering.
I use it as an upsell technique since I know most buyers buy say "3" and so I run a special at "5" units to get the upsell. It works really well in my case anyway.
Hi All,
First, I have zen-cart-v1.3.8a and it has been working pretty much great, other than a few security issues, which I have finally gotten resolved. Then I went and downloaded dual pricing and I have slammed up against an admin roadblock that has given me a major pia.:frusty: My site is showing up fine, I can't login to admin. I did the copy and paste into the sql patch and poof, admin was gone. :oops: I've looked everywhere and can't find the answer. I would be happy if it gave me a real error message, what it says is:
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
I've been through the config files and I'm at a lose, they all look right. Somebody please give me an answer that will make it all good again. I was actually thinking about upgrading to the latest version and thought I would wait until after Christmas, now I'm wondering if I shouldn't ought to go ahead and do it.
Thanks in advance,
Katydid
groovingrannylive.com
Hi All,
First, I have zen-cart-v1.3.8a and it has been working pretty much great, other than a few security issues, which I have finally gotten resolved. Then I went and downloaded dual pricing and I have slammed up against an admin roadblock that has given me a major pia. My site is showing up fine, I can't login to admin. I did the copy and paste into the sql patch and poof, admin was gone. I've looked everywhere and can't find the answer. I would be happy if it gave me a real error message, what it says is:
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
I've been through the config files and I'm at a lose, they all look right. Somebody please give me an answer that will make it all good again. I was actually thinking about upgrading to the latest version and thought I would wait until after Christmas, now I'm wondering if I shouldn't ought to go ahead and do it.
Thanks in advance,
Katydid
groovingrannylive.com
try this again on the first page instead of the last.:D
This has been mentioned a couple of times.
I have the latest versions of stock_by_attributes and dual_pricing installed on zencart 1.3.9h.
When logged in as a wholesale user and adding a product with attributes to the shopping cart, the retail price is listed.
I gather this is a problem with shopping_cart.php, but I can't find anything.
Has anyone figured out a solution to this?
Hi anyone has a solution to the shopping cart not displaying the correct pricing if the User is a WS?
Discount Value - This value is used in Shopping Cart instead of TEXT_PRODUCTS_DISCOUNT_PRICE_W.
Thanks a million.
this mod isn't working properly in 139h. it can't see the wholesale customer variable turned on. i'm desperately working on a solution, i have the value working in the admin just not in the cart... yet.
Hi Everyone,
Just spent 3 hours of browsing through forums for the answer of one simple question:
Is it possible with this dual pricing mod to display the wholesale prices without taxes. While the retail prices are shown with taxes?
This question has been asked several times on different forums but there is no clear answer on this.
Thanks in advance :bigups:
I too cannot get this to work with the latest version:
Zen Cart 1.3.9h
1.6 worked great then I upgrade which of course wiped it all out...it was okay since I found that the mod was updated to 1.7 but the instructions aren't clear to install and it's not changing anything when I upload and install. Hmmm...I'll be watching this thread. I really LOVE this mod. :D
Not sure what trouble you are having but I installed this and I couldn't for the life of me work out the problem with my attributes controller then I did a quick winmerge of the admin/attributes_controller.php and realized that this mod needed an updated version to work with 1.3.9hQuote:
Originally Posted by townsend2009
It was missingFrom a number of sectionsCode:<?php echo zen_draw_hidden_field('securityToken', $_SESSION['securityToken']); ?>
I hope this helps - this made it work on my store (cross the fingers there is no other issues)
I have attached my version if anyone can use it!
Is it still working? I'm very interested in this mod :cool:Quote:
Originally Posted by supersnow
Major Big Bug Fix here!
the variable 'customers_whole' was not consistently written throughout the current install package for 1.3.9h!!!
there are two ways to correct this, by doing a find for the words 'customer_whole' and replacing it with 'customers_whole' (plural)
or
follow the list i made below:
includes/functions/functions_prices.php
from line 120
// is there a products_price to add to attributes
if ($_SESSION['customer_whole']) {
if ($_SESSION['customer_whole'] != '0') {
$i = (int)$_SESSION['customer_whole'];
to:
// is there a products_price to add to attributes
if ($_SESSION['customers_whole']) {
if ($_SESSION['customers_whole'] != '0') {
$i = (int)$_SESSION['customers_whole'];
from line 154
if ($_SESSION['customer_whole']) {
if ($_SESSION['customer_whole'] != '0') {
$i = (int)$_SESSION['customer_whole'];
to:
if ($_SESSION['customers_whole']) {
if ($_SESSION['customers_whole'] != '0') {
$i = (int)$_SESSION['customers_whole'];
from line 1302
if ($_SESSION['customer_whole']) {
if ($_SESSION['customer_whole'] != '0') {
$i = (int)$_SESSION['customer_whole'];
to:
if ($_SESSION['customers_whole']) {
if ($_SESSION['customers_whole'] != '0') {
$i = (int)$_SESSION['customers_whole'];
includes/modules/products_quantity_discounts.php
from line 101
// percentage discount
case '1':
if ($products_discount_type_from == '0') {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
// percentage discount
case '1':
if ($products_discount_type_from == '0') {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
from line 107
if (!$display_specials_price) {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
if (!$display_specials_price) {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
from line 118
// actual price
case '2':
if ($products_discount_type_from == '0') {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
// actual price
case '2':
if ($products_discount_type_from == '0') {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
from line 134
// amount offprice
case '3':
if ($products_discount_type_from == '0') {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
// amount offprice
case '3':
if ($products_discount_type_from == '0') {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
from line 143
if (!$display_specials_price) {
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
if (!$display_specials_price) {
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
includes/modules/pages/login/header_php.php
from line 90
$_SESSION['customer_whole'] = $check_customer->fields['customers_whole'];
to:
$_SESSION['customers_whole'] = $check_customer->fields['customers_whole'];
includes/templates/YOUR_TEMPLATE_NAME_HERE/templates/tpl_product_info_display.php
from line 69
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
from line 84
if ($_SESSION['customer_whole'] && $_SESSION['customer_whole'] != '0' ) {
to:
if ($_SESSION['customers_whole'] && $_SESSION['customers_whole'] != '0' ) {
there are more bugs i have fixes for i will post shortly, the cart will now see the wholesale customer as well as the prices for a wholesale customer!
Twitch
Scrap the above post #685! I have finally FINALLY found the source of the problem!
I will post the correct install.sql, and all of the changes required to make the cart not only see the wholesale customer, but use the correct pricing AND allow the admin to see and control the customer type. Now working in 1.3.9h!!!
Twitch
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
I'm not responsible for anything you do to your ZenCart, please backup your files and your database... in two locations.
Step 1 - download and extract
'dual_pricing_wholesale_pricing_1-7c.zip
located here:
http://www.zen-cart.com/index.php?ma...roducts_id=166
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`;
----------
Step 2 - rename the 'control' folder to the name of your 'admin' folder.
Step 3 (Optional) - rename 'template_default' with the name of the template you are currently using.
Note: this will prevent overwriting the original Zen Cart core template file.
Step 4 - merge the new 'admin' folder and the 'includes' folder with your ZenCart install.
Step 5 (Optional) - download and unzip the attributes controller found here:
http://www.zen-cart.com/forum/showpo...&postcount=683
attributes_controller.zip
from: supersnow
Step 6 (Optional) - merge 'attributes_controller.php' to admin/attributes_controller.php in your ZenCart install.
Step 7 - You must first replace all instances of 'customer_whole' and 'customer_wholesale' with 'customers_whole' and 'customers_wholesale'
Step 8 - Replace all 'customers_whole" with 'customers_wholesale'
Step 9 - Remove the duplicate instances of 'customers_wholesale':
delete line 100 in admin/customers.php - $customers_wholesale = zen_db_prepare_input($_POST['customers_wholesale']);
delete line 258 in admin/customers.php - 'customers_wholesale' => $customers_wholesale
remove duplicate 'c.customers_wholesale' in line 350 of admin.customers.php
These files will be modified:
includes/functions/functions_prices.php
includes/modules/products_quantity_discounts.php
includes/modules/pages/login/header_php.php
includes/templates/YOUR_TEMPLATE_NAME/templates/tpl_product_info_display.php
admin/customers/php
includes/classes/shopping_cart.php
Step 10 - Add the following code to view Wholesale Price Level in the admin right listBox:
look in file - admin/customers.php for: $contents[] = array('text' => '<br />' . CUSTOMERS_REFERRAL . ' ' . $cInfo->customers_referral);
and add this line below it: $contents[] = array('text' => '<br />' . ENTRY_WHOLESALE_PRICING_LEVEL . ' ' . $cInfo->customers_wholesale);
Step 11 - Correct the variable in admin/customers.php:
search for: '$customers_query_raw'
you will find: 'customers_wholesale' at the end of the statement.
replace it with: 'c.customers_wholesale'
Step 12 - Ensure that you have uploaded all of the files in the package!
Step 13 - Log in to admin, go to customers/customers and notice the column 'Request Wholesale' defaults to 0.
Step 14 - Click on your test account name, notice the right listBox reads 'Wholesale pricing level 0'.
Step 15 - Edit your account and change the 'Wholesale pricing level' to 1, click update.
Step 16 - You will return to the admin page and see the value has changed in the 'Request Wholesale' column.
Step 17 - Click on Catalog, Select a Product, Add in a Wholesale Price (right below the 'Products Price (Gross)')
Step 18 - Log into your live ZenCart test account - like a customer would, you will see 'Whole Sale Price:' below the retail price of the product you added a wholesale price to in Step 17.
Step 19 - Thank me.
NOTES: Know that the login page (includes/modules/pages/login/header_php.php) holds the first 'switch' to find the 'customers_wholesale' price level. If the cart timed out or the switch didn't get turned on via the login page, the cart won't see the wholesale pricing level.
I thank you. Twitch.
Quote:
Originally Posted by rayring
Yes it's possible, it would require some hard coding and a mitt full of time.
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.
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']);
Is it possible to have different shipping rates for wholesale customers with this mod?
Thanks.
wholesalesale?Quote:
Originally Posted by Hollywood691
I think I may wait for the mod to be updated. LOL I'm a bit confused ;)
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
Quote:
Originally Posted by 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.
This is a result of using find/replace without reading each line BEFORE replacing the text string.Quote:
Originally Posted by ZL Conquistador
OR incorrectly following step 7 and 8.
Thanks
Twitch.
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
Thanks twitch! Mod works perfect so far as well as I can see.Quote:
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.
The problems I had withwas exactly like you said. I did not Read, and just did the find and replace. I see how that happened now.Quote:
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']);
Thank you very much! :clap:
Hollywood~
twitchtoo,Quote:
Originally Posted by 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:
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? :blink:Code: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######################']
Thanks!
CG
the error is in your very first line:Quote:
Originally Posted by missmobtown
'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.
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