Setup Your eCommerce Product Catalog from a Spreadsheet

Are you ready to launch e-commerce to allow your members to purchase your food, beverages or merch? Check out this tutorial to get started with a simple excel spreadsheet.


Setting up eCommerce in PeopleVine can be done in one quick shot, by importing your data via a CSV file.  You can import attributes, photos, pricing, prodcut details and more.  Follow these steps to get started:

  1. Visit our guide for importing data at https://peoplevine.com/blog/31021 and find the one for Products.  This will provide you guidance on what fields are out of the box for your import and which ones you to create as attributes.


  2. Start by updating your spreadsheet to ensure your column headers are on the first row and ensure the labels correlate to those provided by standard.  


  3. For the ones that you are unable to match, you will need to setup a product attribute.
  4. To setup a product attribute, go to the company settings menu and click on Setup New Attribute under the Tagging/Attributes section.


  5. If you are simply importing data as an option for filtering, you can setup a field type of Label.  If you're looking to have someone select an option, then select Dropdown.


  6. You can leave the rest of the options to it's default setting, but feel free to read through and confirm the other settings.
  7. Once your attributes are setup, you can proceed to importing the data by going to the company menu and click on Import Data


  8. Select to import eCommerce Products, attach your file and then click on Load File.


  9. You will notice that our system has identified your rows and is asking you to map them.  If it identifies a match, it will pre-select for you.


  10. Once your data fields are mapped then click Process Import.
  11. Once your data is loaded, you will receive an e-mail to confrim this.
  12. You can confirm that your products are lodaed by going to the Product catalog under Sell > eComerce > Products then click on Manage Products.


  13. To see the products you just imported, select the sort by filter and selecct Newest First.


  14. You can now confirm your data is correct and you will see your products live on the website at https://yourcompany.com/shop.



  15. If you imported your products with a category, you may want to ensure those are organized in the correct hierarchy.
  16. Now go to https://yoursite.com/shop to browse your product catalog.

Additional Help Tutorials

Find more ways to grow on PeopleVine.

Create a Single Sign On Amongst All Your Sub-Domains on PeopleVine

In the platform settings, you can enable a multi-domain cookie which will carry over member settings into your various sub domain names in PeopleVine.

Posted October 18, 2020

Applying a Discount in the Virtual POS is Easier

You can now apply a % discount or $ discount when taking a payment in the Virtual POS.

Posted October 15, 2020

Setup a Dining Reservation with Specific Tables for Dining or Cocktails

Allow your members to select what type of table they're looking for (e.g. cocktail, hightop, outside, etc.) by providing the table numbers within your dining page.

Posted October 8, 2020

Setup Your Billing to Start on the 1st of the Month (or Year) When Enabling Prorated Billing on the Service

We know you've been able to prorate members for quite some time, but only if you manually set them up. Now members can be automatically prorated depending on when they sign up or are approved.

Posted September 29, 2020

Platform Updates 1st Half September 2020

We thought we'd share some of our notes on what was released so far in September.

Posted September 12, 2020

You Can Set What Gift Certificates are Valid For

When issuing a gift certificate to a person, you have the ability to select what the gift card is valid for. This allows you to issue a gift certificate to utilize for a series of events or a specific appointment type. When purchasing something else, this gift certificate will not be available for use.

Posted September 12, 2020

Answer a Survey/Form From Your External Website via our API

By leveraging our API, you can customize the front-end of your experience and capture data on your external website.

Posted September 10, 2020

Setup a Certificate of Completion, Diploma or Other Important Documents for Your Members After Achieving a Goal

With our image generator + text you have the ability to overlay messages over your existing graphics.

Posted September 9, 2020

Set the Time Tickets Go On Sale and Off Sale, Not Just the Date

You now have the ability to set the time that tickets should go on sale and off sale.

Posted September 4, 2020

Setup an Event and Enable an External Party to Manage the Event

You can enable your partners access to event details without giving them access to the whole platform.

Posted September 4, 2020

Use SAML based SSO Login for Your Website or App

You can leverage our /login/sso to get started with signing into your member portal with one-click SSO.

Posted September 1, 2020

Gain More Control Over Automating Membership Activities with New Triggers

We added several new triggers enabling you to setup automated activities after certain activities happen.

Posted August 28, 2020

As We Close Out Month 8 of 2020 - Here Are Some Noticeable Updates

We added a few updates the last week of August, here are a few to highlight.

Posted August 28, 2020

Members Can See Open Orders to Pay and Close

Members can now see open orders in their order history to make it a two-click pay and close the check experience.

Posted August 28, 2020

Create Multiple Unique Branded Experiences with One CRM/Backend

You can setup content pages to only display on certain domain names when overriding our out of the box pages.

Posted August 27, 2020

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