By dineshsbm on

Hi....
Is there any chance of integrating OSCommerce with drupal? Actually Its a task given in my company and I suppose to complete as soon as possible...

Please reply me if have ideas.

Thanks in advance...
Dinesh

⋅ Categories: Drupal 5.x

Comments

Island Usurper’s picture

Island Usurper commented

Let me put it this way: I'm writing Übercart because my company wants to start using Drupal and stop using osCommerce. Since we have a pretty extensive catalog, there are some export scripts for osC to get an XML file that Übercart can import. They aren't generally available, but I'll give them to you if it keeps you from making what I think is a huge mistake.

-----
Übercart -- One cart to rule them all.

TamboWeb’s picture

TamboWeb commented

Hello, I have been searching for some tips and ideas how to integrate oscommerce and Drupal. Unfortunately, nothing useful has come up. Here are the issues I am facing:

The Setup:
1.- I need to add Drupal to an existing matured oscommerse site to add blogging and article creation functionality.

2.- The current feature set for my oscommerce site is too extensive to be replaced. There are too many mods and custom scripts to replace if I would start with some other ecommerce module designed for drupal.

Here is the challenge:

1.- Synchronize the user login for both oscommerce and drupal. A user must be able to log in once on either the oscommerce side or the drupal side. This implies that the user id and password must be handled by one or both systems.

2.- Both drupal and oscommerce must be on same domain and not on a separate subdomains. I would put drupal in a sub directory, but leave oscommerce on the root directory.

3.- Both Drupal and oscommerce must share the sessions and cookie data to prevent any cart items from being dropped.

4.- All mods must be made to the oscommerce code to protect the modularity of drupal. Or perhaps create a drupal module to handle the visitor login data and verify it on the user’s tables for the oscommerce and drupal.

5.- No, can not use the other ecommerce modules as they do not have all the ecommerce/inventory management/order processing/merchandizing features.

6.- Must be able to use URL rewrite on both systems for seo purposes.

Well, this looks like a wish list. I am currently exploring how to integrate both systems in a way such that oscommerce is the front end (money making part) and drupal handles content generation for articles and user generated content.

Has anyone tried this? Any comments, suggestions are greatly appreciated.

Island Usurper’s picture

Island Usurper commented

I strongly suspect Übercart really can do what you need it to. Remember, we're going to be using it to replace osCommerce. We need it to work even better than what we have. The kinds of terrible, terrible hacks that you would need are far more complicated, frustrating, and expensive than writing modules for Übercart to fill in any holes in the functionality that you find.

What kinds of mods have you done to osCommerce? I think you'll be surprised by what Übercart already does on its own.

I think it's a bad idea to add Drupal to anything. Drupal is what you add things to.

-----
Übercart -- One cart to rule them all.

TamboWeb’s picture

TamboWeb commented

Hello Lyle, thank you for responding to my previous post.

The reason I am not switching over to Ubercart yet is that my current ecommerce implementation has a great deal of seo added to it and custom css design templates and many other functionality. It also has several hooks that tie the order processing into my accounting software as well as my customer database and inventory databases. These last three pieces of data are not part of the shopping cart. I run several sites with a central inventory database and accounting database running on my desktop.

Switching over to drupal / Ubercart implies that I would need to do extensive testing to insure ubercart has all the merchandising and inventory control features to name a few. In my experience, I have noticed that switching over to a new system brings in a bunch of other unintentional issues. I have briefly visited a demo drupal/ubercart site and was not too impressed initially. I can't say anything for the backend as this portion was restricted. I guess I would have to download it and test it on my localserver to see if its up to par.

Please do not get me wrong, os commerce does have its set of issues. The code is a nightmare to customize. As promising as Ubercart may seem, I still want to explore the os-commerce alternative as a second option.

I will be testing the drupal/ubercart implementation in a few days. I will post back with my review in a few days.

regards,

Sandro.

Island Usurper’s picture

Island Usurper commented

In that case, take a look at http://demo.ubercart.org. It's a site that resets every hour, but you can take a look at the adminstration section of Übercart while you're there.

I certainly understand the desire to keep all of the integration with accounting software. That's the main reason my company hasn't switched to Übercart yet. I still think that using Übercart is time better spent than Frankensteining Drupal and osCommerce (of course I do), but I admit that part of that is that I want the community to benefit from any work that you might share. That is less likely to happen with any work on osCommerce.

Don't mean to guilt trip you, but I thought I'd let you know where I was coming from, too.

-----
Übercart -- One cart to rule them all.