Create restaurant menu with google sheets import

  • Resolved owenpiccirillo

    (@owenpiccirillo)


    3 years, 1 month ago

    Hello,

    I am looking for a solution that a client can automatically change prices via their google sheets account that will sync with the website laid out in a menu style fashion on their website.

    I know you can import the data and it will display in a cellular style on the site with tablepress, and say the responsive styles.

    What I am looking to do though, is have a two column or three, with titles that I can css myself, then the client can log in anytime and swap out the prices via google sheets.

    My questions is, is this possible? Can I grab that shortcode and just !important css the data to try and make it work… also, what if i have different menu sections like Appetizers and Desserts.

    Would the best way to do this is create multiple google sheets, import then in their own tables, then in the front-end of the website ill just hard code the Names of each section following the embed shortcode below?

    Thanks, will purchase items
    -O

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    For this, you could use a TablePress table and the TablePress Extension from https://tablepress.org/extensions/table-auto-import/
    This could be used to sync a TablePress table and a Google Sheet (via automatic CSV imports).

    Then, you could either display the tables directly from this, or use e.g. https://tablepress.org/extensions/table-cell-shortcode/ to only retrieve single cell values, e.g. if you want a special layout.

    Regards,
    Tobias

    Thread Starter owenpiccirillo

    (@owenpiccirillo)

    Thanks,

    That might not work because if its a menu.. the price might change for example and this method would work… but what if they completely delete the item or add new items then the shorted to that single cell would not work, because it wouldn’t be grabbing the new cells

    Unless I can set a loop to go through it…

    I think the best method to do this would be.

    – Make multiple “page tabs” in a google sheets.
    – Name each tab, Apps, Entrees, Soups, Desserts.
    – Let the client upldate these at will, changing name, pricing, adding or deleting.
    – Then use tablepress to import each sheets tab.
    – I would have to hard code the tab Title ex) Apps, Desserts, etc…
    – Under each title I can shortcode the list id.
    – Lastly I would have to use css to !important over the grid to make it look more like a menu layout.

    Question? Can I alter the way the data is structures in tablepress? Like add <div class =”etc”></div> Wrappers and whatnot?

    I know you can you import a google sheet with the tablepress importer.. but can you specify the “tab” if you have multiple ones if you import it per table id?

    Thanks!
    -O

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    ok, if the menu would be altered significantly (i.e. more than prices), then that idea with the Single Cell Shortcode Extension will indeed not work.

    You would then have to set up the actual menu tables in Google Sheets already, and an import would replace them completely.

    As for the multiple tabs: This depends on whether you can find a CSV Sharing URL in Google Sheets that returns the desired tab. Each tab would have to become a separate table in TablePress.

    Regards,
    Tobias

    Thread Starter owenpiccirillo

    (@owenpiccirillo)

    Okay!

    I am working on this now.

    Is there a way I can change the layout of the structure?

    Like change the <table><tr> etc… to add or remove <div class=””> etc…?

    Thanks
    -O

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    TablePress offers some filter hooks that you could maybe use for this, please see the code of the class-render.php file.

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Create restaurant menu with google sheets import’ is closed to new replies.