Total Posts: 64
I do not know what you mean fully by integrate, or what that means to you specifically.
Magento can export its product database, and its user database, it can also export reports.
The exporting process I have not had an issue with, importing can be a whole different situation.
Their ‘dataflow’ which is an entire section of its own is continually under development.
Currently, you can export via CVS (with custom delimiters) or XML.
You will find that when importing you need to pay close attention to what your application means by “CSV” if this is the way you wish to go to ‘intergrate’ the data.
When i say, what this means… i mean…
does the CSV raw data look like:
what magento expects: “bob”,"”,"1,2”,"”,"”,"","”
if you provide: bob,,"1,2",,,,
as “CSV” you are going to be in a world of hurt.
Also when importing, Magento supports Multiple stores, you will need to ensure what store you are pulling new information into, and also need to know what values things are based on… for instance, everything is based on a unique key ‘SKU’ if you try to import a new list and you keep the sku the same, things will be updated to the current sku, if you change the sku, you will find you have new product merchandise.
There are also other required fields, and if neglected, you will see things explode.
What you need to do is find out exactly what is your software looking for… and what does it provide.
If you are using excel 2007, avoid CSV all together, use XML.
You will need to get more feedback on what Business Vision provides (i am unaware) but there is work being done for integration with Quickbooks.