WDCi Blogs

Check out our Integration Planning guide, it’s simple and should help you get going.

The first problem that we had while integrating MYOB with another system was importing multiple Cards with the same name into MYOB as different Cards.

In the standard MYOB interface, it allows you to create two new Cards with the same name. However, this is retricted when the cards are created via the ODBC import function. For example:

insert into import_customer_cards (CoLastName, FirstName, InvoiceDelivery)
values ((’Andy’, ‘Cole’, ‘B’), (’Andy’, ‘Cole’, ‘P’))

This import statement will only create one Card “Andy, Cole”. The reason being is that MYOB will create a new card “Andy, Cole” using the first “value” and update the same card again using the second “value”. This is not ideal if we happen to have two customers that have the same name.

To fix this issue, we needed to add the “CardId” field to the import statement as an unique identifier for the cards. For example:

insert into import_customer_cards (CoLastName, FirstName, InvoiceDelivery, CardId)
values ((’Andy’, ‘Cole’, ‘B’, ”), (’Andy’, ‘Cole’, ‘P’, ‘0001′))

We were first introduced to SmartTurn during our recent work with integrating to eBay - SmartTurn. SmartTurn is considered one of the ‘friendly’ applications to use due to its usability and the fact it’s easy to integrate with. The simple integration interface has enabled us to deliver a few more SmartTurn integration projects for our customers over the last couple of days.

The core of the process is illustrated in the diagram above. All sales orders are saved in a CSV file which is distributed through email. Sales records are retrieved and a SmartTurn sales order is created. Throughout the process there will be email and notification alerts indicating:

• items that do not exist in SmartTurn
• errors in creating a Sales Order
• a list of successfully created Sales Orders

Direct and automated! Interested and keen to get it implemented for your organisation too? Do contact us .

Thanks to www.dryicons.com for the above people icon.

We have been approached by numerous customers to integrate eBay and SmartTurn.

The effort to develop the eBay connectivity has paid off as we are now able to sync eBay seller transactions to SmartTurn Sales Orders!

The idea was to ensure that the stock tracking operation is made easy. All items listed in eBay are stored in SmartTurn warehouse inventory system.  For every paid transaction in eBay, a sales order will be created in SmartTurn which will then update the warehouse inventory system.

Using our approach, we can cater for any e-commerce website. With this simplified inventory control,  you will be able to post your item listings in numerous e-commerce websites and use our connector to sync all your sales orders to SmartTurn as a single point of management.

We’re always looking for real customer use-cases, so please feel free to contact us if you have a similar operation running in your organisation.

And if you are interested in knowing the details of our eBay - SmartTurn implementation, please contact us .

Good blog on what to look out for when building/updating your API .  Article by Rick Nucci @ Boomi .

WDCi is an OEM partner with Talend, the leader in open source integration and ETL.  The Talend ETL tool is used by WDCi in both our consulting and some of our pre-built integration solutions, check out the November edition of the Talend Newsletter .

Many thanks to Solatube for participating as well.  Solatube has worked closely with us to refine one of our solutions (MYOB-Salesforce).  Nothing can replace real use-case details, especially when you are trying to pre-build and package a business process to suit hundreds of organisations.

We have just released a 1.3 version of our Salesforce-MYOB pre-built integration.  The key new features are:

1. Personal Contacts in Salesforce can now be sync’d to MYOB Cards
2. The Salesperson name can be captured in Salesforce and transferred to MYOB to include in Sales Orders/Invoices
3. Duplicate Cards are now handled more gracefully, allowing Salesforce to create duplicate Cards in MYOB

Check out the website for some more detail on how it works.