Automated Order Import E-commerce Integration

SUGGESTED

My client would like to import orders from their e-commerce site, as well as update the site when orders change in BW (i.e. update order status on site when order converted to invoice, update shipping tracking info, etc). It sounds like importing orders manually is pretty straightforward, by following the formatting guidelines (Importing Quotes and Sales Order pdf). If we want to automate this process, however, my understanding is that we need to use 'BWGAccess'. This is where my knowledge ends. Our Sage consultant suggested following up here for further info.

- Is there documentation for BWGAccess that is available somewhere?

- Any other options or considerations?

If anyone can point us in the right direction it would be much appreciated. Thank you. 

Parents Reply Children
  • 0 in reply to Douglas McDonald
    SUGGESTED

    Douglas McDonald-

    Thank you for letting me know about the issue with the link.  I am having someone take a look at the article to get that fixed.  In the meantime, here are the contents of the article.  If you are interesting in applying, then contact Sage BusinessWorks support via Live Chat and they can work with you to get that started.  

    How to apply for Sage BusinessWorks SDK or Third Party Developer (83402)

    Resolution

    BWGACCESS is a program that allows third-party developers to gain access to Sage BusinessWorks data files allowing the developer to Import and Export BusinessWorks data. BWGACCESS can run in the background and does not need End-user intervention to run. The developer simply tells BWGACCESS what data to import or export.

    With BWGACCESS, vertical DOS and Windows applications can access Sage BusinessWorks General Ledger, Cash Management, Accounts Payable, Accounts Receivable, Order Entry, Inventory Control, Payroll and Job Cost. The interface is seamless and requires no user interaction. BWGACCESS performs no screen output and never requests any keyboard or user input.

    BWGACCESS uses all the extensive importing and exporting features built into the Sage BusinessWorks accounting modules plus:

    • Adds additional data exporting fields
    • Allows greater flexibility in selecting data to be exported
    • Permits importing of information that cannot be imported using Sage BusinessWorks alone (Such as Inventory Control transactions)
    • One or more type of imports can be performed with a single execution of BWGAccess
    • Provides validation and generates an error log if problem is encountered
    • Does not require any user intervention or participation
    • BWGAccess is available for Windows® only and is compatible with Sage BusinessWorks Accounting

    To apply, contact Sage BusinessWorks support for information.

  • 0 in reply to Coleen Graber

    Thanks Coleen. Much appreciated. Happy New Year!