WPPizza – A Restaurant Plugin for WordPress › Support › General Support › Guest "checkout" report.
- AuthorPosts
- 29 May, 2017 at 9:07 pm #28040
Hello Oliver and users…
We have setup WPPizza to use for our B&B room service. We have 3 suites. We are still in test mode, but it’s working beautifully. A few questions:
1) Is there a way to do a report by email or name that will show all orders for a particular guest so we can tabulate a bill upon check out?
2) Admittedly a more custom need… In addition to orders that our guest place on our website, there are also service items placed in the room. At the end of a guest stay, our cleaning crew tabulates the items that are taken. I am creating a custom UI for them to enter the items on an iPad.
Is there a way to recall the guest info so as they tabulate, they can attribute the fees to the proper guest?3)Breakfast for two and a coffee carafe comes included with a night stay at our B&B. We have three breakfast items listed at $15 each on our menu and the coffee carafe is listed at $5. To make breakfast “Inclusive” for guests I set a discount as follows:
“If order total > 10 get 35 off”
This workaround seems to work well for the vast majority of guests. Gratefully WPPpizza is smart enough to only discount up to the dollar amount spent. The only time is doesn’t work is when there’s only one guest…. if they add just one breakfast entree for $15, they can add as many as four coffee carafes for free.
This has only been a problem a few times, but ideally, we’d be able to setup the coffee carafe differently. For example, maybe make the first one free and only charge for subsequent carafes that are added. I also thought about designating the coffee carafe as a “topping” but I don’t think that’ll work either.
The only other issue with this setup is that guest can order multiple times a day and get the same discount. This has happened a few times.Just wondering if anyone has a better workaround for this overall setup.
Steve
1 June, 2017 at 12:46 am #28081Hello!
Is there someone who can chime in on this?
namely #1….1) Is there a way to do a report by email or name that will show all orders for a particular guest so we can tabulate a bill upon check out?
Many thanks
1 June, 2017 at 9:49 am #28082if you have the username/password for every user (i assume you are using this whole shebang somewhat internally ) you could create a order history page (i.e a page with [wppizza type=”orderhistory”] shortcode on it) and get a list of that particulars person orders.
however, as it stands, there isn’t really any integration of any kind to send this by email in a “click here to email” button sort of way#
the only thing i can think of is doing something like running the_content filter on that purchase history page along these lines
add_filter( 'the_content', 'my_the_content_filter', 20 ); function my_the_content_filter( $content ) { global $post; if($post->ID == x && is_user_logged_in()){//x being the post id of that page $user = wp_get_current_user(); $user_id = $user->ID; $user_email = $user->email;//or similar, dont know of the top off my head how to get the email, see codex /* run a query on wppizza orders table using wp_user_id = $user_id and save as file somewhere perhaps*/ $content.='add some button that on click sends the file to user ';// } return $content; }the above is just a very rough idea, i am sure there would be more hoops to jump through to make this work, but should be doable
1 June, 2017 at 10:11 am #28083>The only other issue with this setup is that guest can order multiple times a day and get the same discount. This has happened a few times.
i know nothing about your setup of course and it’s just an idea, but this one
https://www.wp-pizza.com/downloads/wppizza-coupons-and-discounts/
let’s you also specify a “once per customer” discount. however, if someone stays for more than one day and this is to be applied every day, you would have to reset the count every day (i.e re-save the discount or create a new one with the same settings)again, just an idea
1 June, 2017 at 11:47 pm #28119Thanks Oliver–
Just To clarify we are a B&B and typically have guests for a few nights and each guest typically places several orders. At the end of each stay we are needing to generate a total check out amount…. a final bill of all food charges (all placed via WPPizza.)
I dont think we have username/pass for guests (are they auto-generated?) but orders all have names and email addresses. Can we be filter by those?
These reports dont need to be emailed, just viewed by our admin staff for bill generation.
2 June, 2017 at 9:51 pm #28127the only half way sensible ideas i have is the following
a) add a filter in inc/admin.report.functions.php on aprox line 752 like
$ordersQuery = apply_filters('wppizza_filter_report_query', $ordersQuery);
right AFTER$ordersQuery.='ORDER BY order_date ASC';(i am happy to add this one to an update if needs be as you would be editing a core file)
b) add a button (or probably a dropdown list of users) somewhere (see wordpress codex) that on change/submit/whatever runs the action as in c) below making sure the filter in a) is applied to only show/select from wp_user_id = xxx (you should be able to get the id from the email)
c) create your own reports as outlined here https://www.wp-pizza.com/topic/create-your-own-sales-report/
i .e you would end up with a csv that only lists orders for that user (by id)
note: this will not be trivial though
3 June, 2017 at 10:39 pm #28154Thanks Olly that update would be great.
I do understand that the plugin was not intended for my specific type of use, but I still have the feeling that this type of report would be useful to more users than just me.All the data is already there, a customer query would be useful.
5 June, 2017 at 10:37 am #28174wppizza v3.x has a dedicated customer screen in the backend
5 June, 2017 at 7:56 pm #28177WWP 3.X is pretty exciting. I read the log and installed the beta on another site we use for testing.
I see the customer screen and I think that will work for us! The search field is a real bonus. Would you consider adding a customer digest? — Combining all orders by a single customer (within a defined date range) on one “copy/pasteable” list? We would gratefully contribute to development hours on this.I do have a few questions about a 2.x to a 3.x update:
1) Understanding that this is a beta, is your warning still in place not to use this on a live site?
2) Will 3.x maintain any 2.x settings/customization?
Will WPP Menu items / Categories still be in place?
Will WordPress customization on the WPP pages still work?
Will WWP customization transfer? (various pngs and wppizza-default.css were updated
Will WPP settings/and localization be in place?
Will 2.x Order history remain?6 June, 2017 at 2:08 am #28180in no particular order
>is your warning still in place not to use this on a live site?
yes (kind of).
the point of the warning is to not just update a live site, but to copy a live site to a test place somewhere, apply updates and make sure it still works – after thorough testing – before actually applying it to a live site. it really depends on the amount and type of customisation that has taken place if upgrading will be easy or time consuming.
generally i would suggest to copy what you have to a test server somewhere, upgrade the plugin and see what the story is.
if no customisations were done (more about customisations below), then the idea is that it will just work, but given the differences between 2.x and 3,x it’s strongly suggested to test this first in an environment where no harm is done if it goes wrong – essentially v3.x is more or less a re-write of the plugin>Will 3.x maintain any 2.x settings/customization?
that really depends on the kind/extend of customisations that have been done>Will WPP Menu items / Categories still be in place?
they should be (again, see above regarding using a test environment first)>Will WordPress customization on the WPP pages still work?
depends on what kind of customisation we are talking about>Will WWP customization transfer? (various pngs and wppizza-default.css were updated
css is – largely – the same. main difference being that the file hierarchy will change a bit to make things somewhat more structured and – for consistency – the cart/order details are using tables now
(in fact, one of the main reasons why it’s not yet out of beta is that i am in the process of writing the documentation for it all. not only what’s there/possible, but also some guide regarding the main differences between 2.x and 3.x and how to make sure ccs edit – for example -can be reasonably simply made to work by making sure the file hierarchy is what it should be in v3.x)>Will WPP settings/and localization be in place?
they should be (again, see above regarding using a test environment first)>Will 2.x Order history remain?
it should be (see above regarding using a test environment first)6 June, 2017 at 2:11 am #28181PS : you might even find that some of your customisations wont even be necessary anymore using v3 and can be achieved with shortcode attributes instead (but depends on what exactly you customised of course)
6 June, 2017 at 4:41 am #28183Ok I get the idea lol… I’ll copy my site to a test location and try the upgrade.
I previously added the 3.x beta to another WP site I have. That helped me see the new UI and tools, but nothing more.
Btw… everything does look more crisp right out of the box. 2.x was no slouch, but I do like the improvements in 3.Any word on the “customer digest” request? I know it’s specific, so I’d pay for development time. I also have to believe the feature would make WPP a very viable option for Airbnb hosts like myself. I’ve already received several inquiries about our ordering system for other hosts. One “super host” wants us to build their room service site.
Airbnb has a nifty feature that allows hosts to bill for room service and other incidentals, a customer digest or “check out bill” that can be copy/pasted into the Airbnb text field would be ideal.Maybe this can be an extension?
6 June, 2017 at 11:56 am #28192a) generally i do not do customisations
https://www.wp-pizza.com/topic/customisation/b) it’s a restaurant / pizza etc plugin. of course it can be used for all sorts of things – evidently – but what you are asking for is way outside the scope of the plugin. I have no intention of making this an AirBnB thing or anything resembling it (after all, AirBnB already exists)
c) that said, i can see that it might be useful – even staying within the scope of wppizza – to add a button in the customer screen that would do something similar as the “print order” button in the order history but showing all orders for the customer. probably not with date ranges set (but i could perhaps add a filter or action hook of some sort that would let people add this if necessary).
However, definitely not before v3.x is released/stable thoughd)extensions only make sense if there’s a demand for them (i.e more than just one or 2 people) as they have to have a ROI while keeping them at reasonable cost
6 June, 2017 at 3:07 pm #28205Just to clarify – i’m not suggesting this become “an Airbnb thing” — Airbnb is a strong platform. I’m only suggesting this modification to support the FOOD SERVICE side of our BnB. The side that Airbnb has no support for.
The two platforms would work independently. Airbnb would do all the reservations and booking, and then WPP would do the food ordering / order tracking for guests once they are here. There will be no interaction between the two platforms besides copying/pasting the final bill. Airbnb does allow for incidental charges.
As I was mentioning, there are many Airbnb hosts that offer food service… With no Airbnb support. I think WP pizza is a viable option and (I believe) it’s within the scope of the platform. This could be helpful for not only Airbnb hosts, but any bed-and-breakfast and small hotel owner.
6 June, 2017 at 9:08 pm #28228> i’m not suggesting this become “an Airbnb thing”
yeah, i didn’t really think you wereregarding the rest what i mentioned under c) in my previous reply still stands and i agree would/could be useful (and would/will be part of the main, free, plugin when the time comes)
6 June, 2017 at 9:14 pm #28229great. One last point/reiteration — The date perimeter would be wildly important to this cause…. We get a lot of repeat customers.
I’m sure the same is even more true of restaurants and pizza places.6 June, 2017 at 10:25 pm #28233>I’m sure the same is even more true of restaurants and pizza places.
be that as it may, the only thing relevant or of interest there is the total per customer regardless of date range
although i am happy to stand corrected if this becomes a requirement that is being asked for frequently , as always, the plugin is and has been growing to the state it is in mostly by user feedback so I am never saying – barring the completely outlandish requests and within reason – it’s not ever going to happensuffice to say, it’s been noted
7 June, 2017 at 1:16 am #28242It would be relevant if the hotel/Bnb room service sector was of interest to you. And with Airbnb, that’s now a lot of folks!
1) There’s virtually no other solution out there to meet the room service need. (I’m on forums where this is discussed at length)
2) it’s a tight-knit communityThere are tons of PMS (property management software) packages out there but NONE that handle food service well over a multi-day period.
WPP is already a working solution with v2.x. V3’s customer screen is another step forward. All we need is a checkout summary.
I’ve stated my point, thanks for listening! You’ve been great since day one Olly and I’m a believer in your product.
10 June, 2017 at 6:00 am #28282Hi Olly–
I successfully updated my test site to v3 170607.1
everything works fine, besides the order page and some customization on did on v2.I did see the warning in the development blog about needing to reset the order widget. I’m using the [wppizza type=’orderpage’] shortcode on the checkout page. The code is still in place but is not working properly, It’s simply rendering code.
What am I missing here? Has the shortcode been updated?While I have you, I have the following css/ php pages (with customization) in my child theme directory (from my v2 setup)
wppizza-default.css
wppizza-loop.php
wppizza-order-email-html.phpI also have some custom images (shopping cart) in a “img” dir in that same child theme dir.
I would think (since they are in the child theme) that they would still be active– so I’m assuming it has to do with the update. Are these able to be used?
Thanks much
10 June, 2017 at 6:19 am #28283Update: The order page itself is working, but I’m missing the “checkout” button that’s normally apparent in cart widget [wppizza type=’cart’]
I have the empty cart button, but no “checkout” - AuthorPosts
- The topic ‘Guest "checkout" report.’ is closed to new replies.