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-structure.sql and foodcoop-standard-prepopulated-data.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
   14. idaho (to catch where you want to put your own coop’s name)
   Yes, it's messy, but we've been focusing on version 2, which moves variables like this into a global definition file, etc. Wanted to get this out to people though in the meantime because it is functional.
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:

   customers@yourdomainname.org

   help@yourdomainname.org

   info@yourdomainname.org

   membership@yourdomainname.org

   orders@yourdomainname.org

   paypal@yourdomainname.org

   pricelist@yourdomainname.org

   problems@yourdomainname.org

   standards@yourdomainname.org

   treasurer@yourdomainname.org

   volunteer@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.

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.oklahomafood.coop/software.php
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, and Jeannie and Laura of the Idaho Food cooperative.

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