Exporting orders and products to our CMS system
Posted: 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.
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.