Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
Hello WPDataTables Support,
I'm currently working on a project involving Cambodian hair extensions and I need assistance with WPDataTables. The project consists of organizing data for these extensions, which spans across approximately 20 tables. The reason for multiple tables is because the products are categorized based on bundles, weight (kg), type, patterns, and varying prices.
To provide an example, the available styles include Straight, Wavy A, Wavy B, Curly C, and Curly D, with lengths ranging from 10 inches to 40 inches. In addition to that, there are other categories such as wigs, wefted hair, HD lace, and more. I have created separate tables for each category.
My intention is to create a unified and searchable table where users can easily select products based on their preferences, including the ability to choose different prices. Once a product is selected or added to the basket, it should be possible to view a detailed breakdown of the selected items and proceed with the payment.
This project is specifically designed for a wholesale shop that requires a comprehensive overview. Consequently, I believe WooCommerce might not be the best solution for this particular project.
I hope my description provides a clear understanding of my requirements. I am looking forward to hearing your point of view and any guidance you can provide.
Thank you for your assistance.
Best regards, Kim
This is to show you the amount of tables, than basically contain the same product (Hair extensions), but all of them is ''different'' product, like wefted hair and so on.
The picture is to give you a an idea, so you see all besicly have the same headers, names, length, but different price according to different styles.
Jet Black Hair Extensions - KG Whole Sales PricesANother questions:
If i want a catalog that show all product in the same table hos du query this?
Example: name of tables
bulk 1 jet black kg
Bulk 2 dos kg
Bulk 3 Virgin kg
Jet black had lace
Jetblack fronthair
Jet black wefted hair
dos hair wefted
Dos Front hair
And so on..
Now, i want to add all product into 1 katalog with search function available.
But as each table have unique name because they ofcourse contains different product, still same styles, like straight hair, wavy a, wavy b, curly c, curly
How can i do this??
Hello Kim.
Thank you for reaching out to us.
Combining all the data in a unified table can be achieved with MySQL query. JOIN and UNION functions don't work well in wpDataTables as we're using a 3rd party PHP SQL parser which can cause issues with sorting, filtering, searching, and editing of those tables, so the proper way to do it would be to create a MySQL view which would then be pulled into wpDataTables with:
SELECT * FROM viewName
Adding the products to the cart is possible but only as a custom solution. You'd need to create a button that would be added to each row, and that would add the product to the cart. Something like this can't be achieved with built-in features of the "Button" option (in URL Link columns of wpDataTables) but I believe the best way to do it would be with a "Multi-line String" editor type, where you would be able to use HTML.
Another great way of doing that dynamically would be to have the product names added in separate columns, so they could be linked to the WooCommerce products. Then, in the SQL query, you'd be able to use the CONCAT function and join the HTML with the product name and the cart action. The example in the video is basic, but it should show you what the CONCAT function actually does.
Please note that the included support for the plugin doesn't cover writing custom queries or code. We're here to give you pointers and advice about how something similar can be achieved.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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