HELP with dual pricing_1_3-beta3

Hi all,

Client requires Retail/Wholesale functionality for Zen Cart 1.3.0.2 GRRRR
Have installed "dual pricing_1_3-beta3", have patched mysql.

Everything works as expected in admin, but dispite assigning a customer a "Wholesale pricing level" and certain products with a "Wholesale Price (Net)" if the customer logs in they still only see Retail prices. There are no attributes associated with any products.

Have searched and read but no cigar!!! Your help would be appreciated.

Do you have any other contributions installed?

Yes

I installed "backup_mysql_plugin_1.2.10a", which initially would not work.
I use Macromedia Dreamweaver 8 and a search of the Forum revealed this plugin's php files needed to be "checked In." This did the trick!

Thanks for your assistance DrByte, but problem is now solved.

A newbe mistake, I use my own template with the override system and stupidly uploaded the include/classes and include/functions files to my template folder.

Placing them in their intended locations solved the problem and the beta version so far works fine. :smile:

totaly off topic but I had to let the world know that I am really finding sholly's icon desturbing. wow but not in a bad way

Hi, I have a little problem too whit my -- dual pricing_1_3-beta3 --. I have my Zen shop 1.3.5. running - I installt dual pricing_1_3-beta3. It works fine, only 1 problem if somebody register in my shop he get automatic the wholesale price. My Shop admin give him no number and so he gets wholesale instead of retail.

What I did wrong ??? Th:yes: nks for any help.

My website: **http://www.naspex.info/designer_t-shirt/index.php**

The dual-pricing 1.3-beta3 code is not designed for v1.3.5 -- it was hastily upgraded for v1.3.0 and has not been kept up to date since then.

That may or may not be the problem.

DrByte:

The dual-pricing 1.3-beta3 code is not designed for v1.3.5 -- it was hastily upgraded for v1.3.0 and has not been kept up to date since then.

That may or may not be the problem.

I'm using it on 1.3.6 with no problems other than when you edit a product you need to re-enter the wholesale price because the field is empty after you press edit. I am using it with the Cross Sell Advanced Module and the Quick Updates Module on a fresh install of 1.3.6. I am using it with all four levels and have tested it every way possible and all was positive. I guess I'm one of the lucky ones!

I also have it installed on a site that was upgraded to 1.3.6 from 1.3.0.1, but am having issues with the four levels working. I can only get one pricing level to work on that one. I have the User Tracking mod installed on that cart and I think (?) dual pricing and user tracking use one of the same files so you have to find the code changes and combine the two (?). Don't quote me on that though!

Thanks for support, but still no idea!

In ADMIN, Customers, Edit..

Wholesale pricing: 0 For RETAIL customers this should be 0.

In my case - If a customer lock in he get automatic the wholesale price, in my ADMIN, Customers, Edit.. is NO - 0 - (retail), only when I write the - 0 - in the field the DUAL Pricing starts to work, put it is to lade the order is already done.

Where I can change this problem?
The 0 should be automatic in the field if new customers lock in.

Thanx

faristababa:

Thanks for support, but still no idea!

In ADMIN, Customers, Edit..

Wholesale pricing: 0 For RETAIL customers this should be 0.

In my case - If a customer lock in he get automatic the wholesale price, in my ADMIN, Customers, Edit.. is NO - 0 - (retail), only when I write the - 0 - in the field the DUAL Pricing starts to work, put it is to lade the order is already done.

Where I can change this problem?
The 0 should be automatic in the field if new customers lock in.

Thanx

Do you have any other mods installed?

Hi
I have this version just installed on v1.3.5. install seemed to go as it should, but there is no new field in the edit customer panel to change their pricing level!

everything else seems to be working ok (but now having two legends in admin product listing, no matter)

used fixes to general.php from craft zombie, who has had no probs on v1.3.6

tried creating new customers instead of editing old ones. Nada

any help on this one? Thanks

sorry my bad, was double sure I uploaded all files, cos thats the stupid sort of thing i'd get wrong, somehow STILL managed to miss customers.php, TWICE

:blush:

wolf99:

sorry my bad, was double sure I uploaded all files, cos thats the stupid sort of thing i'd get wrong, somehow STILL managed to miss customers.php, TWICE

:blush:

I do that all the time! Yeah, around line 607 of the customers.php file, there should be this:

<tr>
            <td class="main"><?php echo ENTRY_WHOLESALE_PRICING_LEVEL; ?></td>
            <td class="main">
<?php
    echo zen_draw_input_field('customers_whole', $cInfo->customers_whole, zen_set_field_length(TABLE_CUSTOMERS, 'customers_whole', 50), false);
?><?php echo NOTES_WHOLESALE_PRICING_LEVEL; ?></td>
          </tr>

that is what makes the field appear in your admin>customers>edit

I have installed the:
zencart - 1.3.5 + german
dual pricing_1_3-beta3
and image-handler_2.0-zc13

Actually it shut work.

faristababa:

I have installed the:
zencart - 1.3.5 + german
dual pricing_1_3-beta3
and image-handler_2.0-zc13

Actually it shut work.

Forgive me if this is a dumb question since you may have already done this, but have you tried re-installing Dual Prices and trying it again? And also, did you fix this:

admin/includes/modules/product/collect_info.php, did you try changing

'products_price_w' => '',

to

'products_price_w' => '0',

I don't know if fixing this would help, but its worth a try.

craftzombie thanx for your effort.

I reinstall many times, the only thing I am not sure about is
my datab:sleepy: ank.

ORG.customers_whole VARCHAR( 4 ) DEFAULT '0' NOT NULL;
customers_whole varchar(4) NOT NULL default '0',


ORG.products_price_w VARCHAR( 150 ) DEFAULT '0'
products_price_w varchar(150) default '0',

ORG.options_values_price_w VARCHAR( 150 ) DEFAULT '0'
options_values_price_w varchar(150) default NULL,

Thanks for that craftzombie, worked a treat.

I have another question that may take a little more to answer.

If I enter a retail price, is there a way that I can set an algorithm into code somewhere, that the wholesale price automatically appears
(as the net does if you enter gross or vice versa)
as our wholesale prices are a percentage of our retail prices
(or rather both are a percentage of the price we by them at, but the retail prices are absolute, I have entered them in on some 800 products without using a difference between gross and net)

IE: if I enter 10.00 into gross field or net field, 5.00 appears as I type in the wholesale price field.

this would also mean that I wouldn't have to go back and enter wholesale prices for all my old products.
If someone could even point me in the right direction, or hazard a guess at what files to start looking at, would be a great help!!

BTW: the mod
'products_price_w' => '',

to

'products_price_w' => '0',

didn't seem to change anything for me, If I leave the wolesale field empty, or don't re-fill it when updating a product, then wholesale still sets to nothing.

faristababa:

craftzombie thanx for your effort.

I reinstall many times, the only thing I am not sure about is
my datab:sleepy: ank.

ORG.customers_whole VARCHAR( 4 ) DEFAULT '0' NOT NULL;
customers_whole varchar(4) NOT NULL default '0',


ORG.products_price_w VARCHAR( 150 ) DEFAULT '0'
products_price_w varchar(150) default '0',

ORG.options_values_price_w VARCHAR( 150 ) DEFAULT '0'
options_values_price_w varchar(150) default NULL,

If your only problem is that you have to manually enter a "0" in customers>edit, then out of the three above, the first one is the one to look at. It looks correct, this is the sql given to us in the instructions. If you look in your phpMyAdmin under customers, there should be a row that says "customers_whole". In that row, there should be a "0" entered in the "default" column. If there is a "0" there already, then I have no clue why it is not working.

Additional to my last Q:

was thinking, maybe could to this via SQL database.

I dunno much at all about SQL, but I understand it to be (rather simply) something like MS excel for website data. If thats so is it possible to give the column that holds the wholesale price data a formula property (like in excel "=C2*3")
so that SQL calculates the wholesale direct from my retail price.

Is this possible dos any1 know, Or am I barking up the wrong tree altogether?

Is there only a two line difference between admin/attributes_controller.php in this package and the original?

am trying to integrate it with the "improved attributes controller" by bunnyip