Post by theace » Fri Jul 04, 2014 5:28 pm

Alright, so a friend of mine will be opening a website for his bakery and wanted to know of a good ecommerce platform. Having used OC for 2 years now, I figured I'd recommend it to him. However, he has a very specific requirement - one I couldn't find how to help him out with no matter how I thought about it. I don't know if a plugin for this kind of thing exists or if it is even possible. Anyway, here's the issue. Please do help me with a solution (and not necessarily a free one :) )

Since it is a bakery, he wants to have a centralized ingredient inventory. I will use a few examples to demonstrate what he wants.

Centralized Inventory -
Sugar = 5 kg
Icing = 5 kg
Flour = 10 kg
Chocolate Shavings = 1 kg
Oil = 2 Litres
Cherries = 200 pcs

Now, a product on the site, "Black Forest Cake" in size "1 kg", requires 0.75kg flour, 0.25kg icing, 0.25kg sugar, 0.1kg shavings, 120ml of oil and 10 cherries.

Another product, "Dutch Truffle" in size "500 gm" has slightly different requirements.

Now, how can this sort of a system be set up? When someone buys a "Black Forest Cake", ingredients are deducted from the centralized inventory accordingly.

A report needs to be generated on a daily or weekly basis to keep track of how much Flour, Oil, etc. is still left and what all needs to be purchased.

Further, if, say, Oil is low on stock, the store admin should get a notification (how doesn't matter. It could be email, a back end popup or something else) and once "Oil" is over, all products that need "oil" to be made should be unavailable, somehow.

Is this possible? Does it exist? Suggestions / Solutions?

New member

Posts

Joined
Sun Jun 17, 2012 2:17 am

Post by Antoni4 » Fri Jul 04, 2014 9:56 pm

Yes - this can all be done in Open Cart.

The ingredients can be modelled through options (with small modifications ofcourse). Catalog->Product->Options.

However, I would suggest NOT to modify options, but instead to add a seperate custom ingredients tab under Products.
Something like Catalog->Product->Ingredients. (this ofcourse means you will need custom tables in the database to keep track of ingredients stock)

The reason behind this, is it will make updating Open Cart to later version much easier in future.

This actually sounds like an intetesting project in Open Cart. I already have enough workload however. When does your friend plans to go Live?

User avatar
New member

Posts

Joined
Sat Sep 29, 2012 7:03 am

Post by theace » Fri Jul 04, 2014 10:54 pm

That sounds great then. As far as I know, nothing like this exists at the moment, does it?

I wasn't planning on using options as such. I had a separate "Ingredients" section in mind myself! Though not because of upgrade reasons. I was thinking of having options interface with the ingredients section as well. Something like "Black Forest Cake" with "Extra Cherries" and "White Chocolate Shavings".

Anyway, he's still looking at trying to get all the costs down. He intends to get into production by September and go live in October or later, perhaps. What would something like this cost? Considering he's just starting off, I doubt he'd be able to afford something exorbitant :|

New member

Posts

Joined
Sun Jun 17, 2012 2:17 am

Post by theace » Fri Jul 11, 2014 6:03 pm

Anyone?

New member

Posts

Joined
Sun Jun 17, 2012 2:17 am
Who is online

Users browsing this forum: No registered users and 80 guests