Zen Cart Logo

DUAL Pricing v2

Views: 363,359

Results 641 to 660 of 1,504
11 Nov 2010, 10:32 PM
#641
herosunfun avatar

herosunfun

New Zenner

Join Date:
Oct 2010
Posts:
11
Plugin Contributions:
0

DUAL Pricing v2

brandon:

AHH - waaay more better!

shoulda realized that control was your name for admin.

should fix that sql error too.

zen has always been so easy to understand....

i have moved stuff in control to my admin folder, but still get the error when install sql:

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.

12 Nov 2010, 12:39 AM
#642
ragareb avatar

ragareb

New Zenner

Join Date:
Nov 2010
Posts:
5
Plugin Contributions:
0

Re: DUAL Pricing v2

[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

12 Nov 2010, 1:43 AM
#643
herosunfun avatar

herosunfun

New Zenner

Join Date:
Oct 2010
Posts:
11
Plugin Contributions:
0

Re: DUAL Pricing v2

Ragareb:

[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.

12 Nov 2010, 1:47 AM
#644
herosunfun avatar

herosunfun

New Zenner

Join Date:
Oct 2010
Posts:
11
Plugin Contributions:
0

Re: DUAL Pricing v2

Any one know how to fix that subtotal is 0 when applied wholesale price.?

12 Nov 2010, 2:53 PM
#645
stevebrett avatar

stevebrett

New Zenner

Join Date:
Oct 2007
Posts:
26
Plugin Contributions:
0

Re: DUAL Pricing v2

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

13 Nov 2010, 4:18 PM
#646
brandon avatar

brandon

New Zenner

Join Date:
Mar 2005
Posts:
64
Plugin Contributions:
0

Re: DUAL Pricing v2

brandon:

I have an issue with dual pricing and 1.3.9h

This suggests that the dual pricing version of admin/attributes_controller.php is involved in the problem.

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.

13 Nov 2010, 8:45 PM
#647
brandon avatar

brandon

New Zenner

Join Date:
Mar 2005
Posts:
64
Plugin Contributions:
0

Re: DUAL Pricing v2

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.

16 Nov 2010, 9:52 PM
#648
wlpdrpat avatar

wlpdrpat

New Zenner

Join Date:
Aug 2010
Posts:
4
Plugin Contributions:
0

Re: DUAL Pricing v2

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

18 Nov 2010, 4:13 PM
#649
chrissiemags avatar

chrissiemags

New Zenner

Join Date:
Sep 2008
Posts:
40
Plugin Contributions:
0

Re: DUAL Pricing v2

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?

20 Nov 2010, 11:23 PM
#650
carilivia avatar

carilivia

New Zenner

Join Date:
Dec 2006
Posts:
32
Plugin Contributions:
0

Re: DUAL Pricing v2

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;

20 Nov 2010, 11:40 PM
#651
carilivia avatar

carilivia

New Zenner

Join Date:
Dec 2006
Posts:
32
Plugin Contributions:
0

Re: DUAL Pricing v2

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!

23 Nov 2010, 2:44 AM
#652
adam371 avatar

adam371

New Zenner

Join Date:
Nov 2010
Posts:
2
Plugin Contributions:
0

Re: DUAL Pricing v2

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:

23 Nov 2010, 11:11 AM
#653
jtellup avatar

jtellup

New Zenner

Join Date:
Aug 2008
Location:
Oxford Ohio
Posts:
16
Plugin Contributions:
0

Re: DUAL Pricing v2

We are having the same problem with the radio button, I'm wondering if it is because of a custom theme

27 Nov 2010, 1:02 AM
#654
scorcher avatar

scorcher

New Zenner

Join Date:
Nov 2010
Posts:
1
Plugin Contributions:
0

Re: DUAL Pricing v2

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?

30 Nov 2010, 4:03 PM
#655
adam371 avatar

adam371

New Zenner

Join Date:
Nov 2010
Posts:
2
Plugin Contributions:
0

Re: DUAL Pricing v2

scorcher:

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.

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

30 Nov 2010, 5:48 PM
#656
mvstudio avatar

mvstudio

Zen Follower

Join Date:
Apr 2008
Posts:
447
Plugin Contributions:
1

Re: DUAL Pricing v2

I found the solution for bug #1. shopping cart shows a sub-total of $0.00

on includes>classes>shopping_cart.php

locate

      // products price
      $product_query = "select products_id, products_price,  products_tax_class_id, products_weight,

and replace for

      // products price
      $product_query = "select products_id, products_price, products_price_w, products_tax_class_id, products_weight,

products_price_w is missing from 1.7

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

30 Nov 2010, 10:08 PM
#657
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: DUAL Pricing v2

Adam371:

-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?

I would totally help but there is no way I can until after xmas. I am swamped.

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:

30 Nov 2010, 10:59 PM
#658
mvstudio avatar

mvstudio

Zen Follower

Join Date:
Apr 2008
Posts:
447
Plugin Contributions:
1

Re: DUAL Pricing v2

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:

<?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
    }
?>

and replace by this one

<?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
    }
?>

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.

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 https://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

2 Dec 2010, 12:33 AM
#659
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: DUAL Pricing v2

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

6 Dec 2010, 3:39 PM
#660
richphitzwell avatar

richphitzwell

Zen Follower

Join Date:
Jul 2010
Location:
My heart will always be in the NorEast
Posts:
110
Plugin Contributions:
0

Re: DUAL Pricing v2

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.