osCommerce / Quickbooks interface

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

cgi on cloud hosting

October 4th, 2012

Copying a site from cpanel hosting to cloud hosting… contact page uses cgiemail to send the message.

Testing the contact page (using the domain alias before changing the nameservers) fails with a not found error on accessing the script and include file.

Trying to access the mail script without the following bit of the path attempts to download the file instead of run it, so it appears to be a web server config problem.

Try adding a handler in a .htaccess file in the cgi-bin directory:

<FilesMatch “cgiemail”>
SetHandler cgi-script
</FilesMatch>

Following that, if you get an Internal Server Error (500), try setting the file permissions to 755.

osCommerce 2.2 Errors on copying a store to a new server

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: totalhealthnow.co.uk

July 5th, 2012

TotalHealthNow is a familyrun alternative health business. The web site contains background information on therapies as well as offering products and mailing list subscription. Future plans include e-commerce.

The layout design expands to fill the full browser width and is optimised for search engines so that the different central content of individual pages is contained nearer the top of the html irrespective of the column layout.

Visit the site and see for yourself: www.totalhealthnow.co.uk

New client site released

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.

osC Addon: SPPC (Separate Prices Per Customer)

April 18th, 2011

Now, just to be clear, I can’t claim much credit for this. It’s a huge add-on developed by lots of people including Jan Zonjee.

All I’ve done is to apply all the specified changes to a 2.3.1 store instead of 2.2, do some testing and bug fixing, and upload the results. I’m also keeping a store online with it implemented (at least for now) and following the thread so I can support any 2.3.1-specific problems.

You can download it from osCommerce Add-ons and get help in the support forum.

osC Add-on: Quick UK Localisation

April 18th, 2011

There might be thousands of existing add-ons for osCommerce 2.2, and it’s even true that many of them work on 2.3.1, but sometimes there isn’t what you need and you have to get on and do it yourself… so I did.

Initially aimed at converting an already-installed store (eg. from cpanel / Fantastico etc), this add-on has been extended so that you can overwrite the downloaded osc install and then run it in one step.

It basically converts the installed store and sample data from being US-based to UK-based, including date format, currency, address format. It sets up a European tax zone, changes ‘state’ to ‘county’ and leaves this free-text.

If you might need it, you can get it at osCommerce addons and see what it looks like in my development store. If you’ve got questions about it, please use the support forum, unless you want to ask me for paid help in implementing it, in which case get in touch directly.

osCommerce 2.3.1 Development store set up

April 18th, 2011

I now have an osCommerce 2.3.1 store set up, so if you want to see what it looks like, go to http://neo-lasers.co.uk/shop-23/ which hasn’t had any changes to the delivered template (at least, not so far) but has a couple of add-ons loaded that configure the appearance.

Development osCommerce stores set up

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.

New client site released

April 25th, 2010

Just this week, I was asked quickly to implement a basic site for a last-minute candidate in the elections in a couple of weeks. She was able to give me text and images that had been prepared for a flyer, so it was possible to get the site up and running on the basic hosting in under a day’s work. The site is www.eolayokun.co.uk for Elizabeth Olayokun.