Description: Open source online business solutions using osCommerce, WordPress, and SQL-Ledger. Let's get your business online quicker, better, and cheaper.
wordpress (9102) linux (6769) lamp (564) oscommerce (127) sql-ledger (4) cluster solutions (1) epixcommerce (1) epixerp (1)
SQL-Ledger offers a nice inventory control module (a.k.a. Goods & Services) that provides inventory count, and making its data available to our online store allows real-time inventories and more. For our servers that are at different locations, this could be done by querying the SL server in real time, but a lost of communications could disable our production system in this synchronous setup. So we use Slony-I to replicate data.
Whenever you have to move customers from one platform to another, a goal is always to reducing the amount of disruptions to the customers’ experience. With that in mind, it was pleasant to learn that I was able to move a customer’s password from OSCommerce to WP’s Woocommerce. It was a good deal that they both use the same password hashing framework, and it was as simple as running a test on a known hashed password between the two platforms. Now, onto moving the customers’ data, I think stored procedure may
Tracking the number of times a product is viewed is a great feature for any shopping cart to have. osCommerce has that feature. Having known that and having studied calculus so I thought it may be a good idea to also collect the time series data of the rate of change of a product being viewed. Well, that went on for almost 10 years (didn’t I say time-series data?). One day (life of a business owner first and geek second), so I thought there should be enough data to do some trend analysis and to see if it wo