Zen Cart Logo
Forums / General Questions / HELP with dual pricing_1_3-beta3

HELP with dual pricing_1_3-beta3

Locked

Views: 3,356

Results 21 to 24 of 24
This thread is locked. New replies are disabled.
11 Jan 2007, 9:13 PM
#21
wolf99 avatar

wolf99

Zen Follower

Join Date:
Sep 2006
Location:
West of Ireland
Posts:
169
Plugin Contributions:
0

HELP with dual pricing_1_3-beta3

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.

12 Jan 2007, 5:54 AM
#22
faristababa avatar

faristababa

New Zenner

Join Date:
Dec 2006
Posts:
45
Plugin Contributions:
0

Re: HELP with dual pricing_1_3-beta3

craftzombie:

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.

Feld: customers_whole
Typ: varchar(4)
Kollation: latin1_swedish_ci
Attribute:
Null: Nein
Standard: 0
Extra:

Which is the default" column?

16 Jan 2007, 2:35 AM
#23
craftzombie avatar

craftzombie

Zen Follower

Join Date:
Jul 2006
Posts:
494
Plugin Contributions:
0

Re: HELP with dual pricing_1_3-beta3

faristababa:

Feld: customers_whole
Typ: varchar(4)
Kollation: latin1_swedish_ci
Attribute:
Null: Nein
Standard: 0
Extra:

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!

27 Jan 2007, 4:38 PM
#24
wolf99 avatar

wolf99

Zen Follower

Join Date:
Sep 2006
Location:
West of Ireland
Posts:
169
Plugin Contributions:
0

Re: HELP with dual pricing_1_3-beta3

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

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

to

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