Easy way to create and maintain multiple tables in wordpress

Discussion in 'Blogging' started by affbull, Nov 11, 2017.

  1. affbull

    affbull Junior Member

    Joined:
    Jan 16, 2016
    Messages:
    156
    Likes Received:
    7
    Hi everyone,

    Was wondering if there is an easy way to create and maintain multiple tables in wordpress. The information in the tables could change from time to time and so I am looking for an easy system to manage them. Example:

    Table of Candy
    1) Product: Candy A
    2) Price: 20 USD
    3) Retailer: Retailer X

    1) Product: Candy B
    2) Price: 30 USD
    3) Retailer: Retailer Y

    Table of Chocolates
    1) Product: Chocolate A
    2) Price: 40 USD
    3) Retailer: Retailer B

    1) Product: Chocolate C
    2) Price: 35 USD
    3) Retailer: Retailer X

    Both the price and retailer selling change all the time and both tables are on different pages of my website. I have over 10 such tables to manage.

    Plugins like Tablepress allow you to upload tables in CSV format however, they only apply to one table.

    Ideally, I was wondering if there is a solution that allows me to update an excel file and upload it to a plugin which then updates all various tables with the revised information?

    Thank you.
     
  2. MisterXYZ

    MisterXYZ Regular Member

    Joined:
    Jul 5, 2017
    Messages:
    296
    Likes Received:
    58
    Use airtable.com

    Create one database and then create views for each table and embed it in pages.
     
  3. Thomas Dr

    Thomas Dr Newbie

    Joined:
    Mar 27, 2016
    Messages:
    41
    Likes Received:
    10
    Gender:
    Male
    Occupation:
    SEO
    Location:
    Broad
    Are you looking for Paid or free plugins?
     
  4. affbull

    affbull Junior Member

    Joined:
    Jan 16, 2016
    Messages:
    156
    Likes Received:
    7
    Free plugins would be ideal but if it isn't too costly I wouldn't mind paid plugins too.
     
    Last edited: Nov 11, 2017
  5. affbull

    affbull Junior Member

    Joined:
    Jan 16, 2016
    Messages:
    156
    Likes Received:
    7
    Thanks would have a look.