DUAL Pricing v2

Can someone please send me the DUAL Pricing mod WITH MySQL DB table file update. I can not find it anywhere and the downloaded mod does not include the sql update.

May thanks

Not to worry. There is a new version for 1.3.8 !!! and it works

oavs:

Can someone please send me the DUAL Pricing mod WITH MySQL DB table file update. I can not find it anywhere and the downloaded mod does not include the sql update.

May thanks

The SQL patch is located in the "dual pricing.txt" file located in your download. Use your admin section to run it.

Just a little update. Adoy's problem was fixed by using the files in the 1.3.2 release. Currently I am for some reason having troubles uploading this to the proper Download section :huh: and there for in the meantime it is available at my web site.

adoy:

hello! need help!

dual pricing mod works for me. i've edited customer set to level 2 and added 2 levels for wholesale pricing by attributes: 30,25

the prices is correctly displayed in product info: 25 but it displays 30 in shopping cart. my /includes/classes/shopping_cart.php was already modified before dual pricing was installed.

anyone can help me what are the specific files and/or lines edited just like how COWOA being installed. thankz a lot!

I thought it was working..but its not.

I can see the wholesale section when I am adding products etc.

Problem is with my products, customer has to upload an image. So when you go to create an attribute to upload 'file' section, Category shows but not the product it self. Its not selectable (viable) from the drop down in the Options manager. When I add the attribute I get an error message

Any ideas please?

1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '2', '1', '0', '0', '0', '+', '0', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
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.

I'm having the same error now when adding a new attribute. I tried some of the fixes suggested in this thread but it still doesn't work: would appreciate if any one can help?

The problem comes because dual prices/wholesale pricing adds a field to the attributes table.

admin/includes/functions/general.php

after line 1914 ish:
Code:
'" . $products_copy_from->fields['options_values_price'] . "',
add:
Code:
'" . $products_copy_from->fields['options_values_price_w'] . "',
after line 1943 ish:
Code:
options_values_price='" . $products_copy_from->fields['options_values_price'] . "',
add:
Code:
options_values_price_w='" . $products_copy_from->fields['options_values_price_w'] . "',

For those suffering with this error when adding attributes to an item and who have followed the various fixes, I discovered that in the admin/attributes_controller.php in or around 255 the value options_values_price_w was missing from the list after adding it I didn't get the error again.

Now it is transferring the "retail" price to the cart rather than the w/s price, but I think there is a thread somewhere with that problem.

$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_price_w, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required)

oavs:

I thought it was working..but its not.

I can see the wholesale section when I am adding products etc.

Problem is with my products, customer has to upload an image. So when you go to create an attribute to upload 'file' section, Category shows but not the product it self. Its not selectable (viable) from the drop down in the Options manager. When I add the attribute I get an error message

Any ideas please?

---

1136 Column count doesn't match value count at row 1
in:
[insert into zen_products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '2', '1', '0', '0', '0', '+', '0', '1', '0', '+', '0', '0', '1', '', '1', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
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.

Oavs,
-Which version of Zen Cart are you using?
-Which version of the Dual Pricing are you using?

oavs:

I thought it was working..but its not.

I can see the wholesale section when I am adding products etc.

Problem is with my products, customer has to upload an image. So when you go to create an attribute to upload 'file' section, Category shows but not the product it self. Its not selectable (viable) from the drop down in the Options manager. When I add the attribute I get an error message

Any ideas please?

Decostyle,

-Again which versions are you using?
-I can't find any version of DP in which admin/includes/functions/general.php is modified, am I missing something?

Decostyle:

I'm having the same error now when adding a new attribute. I tried some of the fixes suggested in this thread but it still doesn't work: would appreciate if any one can help?

The problem comes because dual prices/wholesale pricing adds a field to the attributes table.

admin/includes/functions/general.php

madfastride

I am using Zencart 1.3.8.a with DUAL Pricing version 2 currently in the download section of the zen.

Since then I have painfully gone through re installing my zencart as I have tried varies versions with different people after reading the forum and got really stuffed up. So regrettably I have uninstalled it. I am now using Group pricing which I am about the test but I really like the idea of DUAL Pricing version 2 ...if it worked.

I hope someone with a good knowledge, fixes, testes and name the booming thing version 4 or some other name so that there is no confusion. (well I am confused anyway)

So there it is. I will not re install it as many had bad experiences with this mod and I can see some people are keeping right out of it.

I hope this will change so we can use it.

Cheers

Hi there,
I am amazed by Zen Cart and the DUAL pricing mod. Both are working fine for me so far. I am only wondering if there is an easy way to let the wholesale customers know that they have to pay an additional sales tax (e.g."plus GST"). Could this message appear next to the price (or alternatively as permanent header/when they log in)?
... till later ...
Matt

mattinnz:

I am only wondering if there is an easy way to let the wholesale customers know that they have to pay an additional sales tax (e.g."plus GST"). Could this message appear next to the price (or alternatively as permanent header/when they log in)?
... till later ...
Matt

Matt, Which one do you want to do? You could modify the wording of "Whole Sale Price:" to something more suitable on line 94 of includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

The other method would be to add another check for a whole sale customer and display a notice in the header. This would probably happen in your includes/header.php file or your could use the messageStack feature built into Zencart (gives a notice like when you forget to delete your install directory).

The code to check for a wholesale customer looks like this. You can change your template to display a notice anywhere you want using this in any file you chose.

if ($_SESSION['customer_id']) {
  $customers_id = $_SESSION['customer_id'];
    $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
 if ($customer_check->fields['customers_whole'] != "0") { 
    
CODE YOU WANT TO USE IF CUSTOMER IS WHOLE SALE


 }
}

Hi madfastride,

thank you for your immediate solution.
I was missing that file in my current template (method one).
I changed the original file by adding "plus GST" and uploaded it.
Now everything works fine.
Wholesalers can even see the retailprice at the same time.
... till later ...
Matt

I downloaded the new dual pricing version 2 from the zen website and i am using zen cart 1.3.8a got everything installed including the sql. I can see the new box when editing customers and if i put that to 1 that means that customer once logged on will get whole sale pricing right? Well then i went to the product and under whole sale pricing adding a price "$2.40" Something like that. I didnt do the dashes because i only need one whole sale pricing, at least at the moment. I logged on as the user and i see no difference. I have gone all the way through the check out process. I would like to be able to have this where i can have a retail price and wholesale price so when the user logs on they will immediately see the price they will pay in the category view, product listing and everywhere. Is this possible. Please anyone have some info on what i could be doing wrong. Thanks

Website Rob:

If I understand correctly how this Mod works, once installed and on the Edit/New Product page, I should see an input box for Wholesale pricing.

I only see:

Tax Class:
Products Price (Net):
Products Price (Gross):

I have the same problem , no fields to put in the wholesale price.

Installed first Zen Cart 1.3.8a clean install, next dual pricing and after easy populate.

Who can help me to fix this problem?

Thanx, Andre

welchyboy:

Well then i went to the product and under whole sale pricing adding a price "$2.40" Something like that. Thanks

Try not adding the "$" it should work then. If there are other problems it could be in the install. Double check that this file is correct and make sure to place it in the folder of the template you are currently using where the file says "YOUR_TEMPLATE"; includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

welchyboy:

I would like to be able to have this where i can have a retail price and wholesale price so when the user logs on they will immediately see the price they will pay in the category view, product listing and everywhere. Is this possible.

This is the way this module works so if you can get it running you will be golden.

andre:

I have the same problem , no fields to put in the wholesale price.

Installed first Zen Cart 1.3.8a clean install, next dual pricing and after easy populate.

Who can help me to fix this problem?

Thanx, Andre

Andre,

You might try checking that this file is correctly updated in your site. It could be an FTP error that it didn't load onto your server correctly or something similar. Let me know if your having more troubles.

admin/inlcudes/modules/product/collect_info.php

Hi all,

I desperately need to figure out SOME way to get this done, and I'm sure there has to be a solution somewhere...I just can't figure it out.

Dual Pricing works great for one thing we need, which is just wholesale pricing for our retail customers. However, here's the problem. We need regular customers to be able to order whatever number of units (usually it will be 1 only of a product), but wholesalers must only be able to order units in multiples of 4 (our wholesale 'packs') or 6 in the case of one product.

I am thinking maybe some combination of Dual Pricing with Product Qty Units, although i'm all for another solution if there is one.

I know enough PHP to get around, but not Zen Cart as of yet and am still learning how it works. I know basically I need to find a way to display one ordering option to regular customers and another to retailers/wholesale in multiples of a specified number.

Is there some way I can achieve this?

Thanks!

Skye

When I was first setting up a Zen version of our sites, I put a lot of thought into making just one site that could handle both retail and wholesale customers. I ended up not doing it. As you can see from the links below, we have completely separate retail and wholesale sites.

In our case we use separate domain names, since both names had been on the web for years and were high in Google. But I believe the same thing could be done using a single domain and the domain style used by so many large companies. For example, www .apple.com, developer.apple.com, and_so_on.apple.com.

So you could have retail.skye.com and wholesale.skye.com, both under www .skye.com (or whatever your domain is.)

You'd then have a full install of ZC in each part of the site, with separate prices and minimums and sales and whatever else you need.

HTH

Rob

madfastride:

Matt, Which one do you want to do? You could modify the wording of "Whole Sale Price:" to something more suitable on line 94 of includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

The other method would be to add another check for a whole sale customer and display a notice in the header. This would probably happen in your includes/header.php file or your could use the messageStack feature built into Zencart (gives a notice like when you forget to delete your install directory).

The code to check for a wholesale customer looks like this. You can change your template to display a notice anywhere you want using this in any file you chose.

if ($_SESSION['customer_id']) {
$customers_id = $_SESSION['customer_id'];
$customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
if ($customer_check->fields['customers_whole'] != "0") {

CODE YOU WANT TO USE IF CUSTOMER IS WHOLE SALE

}
}

I can't get this code to work. Tried inserting it in tpl_product_info_display to simply output a message -- echo("you are wholesale!"); in place of "CODE YOU WANT..." and it breaks the page. 

It should work anywhere in the code right? Anyone get this to work?

rstevenson:

When I was first setting up a Zen version of our sites, I put a lot of thought into making just one site that could handle both retail and wholesale customers. I ended up not doing it. As you can see from the links below, we have completely separate retail and wholesale sites.

In our case we use separate domain names, since both names had been on the web for years and were high in Google. But I believe the same thing could be done using a single domain and the domain style used by so many large companies. For example, www .apple.com, developer.apple.com, and_so_on.apple.com.

So you could have retail.skye.com and wholesale.skye.com, both under www .skye.com (or whatever your domain is.)

You'd then have a full install of ZC in each part of the site, with separate prices and minimums and sales and whatever else you need.

HTH

Rob
I'm really hoping to not have to do this, but it may be the best solution in the end. Mostly I'm concerned with setting my clients up with multiple admin panels, multiple databases, two places to update/change products etc, though in the end it will allow all the flexibility we need on the front end.

I started digging deeper in the code, it's a bit intimidating for my skill level, but maybe I can write something to take care of this.

I don't want to go start implementing a different cart, but are there others that are more flexible in this arena of wholesale/quantities/etc support?

slowawake:

Hi all,

I am thinking maybe some combination of Dual Pricing with Product Qty Units, although i'm all for another solution if there is one.

Skye

Looks like your on the right path. The code you have question about and can't get working does work.

<?
if ($_SESSION['customer_id']) {
    $customers_id = $_SESSION['customer_id'];
    $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
        if ($customer_check->fields['customers_whole'] != "0") {

// YOUR CODE


  }
}
?>

I've done several customizations of this module wrapping that code around different elements. You will need to wrap it around portions of Product Qty Units so that it is only activated when a whole sale customer is logged in. As far as the troubles your having with that code try turning on strict error reporting to see what the actual problem is with the site. To do this create the file YOUR_DOMAIN/includes/local/configure.php
and place in the file the following code

<?php
define('STRICT_ERROR_REPORTING', true);
?>

Reload the page your having troubles with and sort through all the errors. The fatal error is the one breaking your site (Inherently the last error). Check to see if you can fix that. Remember to delete or note out the define() line once you're done so that the errors aren't always showing.