Purchase Order for osCommerce

Recently a client of mine decided to do away with the useless “best sellers” page in admin (found at admin > reports > products purchased) and instead make it do something more useful.

Introducing the “Purchase Order” report…

1. We added a dropdown to select the last 30 / 60 / 90 days. When this is clicked the report updates to show a list of all the products sold within the selected timeframe

new_report

You’ll notice there are some extra columns; Manufacturers Name, Model, Stock on Hand. You’ll also notice a very special column where you can insert the quantity you want to re-order.

2. We added a “create purchase order” button linked to a script that creates a CSV file ready to save onto your hard drive and open up in your favourite spreadsheet.

csv

Are you asking yourself how can that be useful ? If so, then you don’t need this script 🙂 If you can see the value of having a re-ordering script like this, then get in touch with me by email ( oscshops@gmail.com ) as it can be yours at very low cost, fully installed, and fully supported and with any extra changes needed.

Possible extensions that I can think of; show gross amount of sales, show net sales, show sales made in August 2013. Show sales that have an order status of completed. I’m sure you can think of more. Use this script to supercharge your backend reporting and purchase ordering…

And here’s a video of it in action

osCommerce Bootstrap Template “AMY” now available

Pleased to say that I found time to update my “Amy” template to make it Bootstrap Enabled. Here’s a screenshot;

AMY_BS

As you can see the template changes “shape” to accomodate different viewing devices. This template changes very minimal core files (about 5 only)! Link to Demo: http://www.template.me.uk/amy_bs/

Let me know if you’re interested in purchasing, as I’ll have a special price for the first few buyers.

Responsive osCommerce now a reality, using Bootstrap

For the last couple of months a small team of coders has been working on updating the shop side of osCommerce to be responsive…

What is responsive?

Responsive Web Design (RWD) is a Web design approach aimed at crafting sites to provide an optimal viewing experience—easy reading and navigation with a minimum of resizing, panning, and scrolling—across a wide range of devices (from mobile phones to desktop computer monitors).

In easy to understand terms, the site changes “shape” if you visit in a mobile phone compared to an iPad compared to a desktop computer.

With that in mind, we had a lot of recoding to do, we pretty much pulled apart the cosmetic look of normal osCommerce and updated it to Responsive osCommerce. Have a look at the responsive version and see how it changes shape depending upon which device you are viewing it in…

Going so in-depth into the code, I also took the opportunity to update a few areas to make them more modern;

The Footer area (which is now modular and controlled from the Admin)

footer

The Reviews (which has a top-down bottom-up overhaul)

reviews

The Header area (modularisation mostly implemented)

header

Other bits and pieces new to this version;

  1. New Category Tree Class
  2. Updated checkout experience
  3. New Card Icons
  4. New Infoboxes (contact us, generic text, customer services)
  5. Grid / List switching in category display
  6. and too much more to list…

Speed

Another important factor in todays online experience is the speed at which your page displays to your customers. We put together this version to be as fast as we could make it. Using “Gt Metrix” to test our changes we saw a great result:

97

Go ahead and try your own osCommerce site and compare your results…you’ll be shocked at the difference.

Changing the look of the site

Pretty much how osCommerce has always been as we did not yet have the time to build in a template system. With just a few changes to around 4 core files I built this:

LARGE
large view

SMALL
small view

Conclusion

I’m really pleased with how this project turned out. Shopowners now have a choice to use the normal 2.3 series osCommerce or to use the new Bootstrapped 2.3. It is possible to upgrade an existing osCommerce shop from normal to Bootstrap, and this Bootstrap version has a massive advantage in that all of the existing addons are useable with it.

So, have a look at the test site. Feel free to fork the codebase or to download the master zip. Install as you would any osCommerce, then go into Admin and turn on the relevant boxes that you would like to show and relevant Header Tags.

Enjoy.