Importing CSV Data
CSV for all fields and sample data needed to import the necessary information
This guide explains how to import information into Upmind using a CSV file, including examples of required columns and formats. These include:
- Client payment details
- Client data
- Contracts
- Invoices
- Product data
- User data
Upmind is ISO 27001 certified and uses enterprise-grade security to protect your payment data during import and storage, ensuring your customers’ information remains safe throughout the process.
Importing CSV
- You can import CSV files from Settings > Imports under Miscellaneous.
Settings > Miscellaneous > Imports
- Then click on Upload CSV files.
Upload CSV files
Client payment details
| Field Name | Description | Example |
|---|---|---|
| id | Unique record identifier. | 1 |
| client_id | Upmind client identifier. | 1 |
| payment_method_name | Descriptive name of the payment method. | Visa ending 4242 |
| gateway_provider_code | Payment gateway identifier used by Upmind. | PayPal_Rest |
| is_default | Indicates if this is the default payment method (1 for yes, 0 for no). | 1 |
| allow_auto_payment | Specifies if automatic payments are allowed (1 = yes). | 1 |
| imported_address_id | Reference ID for the imported billing address. | 61051 |
| card_type | Type of credit card used. | visa |
| card_last4 | Last four digits of the card number. | 4242 |
| card_expire_date | Card expiration date in MM/YYYY format. | 11/2023 |
| payment_method_token | Unique token representing the payment method in the gateway. | pm_1NpTxkEZLEAqFQ2mTqZcDC6c |
| customer_reference | Customer reference ID from the payment gateway. | cus_OcjQJtdNFORBpu |
| stripe_setup_intent | Stripe setup intent ID. | seti_1NpTyoFSPY1r1zi86UsAyzql |
| stripe_payment_method_type | Payment method type registered with Stripe. | paypal |
| address_1 | Primary street address. | Varna |
| address_2 | Secondary address line. | Apt 5B |
| country_code | Two-letter ISO alpha-2 country code. | BG |
| region_code | Regional or state code. | 13 |
| postcode | Postal or ZIP code. | 4400 |
Client data
| Field Name | Description | Example |
|---|---|---|
| id | Unique client record identifier. | 1 |
| first_name | Client's first name. | Leon |
| last_name | Client's last name. | Gomez |
| has_login | Indicates login access (1 for yes, 0 for no). | 1 |
| verified | Client's verification status (1 = verified). | 1 |
| Client email address. | [email protected] | |
| phone_phone | Client’s phone number. | 888777777 |
| phone_country_code | Two-letter ISO alpha-2 country code. | BG |
| phone_verified | Phone verification status (1 = verified). | 1 |
| address_address_1 | Street address line 1. | Sofia |
| address_city | City name. | California |
| address_postcode | Postal or ZIP code. | 1220 |
| address_country_code | Two-letter ISO alpha-2 country code. | BG |
| address_verified | Address verification status (1 = verified). | 1 |
| company_name | Client company name. | Upmind Solutions Ltd. |
| company_verified | Company verification status (1 = verified). | 1 |
| currency_code | Client's default currency in ISO 4217 format. | GBP |
Contracts
| Field Name | Description | Example |
|---|---|---|
| id | Unique contract identifier. | 1 |
| name | Contract title or name. | Standard Hosting Agreement |
| start_date | Contract start date in YYYY-MM-DD format. | 2025-01-27 |
| activation_date | Date contract was activated. | 2025-01-27 |
| client_id | Associated client’s unique ID. | 1 |
| company_id | Linked company identifier. | 42 |
| address_id | Billing or service address ID. | 1 |
| total_amount | Total contract value. | 20 |
| status | Contract state (e.g., contract_pending). | contract_pending |
| created_at | Timestamp of contract creation. | 2025-01-27 04:41:14 |
| updated_at | Timestamp of last update. | 2025-08-02 14:11:39 |
| contract_product_id | Unique contract product ID. | 101 |
| contract_product_product_id | Product ID linked to contract product. | 1 |
| contract_product_name | Product name. | Shared Hosting |
| contract_product_description | Product description. | Shared Hosting |
| contract_product_billing_cycle_months | Billing cycle length in months. | 1 |
| contract_product_quantity | Number of products purchased. | 1 |
| contract_product_unit_quantity | Unit of measurement for the product. | 5 GB |
| contract_product_price | Unit price per product. | 20 |
| contract_product_amount | Total amount for the product line. | 20 |
| contract_product_status | Status of the contract product. | contract_pending |
| contract_product_total_amount | Total cost including taxes and discounts. | 20 |
| contract_product_net_amount | Amount before taxes. | 20 |
| contract_product_tax_amount | Tax amount charged. | 0 |
| contract_product_net_selling_price | Selling price excluding taxes. | 20 |
| contract_product_base_price | Base price of the product. | 20 |
| contract_product_selling_price | Final selling price charged. | 20 |
| contract_product_net_product_discount_amount | Discount amount on the product. | 0 |
| contract_product_created_at | Contract product creation timestamp. | 2025-01-27 04:41:14 |
| contract_product_updated_at | Contract product last updated timestamp. | 2025-08-02 14:11:39 |
| contract_product_renew | Flag if product auto-renews (1 = yes). | 1 |
| contract_product_initial_invoice_amount | Initial invoice amount for product. | 20 |
| contract_product_manual_status | Flag for manual status override (0 = no). | 0 |
| currency_code | ISO 4217 currency code. | GBP |
| contract_product_next_due_date | Next billing due date. | 2026-01-12 |
| main_contract_product_id | Primary related contract product ID. | 101 |
| provisioning_product_type | Type of provisioning service. | hosting |
| provisioning_domain_registrar | Domain registrar name. | GoDaddy |
| provisioning_hosting_server_id | Server identifier. | server123 |
| provisioning_hosting_type | Hosting type (e.g., shared-hosting). | shared-hosting |
| provisioning_hosting_hostname | Hosting server hostname. | server.hostname |
| provisioning_hosting_ip | Hosting server IP address. | 127.0.0.1 |
| provisioning_username | Username for provisioning access. | hostingUser1 |
| provisioning_domain_name | Domain name provisioned. | mydomain.com |
Invoices
| Field Name | Description | Example |
|---|---|---|
| id | Unique invoice identifier. | 1 |
| contract_id | Associated contract’s unique ID. | 1 |
| number | Invoice number or reference code. | C-INV-00001 |
| client_id | Client’s unique identifier. | 1 |
| user_id | ID of user who created or manages the invoice. | 1 |
| net_amount | Total amount before taxes. | 20 |
| tax_amount | Tax charged on the invoice. | 4 |
| total_amount | Total amount including tax. | 24 |
| paid_amount | Amount already paid. | 0 |
| status | Invoice payment status (e.g., invoice_unpaid). | invoice_unpaid |
| paid_datetime | Timestamp when payment was made; use NULL if unpaid. | NULL |
| due_date | Payment due date in YYYY-MM-DD format. | 2025-01-27 |
| created_at | Timestamp of invoice creation. | 2025-01-26 05:38:53 |
| updated_at | Timestamp of last update. | 2025-01-27 18:51:51 |
| cancellation_datetime | Timestamp of cancellation if any; NULL if none. | NULL |
| invoice_product_id | Unique identifier for invoice line item. | 1 |
| invoice_product_product_id | Product ID linked to the invoice item. | 1 |
| invoice_product_name | Product or service name. | Shared Hosting |
| invoice_product_description | Description of the product or service. | Shared Hosting |
| invoice_product_quantity | Quantity billed. | 1 |
| invoice_product_unit_quantity | Additional unit details if applicable; use NULL if N/A. | NULL |
| invoice_product_net_amount | Net amount for the line item. | 20 |
| invoice_product_tax_amount | Tax amount applied to the line item. | 4 |
| invoice_product_vat_percentage | VAT or tax rate percentage. | 20 |
| invoice_product_total_amount | Total line item amount including tax. | 24 |
| invoice_product_created_at | Timestamp when this line item was created. | 2025-01-26 05:38:54 |
| invoice_product_updated_at | Last update time for the invoice line item. | 2025-01-27 04:41:14 |
| currency_code | ISO 4217 currency code for the invoice | GBP |
Product data
| Field Name | Description | Example |
|---|---|---|
| id | A unique number identifying each product. | 1 |
| name | The product's descriptive name. | Shared Hosting |
| product_type | Numeric code representing the product category. | 1 |
| order_type | Numeric code indicating how the product is ordered. | 1 |
| unit_quantity | Optional unit measurement for the product. | NULL/5 GB |
| product_billing_type | Billing cycle type code. | 0 for one-time or recurring |
| available_for_sales | Whether the product is listed for sale (1 for yes). | 1 |
| clients_can_order | Indicates if clients can directly order this product (1 for yes). | 1 |
| price_price | Product price, usually in decimal format. | 0 |
| price_billing_cycle_months | Billing cycle length in months. | 1 |
| price_currency_code | ISO code for the currency. | GBP |
| provision_configuration_id | Identifier for the provisioning setup. | 12345 |
User data
| Field Name | Description | Example |
|---|---|---|
| id | Unique numeric identifier for each user. | 1 |
| firstname | User’s first name. | Brian |
| lastname | User’s last name. | West |
| username | Unique login name for the user. | bwest |
| User’s email address. | [email protected] | |
| admin | Indicates administrative privileges (1 = admin, 0 = regular user). | 0 |
| active | User account status (1 = active, 0 = inactive). | 1 |
| language_code | Preferred user interface language code (ISO 639-1). | en |
| group_ids | Comma-separated list of group IDs the user belongs to. | 1,3,7 |
You can use the Upmind examples repository (GitHub csv-import-examples) for additional CSV templates.
Updated 21 days ago