I've spent quite a bit of time integrating an osCommerce store to MOM over the past 12 months.

Orders are exported from MOM and come down to the local server where MOM can auto import then.
Stock figure go up from MOM and update osCommerce (attribute level)
Gift vouchers are exported from MOM so available to use on the website
Order status is exported MOM and updated in osCommerce
Next delivery dates go up from MOM to osCommerce if stock is unavailable on website
Source code options go up from MOM to website so users can select how they came across website

I haven't integrated product names, descriptions, prices, shipping etc - that seemed a bit overkill given the number, and how often we update them but can be done.

There are some 3party products out there now which will link osCommerce to MOM so well worth looking into. osCommerce offers a great scalable platform which you can adapt and develop in the future.

I've made some progress on this now and have got:

- stock inventory from MOM going up to osCommerce
- orders from osCommerce going into MOM
- gift certificates going from MOM into osCommerce
- order status going from MOM into osCommerce

Can't say it's perfect but it seems to be working ok. If anyone else is working on osCommerce / MOM please drop me a line:

david |@| gossypium.co.uk

because I'd be interested in hearing how other people have got this working or how the processes could be improved.

Best wishes,

David
www.gossypium.co.uk

Hi I was wondering if anyone can offer me some advice. I'm looking to integrate MOM more tightly with our website and hopefully using some automated batch code so stock levels, order status', product prices etc can be set in MOM and be reflected quickly on the website with minimum human intervention.

At the moment I'm taking a nightly copy of the Momwin directory, and then using OLEDB from EXCEL to convert the dbf files I'm interested in, in to CSV files which I can upload to the website and work on. The only downside to this, is that the website is only updated once daily using the nightly copy of the data.

Obviously I prefer working on the copy of the foxpro database but I need to find a way to safely make a copy of it, whilst it's in use, so I can update the website more frequently. I'm not too hot on Foxpro and searching the web, and sending mail to dynacomp hasn't offered a solution.

I'm guessing that doing a windows filecopy of the MOM directory wouldn't be safe whilst it's open? I'm guessing connecting to the live database using OLEDB isn't safe either? If anyone would have any ideas or advice I'd be all ears, and it would be much apreciated.

best wishes,

David

This would be pretty easy to code for oscommerce, using some of the existing order export modules. Checkout the contribution section on their site.

This is something I'm going to be writing for our osCommerce website (www.gossypium.co.uk). I probably will adapt one of the existing modules as suggested. Feel free to drop me a line if you would like to collaborate,

thanks,

David

David does Mom work on a peer to peer network we tried it a while ago ( for a temp sol. ) and kept on getting errors
how did you do it

Sorry if I've duplicated this - I couldn't see my response had gone. I'm afraid we've never done p2p, so can't really offer any advice - hopefully someone else on the forum can help? From what I understand you can peer to peer up to 5 workstations. We want to go with the server option because hope to have more than 5 workstations in the future (initally 3). In the UK, the Dydacomp people are now suggesting 4GB ram. I'd be really greatful if anyone is running v6 on a server, if you could tell me what spec server you have and how it runs because would be a great help.

cheers,

Dave

Hi - we're looking to purchase a server to run MOM v6. I was wondering if anyone would be willing to share the specs of the server they're currently using and how well it runs?

I was looking at a server with Dual Intel Xeon 3040 Processor at 1.86GHz with 2 GB ram, but would like to be sure if this will be up to the job. We're only looking at 3 workstations initally but don't want to use peer-to-peer so we can add more workstations in the future,

thanks in advance,

David