We are aware that most businesses already have their own spreadsheet or application that contains their inventory data. Qoblex enables you to import or export your line items in an order through a CSV file.
In this article, we will let you know how you can successfully perform these tasks.

Steps to Import line items in Purchase or Sales Orders
To import line items in a given Purchase or Sales Orders:
- Go to your Stock Control > Purchases. For Sales, you can go to your Sales module.
- Click the order that you want to import line items with.
- Click Import / Export drop-down menu and select Import line items from CSV.
- A dialog box will appear to download our template.
- Modify the template containing your line items.
- Once done, upload the modified file back to the platform.

Steps to Export line items in Purchase or Sales Orders
To export line items in a given Purchase or Sales Orders:
- Go to your Stock Control > Purchases. For Sales, you can go to your Sales module.
- Click the order that you want to export line items with.
- Click Import / Export drop-down menu and select Export line items from CSV.
- A dialog box will appear to download our template.
- A file will automatically be downloaded.

Columns in the CSV file
The following are the columns in the template CSV file that you can download by importing or exporting:
LineType | The line item type can be considered as: – Line Item: Order line item – Landed Cost: Additional cost in the order. Can be shipping or handling cost. |
Description | The line item description. |
SKU | Your product’s SKU. This is used to lookup and match your products when the file is uploaded. |
SupplierSKU | The product supplier’s SKU. This can be optional. |
Barcode | The product’s barcode. This property is used to lookup and match products as well. |
Quantity | The line item’s quantity in your order. |
Discount | The line item’s discount. |
Price | The price for the line item in your order. The price depends on the order currency that you have set. |
Tax name | The line item’s tax class name. |