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
  • 0

    BWGAccess is a Developers tool that can only be purchased by an approved Developer.  There are a few out there so contact SAGE and they can point you in the right direction.  That said - Import Sales Orders can be done without going to that level.  Look at the Transfer - Import Quotes/Sales Orders - click on the "How do I" and the import file document will appear here.  Good luck

  • 0 in reply to DeeDee Heyne

    Thank you DeeDee. Much appreciated. I guess the question is, I would like to get a sense of how complicated the process is, and if doable, perhaps register to become an approved developer, so that I can develop a plug-in that works with my clients e-commerce system (and then make it available to others using the same system). Thanks.

  • 0 in reply to Douglas McDonald
    SUGGESTED

    Douglas McDonal-

    Here is some more information regarding applying to be a Third Party Developer.  Through the application process you will be asked questions regarding what you are trying to develop, the scope of your program, etc….  During that process you can ask more questions regarding the BWGACCESS software and how it is used.

     

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

    at URL : https://csa-support.na.sage.com/knowledgecentral/viewdocument.do?noCount=true&externalId=83402&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=29294&cmd=displayKC&dialogID=322993&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

    Sincerely,

    Coleen

  • 0 in reply to Coleen Graber

    Hi Coleen. Thank you. Unfortunately the link you sent me to doesn't work. I tried a separate search in knowledgebase for 83402 and came up with a doc with no content (title only). Might want to look into that. Best. — Douglas

  • 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.

Reply
  • 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.

Children