General Overview
   Service Overview
   Custom Data Feeds
   Marketplaces
   Webstores
   3rd Party Software
   Migrations
   Product Catalog Data

 Catalog Conversion
   Dropship Conversions
   Supplier Integration
   E-Catalog Output 
   Custom Catalogs
   Software Solutions
   EDI for Online Retail
   Catalog Transformer
   Marketplace Enablement
   Professional Services
   Retail Data Consultancy


 

Integrate your Webstore to Accounting and Back-Office systems with customised feeds designed for any Webstore, Multi-Channel Platform or Transactional Website. Convert  Sales Orders from Magento, Amazon AWS, Volusion, XCart, Bigcommerce, Shopify, EKM Powershop and other Webstores  into native formats for your Accounting system, no matter the format.

Customer and Sales Orders Integration

With the dramatic rise of sales transactions made via online webstores and marketplaces, Retailers require an integrated approach to process post-sales transactions for accounting, invoicing, fulfilment and dispatch.

Traditional Retail business typically use EDI (Electronic Data Interchange) to fulfil these post-sales requirements, however for Online Retailing post-sales integration occurs through the use of API’s, XML and CSV/EXCEL exports.

If a Retailer is fortunate to have an existing pre-built connection (API) or directly configured export that matches their accounting system then post sales-data can be synced successfully. This is a best case scenario, but will not meet the requirements of the following type of Retailer.

 OPERATING MULTIPLE WEBSTORES ON DIFFERENT PLATFORMS WITH ONE ACCOUNTING SYSTEM (I.E. MULTIPLE DIFFERENT SALES ORDERS)
 RETAILERS WITH CUSTOM ACCOUNTING SYSTEMS WITH NO PRE-BUILT 'API'/CONNECTOR TO WEBSTORE OR PLATFORM
 TWO OR MORE RADICALLY DIFFERENT FILE TYPES THAT REQUIRE INTEGRATION (I.E. TSV (TAB SEPARATED) EXPORT TO XML IMPORT)
 RETAILERS THAT HAVE ACCOUNTING SYSTEMS THAT REQUIRE MORE DETAILED INFORMATION THAN IS PROVIDED BY THE WEBSTORES EXPORT

Integration for Multiple Webstores

Many sophisticated Online Retailers are now choosing to split inventory and brands across various webstores they operate. This strategy has proven to be a double edge sword, the positive is an increase in the volume of sales generated with the negative being greater complexity for the integration of multiple webstores and platforms into one backend accounting system.

Where a one to one connection between a webstore and accounting system may be the original requirement, the up-scaled online retail operation now involving multiple webstores requiring a more flexible and adaptive approach to integrate multiple customer and sales orders that are being exported in various formats, structures and with varying levels of detail.

A flexible and adaptive approach is required for the consolidation of various post-sales data due to factors such as

 DIFFERENT BUILDS AND IMPLEMENTATIONS (I.E. NO STANDARDISED EXPORT)
 DIFFERENT EXPORT MODULES AND CONFIGURATIONS
 NEW AND LEGACY WEBSTORES IN OPERATION
 RETAILERS NOT CHOOSING TO RE-PLATFORM BUT CREATE NEW BUILDS ON DIFFERENT PLATFORMS

Supported Webstores, Systems and Platforms

Custom accounting feed solutions allow customer and sales order information to be seamlessly imported into accounting and back-office system in native formats regardless of the data type and structure being exported by the Webstore or Platform. In turn, product information, inventory, and shipping details can be automatically synced for picking, invoicing and dispatch, bypassing manual data entry.

Typical Accounting systems that use custom feeds include: Sage, Intuit Quickbooks, Netsuite, Microsoft Dynamics (Navision), Exchequer, SAP BusinessOne, Exact, Access Accounts, IRIS, Pegasus, MYOB.

XML, CSV ,TSV, EXCEL & EDI Conversions for Accounting Integration

The chart below shows various Webstores and Platform exports that have been transformed for importing into Accounting systems.

 Webstore/ Platform (Sales Orders)  Accounting System (Import)  Format Conversion (Requirement)
 EKMPowershop   SAGE  XML to XML (Different Structure)
 Magento + EKMPowershop  Quickbooks  XML + XML to CSV
 Bigcommerce  Custom System  XML to TAB
 Volusion + Prestashop  Exchequer  XML + CSV to XML

Solving Your Accounting Integration Issues

Transforming Data provides a Cloud based Data Transformation solution that is effective for Retailers who exchange a few sales orders a day and powerful enough for those who handle thousands every hour. Choose the streamlined approach that eliminates time-consuming manual data entry, connects order, customers and inventory across operations whilst reducing the overall invoicing to dispatch process.