Import/Export of Sales Order

More
18 Feb 2013 13:44 #2718 by 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

Please Log in to join the conversation.

More
18 Feb 2013 21:12 #2720 by 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

Please Log in to join the conversation.

More
19 Feb 2013 09:26 #2721 by 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.

Please Log in to join the conversation.

Time to create page: 0.102 seconds