The Ultimate Guide to Importing Data into PeopleVine

You can easily import your data to PeopleVine by placing it in a CSV file and mapping the data to the appropriate fields in PeopleVine. Check out this guide for some samples and the overall data model.


  • Gift Card / House Credit Balances (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • Certificate Number (serial_number)
    • Initial Value (initial_value)
    • Current Value (current_value)
    • Status (active or inactive) (status)
    • Gift Card Pin (gift_card_pin)
    • Expires On (expires_on)
    • Created On / Issued On (created_on)
    • Gift Card Type (giftcard, rewardcert, promocert) (gift_card_type)
  • Vanity URLs for SEO (sample csv)
    • Domain Name (domain_name)
    • Vanity URL Path* (e.g. /baseball) (domain_path)
    • Destination* (route_url)
  • Customer CRM Data (sample csv)
    • Tag as Attribute (attribute)
    • Note (add as customer note) (note)
    • Customer Type (customer, dealer, employee, admin) (customer_type)
    • Email *Unique ID* (email)
    • Email Secondary (sets up new CRM record and links) (email2)
    • Full Name (full_name)
    • First Name (first_name)
    • Middle Name (middle_name)
    • Last Name (last_name)
    • Gender (M for Male, F for Female, T for Transgender or U for Unknown) (gender)
    • Company Name (company_name)
    • Company Title (company_title)
    • Mobile Number *Unique ID* (mobile_number)
    • Phone Number (phone_number)
    • Birthdate (birthdate)
    • Anniversary Date (anniversary_date)
    • Address (address)
    • Address 2 (address2)
    • Address 3 (address3)
    • City (city)
    • State (state)
    • Zip Code (zip_code)
    • Country (country)
    • Customer Reference (customer_reference)
    • Profile Photo (profile_photo)
    • Opt In Email (Y or N) (opt_in_email)
    • Opt In SMS (Y or N) (opt_in_sms)
    • Opt In Updates (Y or N) (opt_in_updates)
    • Facebook Handle (facebook_handle)
    • Instagram Handle (instagram_handle)
    • LinkedIn Handle (linkedin_handle)
    • Twitter Handle (twitter_handle)
    • Website (website)
    • Passbook Enabled (passbook_enabled)
    • Username (username)
    • Password (password)
    • Timezone (timezone)
    • Created On (created_on)
    • Modified On (modified_on)
    • Secondary Title (address_type)
    • Secondary Address (secondary_address)
    • Secondary Address 2 (secondary_address2)
    • Secondary Address 3 (secondary_address3)
    • Secondary City (secondary_city)
    • Secondary State (secondary_state)
    • Secondary Zip Code (secondary_zip_code)
    • Secondary Country (secondary_country)
    • Secondary Address Notes (secondary_address_notes)
    • Secondary Address Phone Number (secondary_address_phone_number)
  • Directory (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • about (about)
    • business_email (business_email)
    • business_id (business_id)
    • business_latitude (business_latitude)
    • business_longitude (business_longitude)
    • business_status (business_status)
    • category_no (category_no)
    • category_name (category_name)
    • company_logo (company_logo)
    • company_name* (company_name)
    • contact_name (contact_name)
    • country (country)
    • created_on (created_on)
    • fax_number (fax_number)
    • phone_number (phone_number)
    • slogan (slogan)
    • tollfree_number (tollfree_number)
    • website (website)
    • Social - Facebook (facebook)
    • Social - Twitter (twitter)
    • Social - Pinterest (pinterest)
    • Social - Instagram (instagram)
    • Social - LinkedIn (linkedin)
    • Social - Flickr (flickr)
    • Social - Vimeo (vimeo)
    • Review - Yelp (yelp)
    • Review - Trip Advisor (tripadvisor)
    • Review - Google Plus (googleplus)
    • Review - Houzz (houzz)
    • Location - address1 (address1)
    • Location - address2 (address2)
    • Location - address3 (address3)
    • Location - business_location_id (business_location_id)
    • Location - business_location_no (business_location_no)
    • Location - business_no (business_no)
    • Location - city (city)
    • Location - country (country)
    • Location - created_on (created_on)
    • Location - email (email)
    • Location - hours_sunday (hours_sunday)
    • Location - hours_monday (hours_monday)
    • Location - hours_tuesday (hours_tuesday)
    • Location - hours_wednesday (hours_wednesday)
    • Location - hours_thursday (hours_thursday)
    • Location - hours_friday (hours_friday)
    • Location - hours_saturday (hours_saturday)
    • Location - location_contacts (location_contacts)
    • Location - location_latitude (location_latitude)
    • Location - location_longitude (location_longitude)
    • Location - location_name (location_name)
    • Location - location_notes (location_notes)
    • Location - location_website (location_website)
    • Location - modified_on (modified_on)
    • Location - phone_number (phone_number)
    • Location - state (state)
    • Location - tollfree_number (tollfree_number)
    • Location - zip_code (zip_code)
    • Custom Attributes (custom_attribute_name)
  • Membership Data (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • Expiration Date (expiration_date)
    • Joined On (created_on)
    • Field 1 (field1_value)
    • Field 2 (field2_value)
    • Field 3 (field3_value)
    • Field 4 (field4_value)
    • Field 5 (field5_value)
    • Field 6 (field6_value)
    • Membership Card Graphic (url) (membership_card_graphic)
    • Membership ID (membership_id)
    • Membership SKU (membership_sku)
    • Membership Status (active, inactive, pending) (card_status)
    • Parent Membership Card (parent_membership_card_no)
    • Parent Member Email (parent_email)
    • Subscription Frequency (subscription_frequency)
    • Subscription Rate (subscription_rate)
    • Subscription Details (subscription_details)
    • Subscription Next Billing Date (next_date)
    • Subscription Last Billing Date (last_date)
  • Parent Membership (sample csv)
    • Parent Membership ID (parent_membership_id)
    • Parent Email (parent_email)
    • Child Membership ID (membership_id)
    • Child Email (email)
  • Inventory (sample csv)
    • Product ID (product_no) (product_no)
    • Product SKU (product_sku)
    • External ID (external_id)
    • Available Inventory (set to this number) (inventory_set)
    • Adjusted Inventory (we will add/remove this number) (inventory_total)
    • Inventory Type (In Hand or On Order) (inventory_type)
    • Stock Date (stock_date)
    • Inventory Location ID (inventory_location_no)
    • Item Cost (inventory_cost)
    • Inventory Threshold - Set value to be notified when running low (inventory_threshold)
    • Variation - Automatically create a variation and sync inventory
  • Order Data (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • Affiliate ID (affiliate_no)
    • Check if Gift (True or False) (gift_flag)
    • Created On (created_on)
    • Discount Total (discount_total)
    • External Order Number (external_order_no)
    • Flag Completed (Enter 1) (flag_completed)
    • Flag Completed Date (flag_completed_date)
    • Flag Followup (Enter 1) (flag_followup)
    • Flag Followup Date (flag_followup_date)
    • Flag Modified (Enter 1) (flag_modified)
    • Flag Modified Date (flag_modified_date)
    • Flag Paid (Enter 1) (flag_paid)
    • Flag Paid Date (flag_paid_date)
    • Flag Pulled (Enter 1) (flag_pulled)
    • Flag Pulled Date (flag_pulled_date)
    • Flag Returned (Enter 1) (flag_returned)
    • Flag Returned Date (flag_returned_date)
    • Flag Shipped (Enter 1) (flag_shipped)
    • Flag Shipped Date (flag_shipped_date)
    • Flag Verified (Enter 1) (flag_verified)
    • Flag Verified Date (flag_verified_date)
    • Gift Message (gift_message)
    • IP Address (ip_address)
    • Modified On (modified_on)
    • Order Data (order_data)
    • Order Date (order_date)
    • Order Notes (order_note)
    • Order Source (order_source)
    • Order Status (pending, processing, completed, cancelled) (order_status)
    • Order Total (order_total)
    • Order Type (purchase, points, quote) (order_type)
    • Order Via (order_via)
    • Purchase Order Number (purchase_order)
    • Session ID (sessionID)
    • Shipping Total (shipping_total)
    • Sub Total (sub_total)
    • Tax Total (tax_total)
    • Tip Total (tip_total)
    • Line Item (Sku|Quantity|Price|Notes,) (line_item)
    • Line Item (Product ID: #, Product Qty: #, Product Unit Price: #, Product Variation Details: ABC|) (line_item_bigc)
    • Shipping Address Notes (address_notes)
    • Shipping Address Type (shipping, service, pickup) (address_type)
    • Shipping Address 1 (address1)
    • Shipping Address 2 (address2)
    • Shipping Address 3 (address3)
    • Shipping City (city)
    • Shipping Company Name (company_name)
    • Shipping Country (country)
    • Shipping First Name (first_name)
    • Shipping Last Name (last_name)
    • Shipping Phone Number (phone_number)
    • Shipping State (state)
    • Shipping Zip Code (zip_code)
    • Shipping Courier (shipping_courier) 
    • Shipping Method (shipping_method)
    • Shipping Quantity (shipping_quantity)
    • Shipping Status (shipped) (shipping_status)
    • Tracking Number (tracking_number)
    • Matched (Y or N) (matched) (cmatched)
    • Payment Type (credit card, papercheck, comped, cash, credit, giftcard, voucher, paypal) (payment_type) (cpayment_type)
    • Purchase Order (purchase_order) (cpurchase_order)
    • Merchant Response (raw_response) (craw_response)
    • Refunded Amount (refunded_amount) (crefunded_amount)
    • Last 4 Digits of Card (t_card_four) (ct_card_four)
    • Credit Card Type (t_card_type) (ct_card_type)
    • Charge Amount (transaction_amount) (ctransaction_amount)
    • Transaction ID (transaction_id) (ctransaction_id)
  • Products (sample csv)
    • Product Title (Long) (product_long)
    • Product Short (Short) (product_short)
    • Product SKU (product_sku)
    • Product Unit (unit_type)
    • Product Type (physical, service, digital, bundle, add-on, external) (product_type)
    • Brand/Manufacturer (brand)
    • Category Name (category)
    • Retail Price (retail_price)
    • Sale Price (sale_price)
    • Add to Cart Price (cart_price)
    • Dealer Price (dealer_price)
    • MSRP Price (msrp_price)
    • Shipping Fee (shipping_fee)
    • Handling Fee (handling_fee)
    • Allow Backorders (Y or N) (flag_backorders)
    • Limited Availability (Y or N) (flag_limited)
    • On Demand (Y or N) (on_demand)
    • Lead Time (in days) (lead_time)
    • Inventory In Stock (in_stock)
    • Page Keyword (page_keyword)
    • SEO: Meta Title (meta_title)
    • SEO: Meta Description (meta_description)
    • SEO: Meta Keywords (meta_keywords)
    • Main Photo (photo_url)
    • Attach Photo (photo)
    • Parent Product (product_no) (product_above)
    • Parent Product (SKU) (product_above_sku)
    • Product Description (product_description)
    • Product Summary (product_brief)
    • Product Flag (featured, frontpage, discontinued, special order) (product_flag)
    • Proudct Weight in lbs. (product_weight)
    • Tax Rate (tax_rate)
    • Visibility (public or hidden) (visibility)
    • Product Link (product_link)
    • Dimensions - Width (dimensions_width)
    • Dimensions - Height (dimensions_height)
    • Dimensions - Depth (dimensions_depth)
    • External ID (external_id)
    • Custom Attribute (custom_attribute)
  • Loyalty Members (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • Activity Completed* (activity_title)
    • Points Earned (point_earned)
    • Status (approved, pending, denied, expired) (status)
    • Notes (internal) (notes)
    • Rewarded On (date) (rewarded_on)
    • Business Name (company_name)
    • Notes (viewable by member) (item_data)
    • Membership ID (membership_id)
    • Import ID (import_id)
  • Loyalty Redemptions (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • Points Spent (point_spent)
    • Redeemed For (redeemed_for)
    • Redemption ID (redemption_id)
    • Membership ID (membership_id)
    • Import ID (import_id)
    • Redeemed On (created_on)
  • Events (sample csv)
    • Event Title (event_title)
    • Full Description (event_description)
    • Brief Summary (event_summary)
    • Start Date (event_date)
    • End Date (event_date_end)
    • Location (Full Address) (event_location)
    • Venue (event_venue)
    • Event Type (public, register, standard, ticket, external) (event_type)
    • Display To (members, public, customers, private) (event_display)
    • Timezone ID (event_timezone_id)
    • Graphic (event_graphic)
    • Keyword for URL (event_keyword)
    • Status (approved, pending, denied) (event_status)
    • Event ID (for repeating events) (event_id)
    • Event Data (event_data)
    • Social Sharing (Short) (share_short)
    • Social Sharing (Long) (share_long)
    • External Link (set event_type = external) (external_link)
    • Event #tag for Social (event_hashtag)
    • Facebook Event URL (facebook_link)
    • SEO Meta Keywords (meta_keywords)
    • SEO Meta Description (meta_description)
    • Allow Cancellation (Y or N) (allow_cancel)
    • Cancel Cutoff Time in Minutes (cancel_cutoff)
    • Allow Transfer Tickets to Other Person (Y or N) (allow_transfer)
    • Event Settings (free JSON field) (event_settings)
    • Event Latitude (event_latitude)
    • Event Longitude (event_longitude)
    • External ID (external_id)
  • Event Attendees (must use link on event menu) (sample csv)
    • Customer - Reference ID (customer_reference)
    • Customer - customer_no (customer_no)
    • Customer - E-mail (email)
    • Customer - Mobile Number (mobile_number)
    • Serial Number (for Validation) (ticket_serial)
    • Purchase Date (purchase_date)
    • Ticket Price (ticket_price)
    • Scanned On (if scanned) (scan_date)
    • Notes (ticket_notes)
    • External ID (external_id)
    • Quantity (Default 1)
    • Ticket Status (default: register or set to: cancelled, purchased, redeemed, scanned)

Additional Help Tutorials

Find more ways to grow on PeopleVine.

Setup a Staging Environment to Build and Test without Impacting Your Members

You can setup a "staging" environment that allows you to move data between two accounts and avoid impacting your member base.

Posted December 4, 2020

Improvements to Refunding Event Tickets

We made some improvements to refunding event tickets to streamline the process.

Posted November 25, 2020

Know How we Charge Service Fees and Taxes on Subscriptions

We wanted to share with you how we charge taxes and service fees on subscriptions, membership initiation fees and more.

Posted November 19, 2020

Updated PDF Receipt, Better Subscription Billing Reporting and More

We made some updates to our transaction and subscription engine we thought we should share.

Posted November 19, 2020

Process Payments in PeopleVine Using their Square Card on File

When you connect to your Square POS, you enable the ability to process payments to a member's card on file at the POS. This tutorial will show you how they can register it and how it works in PeopleVine.

Posted November 10, 2020

Adding a Card on File at the POS for Square

We recommend you having your members register their card on file at your POS for the most secure and cost-effective way for charging for orders and other items in PeopleVine.

Posted November 10, 2020

Your Members Can Register their Card on File with Square from the Member Portal

Your members are able to add a payment on file to be leveraged at the Square POS.

Posted November 10, 2020

Connect Your Square POS for Order History, Loyalty, Card on File and More

With our integration to Square you can track member spend to their CRM profile in PeopleVine while enabling a secured way for registering your card on file at the POS.

Posted November 9, 2020

Syncing Your Customers, Members and Orders with Square

With our Square integration, you can ensure that your CRM in PeopleVine has the latest data on your customer's behaviors, while ensuring your members are ready in the Square POS.

Posted November 9, 2020

Enable a Webhook to Automatically Tag a Person with an Attribute

You can trigger a webhook to automatically attach an attribute to the person's profile.

Posted November 4, 2020

Get a Quick Glimpse of Your Commerce Revenue by Category

If you're POS is connected to PeopleVine or you're leveraging our eCommerce, you can now get a quick glimpse of how a specific category is performing.

Posted November 2, 2020

Adding Your Member to a Ticket in Toast, Allowing them to Pay from their Phone

Leverage this guide to train your employees how to add a member to a check when using Toast.

Posted October 28, 2020

Troubleshooting Toast - Getting an Error Validating the Loyalty Account

If you're getting an error "Error validating the loyalty account," it is most likely related to a change in the member's profile. Although an unlikely scenario, we wanted to ensure you knew how to handle.

Posted October 28, 2020

Overview of the Integration with Toast POS System and PeopleVine

As we have launched our integration with Toast, we wanted to highlight the overall features and experience.

Posted October 28, 2020

Improvements to the Virtual POS - Tips, Discounts and More

We recently made major updates to the Virtual POS and Commerce engine in an effort to ensure continuity between experiences along with providing better control and reporting on payment details.

Posted October 28, 2020

© PeopleVine 2020. Powered by PeopleVine. Terms of use | Privacy & cookies