Import/Export of Sales Order

Di più
18/02/2013 13:44 #2718 da menonmat
Hi,
I would like to know if there is a method to Import/Export Sales Order throw a CSV file like the Accounts.
Thanks

Si prega Accedi a partecipare alla conversazione.

Di più
18/02/2013 21:12 #2720 da dende
There aren't any standard functionality to do that.
Because salesorder have products/services in it (salesorder's body), you must populate product and/or services first and pass the relatives ids.
A CSV file is suitable only for standalone entities

Regards

Si prega Accedi a partecipare alla conversazione.

Di più
19/02/2013 09:26 #2721 da menonmat
Thanks for the reply.

I have to import data of Accounts and Sales Order from an old ERP.

For the Accounts and Products I can use the CSV functionality;
for the Sales Order I have to import data directly in MySql database? Are there other methods?

In case 1 I have to match:

vte_salesorder.accountid = vte_account.accountid

vte_inventoryproductrel.id = vte_salesorder.salesorderid

vte_inventoryproductrel.productid = vte_products.productid ?

For the values of salesorderid I have to start from the current value of vte_crmentity_seq and increment for every Sale Order?

Are there other tables to update?

Thanks and sorry for the many questions.

Si prega Accedi a partecipare alla conversazione.

Tempo creazione pagina: 0.159 secondi