Connecting the Dots – a solution found. —

Connecting the Dots – a solution found.

Sometimes the hardest thing about working with a technical situation is scoping out the best solution – especially when it isn’t the obvious one.

For example, let’s say you want to setup an online ecommerce store, but your pricing structure does not work with teh shopping cart out of the box. At this point you have 2 choices – customize the store, or find a different way to finagle the pricing into a format the cart can work with.

Customizing the store means you’ll be adding to the upfront development expense, and you very well may be locking yourself out of any upgrades or even security patches. If the customization isn’t handled well, you very well may have a customized cart that can’t be updated, AND where the prices have to be updated one by one.

This is not a good place to be if you have several thousand products in your catalog.

The solution I’m working on involves pulling the new pricing info (received from the master vendor) into an Excel spreadsheet, which then massages the data into something acceptable. We can then export a CSV file, which the cart can read en masse.

It’s quick, simple, and easily changed. It also makes the cart updateable – a win-win situation.

Leave a Reply