Hello,

Please refer the forum. 

To be able to import everything, you need to have coding skills to import using the API.

Without coding, you must split your import file into batches of 2000. I recommend sorting the data according to their order reference first, then dividing it into several sheets. After that, you can select the sheet you want to import on the column matching page in Odoo.

If you want to code, you can try the script below:

impor xmlrpc.client

import csv

# --- CONFIGURATION ---

url = "http://your-odoo-instance.com"

db = "your_database_name"

username = "your_username"

password = "your_password"

csv_file = "sales_orders.csv"  # path to your CSV file

# --- CONNECTION ---

common = xmlrpc.client.ServerProxy(f'{url}/xmlrpc/2/common')

uid = common.authenticate(db, username, password, {})

models = xmlrpc.client.ServerProxy(f'{url}/xmlrpc/2/object')

# --- HELPERS ---

def find_partner_id(name):

    """Find partner (customer) ID by name"""

    ids = models.execute_kw(db, uid, password, 'res.partner', 'search', [[['name', '=', name]]], {'limit': 1})

    return ids[0] if ids else None

def find_product_id(code_or_name):

    """Find product ID by internal reference (default_code) or name"""

    ids = models.execute_kw(db, uid, password, 'product.product', 'search', [

        ['|', ['default_code', '=', code_or_name], ['name', '=', code_or_name]]

    ], {'limit': 1})

    return ids[0] if ids else None

# --- READ CSV ---

orders = {}

with open(csv_file, newline='', encoding="utf-8") as f:

    reader = csv.DictReader(f)

    for row in reader:

        order_ref = row['order_ref']

        customer = row['customer']

        product = row['Line/Product']

        qty = float(row['Line/qty'])

        price = float(row['Line/price'])

        if order_ref not in orders:

            orders[order_ref] = {

                'customer': customer,

                'lines': []

            }

        orders[order_ref]['lines'].append((product, qty, price))

# --- IMPORT PROCESS ---

for order_ref, data in orders.items():

    partner_id = find_partner_id(data['customer'])

    if not partner_id:

        print(f"❌ Customer '{data['customer']}' not found, skipping {order_ref}")

        continue

    # create Sales Order

    so_vals = {

        'partner_id': partner_id,

        'client_order_ref': order_ref,

    }

    order_id = models.execute_kw(db, uid, password, 'sale.order', 'create', [so_vals])

    print(f" Sales Order created: {order_ref} (ID={order_id})")

    # create Sales Order Lines

    for (product, qty, price) in data['lines']:

        product_id = find_product_id(product)

        if not product_id:

            print(f"   ⚠️ Product '{product}' not found, skipping line")

            continue

        line_vals = {

            'order_id': order_id,

            'product_id': product_id,

            'product_uom_qty': qty,

            'price_unit': price,

        }

        line_id = models.execute_kw(db, uid, password, 'sale.order.line', 'create', [line_vals])

        print(f"   → Line created: {product} (ID={line_id})")


This is sales_orders.csv be like:

order_ref,customer,Line/Product,Line/qty,Line/price

SO001,PT ABC,product1,10,120000

SO001,PT ABC,product2,5,250000

SO002,PT XYZ,product3,3,120000

Make sure you have entered the customer and product data first before performing the import.

Hope it helps.

Regards,

Appschef

Hi,

When importing large sales data into Odoo, you should split the file smartly: keep the 2000 sales orders in one import (with their basic details), then import the 12000 sales order lines in separate batches, making sure each line references the correct order by its unique identifier (e.g., Order Name). Odoo’s importer only allows around 2000 rows at once for performance reasons, so breaking the lines into multiple files is normal. As long as the Sales Order Name column matches exactly, Odoo will link the lines to the right orders automatically. This way, you avoid confusion and safely import everything step by step.

For more details, please refer to the following links:

1. https://www.cybrosys.com/blog/how-to-import-sale-orders-and-purchase-orders-in-odoo-17

Module: https://odoo-community.org/shop/sale-order-import-571#attr=944043

Hope it helps.