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.

FWIW I've been working on some stuff with SpreeCommerce (spreecommerce.com), it's a shopping cart system written in Ruby on Rails.

mydb=> \dt

List of relations

Schema | Name | Type | Owner

--------+-----------------------------------+-------+---------

public | schema_migrations | table | mydb

public | spree_activators | table | mydb

public | spree_addresses | table | mydb

public | spree_adjustments | table | mydb

public | spree_assets | table | mydb

public | spree_calculators | table | mydb

public | spree_configurations | table | mydb

public | spree_countries | table | mydb

public | spree_credit_cards | table | mydb

public | spree_gateways | table | mydb

public | spree_inventory_units | table | mydb

public | spree_line_items | table | mydb

public | spree_log_entries | table | mydb

public | spree_option_types | table | mydb

public | spree_option_types_prototypes | table | mydb

public | spree_option_values | table | mydb

public | spree_option_values_variants | table | mydb

public | spree_orders | table | mydb

public | spree_pages | table | mydb

public | spree_payment_methods | table | mydb

public | spree_payments | table | mydb

public | spree_preferences | table | mydb

public | spree_prices | table | mydb

public | spree_product_option_types | table | mydb

public | spree_product_properties | table | mydb

public | spree_products | table | mydb

public | spree_products_promotion_rules | table | mydb

public | spree_products_taxons | table | mydb

public | spree_promotion_action_line_items | table | mydb

public | spree_promotion_actions | table | mydb

public | spree_promotion_rules | table | mydb

public | spree_promotion_rules_users | table | mydb

public | spree_properties | table | mydb

public | spree_properties_prototypes | table | mydb

public | spree_prototypes | table | mydb

public | spree_return_authorizations | table | mydb

public | spree_roles | table | mydb

public | spree_roles_users | table | mydb

public | spree_shipments | table | mydb

public | spree_shipping_categories | table | mydb

public | spree_shipping_method_categories | table | mydb

public | spree_shipping_methods | table | mydb

public | spree_shipping_methods_zones | table | mydb

public | spree_shipping_rates | table | mydb

public | spree_skrill_transactions | table | mydb

public | spree_state_changes | table | mydb

public | spree_states | table | mydb

public | spree_stock_items | table | mydb

public | spree_stock_locations | table | mydb

public | spree_stock_movements | table | mydb

public | spree_stock_transfers | table | mydb

public | spree_tax_categories | table | mydb

public | spree_tax_rates | table | mydb

public | spree_taxonomies | table | mydb

public | spree_taxons | table | mydb

public | spree_tokenized_permissions | table | mydb

public | spree_trackers | table | mydb

public | spree_users | table | mydb

public | spree_variants | table | mydb

public | spree_zone_members | table | mydb

public | spree_zones | table | mydb

(61 rows)

On Thu, Apr 10, 2014 at 12:31 AM, Hartmut W Sager <hwsager@marityme.net> wrote:

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.

As a bit of an aside, I wouldn't trust or use anything derived from osCommerce, including the very pricey Magento cart.

Hartmut Sager

On 9 April 2014 16:40, Bradford C. Vokey <brad@fsi.ca> wrote:
Further to the number of database tables Opencart creates with its default modules:

The answer is...
MariaDB [spiritoos]> show tables;

+-----------------------------------+
| Tables_in_spiritoos |
+-----------------------------------+
| oc_address |
| oc_affiliate |
| oc_affiliate_transaction |
| oc_attribute |
| oc_attribute_description |
| oc_attribute_group |
| oc_attribute_group_description |
| oc_banner |
| oc_banner_image |
| oc_banner_image_description |
| oc_category |
| oc_category_description |
| oc_category_filter |
| oc_category_path |
| oc_category_to_layout |
| oc_category_to_store |
| oc_country |
| oc_coupon |
| oc_coupon_category |
| oc_coupon_history |
| oc_coupon_product |
| oc_currency |
| oc_custom_field |
| oc_custom_field_description |
| oc_custom_field_to_customer_group |
| oc_custom_field_value |
| oc_custom_field_value_description |
| oc_customer |
| oc_customer_ban_ip |
| oc_customer_field |
| oc_customer_group |
| oc_customer_group_description |
| oc_customer_history |
| oc_customer_ip |
| oc_customer_online |
| oc_customer_reward |
| oc_customer_transaction |
| oc_download |
| oc_download_description |
| oc_extension |
| oc_filter |
| oc_filter_description |
| oc_filter_group |
| oc_filter_group_description |
| oc_geo_zone |
| oc_information |
| oc_information_description |
| oc_information_to_layout |
| oc_information_to_store |
| oc_language |
| oc_layout |
| oc_layout_route |
| oc_length_class |
| oc_length_class_description |
| oc_manufacturer |
| oc_manufacturer_to_store |
| oc_option |
| oc_option_description |
| oc_option_value |
| oc_option_value_description |
| oc_order |
| oc_order_download |
| oc_order_field |
| oc_order_fraud |
| oc_order_history |
| oc_order_option |
| oc_order_product |
| oc_order_status |
| oc_order_total |
| oc_order_voucher |
| oc_product |
| oc_product_attribute |
| oc_product_description |
| oc_product_discount |
| oc_product_filter |
| oc_product_image |
| oc_product_option |
| oc_product_option_value |
| oc_product_related |
| oc_product_reward |
| oc_product_special |
| oc_product_to_category |
| oc_product_to_download |
| oc_product_to_layout |
| oc_product_to_store |
| oc_return |
| oc_return_action |
| oc_return_history |
| oc_return_reason |
| oc_return_status |
| oc_review |
| oc_setting |
| oc_stock_status |
| oc_store |
| oc_tax_class |
| oc_tax_rate |
| oc_tax_rate_to_customer_group |
| oc_tax_rule |
| oc_url_alias |
| oc_user |
| oc_user_group |
| oc_voucher |
| oc_voucher_history |
| oc_voucher_theme |
| oc_voucher_theme_description |
| oc_weight_class |
| oc_weight_class_description |
| oc_zone |
| oc_zone_to_geo_zone |
+-----------------------------------+
109 rows in set (0.00 sec)

... with LOTS of duplication of data... sigh...

Brad.
_______________________________________________
Roundtable mailing list
Roundtable@muug.mb.ca
http://www.muug.mb.ca/mailman/listinfo/roundtable

_______________________________________________
Roundtable mailing list
Roundtable@muug.mb.ca
http://www.muug.mb.ca/mailman/listinfo/roundtable

--
Sean Walberg <sean@ertw.com> http://ertw.com/