Should I make an osCommerce Integration?

[HuangA]

Hi;
Just wondering if there is or should I be coding an osCommerce Integration hack? I need one done so that both osCommerce and vB use the same user database, and perhaps offer discounts based on user group; and thus far, I've yet to see anything like it. So, here's a quick poll, should I do it or not?

[13th_Disciple]

you got my vote.. however, you may want to speak to Wayne Luke.. I think he may be able to offer you a bit of insight as to OSC and vB integration.. I personally would love to see this and with the discount per usergroup option you mentioned..

nice idea and gl if you decide to do this..

[HuangA]

Right now, I can foresee two or three set backs; one of them is fairly small, and the other two I still need to poke around...

First, the small one is the user integration. OSC have their 2.2 Milestone 2's database structure listed in a PDF file bundled with the download. From what I can see, there will need to be a few custom fields added to vB's db, and a new registration form made to get all the info into the right tables.

Second, the slightly bigger one is the looks and feel of vB. Right now, I am not sure if the vB looks and feel can be carried over as I've had my vB license for lesser than a month and I have no idea how to clone the looks and feel yet; this could be a set back that I'll have to look at / address later.

I have yet to look at OSC's purchase system, I wonder if it would be very difficult to add a few SQL calls around them to check for user group and apply discounts or if there is similar modules. I think an easy way to tackle this is to set two price tags to each merchandies; one for standard price, another for discounted group's price. But by doing so, it will limit the discount to only one usergroup alone. Ideally, I would like to have multiple user levels with different discount values for each product. That definetly will need some work, and thus is the biggest set back I can foresee right now.

I think, given time and assume that I can work out those above three things, integration shouldn't be possible. If all else fails, another way to do it is to use snipplets of OSC's code, and build it from vB. However, that way it wouldn't be an integration, but quite a large hack...

I would definetly like to hear some opinions on this one though. Seems to be quite a bit of work ahead of me and I'm not even quite sure where to start yet :)

[SaN-DeeP]

Hi;
Just wondering if there is or should I be coding an osCommerce Integration hack? I need one done so that both osCommerce and vB use the same user database, and perhaps offer discounts based on user group; and thus far, I've yet to see anything like it. So, here's a quick poll, should I do it or not?
If something like this is possible. I am ready to pay $$ too :)

Thnx. for putting this up

[romanticyao]

ofcuz you should! i m waiting for this...:ninja:

[HuangA]

Good news, I was pointed to a link which covers how to make none vB pages look like vB. That means one of the three problems is kind of resolved. I will start poking around with it shortly.

[DrkFusion]

Well an integration would be dandy, but what exactly needs integrating?

[HuangA]

The most essential part of both softwares -- the users. And perhaps the interface, so that the two looks the same through out.

As mentioned above, what I have in mind right now is to share the "user" table from vBulletin with osCommerce to replace its "customers" table. Then, preferably, I would like to try to make it so that both software share the same skin so the site looks the same through out. Finally, I would like to try to make it so certain selected user group can have discounted price on selected items.

If there are any other suggestions, I would definetly like to hear it and see if I can include it in this one...

Cheers

[mattster2002]

I like to think of the two as seperate sites, but it would be extremely handy to intergrate the users table. I currently run a store on osCommerce and forums on vb.

[y2krazy]

Any new leads on this, Huang? I would REALLY, REALLY need this if you could make it happen!!! Thanks. :)

[Rick Sample]

This would be awesome! I have the interface of OScommerence integrated with vbulletin on my site. I just need something that can merge the user database and maybe the who's online.

EDIT** ok, this thread is old, so doubtfully he is still making it :)

[y2krazy]

I have the interface of OScommerence integrated with vbulletin on my site.How did you get this to work? I tried once and failed miserably... :disappointed:

[Rick Sample]

Basically, just use some of the same coding you used in your header.php file in your vbulletin header file, after you have the header looking the same, its just a matter of having the same exact colors in vbulletin as you do in oscommerence.

I still have a lot more work to do, I still have to integrate my footer of oscommerence and vbulletin. :)

All I need now is for someone to integrate the databases so vbulletins who's online will show users on the main site, too!

[SaN-DeeP]

well rick, when are you planning to release the same :)
It looks quite awesome on your site

Regards,

[shawno]

Hey Rick,

Checked out your site and its impressive! Any word on whether you are going to provide any details on how you did this?

Thanks

Shawno

[SaN-DeeP]

well rick, when are you planning to release the same :)
It looks quite awesome on your site

Regards,
Now i dropped the idea of forum + shopping cart integration.
There are huge edits i keep on doing to forums for users, morever sharing the information about customers on a store can be vital..

So i wont go for an integration of forums + store anyway

[inverted]

hmm, i REALLY wanted a store/forum integration, so i originally voted for this, but now that i read SaN-DeeP's post here, i dunno, ther eis an issue with having customer data open to the forum members. it might be a better/safer idea to keep them separate.

eh, keep me updated tho if you do integrate osCommerce, cuz i guess it really depends on how you do it and the features you can give.

- inverted

[RS25com]

I would be all for this, as I am curently looking for someone who has done this.

Technical stuff aside, I think it would be awesome to integrate the two systems so that it was set up like this:

The home page of the site should look a lot like vBadvanced:

Have the left column for osCommerce boxes, the middle for products & below them recent posts from select forums (say vendor forums), and finally the right side have forums stats, info, and a list of all recent posts.

So, any updates on this? :D

[PixelFx]

osCommerce what is used on vBavanced Products page or is that a custom hack? and if custom how much?

[FOZ13]

$$ in hand awaiting the hack

[Reynaldovb]

In my opinion, Oscommerce is like the most popular store software out there, but its template system sucks big time. The way that the programming code is merged with the design makes it too easy to break it for designers who dont know/dont want to learn programming.

I got a friend with a Oscommerce based store, and I cant count how many times I have had to fix things he broke while trying to change templates.

This is my opinion, but I think that instead of coding the integration, we need a new software, one that would use the amazing template system that Vbulletin has in place.

[davidcb]

It is available at http://www.oscommerce.com/community/contributions,4239/category,all/search,vbulletin and I can change it or install it for you for a fee - if you have some php knowledge then give it a go yourself - contact me at david<a>countrybumpkin.com.au if you have any questions.

[tuslic]

It is available at http://www.oscommerce.com/community/contributions,4239/category,all/search,vbulletin and I can change it or install it for you for a fee - if you have some php knowledge then give it a go yourself - contact me at david<a>countrybumpkin.com.au if you have any questions.

what kinda fee?

[KGP]

Hey Rick,

Checked out your site and its impressive! Any word on whether you are going to provide any details on how you did this?

Thanks

Shawno

I know this is old... but I am wondering the same.

[davidcb]

To integrate the two applications I used nusoap which is a common tool used to communicate between applications (can be on different servers) integrate vbulleting with other applications. You create functions in each application eg create acount in vbulletin and just call it from oscommerce or vice versa. You just have to work out how the function works in the application ie you have to look thru the source code in vbulletin on how it creates an account. But what I created for country bumpkin is very specific for their needs and will not necessarily suit your requirements. Also at the moment you have to login to both applications but with some extra work I am sure that one login can be used to be logged into both applications.

[farooqaaa]

YES!!!!! we need it :). i voted yEs,!

If something like this is possible. I am ready to pay $$ too

you can donate him ;)

[davidcb]

send me an email at david@countrybumpkin.com.au if you are interested

[Clayton]

Q. Should I make an osCommerce Integration?

A. Is the Pope Catholic?

:cheeky:




edit: will rather be looking at zencart now :p

[Ziki]

Huh I already did it for someone but don't remember who.Was quite easy

[Clayton]

Ziki make it a can do for Zen cart then we will be talking

:)

:beard:

[ociosos]

can't wait to see it working on my site :P :P

[viper357]

Did this ever happen?

[fattony69]

Did this ever happen?

No, but you could use vbcredits and vbcommerce and get the same results.

[metalguy639]

No, but you could use vbcredits and vbcommerce and get the same results.

Not if you want to actually sell something like a download and actually make money and not credits.

[Clayton]

Not if you want to actually sell something like a download and actually make money and not credits.

now who would want to do that, the internet is free afterall

;)

[metalguy639]

now who would want to do that, the internet is free afterall

;)

Its is?! But no one told my ISP! LOL

[BlackJacket]

Anyone interested in developing this or creating a mod that does this?

[steven s]

BUMP
I too need a bridge for vB4.x

[Satviewers]

Oscommerce has been integrated here: www.itvault.com