Okay
  Public Ticket #2844094
Search a database/csv and display the results on a webpage
Closed

Comments

  • jim started the conversation

    Hi ,

    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 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

  •  2,503
    Aleksandar replied

    Hello Jim

    Thank you for your interest in wpDataTables.

    This seems like a simple task, but in order to hide the table before filtering is applied (searching for the order number), you will also need to purchase the Powerful Filters add-on.

    Also, when creating the table from a CSV file, there are two approaches:

    1. Creating a table linked to a CSV file, in which case the plugin stores a copy of the file in ../wp-content/uploads/YEAR/MONTH. This table would not be editable, but would only display the data from the file. In order to change the status of the order, you would need to edit the file in this location.

    2. Create a table by importing the CSV file - in this case, the plugin reads the source file, and creates a manual table. This table would be editable, but it wouldn't be linked to the source file anymore, so any changes made to the file won't be shown in the table, and vice versa. Instead, you would need to edit the table in order to change the status of the order.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables