Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

customizing osCommerce


Recommended Posts

I work in a small company and we need to setup a webshop for a

customer, so we think about using either phpshop

(http://www.phpshop.org) or osCommerce for this.


We need support for barcodes as the unique identification for articles

(and ArticleID's which are shared between e.g. products which differ

only in color). We don't need a payment-system, we only need a order-

confirmation that is sent via e-mail. We might need to add/change

some other product-properties too.


Furthermore, and this is the hardest part: we need to synchronize the

osCommerce-DB with our customer's enterprise resource planning

database (the ERP-software needs to know when an Article has been sold

and vice versa and we need to draw the products from the

ERP-system). The problem is that the customer's ERP- system is running

on MS-SQL Server.


I have 1.5 years of experience programming php.

How much effort is this going to be? Is this realistic?

any hints would be appreciated.



Linux from *scratch* (www.gnu.org/software/emacs/)

Link to comment
Share on other sites

The only real difficult part is going to be the syncronization. OSCommerce will only work with MySQL, meaning that youd have to create a script that executes when a product is sold to update your ERP software. So, you'd need to know how to update your ERPsoftware on MS SQL erver through a script that's executed when an item is purchased.


Since you'd probably need more than just inventory to sync, you'd need to write a different scirpt for each thingthat you need to keep in sync, and place thin into OSC accordingly. Or you could put all of the syncing commands in one script and only sync periodically, through a scheduling program, like cron or winat.


NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

  • 2 weeks later...

I dont know if this helps but try this link


They have an ERP solution and an Ecommerce solution so maybe the two can be combined or the ecommerce has all you need from the box. :D

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...