HELP with dual pricing_1_3-beta3

[wolf99]

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.

[faristababa]

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.

[FONT=Verdana]Feld: customers_whole[/FONT]
[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?

[craftzombie]

[FONT=Verdana]Feld: customers_whole[/FONT]
[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:



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!

[wolf99]

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]