foodclub.org

Hi,
How do I get items to show up as a single row in the invoice?
We have a private database set up with PHP MyAdmin.
Currently, if I order 5kg of an item - for instance Lemons- it shows up as 5 items in the invoice and invoice processing pages.
Is there a way to get this to show as 1 item?
As an example of what I have set in the database for Lemons:
size: 1kg
price: 2.50
price_per_weight: 2.50
is_priced_by_weight: 1

Also, I see a user manual and a database fields wiki but is there an admin manual?

cheers,
Grant Focas
PEG Food Network
Woy Woy, NSW
Australia

Greetings from the northern hemisphere. Hope your winter is treating you well.

When you set an item is_priced_by_weight, it always separates rows on Invoice processing (and Invoices) into one for each quantity of the item. This is because the priced by weight feature is designed for individual quantities of items which are of varying weights: primarily the feature is designed for meats and cheeses.

E.g.
description: whole turkey
size: 1 @ average 15lb
price: 45.00
price_per_weight: 3.00
is_priced_by_weight: 1

In this case, the price of each quantity is calculated by the exact weight of the bird, which is why there is a separate row for each quantity.

For your situation with lemons, it sounds like you don't actually want is_priced_by_weight. Either that or you should set the size to the case size of the lemons. Do they sell by the case? You are buying them wholesale, correct? Sorry, I don't know how produce distributors operate in Australia so you'll have to tell me how it works. i.e. can you just buy any arbitrary amount of lemons without a minimum case size? or are there specific case sizes (either count or weight) that you have to buy to get wholesale prices?

Let me know about that and then I'll tell you how to proceed.

Thanks for replying so quickly. Winter here is pretty mild, and we are definitely on the spring side of it. I hear the U.S. summer has been really hot.
You are right - we don't want priced_by_weight for lemons and that has fixed things in the Invoice processing page (not in the Invoice page but I'm presuming that is because the order was locked - at this stage we are still in the testing phase).
We are ordering wholesale - from 2 distributors (one local farmers and one is Sydney based), we get some items from distributors by kilo (like lemons) but mostly case sizes (such as 8kg broccoli or 9 coconuts).

Sounds like you got it figured out. If your lemons can be bought by the kg, then you can make the size simply "1 kg" (as I believe you have). Then turn off is_priced_by_weight for the lemons, because each quantity (1 kg) is always the exact same weight as the next (1 kg).

One warning though: if you toggle is_priced_by_weight for an item in the middle of an order cycle where you have already generated invoices, you must "Clear invoices" to fix issues on invoices. The issues will be strange prices that don't calculate correctly for the item(s) for which you changed is_priced_by_weight. There is a bug which does not recognize a change in is_priced_by_weight in existing invoices, and the only current fix is to "Clear invoices" and generate them again.

This is usually a painless process, unless you have added a bunch of custom fees or credits to your invoices, in which case those would be lost and have to be re-added. Good thing you are still testing so you know about this issue for the future.

Also, to answer your question about why the Invoices page did not update: the Invoices page does not get updated from changes to Invoice processing data until you save. You just have to "Save data" on Invoice processing. But once you do, beware of the above bug, because it may mess up your invoices for those items. Then just "Clear" and re-save.