[OFBiz] Users - Catalog and product organization question

[bjfree at free-man.net]

This is only a suggestion, you may get others.
You define a Store and make that the school.
Catalog groups products. so a Catalog can be a grade or course. you can
assign many catalogs to a store or a student.
You can use a derivative of the Bill of material to make a class/course.if
you look at how Ecommerce runs a job when a product that is a BOM is ordered
you will get an idea how to do the inventory part of the class.
Look at the Ecommerce marketing, you can set up a class to have so many
orders (signups)
There is a Start and end date for each product. That can be used to schedule
the classes.
 
 
 
-----Original Message-----
From: Manuel Meyer [mailto:m.meyer at wanadoo.fr]
Sent: Saturday, May 07, 2005 10:56 AM
To: users at lists.ofbiz.org
Subject: [OFBiz] Users - Catalog and product organization question



Hello all,

 

I am facing a problem, I can see several ways but I think I definitively
need a couple of advices.

 

I am building a site where people will be able to book lessons.

The lesson duration is between 1 and 2 hours, lessons are distributed on a
calendar.

 

You can have for example

 

May 2005

Monday 16 

LessonA - 2 to 4 pm

LessonB - 10 to 12 am

LessonC - 4 to 6 pm 

 

Tuesday 17 

LessonD - 2 to 4 pm

LessonE - 10 to 12 am

LessonA - 4 to 6 pm 

 

Wednesay 18

LessonA - 2 to 4 pm

LessonB - 10 to 12 am

LessonF - 4 to 6 pm 

...

June 2005

...

Monday 6 

LessonG - 5 to 7 pm

LessonH - 10 to 12 am

LessonA - 4 to 6 pm 

...

 

People are buying a lesson or a set of lesson, but they do not have to
follow a school program - lessons are independent.

You are not obliged to have followed LessonA to book LessonB.

 

6 different schools are planned, and each lesson belongs to only one school.

 

You have for example

School1

LessonA

LessonB

...

School2

LessonC

LessonD

LessonE

...

School3

...

... and so on.

 

You can navigate thru lessons by school (I want to take a lesson on school
s1) or by date (I want to take a lesson this day - what do you offer that
day).

You'll (probably) be obliged to select a date for your lesson of you want to
order a lesson.

 

I was thinking about creating 1 category per school, and set LessonA,
LessonB... LessonX as virtual products belonging respectively to one
category.

For exemple, LessonA should be a virtual product belonging to category
'school1'.

 

Then, to assign a date to a Lesson, I was panning to create a variant of
LessonA, and assign it a feature containing a date.

So, LessonA - May 2005 - Monday 2 - 2 to 4 pm could be a variant of LessonA,
having May 2005 - Monday 2 - 2 to 4 pm as a feature.

Regarding the feature type, I was thinking about creating a feature with a
uom of TM_min, for example, which would represent the number of mn since
January 1, 1970, 00:00:00 GMT.

Then for each lesson, I'll have to create a feature of the type mentioned
above and assign it the number of mn since January 1, 1970, 00:00:00 GMT as
quantity.

 

Does this make sense? I haven't seen other way to achieve that, but this
solution does not satisfy me too much - it looks like it does not fit in the
design of product feature.

 

The type of product could be 'service'.

 

On the other hand, I am also interested by the 'fixed asset usage' product
type, because every lesson has a limited number of people that can book for
the same date, and there is a check on this done by ofbiz if you use the
'fixed asset usage' type, as I understood.

Also, being able to have a look at the planning is very important for
example to set promotions if a lesson at a given date is not heavily booked,
or to know how many students you'll have and so how many supplies you need
to buy. 

I've seen that the 'fixed asset' part of the accounting has a calendar
displaying this kind of information.

 

So, I was wondering if I can mix the two concepts (virtual + variant with
the date as a feature and fixed asset usage for the calendar and the check)
in order to achieve what I am planning.

In that case, one fixed asset will be associated with a variant product and
the global planning could be a 'sum' of the fixed asset calendar?

 

I think the problematic is interesting because the same could arise if
someone plans to sell tickets online (cinema or theatre), I was wondering if
anyone has already faced this?

 

Any comments or suggestions very welcome,

Best regards,

 

Manuel

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ofbiz.org/pipermail/users/attachments/20050507/e3f36301/attachment-0001.htm