Bit Of Oscommerce Coding

Greeting programmers!

I’m looking for an experienced OSCommerce programmer to help me with a bit of custom coding.

**** SHORT VERSION ****
I need a programmer to help me pull pricing info, based on the currently viewed category, and teach me to manually put it into category pages.

I’m using OSC 2.2 RC2 with STS Templates.

**** LONG VERSION ****
I’m in charge of our rather large OSC web store. We’re about to add a database of 1800 new Router Bits (for woodworking) in 290 categories. In the current OSC configuration, this many products would be annoying to click through.

More importantly, as you drill down the categories, you’ll end up with a single type of bit, that is available in MANY different sizes and arrangements.

The vendor who makes these router bits does a great job of arranging them on their own website, and we’re using their content. Instead of having a separate page for each product size, they have a single page with a list of available sizes. Here is an important example: http://www.amanatool.com/bits-fv/49360.html

We want to replicate this in our OSC store. To do so, I’ve created the categories, and used STS Templates to create a custom category page. On that page I’ve been moving the content from the vendor’s site, to our own. Here is a completed category page on our site based on the page I just pointed you to at the vendor’s site:
http://www.woodwerks.com/superabbet%C3%82%E2%84%A2-c-236_237_247_293.html

Now normally, all of the products in that category would show up in a grid under my custom content. But I don’t want that. So I took out the $content tag in the STS template.

Instead I add a “Add to cart” button next to each product listing and manually include the correct link.

What you’ll notice missing on my page, is a price.

THE JOB
I need some code to dump into each of these category pages, what will pull the price of each product from my products database, and put them in a price column.

I don’t know if this should be done by somehow looking at the current category you’re in, and pulling the price for every product in that category?

Either way, once the price is available, I need instructions (a line of code with product id) for dropping into the price column for each product.

The goal here is to manually list out all the products, but dynamically keep their price up to date on the page by pulling it from the database.

Good lord I hope this makes sense. Please feel free to email me with questions before you bid.

Thanks!

Robert Smith

Leave a Reply

Your email address will not be published. Required fields are marked *