Integrate OSCommerce & Everest ERP & quote...suggestions?
Posted: Sun Oct 16, 2011 6:54 am
Hi, I'm new to the forum. My client has an OSCommerce site and wants to a) link it with Everest ERP software, and b) auto-generate & email quotes from a click of a button on the site. (re. a) he specifically wants to be able to have OSC take an order & feed it directly into Everest ERP system; re. b) he wants the user to be able to go onto the OSC-based site, click a button, the system create a quote for that item given the various quote-details (auto-generate docx filename, autofill product codes upon typing into the online form, autofill pre-existing client info if customer-code exists, and 'remember' the email address of the client based on an email news-blast (is this possible?)). He also wants to be able to click a button and 'auto-generate' a .docx quote with auto-fill fields, auto-drop-down listing upon entering some characters (e.g. if user enters 'tim' a list auto-appears with all words/combinations in the DB starting w. 'tim'), save it as docx & pdf formats on a network server & auto-email the docx file to specific people. I have an idea of how to do this stuff in VBScript/VBA, but no clue where to start in PHP....any suggestions of coding snippets/websites for guidance would be appreciated. Cheers.