Difference between revisions of "Importing from NetSuite to opentaps"

From Opentaps Wiki
Jump to navigationJump to search
m (Protected "Importing from NetSuite to opentaps": Sysop page [edit=sysop:move=sysop])
Line 1: Line 1:
Data from NetSuite can be imported into opentaps by saving them as CSV files first.  As of opentaps version 1.4, the following data can be imported from NetSuite:
+
Data from NetSuite can be imported into opentaps by saving them as CSV files first and then importing them into the tables which began with "NetSuite".  As of opentaps version 1.4, the following data can be imported from NetSuite:
* Products
+
* Products
* Customers and address books
+
* Customers and address books
* Orders and Invoices
+
* Orders and Invoices
 +
 
 +
===Products===
 +
 
 +
To import your products, export your items list as a CSV file and import them into the NetSuiteItems table in your opentaps database.  Then run the service <tt>netsuite.importItems</tt>.

Revision as of 01:23, 27 September 2008

Data from NetSuite can be imported into opentaps by saving them as CSV files first and then importing them into the tables which began with "NetSuite". As of opentaps version 1.4, the following data can be imported from NetSuite:

  • Products
  • Customers and address books
  • Orders and Invoices

Products

To import your products, export your items list as a CSV file and import them into the NetSuiteItems table in your opentaps database. Then run the service netsuite.importItems.