This article covers exporting of sale or purchase order line items within Stock&Buy.
Stock&Buy allows you to export a sale or purchase order line items into a CSV file.
To export line items to of a given sale or purchase order:
- Navigate to the Sales page (or the Stock Control if you would like to import items to a purchase order)
- Open the order details
- Click on Import / Export drop down menu and select Export line items to CSV
- A file will automatically download
The order line items CSV file has the following columns:
LineType | The line item type, supported values are:
|
Description | Line item description |
SKU | The product SKU. This property is used to lookup and match products when a file is uploaded |
SupplierSKU | Optional: The product supplier SKU |
Barcode | The product barcode. This property is used to lookup and match products |
Quantity | The line item quantity |
Discount | The line item discount |
Price | The line item price.
Note: The line item price is in the order currency. |
Tax | The line item tax percentage. |
The procedure described above applies to both sale and purchase orders. Similarly, you can import sale or purchase line items from a CSV file. Here’s a handy guide for your reference.