How to import orders and their items

Hello, I’m having trouble importing orders to suitecrm.

first i create an order and then i click import line items.

however, after mapping the fields and placing the reference for the order I created, the import result enters as service items and not as products.

I need help with that. Thank you

Hi,
It is simple.
-> First Create an order from User Interface with product line items. And then export it.
-> This will give you idea about how the import CSV files format should be.
-> So you can then convert your data as per the required format.
-> And finally try it.

Thanks

1 Like

For product line, you would need to Crete or Import the Products with same IDs into the CRM (products module) Then the import will map them to the existing products. If you are importing from an old CRM, you can check aos_products table

1 Like

That’s what I did.

I exported all ids and crossed with the product reference codes, directly by Excel.

so the import ran just needing the quantity, id and price field.

thank you