Archive for the ‘osCommerce 2.2 RC2a’ Category

osCommerce / Quickbooks interface

Saturday, February 9th, 2013

Recently released: interface between osC 2.2 and Quickbooks using QBWC

This is a complex & rich implementation, which linked an existing online catalogue & customers with existing inventory and customers in Quickbooks, which is used to record high-street shop customers and transactions. Ongoing functionality keeps stock levels in sync and feeds online transactions and customers to QB.

As well as semi-automated take-on, there’s flexible matching support that makes it straightforward to link the two inventories – no automated product/item creation.

The Quickbooks Web Connector (QBWC, available free from Intuit) runs on a pc alongside the desktop versions of Quickbooks, and communicates with a SOAP server based on ConsoliByte’s PHP integration framework. This was developed to implement the necessary calls, plus a transaction manager within osC to group together the several interface calls needed to support a shop transaction.  The main constraint is that QBWC requires SSL (but then, so does a fully integrated implementation of Googlecheckout/Google Wallet).

I expect to begin a simpler QB interface implementation for another site, based on osCommerce 2.3.1

osCommerce 2.2 Errors on copying a store to a new server

Sunday, August 5th, 2012

Recently I’ve been setting up a test server within the LAN (to be able to use Quickbooks Web Connector without an SSL licence) and have had to resolve several errors relating to setting up a copy of an osCommerce 2.2 store.

Some issues relating to .htaccess files:
– these are used particularly in shared hosting to set specific system options that you might better set as server options on your own server
– a new LAMP installation typically defaults to not processing .htaccess files, so they are ignored
– when copying a store with URL rewriting enabled, the page links within the store are set to the rewritten URLs, but the server rewriting rules for the store are contained in the .htaccess file in the catalog directory and being ignored by default
– enabling the .htaccess files causes both the catalog and admin sides of the store to fail with Internal Error 500s
– the catalog side fails because other default server settings do not allow the .htaccess files to override server settings so you have to set AllowOverride to On for the URL rewriting
– the admin side fails because the password protection settings for the directory refer to paths and files on the old server

New client site released

Monday, April 18th, 2011

Actually, this is rather old news – it was released back in October 2010!

The site is an e-commerce site based on osCommerce, with a lot of add-ons and a certain amount of bespoke development, including postcode-based shipping calculations. The catalogue was initially seeded by taking on data from an ms-access database.

It’s currently hosted at www.cheapcablesonline.co.uk but may be relocated to a sub-directory of the main company site (www.clubtek.co.uk) at a later date.

Development osCommerce stores set up

Tuesday, May 4th, 2010

Just set up a couple of osCommerce installations, initially to investigate the different behaviours of the two add-ons PWA (Purchase without account) and Checkout Redux, which streamlines things but seems to have a bug or two. Checkout Redux is on shop one while the other store started with PWA and is now getting other stuff on top, towards a suggested initial package for most stores. The front page should carry a current list of add-ons here.