Local Food Cooperative Software

---

The Jist: This software operates on an order cycle instead of an “always open” system. Producers/farmers can log in and add products to their product catalog at anytime for sale. During a designated time, cooperative members place orders.

Software Requirements

MySQL database 4.1+
PHP 4+

Set-up

1. Create a database and run the foodcoop_v1.sql file
2. Do a find on the files for the following variables and update them to suit your needs:
   1. $state_tax
      (either comment it out if no state sales tax or update the value from .06 to your tax amount.)
   2. Producer fee:
      $producer_fee = round(($total*.15)+0.00000001,2); (change the .15 to whatever your fee is)
      $fee = "15%"; (change the 15% to whatever your fee is)
   3. Customer fee: shop/func/gen_invoice.php
      line 704: $sh = number_format(round(($total_for_sh*.15)+0.00000001,2),2); (change the .15)
      line 757: <b>Shipping & Handling + 15% Co-op Fee</b> (change the 15%)
   4. $db_user = "";
   5. $db_pass = "";
   6. $db_name = "";
   7. $domainname = "";
   8. database name
   9. database username
   10. database password
   11. localhost (only if your mysql server doesn’t use localhost)
   12. /home/user/public_html (put in your file path)
   13. yourdomainname.org
   Yes, it’s messy, but this release is a little less messy because all the hard coded email addresses and web addresses were repleaced with variables that are defined in the config files.
3. Update and place the config_ files in the home directory of your website
4. Upload the "shop" folder into the public_html or www folder into your main web folder on your hosting account.
5. Set up the following email aliases if you want to use the built in email addresses:

   customer@yourdomainname.org

   help@yourdomainname.org

   info@yourdomainname.org

   membership@yourdomainname.org

   orders@yourdomainname.org

   paypal@yourdomainname.org

   pricelist@yourdomainname.org

   problems@yourdomainname.org

   producer-care@yourdomainname.org

   software@yourdomainname.org

   standards@yourdomainname.org

   treasurer@yourdomainname.org

   volunteer@yourdomainname.org

   web@yourdomainname.org

Notes:
* the adjustments tables aren’t in use anymore, so don’t be alarmed that they don’t populate. Everything goes into the transactions table. The adjustments tables are still there until the sales reports can be updated to use the transactions report soley.

Test logins

There are five test members added so you can log in right away and see how things work.

*** Change the usernames and passwords or remove the users for production so no one can know how to log in and see all your valuable customer information. ***

In the "members" table

Username	Password
administrator	administrator
member	member
producer	producer
rtemanager	rtemanager
cashier	cashier

In the "auth_users_c" table

Username	Password
administrator	administrator

Copyright Notice

This is available under the GNU Public License. This is available under the GNU General Public License (GPL). Please see GPL.html for the full license.

More information

http://sourceforge.net/projects/foodcoop/
http://www.localfoodcoop.org/
http://sourceforge.net/docman/index.php?group_id=161048 (Select Intended Audience and click Go)

Working Examples

http://www.oklahomafood.coop/shop/
http://www.nebraskafood.org/shop/
http://www.idahosbounty.org/shop/

Feedback and Suggestions

Yes, this could be better. If you make updates, feel free to share in the spirit of open source. We would have streamlined it more, putting all variables in a list for easier editing, and several other things, but in the interest of not delaying the distribution of this information any longer, we opted to post it as is.

Version 2 is in process and is a complete re-vamping.

Email software@oklahomafood.coop

Credits

Thank you to all of those who helped make this release possible:

Nancy, Robert, Jonalu, and Cindy of the Oklahoma Food Cooperative, Randy and Roy of the Nebraska Food Cooperative, Jeannie and Laura of the Idaho Food cooperative, and Ben Anderman of the Ottawa Valley Food Coop.

Thank you and best wishes,
Oklahoma Food Coop Software Team
software@oklahomafood.coop