<div dir="ltr">There's a Magento community edition that's free. I have no first hand experience running it but I've been following a couple of eCommerce podcasts for the last year or so and that's what almost all the interviewees are running. So perhaps this is one of those "it may not win any technical awards but it makes business sense" type of things.<div>
<br></div><div>FWIW I've been working on some stuff with SpreeCommerce (<a href="http://spreecommerce.com">spreecommerce.com</a>), it's a shopping cart system written in Ruby on Rails.</div><div><br></div><div><div>
<font face="courier new, monospace">mydb=> \dt</font></div><div><font face="courier new, monospace"> List of relations</font></div><div><font face="courier new, monospace"> Schema | Name | Type | Owner</font></div>
<div><font face="courier new, monospace">--------+-----------------------------------+-------+---------</font></div><div><font face="courier new, monospace"> public | schema_migrations | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_activators | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_addresses | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_adjustments | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_assets | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_calculators | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_configurations | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_countries | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_credit_cards | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_gateways | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_inventory_units | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_line_items | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_log_entries | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_option_types | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_option_types_prototypes | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_option_values | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_option_values_variants | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_orders | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_pages | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_payment_methods | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_payments | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_preferences | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_prices | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_product_option_types | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_product_properties | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_products | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_products_promotion_rules | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_products_taxons | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_promotion_action_line_items | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_promotion_actions | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_promotion_rules | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_promotion_rules_users | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_properties | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_properties_prototypes | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_prototypes | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_return_authorizations | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_roles | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_roles_users | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_shipments | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_shipping_categories | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_shipping_method_categories | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_shipping_methods | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_shipping_methods_zones | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_shipping_rates | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_skrill_transactions | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_state_changes | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_states | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_stock_items | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_stock_locations | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_stock_movements | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_stock_transfers | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_tax_categories | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_tax_rates | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_taxonomies | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_taxons | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_tokenized_permissions | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_trackers | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_users | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_variants | table | mydb</font></div>
<div><font face="courier new, monospace"> public | spree_zone_members | table | mydb</font></div><div><font face="courier new, monospace"> public | spree_zones | table | mydb</font></div>
<div><font face="courier new, monospace">(61 rows)</font></div></div><div><br></div><div> <br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Apr 10, 2014 at 12:31 AM, Hartmut W Sager <span dir="ltr"><<a href="mailto:hwsager@marityme.net" target="_blank">hwsager@marityme.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-size:small;font-family:verdana,sans-serif">This looks just as messy (tons of tables, fields, and duplicated data) as I saw in the (in)famous osCommerce shopping cart software a few years ago. Furthermore, the tables and fields here (in OpenCart) look remarkably similar to those in osCommerce.<br>
<br></div><div class="gmail_default" style="font-size:small;font-family:verdana,sans-serif">As a bit of an aside, I wouldn't trust or use anything derived from osCommerce, including the very pricey Magento cart.<span class="HOEnZb"><font color="#888888"><br>
</font></span></div><div class="gmail_extra"><span class="HOEnZb"><font color="#888888"><div class="gmail_default" style="font-size:small;font-family:verdana,sans-serif"> </div><span style="font-family:verdana,sans-serif">Hartmut Sager<br>
</span></font></span><div><div class="h5"><div><div dir="ltr">
<br></div></div>
<br><div class="gmail_quote">On 9 April 2014 16:40, Bradford C. Vokey <span dir="ltr"><<a href="mailto:brad@fsi.ca" target="_blank">brad@fsi.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Further to the number of database tables Opencart creates with its default modules:<br>
<br>
The answer is...<br>
MariaDB [spiritoos]> show tables;<br>
<br>
+-----------------------------<u></u>------+<br>
| Tables_in_spiritoos |<br>
+-----------------------------<u></u>------+<br>
| oc_address |<br>
| oc_affiliate |<br>
| oc_affiliate_transaction |<br>
| oc_attribute |<br>
| oc_attribute_description |<br>
| oc_attribute_group |<br>
| oc_attribute_group_description |<br>
| oc_banner |<br>
| oc_banner_image |<br>
| oc_banner_image_description |<br>
| oc_category |<br>
| oc_category_description |<br>
| oc_category_filter |<br>
| oc_category_path |<br>
| oc_category_to_layout |<br>
| oc_category_to_store |<br>
| oc_country |<br>
| oc_coupon |<br>
| oc_coupon_category |<br>
| oc_coupon_history |<br>
| oc_coupon_product |<br>
| oc_currency |<br>
| oc_custom_field |<br>
| oc_custom_field_description |<br>
| oc_custom_field_to_customer_<u></u>group |<br>
| oc_custom_field_value |<br>
| oc_custom_field_value_<u></u>description |<br>
| oc_customer |<br>
| oc_customer_ban_ip |<br>
| oc_customer_field |<br>
| oc_customer_group |<br>
| oc_customer_group_description |<br>
| oc_customer_history |<br>
| oc_customer_ip |<br>
| oc_customer_online |<br>
| oc_customer_reward |<br>
| oc_customer_transaction |<br>
| oc_download |<br>
| oc_download_description |<br>
| oc_extension |<br>
| oc_filter |<br>
| oc_filter_description |<br>
| oc_filter_group |<br>
| oc_filter_group_description |<br>
| oc_geo_zone |<br>
| oc_information |<br>
| oc_information_description |<br>
| oc_information_to_layout |<br>
| oc_information_to_store |<br>
| oc_language |<br>
| oc_layout |<br>
| oc_layout_route |<br>
| oc_length_class |<br>
| oc_length_class_description |<br>
| oc_manufacturer |<br>
| oc_manufacturer_to_store |<br>
| oc_option |<br>
| oc_option_description |<br>
| oc_option_value |<br>
| oc_option_value_description |<br>
| oc_order |<br>
| oc_order_download |<br>
| oc_order_field |<br>
| oc_order_fraud |<br>
| oc_order_history |<br>
| oc_order_option |<br>
| oc_order_product |<br>
| oc_order_status |<br>
| oc_order_total |<br>
| oc_order_voucher |<br>
| oc_product |<br>
| oc_product_attribute |<br>
| oc_product_description |<br>
| oc_product_discount |<br>
| oc_product_filter |<br>
| oc_product_image |<br>
| oc_product_option |<br>
| oc_product_option_value |<br>
| oc_product_related |<br>
| oc_product_reward |<br>
| oc_product_special |<br>
| oc_product_to_category |<br>
| oc_product_to_download |<br>
| oc_product_to_layout |<br>
| oc_product_to_store |<br>
| oc_return |<br>
| oc_return_action |<br>
| oc_return_history |<br>
| oc_return_reason |<br>
| oc_return_status |<br>
| oc_review |<br>
| oc_setting |<br>
| oc_stock_status |<br>
| oc_store |<br>
| oc_tax_class |<br>
| oc_tax_rate |<br>
| oc_tax_rate_to_customer_group |<br>
| oc_tax_rule |<br>
| oc_url_alias |<br>
| oc_user |<br>
| oc_user_group |<br>
| oc_voucher |<br>
| oc_voucher_history |<br>
| oc_voucher_theme |<br>
| oc_voucher_theme_description |<br>
| oc_weight_class |<br>
| oc_weight_class_description |<br>
| oc_zone |<br>
| oc_zone_to_geo_zone |<br>
+-----------------------------<u></u>------+<br>
109 rows in set (0.00 sec)<br>
<br>
... with LOTS of duplication of data... sigh...<br>
<br>
Brad.<br>
______________________________<u></u>_________________<br>
Roundtable mailing list<br>
<a href="mailto:Roundtable@muug.mb.ca" target="_blank">Roundtable@muug.mb.ca</a><br>
<a href="http://www.muug.mb.ca/mailman/listinfo/roundtable" target="_blank">http://www.muug.mb.ca/mailman/<u></u>listinfo/roundtable</a><br>
</blockquote></div><br></div></div></div></div>
<br>_______________________________________________<br>
Roundtable mailing list<br>
<a href="mailto:Roundtable@muug.mb.ca">Roundtable@muug.mb.ca</a><br>
<a href="http://www.muug.mb.ca/mailman/listinfo/roundtable" target="_blank">http://www.muug.mb.ca/mailman/listinfo/roundtable</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Sean Walberg <<a href="mailto:sean@ertw.com" target="_blank">sean@ertw.com</a>> <a href="http://ertw.com/" target="_blank">http://ertw.com/</a>
</div>