search

nikolai-b / leeds-bread-coop

0 stars 0 forks source link

Copying data forward - wholesale orders #86

Open LeedsBreadCo-op opened 8 years ago

LeedsBreadCo-op commented 8 years ago

Is there any way in which wholesale orders could be copied forward in time.

Eg select a wholesale customers order for a particular day and copy it to another day or select a week for a wholesale customer and duplicate all entries forward and where both actions erase existing data and these actions are beyond the three day production cut off?

I'm thinking that if we receive an order change to a regular order we will need to edit it for the current week and the following two weeks so it will get copied forward. Obvs we can do this manually if its a pain to do.

Zig

nikolai-b commented 8 years ago

After you've fully migrated we could scheduled a meeting in Dec (over xmas when I'm not working) and then you'll have had a time to use it more.

Basically, can we stick with the system as it is for a while and meet after a month?

LeedsBreadCo-op commented 8 years ago

The thinking behind this is in part to do with the time it's taking us to input all the orders - we're at the point where we're updating heroku wholesale orders alongside breadorders s/s but until we've got the orders all in for 3 weeks into the future we can't transition over to it, plus subs up to date - which is 2-3 days work of data inputting, we're constantly playing catch up with it!

nikolai-b commented 8 years ago

I think the solution is to have regular orders and one-off orders. Then a wholesale customer could have up-to 7 regular orders (one per day, never two on the same day) AND one-off orders (which could be pre-filled as the regular for that day (if it exists)) but that override the regular.

E.g. Lanes has a regular 10x sour dough on Mon Mon 14th they have a one-off 12x sour dough order on Mon 7th, 21st ... they get 10x sour dough and on the 14th they have 12x

If you change the regular Monday order to 13 then the 14th would still only have 12 (it would not be altered) but all the days were there isn't a one-off would default to 13 now, the regular order.

Problems: in January you want to do some accounting but half way though Dec you'd changed the regular order from 10 to 13, then the system would not keep track of the previous regular order. We could do it so at the start of the day regular orders from yesterday become one-off orders (which are saved to the database).

Agree its important but I think we need to speak in person.