Tim Tim

WordPress & OSCommerce Portable PHP Password Hashing Framework Compatibility

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 be a good way to go so stay tune…

Tim Tim

osCommerce, Who Cares About Product Viewed

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 would be possible to identify a signal to purchase conversion. You know, something is not right when I was doing a sanity check on the aggregated numbers, and they are not tracking my Google Analytic numbers.

Guess what?!

Read More

Tim Tim

Member Approval Add On for Responsive osCommerce

This member approval plugin was put together for a B2B osCommerce site. The main feature was to be able let the site administrator to validate and approval every newly sign-up account prior to it having full access to competition sensitive information such as price and inventory. The front-end is fully responsive, and it has an upload page to allow a new account to submit the necessary registration documentation such as reseller permit, business license, picture of a store front, and etc. to verify its B2B status. One minor admin core file change required.

Read More

Tim Tim

Using Smart Slider2 For WordPress In osCommerce

Ok, I am a big fan of WordPress’s plugins more than osCommerce’s addons. So it is natural that I would look for a WordPress slider to use in osCommerce before installing one of osCommerce’s addons. Well, that’s because I had done both and I tend to go with the path of less resistance. Perhaps that was the path of less resistance to me as I can code a little so it was easier to hack than had to show our creative folks on how to create or update a nifty animated slide. Here I am going to show you how I had hacked Smart Slider 2 for WordPress into an OSC demo store that I am creating. I am also going to assume that you had integrated WordPress into OSC. I must say the result had turned out great. There was definitely a learning curve on figuring out how to use the slider’s admin inteface, but once that’s done you can for sure update your OSC front page with ease.

osc_smart_slider2
Click to see it in action.

Read More

Tim Tim

Integrating WordPress Into osCommerce

I had been integrating WordPress into osCommerce 2.2 since 2008 based on several online tutorials. It was a daunting task as there were a few files that needed to be modified and it was a maintenance nightmare whenever there’s a software upgrade. Then there were other similar integration attempts in both communities, OSC into WordPress or WordPress into OSC, and I had no clue what had became of them. Well, since the modular top and bottom templates implementation in OSC 2.3, integrating WordPress and OSC had actually gotten a lot easier; hence, the creation of this WordPress-OSC template. The idea was basically to make OSC’s modular header and footer available in a WordPress template. So let’s take this out for a spin…

Read More

Tim Tim

osCommerce 2.3.3 to 2.3.4 Upgrade Notes

We are working to update our osCommerce platform and as we deploy both the 2.2 and 2.3 based engines; so we are in the process of defining a commercial ready engine that we can migrate them to. The main criteria in this new engine was it must be mobile ready and it must offer a template for quick marketing response.

Since last year we have been incorporating a lot of the bells and whistles such as social login, store credit and coupon code, and ERP integration and etc. into the 2.3.3 engine, and in order to bring this engine to 2.3.4, several updates had been applied. The overall update was successful but not without minor hiccups as listed below:

  1. Ultimate SEO URL 5 from FWR produced errors from the database function update. For now caching can only be via file and not MySQL. Reference error in http://forums.oscommerce.com/topic/394421-admin-login-loop-after-upgrade-2331-to-2332/page-2.
  2. Replace bxGallery and FancyBox with PhotosetGrid and ColorBox not implemented as our current engine uses jqzoom.
  3. New Content Modules implementation for the Account, Checkout Success, & etc. TBD for the reason it conflicts with our social login and simply 2 page checkout mods.