BigQuery Connector
€30 / month
AbiCart
Fetches order, orderitem, customer, product & stock-level data from your abicart store for further analysis with BiqQuery / Looker Studio.
Guide / Information
Get your API credentials by logging into your abicart store.
Visit "settings" -> "External connections" -> "AbiCart API", to generate credentials.
Available fields
Date fields
Order date
Changed date
Created date
Metric fields
Exchange rate
Shipping exVAT
Shipping incVAT
Shipping VAT
Shipping VAT rate
Price exVAT
Price inc VAT
Price VAT
Row VAT rate
Row total ex VAT
Discount ex VAT
Discount inc VAT
Discount VAT
Discount VAT rate
Quantity
Current price
Regular price
Stock level
Dimension fields
Town
Phone
Row ID
URL
Slug
Draft
Hidden
Images
Order ID
Order number
External order number
Currency
Payment status
Discarded
Has VAT
Delivery status
First name
Last name
Address
Post code
Country
Article
Article number
Article name
Article ID
Free freight
Is bulky
Is buyable
Type
Article group
* We'll add more fields on request 👏