WDCI Blog...

Quickbooks Integration: Transactional Data Model

By TIM | Jun 9, 2011

If you are integrating with Quickbooks (desktop version), here we have an example of the transactional data model of the objects that can be integrated.   A customer object can have one or many transactions (Sales Order, Invoice, Sales Receipt) A transaction object can have one or many items. A Sales Order can be converted…

Read More

Dynamics GreatPlains Integration: Data Model

By TIM | Jun 1, 2011

If you are integrating with Microsoft Dynamics GreatPlains, this is the high-level data model for the finance module: A customer object is a company. It doesn’t have an independent contact object. A customer can have many addresses. Inside each address, you can keep track of contact name. A customer can have many sales entries (Invoice…

Read More

QuickBooks Integration: Transaction (Sales Order, Invoice) Counter

By TIM | May 25, 2011

When creating a transaction in QuickBooks, a transaction number will be generated followed by the last transaction created. In most of the applications, transaction number has to be unique and is not allowed to be modified to prevent duplication and confusion. However, in QuickBooks, transaction number is allowed to be modified which means that when…

Read More

Magento Integration: Synchronise Product Data

By TIM | May 19, 2011

In Magento, one SKU can have different product names. For example: If you have two different store views, you can have your product name in two different languages English: Table Spanish: Silla   To do this via the Magento Core API, you will need to: Create the product using the catalogProductCreate function (default values) Update…

Read More

Netsuite Integration: Session Limits

By TIM | May 18, 2011

A given standard Netsuite user login is limited to two sessions at the same time, one through the front-end (UI) and one through the web services.   For example, if someone attempts to log in from two different browsers at a time by using the same login user, the login from the second browser will…

Read More

Aprimo Integration : Retrieving a Digital Asset

By TIM | May 14, 2011

Aprimo has a sophisticated data model to handle Digital Asset. You can retrieve from the API directly. Before you do that, you should understand the following data structure:   Activity Each activity can have one or more digital asset. You can add an existing digital asset or promote from existing attachment.     AssetVersion Each…

Read More

Extracting Data from MYOB : Total Sales

By TIM | May 11, 2011

  There are ways to extract data like total sales from MYOB (Database) and generate this data into useful information for the company. Here is one of the ways.   First, we may need to query all the sales data from MYOB by filtering them by type of invoice.   The next step, we can…

Read More

Magento Integration: Access to web services

By TIM | May 4, 2011

In order to access Magento web services API, you will need to do the following: Log in with a username and API key. This username is not the same as the username that you used to log in to the admin backend of the store. You will need to create an API user and role…

Read More

Volusion Integration : API

By TIM | Apr 30, 2011

Volusion has an interesting API. It allows you to somehow perform a “SQL query” in the URL. For example, if I want to query customer with the following SQL:   SELECT CustomerID,BillingAddress1,City,CompanyName FROM Customer WHERE CompanyName=’WDCi’   I can achieve it with the following URL:   https://<volusion_url>/net/WebService.aspx?Login=<login>&EncryptedPassword=<encrypted_password>&EDI_Name=Generic\Customers&SELECT_Columns=CustomerID,BillingAddress1,City,CompanyName&WHERE_Column=CompanyName&WHERE_Value=WDCi

Read More

WDCi becomes one of the first certified Dell Boomi partners

By TIM | Apr 28, 2011

Dell Boomi has just launched a certification program for their partners.  If you’re asking yourself is this an attempt at shameless self-promotion, you’re right, WDCi is one of the first certified partners.  Boomi announced the list of initial certified partners in their Spring Product Release announcement.   Details on the certification program can be found…

Read More