Internet Commerce and Local Foods: Computer Systems
Before you get started with this software, here is an overview and questions you may want to ask first to see if this software will serve your purposes.
The localfoodcoop software is Open Source
- The source code is made available to the general public with relaxed intellectual property restrictions.
- Anyone can use and modify the source. And if they do, they cannot close the source.
- Independent developers can share features back with the community, which has lead to a great deal of collaboration.
- GPL — General Public License — not “free” — osCommerce and the localfoodcoop software are both released under the GPL
Overview of the localfoodcoop Software
Workflow:
- Administrator sets up on an order cycle
- Producers add and edit products at any time — inventory, photos, descriptions
- Admins screen product changes, then make the product changes live to public
- The order “opens” allowing customers to order. This may last for days or weeks. There is no check-out procedure; items left in the shopping cart when the order closes is considered valid orders
- After the order closes, producers log in and enter weights and mark stock
- Route managers remind customers on their routes to pick up their orders
- Invoice payments posted from previous cycle (this can be done at any time)
- Customer and producer invoice totals are saved “finalized”
- Customer and producer invoices generated as PDFs and printed for delivery day
- Delivery day — producers transport orders to designated sorting locations, volunteers sort the orders, and customers arrive to pick up their orders!
- Adjustments entered — such as for missing or damaged goods
Features not typical of standard shopping carts:
- Delivery route lists
- Product labels
- Weights can be entered to calculate product price (2.23 pounds of tomatoes)
- Adjustments — taxed and non-taxed
- Membership maintenance, shares can be purchased online
- Aging reports
- Customer balances carried forward and applied to next cycle’s invoice
- Future delivery options — installments, deposits for pre-purchase, items appear on both that invoice and noted on delivery invoice
- Webpages for producers
Overview of osCommerce
- Typical shopping cart, click, buy, and get. Always open.
- Default is one central shipping and payment processing, and one producer
- KS River Valley Brokerage has decided to use it for wholesale buyers and to be a clearinghouse for local products, not processing money
- KS customized features:
- Separate logins for producers
- Producer deals directly with customers
Questions to ask yourselves
- Order cycle system or order always open?
- Who are your buyers?
- Who fulfills your orders — producers direct to customer or co-op the go-between? What kind of distribution system will you use?
- Who will handle the money?
- Will you allow for weight-affected products? (price calculated after order place and item is weighed)
- What kind of financial interface do you want?
Main Differences in Software approaches
|
Co-op software
|
Default osCommerce
|
KS osCommerce
|
|
|
Ordering
|
Cycle system
|
Always open
|
Always open
|
|
Weight-affected products
|
Producers enter weights before invoice totals final
|
N/A
|
N/A
|
|
Order fulfillment
|
Co-op fulfills
|
Co-op
|
Producer
|
|
Money processing
|
Co-op processes
|
Co-op
|
Producer
|
|
Sales tax
|
Yes, Co-op files
|
Yes, Co-op files
|
No, producers file
|
|
Payments tracked in the system and Balances carried forward |
Yes
|
No
|
No
|