Archive for September, 2009

Get a Calculator for your Website

Saturday, September 19th, 2009

A calculator can be a great asset for your website. For example, if your company lends money, your website could benefit from a loan payment calculator, so your customers could see what their payments would be, based on the amount borrowed, interest rate, and length of the term.

We can create a calculator to perform any calculation that you have a mathematical formula for. We recently built a Gold Value Calculator for a Pawn Shop. The Pawn Shop buys scrap gold from it’s customers. With our Gold Value Calculator, the customer can get an idea of what their gold is worth, on the Pawn Shop’s website, before they take it in. The Pawn Shop also uses the calculator to determine the value of their customers’ gold items, after verifying the authenticity and weight. Our Gold Value Calculator has proven to be such an effective tool, that one of the Pawn Shop’s competitors actually uses the calculator, on the Pawn Shop’s website, to determine Gold Value for his clients!

Our calculators are written in PHP. We prefer PHP over Javascript, because it is fast, effective, and hides the mathematical formula from potential copying. Viewing the source code of one of our calculators will only reveal the same information that can be seen on the screen. The mathematical formula is never displayed. 

Try our Gold Value Calculator Demo - be sure to right-click and view the source code of the calculator. Note that it doesn’t reveal the proprietary mathematical formula that performs the calculations.

osCommerce Errors

Saturday, September 19th, 2009

With new requirements for server security, many older osCommerce stores are not able to run with the new settings. A common error seen in these older stores is:

1054 – Unknown column ‘p.products_id’ in ‘on clause’

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’85′


What to do? Chances are, you probably paid for a nice template and spent lots of time adding your products and building a customer base over the years. The simplest solution is to have us upgrade your store to the latest version of osCommerce, keeping the look and feel, as well as your products and customers intact. We write custom code for your template, then move your products and other pertinent information over to the new store.

Ready to get started? Contact us by email, or give us a call at (814) 723-4105 to receive a custom quote on your store.

We also build new osCommerce sites from scratch, to your specifications!