In a recent implementation engagement to get off QuickBooks to adopt NetSuite, we were presented with the challenge to help our client who has a PHP eCommerce platform called xCart. xCart is similar to the popular Magento eCommerce system in that it has low cost licensing but lives stand-alone relative to entire enterprise business coordination. In due course, we will help the client move on to NetSuite eCommerce. But in the meantime, we need to get the eCommerce orders into NetSuite.
The xCart eCommerce system supports the generation of QuickBooks IIF files. One of our senior consultants, who is a strong software developer, simply parsed the QuickBooks file into the equivalent NetSuite CSV import files. This produced the key elements we needed to get eCommerce orders into NetSuite:
- New Customer Information: first import customer information. NetSuite will take care of duplicate management.
- Order information: next import the order information which will reference the imported customer information.
- Exceptions: if the eCommerce system and NetSuite do not have the same Item / SKU references, we produce exception files
Marty Zigman
Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.
More Posts - Website - Twitter - Facebook - LinkedIn - YouTube
