per 'Category' Dual or Wholesale Pricing

[shags38]

I would like to be able to set wholesale customers a 'discount per category', and it should override Salemaker discounts - is there a plugin or other modification that will do this. I have searched plugins and forums and Google but the closest I found is 'Dual Pricing - Wholesale Pricing' plugin but it only allows setting a net price, per item.

Any ideas on how this could be achieved?

cheers,
Mike

[mprough]

Check these out

https://www.zen-cart.com/downloads.php?do=file&id=2154
https://www.zen-cart.com/downloads.php?do=file&id=154

~Melanie

[shags38]

Check these out

https://www.zen-cart.com/downloads.php?do=file&id=2154
https://www.zen-cart.com/downloads.php?do=file&id=154

~Melanie

Many thanks Melanie - I installed your Group Pricing Unlimited on a 1.5.5f install using method 2 (overwrite a core file, collect_info.php) and the same (overwrite) with the two includes files /includes/functions/functions_prices.php and /includes/classes/shopping_cart.php and am getting the following myDEBUG error - symptoms were only two lines in admin/configuration/Group Pricing Unlimited (version and status, nothing else, expected more?) and an error on admin/catalogue/products > product page 'Group Pricing - WARNING: An Error occurred, please refresh the page and try again.' and nothing at all under that, no content.
My knowledge of database code is very limited so I am not sure how to resolve this.

[04-Sep-2018 06:26:16 UTC] Request URI: /admin/product.php?cPath=65&product_type=1&pID=279&action=new_product, IP address: 203.63.42.62
#1  trigger_error() called at [/home/rings1/public_html/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/rings1/public_html/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/rings1/public_html/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/rings1/public_html/admin/includes/functions/extra_functions/group_pricing_unlimited.php:16]
#5  get_gpu_pricing() called at [/home/rings1/public_html/admin/includes/modules/group_pricing_unlimited.php:20]
#6  require(/home/rings1/public_html/admin/includes/modules/group_pricing_unlimited.php) called at [/home/rings1/public_html/admin/includes/modules/product/collect_info.php:417]
#7  require(/home/rings1/public_html/admin/includes/modules/product/collect_info.php) called at [/home/rings1/public_html/admin/product.php:142]

[04-Sep-2018 06:26:16 UTC] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY group_id' at line 1 :: SELECT * FROM zen1_group_pricingORDER BY group_id ==> (as called by) /home/rings1/public_html/admin/includes/functions/extra_functions/group_pricing_unlimited.php on line 16 <== in /home/rings1/public_html/includes/classes/db/mysql/query_factory.php on line 171

*changed all instances of my admin folder name in above file to 'admin' for security reasons
cheers,
Mike

[swguy]

./YOUR_ADMIN/includes/functions/extra_functions/group_pricing_unlimited.php line 20
change

TABLE_GROUP_PRICING. "ORDER
to
TABLE_GROUP_PRICING. " ORDER

(space after quote).

[shags38]

./YOUR_ADMIN/includes/functions/extra_functions/group_pricing_unlimited.php line 20
change

TABLE_GROUP_PRICING. "ORDER
to
TABLE_GROUP_PRICING. " ORDER

(space after quote).

Thanks for that Scott - it did get rid of the error warning however the overall function has not improved - I now get the myDEBUG error below - I am wondering if the database table prefix may be an issue? I use a prefix zen1_ ... checking the database a configuration_group exists for Group_pricing_unlimited and are there two entries in configuration, version and status.

[05-Sep-2018 00:04:02 UTC] PHP Fatal error:  Call to undefined function zen_draw_label() in /home/rings1/public_html/MY_ADMIN/includes/modules/group_pricing_unlimited.php on line 29

Attachment 18020
Attachment 18021

[swguy]

This is a 1.5.5 function; you can just add it to

admin/includes/functions/html_output.php

  function zen_draw_label($text, $for, $parameters = ''){
    $label = '<label for="' . $for . '" ' . $parameters . '>' . $text . '</label>';
    return $label;
  }

[shags38]

This is a 1.5.5 function; you can just add it to

admin/includes/functions/html_output.php

  function zen_draw_label($text, $for, $parameters = ''){
    $label = '<label for="' . $for . '" ' . $parameters . '>' . $text . '</label>';
    return $label;
  }

Thanks Scott - that worked.

So I have read the readme but cannot find an explanation as to how to;
a) create groups
b) add a customer to a group

also I assume to populate groups to products I would use EasyPopulate and adjust every group price manually?

I appreciate that this plugin is based on 'product and unit price' - ideally I was hoping for a process whereby I could apply a discount 'percentage' off list prices 'by category' for different levels of wholesaler/stockist, .i.e. some will get a larger discount than others based on their level and some will not want, need, be authorized for all categories.

Applying a discount per category can be done via coupon manager using the restrictions tab however it does not allow to apply the discount to the 'list price only if the product is on special', hence a wholesaler would get discount on sale price .... (inbuilt SaleMaker has the function selection to do this) ... if that function was available in the coupon admin it would solve my requirement (and be useful to others I would think).

In your opinion could this function be added to the coupon program without a massive rewrite? I am not a coder so am not sure what may or may not be involved.

Many thanks for your support,
cheers,
Mike

[swguy]

a) create groups
- Admin-Customers-Group Pricing, then do an Insert
b) add a customer to a group
- Admin-Customers-Customer-Edit then at the bottom, set pricing group.

BTW just sent you email. There are much less painful ways to accomplish this.

[shags38]

a) create groups
- Admin-Customers-Group Pricing, then do an Insert
b) add a customer to a group
- Admin-Customers-Customer-Edit then at the bottom, set pricing group.

BTW just sent you email. There are much less painful ways to accomplish this.

Thanks Scott - I haven't seen your email yet ?

cheers,
Mike

[shags38]

Found the email