Stock&Buy Evolves Into Qoblex Read More
  1. Home
  2. Knowledge Base
  3. Stock Control
  4. Importing Purchase Orders via CSV file

Importing Purchase Orders via CSV file

Importing purchase orders into your account using a comma-separated values (CSV) file is useful when you need to create multiple purchase orders. This feature is also useful when switching from another platform, as it allows you to import all active orders in one go.

When you import purchase orders, the data is converted from the CSV file into orders.

Steps

  1. Navigate to Stock Control module, select Purchases, then click Import from the top-right-hand corner of the screen.
  • Click Next.
  • Then download our spreadsheet template file and fill it up with your orders and information, including External Id, Client information, SKU, prices, and much more.

Tip: We recommend using Google Sheets to handle CSV files.

  • Once you made the desired changes to the spreadsheet file, click next, and you will be able to upload your purchase orders into Qoblex.

Your product CSV can’t exceed 2MB. Consider splitting your CSV files into multiple chunks if you have a large number of products to import.

CSV File Format

ColumnDescription
External Order IDThis is a mandatory field. An order ID that helps identify purchase orders.
Creation DateThe date the purchase order was created.
Full NameThe full name of the supplier.
Phone NumberThe phone number of the supplier.
EmailThe email address of the supplier.
Address1The primary address of the supplier.
Address2The secondary address of the supplier, if there’s any.
CityThe city where the supplier is from.
State (County)The state or county where the supplier is from.
Zip (Postal Code)The ZIP or Postal Code where the supplier is from.
CountryThe country where the supplier is from.
SKUIt is a unique alphanumeric code or identifier assigned to a specific product.
QuantityThe number of units of a specific product.
PriceThe cost of the product.
Tax (%)The percentage or rate of tax applied to the price of a product.
Is Tax Inclusive?True, if tax is included in the product prices, otherwise, false.
Discount (%)The discount rate for a specific product.
Landed CostTrue, if tax is included in the landed cost. Otherwise, false.
Landed Cost Tax (%)The tax amount associated with the landed cost of a product.
Is Tax Included in Landed Cost?True, if tax is included in the landed cost, otherwise, false.
Is Received?True, if an order is received. Otherwise, false.
Was this article helpful?

Related Articles