Printable View
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
[FONT=Times New Roman]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. [/FONT]
[FONT=Times New Roman]What I did wrong ??? Th:yes: nks for any help.[/FONT]
[FONT=Times New Roman]My website: [/FONT][FONT=Times New Roman]http://www.naspex.info/designer_t-shirt/index.php[/FONT]
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!Quote:
Originally Posted by DrByte
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
Do you have any other mods installed?Quote:
Originally Posted by faristababa
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:
I do that all the time! Yeah, around line 607 of the customers.php file, there should be this:Quote:
Originally Posted by wolf99
that is what makes the field appear in your admin>customers>editCode:<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>
[FONT=Franklin Gothic Medium]I have installed the: [/FONT]
[FONT=Franklin Gothic Medium]zencart - 1.3.5 + german[/FONT]
[FONT=Franklin Gothic Medium]dual pricing_1_3-beta3 [/FONT]
[FONT=Franklin Gothic Medium]and image-handler_2.0-zc13[/FONT]
[FONT=Franklin Gothic Medium]Actually it shut work.[/FONT]
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:Quote:
Originally Posted by faristababa
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.
[FONT=Times New Roman]I reinstall many times, the only thing I am not sure about is [/FONT]
[FONT=Times New Roman]my datab:sleepy: ank. [/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]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,
[/FONT]
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.
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.Quote:
Originally Posted by faristababa
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
OK ignore that last one, stupid me.....
Are any of the changes to admin/attributes_controller.php needed
I don't see any difference in attributes in my control panel, bar a bit of moving around with the layout.
[FONT=Verdana]Feld: customers_whole[/FONT]Quote:
Originally Posted by craftzombie
[FONT=Verdana]Typ:[/FONT][FONT=Verdana] varchar(4)[/FONT]
[FONT=Verdana]Kollation:[/FONT][FONT=Verdana] latin1_swedish_ci[/FONT]
[FONT=Verdana]Attribute:[/FONT]
[FONT=Verdana]Null:[/FONT][FONT=Verdana] Nein[/FONT]
[FONT=Verdana]Standard:[/FONT][FONT=Verdana] 0[/FONT]
[FONT=Verdana]Extra:[/FONT]
Which is the default" column?
This is what my customers section looks like in phpmyadmin:Quote:
Originally Posted by faristababa
http://craftzombie.com/zencart/phpadmin.gif
I have green circles around the sections I was referring to. You should have something similar to this.
maybe yours is the one called "standard" instead? I'm not sure since I am not a database expert by any means!
Is there a specific reason that products_price_w row is a char?
If not was thinking to change to float as currently it truncates all my wholesale price's if editing a product (ie: product wholesale is initially set to €20.57) If I edit the product it gets changed to €20)
Hopefully this will also help with the way that if no wholesale price is specified the 0 is automatically in the wholesale field when editing a product and does not have to be re-edited
[FONT=Times New Roman]ORG.`products_price_w` VARCHAR( 150 ) DEFAULT '0'
`products_price_w` varchar(150) default '0',
to
[/FONT][FONT=Times New Roman]ORG.`products_price_w` VARCHAR( 150 ) DEFAULT '0'
`products_price_w` varchar(150) default '0',
[/FONT]