As you may or may not know ACCTivate! integrates with a handful of shopping carts, but there are so many choices and sites out there that it just can’t have a direct integration for them all. We were contacted by a rather new ACCTivate! user that is currently utilizing one of the unsupported sites; however, they may be moving to a supported site in the next 6 to 9 months.
The Problem: The customer didn’t want to keep hand keying in their Web Orders while on their current system; but they also didn’t want to spend too much on a solution to eliminate manual entry because of the plan to migrate to a supported site down the road.
How Did We Help: After some discussion we learned that the customer could either download a poorly formatted text file or a nicely laid out XML file. We suggested writing a small custom program that would take the XML file and convert it into a comma separated value (.csv) file that could be used with the Sales Order Import feature in ACCTivate!. The customer chose to go with the custom program option so we moved forward with that plan. Now the customer has a custom program that reads an XML file into the program and outputs a perfectly formatted .csv file which they use to import their Web Orders into ACCTivate! via the Sales Order Import function. This has done away with the manual entry work they were doing and has saved time as well as eliminated human error. It is not as automated as the Web Order module that ACCTivate! has, but it was a quick and rather inexpensive interim solution while they decide if and when they will make a shopping cart change.