Booknetic

Help Desk ›› Feature Requests ›› Booknetic
Log In to Reply
20 September, 2023 04:51:39
Tealme
Topics: 1
Messages: 10
Hi,
I am using Woocommerce integrated to another booking plugin (Booknetic). I am unable to get the correct Meta details as shown in the image attached. I need to get the booking details like the date and duration. It only result in the name of the table ( maybe). How can I access this and put it in the pdf? with the default invoice mail of woocommerce, this info can be captured (2nd image attached). I am not sure how with e2pdf. Please help! thanks
20 September, 2023 05:49:46
Tealme
Topics: 1
Messages: 10
Is there a way to Map the meta data in e2pdf? or can I map the woocommerce tables as follows manually:

"WooCommerce Products are located basically on two tables:

wp_posts table with a post_type product or product_variation,
wp_postmeta table with the corresponding post_id by product. (the product ID)
The following table contains product types, categories, subcategories, tags, attributes, and all additional custom taxonomies for specific products:

wp_terms
wp_termmeta
wp_term_taxonomy
wp_term_relationships
wp_woocommerce_termmeta
wp_woocommerce_attribute_taxonomies"

Thank you
20 September, 2023 05:57:09
E2Pdf
Support
Topics: 7
Messages: 3188
Hello,

It must be possible to get meta and terms: https://e2pdf.com/docs/extensions/woocommerce, however the syntax can be different depending on your E2Pdf Template connection: Orders / Products / Variations

Can you let us know please which connection are you trying to use? And which shortcodes did you try to use inside the E2Pdf Template?
We would really appreciate your feedback at WordPress.org!
21 September, 2023 02:32:38
Tealme
Topics: 1
Messages: 10
Hi,

I have tried almost all the available map field function in the Order, Cart and Product connections

Examples I have used:

[e2pdf-foreach shortcode="e2pdf-wc-product" key="get_formatted_meta_data" index="0"][e2pdf-wc-product key="get_formatted_meta_data" path="[e2pdf-foreach-key].display_value" index="0"]
[/e2pdf-foreach]

I am trying the Orders connection. Please help me out.


Also, how can I show the product only in an input object rather than html on this code ( the code below shows a table with column name, I dont want to show a table with column name, just the product item):
[e2pdf-wc-order key="cart" show_image="false" show_sku="false" show_quantity="false" show_subtotal="false" show_totals="false" show_price="false"]


Thank you very much
21 September, 2023 02:42:22
Tealme
Topics: 1
Messages: 10
I also used the Auto PDF function and it returned the same thing ( used Order, Product, Cart) : please view attached image(booknetic.jpg)

I am curious because when I tried the plugin YayMail, or other, it can get the right information as seen in the next image(booknetic2.jpg) so I know it can be done. I just don't know where to map it in e2pdf. Please help me out as I badly need this.
21 September, 2023 02:45:23
E2Pdf
Support
Topics: 7
Messages: 3188
Hello,

Are you able to provide us access details to the WP Admin Dashboard, so we can login and check your setup? If yes, please submit access details here: https://e2pdf.com/support/request.

Usually, the syntax is:

[e2pdf-wc-product key="metakey" order_item_meta="true" index="0"]

* however, we need to see how the data is associated and stored. Some plugins can use their own "structure" to store the data so we need to see if it's possible to get the data without any additional hooks.
We would really appreciate your feedback at WordPress.org!
21 September, 2023 03:01:25
Tealme
Topics: 1
Messages: 10
Do you need an admin access or a Editor access will do?
21 September, 2023 03:13:11
E2Pdf
Support
Topics: 7
Messages: 3188
Admin access is required. As an alternative, you can create a "staging" duplicated website with test data (orders, products, etc) and send access details to it. It must have the same complete setup (plugins and settings).
We would really appreciate your feedback at WordPress.org!
21 September, 2023 04:04:03
Tealme
Topics: 1
Messages: 10
I have submitted the support form. Thank you and I look forward to your help
23 September, 2023 00:37:26
Tealme
Topics: 1
Messages: 10
Thank you so much for helping me out! It means so much to me!

I just have 2 more questions regarding this:

1. I want to extract the information(product) in the cart, without displaying the table and column name, please see below for my code. I can get the correct information, but I just don't need it to be on a table. I just need the product details. How can I do this?
I am using Order connection
Code: [e2pdf-wc-order key="cart" show_image="false" show_sku="false" show_quantity="false" show_subtotal="false" show_totals="false" show_price="false"] ( output is on the attached image)

2. How can I manipulate the date in e2pdf?
For example I need to subtract 30 minutes. My output data is 11:00, and I need to get the time minus 30 minutes
Code: [e2pdf-format-output substr="-11,5" filter="rtrim,ucfirst"]
[e2pdf-wc-product key="booknetic_appointment_id" order_item_meta="true" index="0" subkey="booknetic_appointment_details"]
[/e2pdf-format-output]


Once again thank you so much. You have absolutely the best support! :)


23 September, 2023 03:56:37
E2Pdf
Support
Topics: 7
Messages: 3188
Hello,

1. You must be able to find the shortcodes from the "Visual Mapper". It can be used for example Order Product / Order Product Item Meta Keys / Product / Product Common, etc. If your E2Pdf Template is connected to WooCommerce Orders, usually, the shortcode must be [e2pdf-wc-product] with index="0" attribute. Screenshot attached.

For example:
[e2pdf-wc-product key="get_name" order="true" index="0"]

2. If you need to subtract a static value, the shortcode below should work:

[e2pdf-format-date offset="-30 minutes" format="H:i"][e2pdf-format-output substr="-11,5" filter="rtrim,ucfirst"][e2pdf-wc-product key="booknetic_appointment_id" order_item_meta="true" index="0" subkey="booknetic_appointment_details"][/e2pdf-format-output][/e2pdf-format-date]
We would really appreciate your feedback at WordPress.org!
23 September, 2023 19:00:59
Tealme
Topics: 1
Messages: 10
Hi,

Thank you so much! the time value is working. For the Product data, I don't think it is stored in woocommerce like the appointment details above.

I have been wondering if I could use column less table instead, but it is not working right now.
Is there a need to create another code snippet to get the product data?
23 September, 2023 20:02:09
Tealme
Topics: 1
Messages: 10
Is there a way to remove column names/ header in the table for the cart? Code is below listed:

[e2pdf-wc-order key="cart" show_image="false" show_sku="false" show_quantity="false" show_subtotal="false" show_totals="false" show_price="false"]
24 September, 2023 02:45:58
E2Pdf
Support
Topics: 7
Messages: 3188
Hello,

There is a PHP filter that allows removing the table header or it's possible to use CSS to hide it (latest RC version).

However, it looks like the correct way is just to modify the PHP filter that is used already on your website. We sent a response to your email directly with explanations.

We remain at your service.
We would really appreciate your feedback at WordPress.org!
24 September, 2023 04:10:52
Tealme
Topics: 1
Messages: 10
Thank you sooooo much!!!!
Best support ever!!!