Bulk Import Sale Orders

You can bulk import sale orders into Stock&Buy using the bulk import feature.

To import orders from a CSV file:

  1. Login to your Stock&Buy account
  2. On the left navigation menu, click Sales
  3. Click on Import button available on the top right corner of the page
  4. Follow the on-screen instructions

The CSV file has the following format:

Order NumberOrder reference number
Creation date (ISO 8601)Created date in ISO 8601 format. Example: 2021-05-19T09:30:20+00:00
Is tax inclusiveTrue if the order is tax inclusive. False, otherwise
Customer nameCustomer name
Customer emailCustomer email
Billing address1Customer billing address
Billing address2Customer billing address
Billing cityCustomer billing address – city
Billing zipCustomer billing address – zip code
Billing provinceCustomer billing address – province
Billing countryCustomer billing address – country
Shipping address1Customer shipping address
Shipping address2Customer shipping address
Shipping cityCustomer shipping address – city
Shipping zipCustomer shipping address – zip code
Shipping provinceCustomer shipping address – province
Shipping countryCustomer shipping address – country
CurrencyOrder currency (USD, EUR…)
Exchange rateExchange rate if the order isn’t in your base currency
ShipFromLocationLocation from which the items will be allocated / shipped
NameProduct name
QuantityOrdered quantity
PriceProduct price
Tax (%)Order line item tax percentage
Discount (%)Order line item discount percentage
SkuProduct SKU
Note: The SKU is used to locate the product that is being ordered. Leave this field empty if you want to look products by barcode
BarcodeProduct barcode
Is paidTrue if the order is paid, False otherwise
Is shippedTrue if the line item is shipped, False otherwise
Is refundedTrue if the line item has been refunded, False otherwise
Is restockedTrue if the item has been refunded and returned back to stock, False if the item has been refunded but wasn’t restocked.

How useful was this post?


We are sorry that this post was not useful for you!

Tell us how we can improve this post?