customizing osCommerce

[fnatter]

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.

 

thanks,

[wizardsandwars]

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.

[Guest]

I dont know if this helps but try this link

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