Bundles vs. price-unit

[torotil]

In our foodcoop we often have the situation that the price is given in terms of some standard unit (ie. 2€/100g) but the bundle size differs from that (ie. about 250g each). The bundle size may vary though. That leads us to two issues:

1. Currently the bundle size has to be the same as the price-unit. There is no way the article comes in 250g pieces but is specified in terms of 100g. That means we have to recalculate the actual price per piece every-time.
2. There is no way to specify varying bundle-sizes when reconciling the order: One delivered piece has 280g instead of 250g and the cost needs to be adjusted accordingly.

[wvengen]

Hi @torotil, thanks for your bug report! Interesting case you have here, I'm not sure I fully understand. The unit quantity (the English term we currently use for Gebindegröße) is meant to be used when suppliers only accept a multiple of the unit distributed in foodcoops. E.g. a wholesale retailer delivers boxes of ten packages of coffee. When working with a farmer, I can imagine that the actual crate weight may vary. Some farmers ask a fixed price for a crate, others may weigh it and bill the actual total weight. Is this the case for you?

Regarding the first point: being able to distribute articles in units different from the supplier is something I've been looking into supporting more easily, including showing a kg-price for members and allowing them to order in steps of a subdivision unit. Some ideas and attempts are given in #209 and foodcoop-adam#101, but it has proved to be somewhat complicated. This is still on the agenda. If anyone wants to help in designing and implementing this, please be welcome.

Regarding the second point, members can be allotted non-whole numbers in the balancing screen. When a member has ordered 250g of a 1.5kg box of tomatoes, but the farmer has only given 1kg to the foodcoop, it is possible to enter 166g/250g=0.67 in the balancing screen for the member.

[torotil]

Some farmers ask a fixed price for a crate, others may weigh it and bill the actual total weight. Is this the case for you?

Exactly, yes.

When a member has ordered 250g of a 1.5kg box of tomatoes, but the farmer has only given 1kg to the foodcoop, it is possible to enter 166g/250g=0.67 in the balancing screen for the member.

How exactly would I do that? Do I simply put a fraction in the "actual delvilered" column? I was unable to figure that one out.

[wvengen]

Yes, you can enter a fractional number in the "Received" column in the balancing screen.

[wvengen]

Ok, so point 2 is clear now, I presume. Regarding entering price per a different unit than what's sold, do you have any idea how we could implement this (in the user-interface)? Any idea for that?

[torotil]

UI wise I'd visually group the article form into three areas:

1. Name, category, origin, remarks
2. Package unit
3. Price

Then the price section could read something like: € [price] per [number-unit] [unit] [including/excluding VAT]

• [price] is the text-field for entering the price.
• [number-unit] is the number of the base unit - if "package unit" is selected the textfield would disappear.
• [unit] is a select-box that defaults to "package unit"
• [including/excluding VAT] is a checkbox that let's the user configure whether the entered price includes VAT.

This way a specific price configuration could read: "€ [2.50] per [100] [g] [including VAT]."