Exporting orders and products to our CMS system

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
jdarby
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Thu Sep 25, 2008 2:21 pm

Exporting orders and products to our CMS system

Post by jdarby » Wed Dec 31, 2008 9:27 am

We are switching over to Dydacomp's Mail Order Manager in the next month or so and it ends up being convenient as we are working on our first AbleCommerce site as well.

Has anyone used the AC Dataport utility to export their products and orders into Mail Order Manager?

The way the data is structured in some places doesn't seem to match up in a harmonious way. The M.O.M. table has a 5 fields for "item sku" (each item on an order) and an associating field for quantity for each of sku fields. The AC tables aren't really structured in the same way.

It's also a bit frustration because in M.O.M.'s data import/export setup, it limits the column titles to 10char but AC has many that are longer.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Exporting orders and products to our CMS system

Post by jmestep » Wed Dec 31, 2008 10:11 am

Web2Market.com is working on a MOM integration for Able 7. They had previously done one for the ColdFusion of Able 5. I'm not sure when it will be released, though. You can email Brad at bkort@web2market.com and he can probably give you details.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply