Price Factor

Locked

Started by farris12 on 6 Sep 2008, 9:18 PM · Views: 3,014

Results 1 to 20 of 22
This thread is locked. New replies are disabled.
6 Sep 2008, 9:18 PM
#1
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Price Factor

I'm selling paint, selling it per litre.

I sell 2,5, 5 and 10 litre cans.

My prices are per litre, ie:
2.5litre: $5 per litre
5 litre: $4.5 per litre
etc.

What I want on my product page:
A dropdown with the option to choose a can (2.5/5/10 litre)
So I selected Price by Attribute and I maked 3 attributes:
2.5
5
10

The 2.5 attribute has the following options:
Price: $5 (because it's $5 per litre)
Weight: 2.5
Price Factor: 2.5 (because it's 2.5 litre)

But, Zen calculates it wrong... I don't get $12.50 but something else (Tax included)

What am I doing wrong?

Here's a link:
LINK
additional info is on the product page

7 Sep 2008, 2:12 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

The Price Factor is used to compute the Product Price * Price Factor ... then if there are additional charges on the Attribute for an Attribute Price that is added in ...

If you also mark the Product as Priced by Attribute, you will get some really weird results ...

If you edit the Product and set the Product Price to 5.00 and mark it as Priced by Attribute NO ...

Then, go to the Attribute for the 2.5, then you will get:
Product Price + Product Price * Price Factor
5.00 + 5.00 * 2.5 = 17.50

If you include an Price Offset of 1.00 you will get:
5.00 + 5.00 * (2.5 - 1) = 12.50

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

7 Sep 2008, 8:17 PM
#3
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

Why do I have to make the price 5.0?

It's only $5 per litre when it's 2.5 litre...
It's $4.5 per litre when the costumer buys 5 litre, etc etc

How do I have to make that in ZC?

7 Sep 2008, 11:23 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

There are a number of ways to price this ...

Using the Price Factor, you need to set a Product Price ... otherwise, you cannot use the Price Factor ...

You could put the full price on the Attribute and then when they buy at the 2.5 liter they get the 2.5 liter price ...

It all depends on how you want the initial price to look ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Sep 2008, 6:29 AM
#5
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

ok :smile:.

I think I can't use a fixed price, because of the fact that the pice depends on the # of liters...
So I think the best way is to doit with Attributes, isn't it?
But do I have to do something with the + or - in the attributes?

When there will be a new version of ZC (ever), they have to make this clearier... :D

8 Sep 2008, 3:05 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

On attributes, the + or blank is add to the Product Price (if any) and the - is subtract from it ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Sep 2008, 3:12 PM
#7
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

I don't get it....

If I set a Product Price, I can't make qty discount (that's what it is, because for 2.5L you pay $5/L and for 5L you pay $4,5/L) because ZC is only working with the product price (and that's NOT $5 for 5L paint, but $4,5).

Everything that has to deal with 2.5L works by now, because that has to deal with the $5. But everything else then the 2.5L can doesn't work, because the price per liter gets lower when the costumer buys more...

It's very easy when I have my prices per can instead of per liter, but I haven't and calculating to 2.5L/5L etc is too much work if there is a option for it in ZC (if there isn't, then I have to :P )

8 Sep 2008, 3:25 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

Could you set the Product Price to the Price for 1 liter ...

Then set the Attribute for the 2.5 Liter to be:
Price Factor 2.5
Price Factor Offset 1.0

Price Factor 5
Price Factor Offset 1.0

etc. etc.

If you want to offer a discount on the number of liters, adjust the Price Factor and Price Factor Offset to obtain the right price ...

Otherwise, set the Product Price to 0.00 and set the Attribute Price to the correct amount for each of the sizes ...

If you then use Priced by Attribute, it will take that price as the displayed price ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Sep 2008, 3:52 PM
#9
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

I've done what you were saying, but I still have the problem that ZC only deals with the 2.5L price....

These are my prices:

......................2.5L......5L.........10L
......................6.93/L....5.81/L....4.97/L
TOTAL incl TAX 19%:...20,62.....34.57.....59.14

But it doesn't work!! Only the price for 2.5L is right, that's because I've set the price to 6.93... But Price Factor 5 for 5L isn't working, because the price ISN'T 6.93/L but 5.81/L....

Hard problem :)

8 Sep 2008, 6:08 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

Is there anything stopping you from just saying on the Attribute itself the actual price instead of using the Price Factor?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Sep 2008, 6:43 PM
#11
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

I am pricing the attribute, but still I dont get how to let ZC calculate that i have 2.5/5/10 liter....

8 Sep 2008, 7:59 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

Maybe we are not on the same page here ...

If I bug 2 2.5 liter things ... am I getting the 2.5 price x 2 or the 5.0 price x 1?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

8 Sep 2008, 8:55 PM
#13
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

When you buy 2x 2,5 Liter then you have to pay for 2x2,5 liter. But it would be nice that you get the price for 5L, but first I have to solve the main problem :smile:

When you buy the 5L you get some off the price/liter...

When I only have 1 attribute, I can use the Price Factor (don't ask me why hehe). The price is 2,5price/liter. that's how I want it.
But, when I have 2 or more attributes, the price factor is unusable. The price isnt anymore 2,5
price/liter, but a strange other amount.

So that is what I want: At 2,5Liter: 2,5price per liter
At 5 liter: 5
price per liter (for 5 liter it's less then for 2,5 liter, so a little bit discount).

I know that it is much easier to just set the total price per can, but in my pricelist every price is per liter, so it's too much work to calculate all prices per can.... You know :)

13 Sep 2008, 10:45 PM
#14
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

hmm after thinking about it, it's easier to calculate the price per can instead of per liter. So that's what I'm gonna do now.

But what I want now:

In the attribute dropdown box on the product page, I want this:

Color:
White 5L (+35.00) (7.00/L)
etc

How do I get that (7.00/L) thingy?

14 Sep 2008, 1:37 AM
#15
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

Pretend I know nothing about paint nor your busines ... what does the 7.00/L mean?

What is the relationship to the 5 L (+35.00) or are you trying to say it is the 35.00/5 = 7L ...

If so, can't your customers do the math? :unsure:

Is it always 7.00/L or does this change per paint?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Sep 2008, 9:23 AM
#16
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

When you buy 5L, you pay 35.00 for it. But the costumer has to see that more paint is cheaper, so that's why the x.xx/l is for.

So the 5L paint costs 35.00 and you pay 7.00/L for it (5x7.00 = 35.00)
But in the dropdown the costumer sees also:
10L (+50.00) (5.00/L)

(10*5.00/L = 50.00)

This is not a good example because when you need 5L you don't buy 10L, but it's needed that the costumer can see that 10L paint is much cheaper then 5L paint... I can put it in the description, but I think it's more convenient to do it by the dropdownbox, isn't it?

14 Sep 2008, 2:35 PM
#17
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

The problem is that half of what you see in the dropdown is text and half is a number ...

There isn't anything to manage that with properly when setup this way where the text has to be translated to a value and then a calculation made ...

Is there any kind of formula that you can see that might work with your products based on actual numeric fields where a calculation could be done?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Sep 2008, 2:41 PM
#18
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

What do you mean? I think a formula could be:

number before the L * price per liter

so 5 * 7.00 to get 35.00.

If the problem is the letter after the number of liters, then this would be a good idea:

A dropdownbox with title:
Number of liters:
and then
5 (35.00, 7.00/L)
10 (50.00, 5.00/L)
15 (60.00, 4.00/L)

14 Sep 2008, 3:26 PM
#19
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Price Factor

The number before the L was set on the Options Value as text wasn't it?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

14 Sep 2008, 8:49 PM
#20
farris12 avatar

farris12

New Zenner

Join Date:
Sep 2008
Posts:
24
Plugin Contributions:
0

Re: Price Factor

The number before the L is set in Option Value manager... Everything in Option Value manager:
White, 2.5 Liter
White, 5 Liter
White, 10 Liter

And the prices etc is set in the attributes manager