Search a database/csv and display the results on a webpage

  • Hi All,

    I have a wordpress website setup for a local based store in my city. The type of product that customers purchase at this store take around 3 months to be ready for them to pick up. This product cannot be sold online/eCommerce as it requires to be built bespoke.

    During the 3 months, there are a few updates on their order for example, measurements completed, manufacturing completed, etc.

    All of the customer orders have a unique order number which are stored in a csv file and the csv file also contains the current status of the order. This is a very simple table where there is two columns – OrderNumber, OrderStatus.

    What I require is to provide customers the ability to review their Order Status on the wordpress website – as follows:

    1. Customer goes to https://www.company.co.uk/checkOrderPage
    2. On this webpage, the customer is presented with a box to enter in their unique order number
    3. Customer enters in the unique order number into the box and clicks a button
    4. They are then displayed with the status of their order

    Can this plugin achieve the above?

    Any help or tips would be appreciated.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author xnau webdesign

    (@xnau)

    Yes, this is possible, there are probably several ways to do it. An easy way to go is to set up the pdb_list shortcode so that it shows an input where the customer can enter their order ID. The list will then show the matching record.

    Your list shortcode should be set up something like this:

    [pdb_list search_fields="order_id" list_limit=1 suppress=true]

    The “suppress” attribute prevents any records from being shown until a search is performed, and then it will only show the one record that matches the order_id.

    You must have the “strict user searches” option checked so that partial matches won’t be shown.

    Thread Starter bdjimmali

    (@bdjimmali)

    Thanks i have got participant up and running and trying a few tests.

    I did try you shortcode however this does not display a search box – is there a reason why this would be the case?

    I did try [pdb_list search=true search_fields=”QuoteID,” list_limit=1 suppress=true] which shows the search field, search button and clear button however when i type in a quoteid, nothing appears.

    QuoteID is a valid column – full list im using for test is:

    QuoteID,Email,SurveyDate,Manufacturing,Installation Date

    also, is there anyway of not showing the clear button and instead if some typed in the wrong quoteid, they woud just type in again the correct one without needing to click clear first?

    Plugin Author xnau webdesign

    (@xnau)

    Ok, so I forgot to add the “search=true” to the shortcode example, glad you caught that.

    Make sure the field name in the shortcode exactly matches the field name (not the Title) from your setup.

    To help understand what is happening, turn plugin debugging on (plugin settings under the advanced tab), clear the debugging log and then re-check the log after testing a search. The log will show you the database query which will help you see what’s going on.

    Easiest way to hide the “clear” button is with a little CSS. If you want more control over the display, you can use a Custom Template for the list shortcode.

    dear Roland dear @bdjimmali

    many many thanks for this great thread. Again i see how versatile the participants Database is. We can use it for more than 100 different use-cases.

    i love it. Many many thanks for all-

    keep up the great project

    Hi all, I’m new to this, it’s not clear to me how to set up the puglin, so that
    when people enter a key that will be provided to them, get specific data (axis, points and rating), I already put the short code pdb_list as discussed here and it does not show results

    How could I do that?

    Thanks in advance for the support.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Search a database/csv and display the results on a webpage’ is closed to new replies.