[Vtigercrm-developers] how to import & synchronize product inventory data

[Maarten von Ziegenweidt]

Hi,

I use OSfinancials for my bookkeeping system. This has got a facility to 
sync with vTiger (I am still working on the sync, as I haven't needed 
the stock to be accurate until now.) Like you, this is my primary stock 
control. This integrates well with my e-commerce websites, and I can 
update the ecommerce sites to reflect the current stock holding.

This however is not what you are asking about, but, the SQL that is used 
there, may be useful to integrate your accounting package. As this is an 
open source package, the SQL is available.

(Which accounting package do you use?)

Maarten

On 31/10/2010 13:53, Byambaa Mendbayar wrote:
> Dear John Crisp,
>
> Thank you very much for your kind response.
>
> I have been reading vtlib document, and also experimenting 'import'
> function from product inventory module for getting mandatory fields list
> of product&  product related tables.
>
> Is there anyone who had been meet familiar for my current research&
> problem? If there any one please, help to me!
>
> Is there ready list of mandatory fields of 'vtiger_products' table? I
> mean I have try to direct import products data from my fin/system DB to
> vTiger DB via SQL DML programming.
>
>
> With regards,
> B.Mendbayar
>
>
> On Thu, 2010-10-28 at 11:48 +0200, John Crisp wrote:
>> On 28/10/10 06:20, Byambaa Mendbayar wrote:
>>
>>> Is there anybody help to me, for synchronize vTiger Products related
>>> tables data with my existing financial system Products data?
>>>
>>> By the way just I have reading vtlib development guide for customizing
>>> vTiger, but actually I do not want to write any new module for vTiger
>>> CRM and really want to synchronize my financial system DB products set
>>> to vTiger product inventory ('vtiger_products',
>>> 'vtiger_product_category' and etc...).
>>>
>>> What is the simple and optimal way for that, please advice to me!
>>>
>> I'm not sure if there is a 'simple' way to do what you want to do.
>>
>> As a starter you could have a look at web services - vtwsclib. That may
>> work in conjunction with vtlib. Also have a look at the vTiger API to
>> familiarize yourself with the system.
>>
>> Beyond that you will need to write a lot of code yourself.
>>
>> HTH
>>
>> B. Rgds
>> John
>
> _______________________________________________
> http://www.vtiger.com/
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1144 / Virus Database: 424/3224 - Release Date: 10/28/10
>
>