Okay
  Public Ticket #3207644
wpDatatables for product catalog page
Closed

Comments

  • [email protected] started the conversation

    Hello tmsplugin team

    I would like to ask you about wpDatatables, is it able to make a product catolog that show live product stock update?

    For example, product A has 100 left in stock, wpDatatables can show a 100 available stock then someone purchases it and it reduces to 77.

    If I refresh the product catalog page that I put wpDatatables on, will it show 77 available stock left?

    I would like to show product image, SKU, Title, Price and available stock in the table format.

    Thank you.

    Attached files:  Screenshot 2566-01-14 at 23.12.16.png

  •  1,702
    Miloš replied

    Hi, [email protected]

    Sorry for the delay, we don't work on weekends.

    - We don't have a native integration with WooCommerce yet, so pulling any data from its database can only be done with some custom MySQL query. If you're able to pull the data you need using this, I believe you'll be able to create a report you need. 

    Please note, though, that this falls under custom work as support doesn't include writing custom MySQL queries. 

    We also have a MySQL Query Constructor, which can help with this.

    - Please note that MySQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.

    -

    Our developers will work on native integration with WooCommerce, but at the moment, it is not possible.

    I can't say an exact ETA when it will be added, 

    but you can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -

    Let me know if you have any additional questions.

    And i just wanted to point out that you can try wpDataTables before purchasing

     on our sandbox Demo sites ( you can find links for the main plugin Demo,  

    as well as add-on Demos, in my signature),

    and there is a 15-day money-back guarantee period, 

    so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

    Thank you

    Kind Regards, 

    Miloš Jovanović
    [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