DUAL Pricing v2

[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

[oavs]

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

[madfastride]

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.

[madfastride]

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 and there for in the meantime it is available at my web site.

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!

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

[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

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)

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

[madfastride]

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

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?

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

[oavs]

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

[mattinnz]

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

[madfastride]

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


 }
}