anastas10s
Forum Replies Created
-
Forum: Plugins
In reply to: [WooCommerce] WooCommerce issueI went ahead with testing further.
Note that, while the site is https://barberteka.com/, all product pages have a button reading
KUPI NA SHOPPSTER.RS
.If deliberately, there is remaining functionality to be deactivated in the site’s code.
Otherwise, consider starting with a new/fresh WooCommerce site, and migrate products, orders, and related data to it – in order to go for a more time-efficient solution to this.
I hope this is helpful! Please let us know if you have any further questions or concerns.
We will be happy to help you further.Forum: Plugins
In reply to: [WooCommerce] Delete pages made by WooHi @sean-h
Thank you for reaching out — we’re happy to help!
Just to be sure, will there be any products/services being sold directly from the site, at this point, or otherwise?
If not, best to consider building the current functionality using core WordPress blocks (image, column, button, etc), and go ahead with adding WooCommerce when a product/service will be available for sale directly from the site (thus, the e-commerce functionality will be needed).
I hope this is helpful! Please let us know if you have any further questions about this matter, or if we misinterpret your concern in any way. We will be happy to help you further.
Forum: Plugins
In reply to: [WooCommerce] Order cancelled automaticallyThank you for reaching back, with further details on this @vlohar08 .
Kirki is reported in the fatal logs, here.
Moreover, in line 249, in the System Status Report (SSR), here, might be the culprit of the orders changing statuses.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
Forum: Plugins
In reply to: [WooCommerce] PHP warning – Attempt to read property “order_awaiting_payment”Hi @khff
Thank you for reaching back, with further details on this.
The PHP warning “Attempt to read property ‘order_awaiting_payment’ on null” indicates that the code is trying to access a property of an object that is currently
null
. This usually happens when an object or variable is not properly initialized or is not in the expected state.From the site’s System Status Report (SSR), Afterpay is the only payment gateway I can see active, and there is order status manipulation functionality installed, also.
Feel free to reach out to their respective support channels, about this, as they would be in a better position to assist you.
Moreover, based on what appears in the error logs about memory being exhausted, best to increase the values of the site’s PHP time limit, that of PHP Post Max and the WP Memory limit.
I hope this helps! Let us know it goes.
Forum: Plugins
In reply to: [Facebook for WooCommerce] ViewContent & AddtoCart not workingHi @icepicknz
server events
Just to be sure, are you referring to the Facebook conversion API (documentation linked here), or otherwise?
from another plugin
Activating multiple plugins might result in functionality conflict(s), therefore it is not recommended.
When a user views a product or adds to cart the events from browser are not coming through
Could you please provide us with a screenshot of these metrics, so that we can see what you are describing?
If you don’t already have a screenshot service installed, https://snipboard.io is a good option – for uploading it there, and sharing the link here afterward.
There is also a walkthrough guide here: https://en.support.wordpress.com/make-a-screenshot/We look forward to your response. In the meantime, please let us know if you have any further questions or concerns.
Forum: Plugins
In reply to: [WooCommerce] Immagini mancanti nelle notifiche email (es. nuovo ordine ecc)Thank you for reaching back, with further details on this, @stickermonkey .
As I understand, the issue is with the
?
appearing, in the blue square, instead of the image(s) in the emails. Correct?This icon is typically displayed when the image that links to is not available to load.
Feel free to right-click on it, and select “Open image in new tab” in order to see its file name. With that, go ahead with searching for it in the site’s media library. It might need to be re-uploaded, as was the case for the logo.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
- This reply was modified 4 months ago by anastas10s. Reason: typo
Forum: Plugins
In reply to: [WooCommerce] product price showing 50% higher than the input?Thank you for reaching back, with further details on this @renovomotors .
Based on the inconsistency in pricing here, then here, and here, along with what other functionality might be currently active as the sidebar here reveals, I’d recommend the following:
- Check if any dynamic pricing functionality might be affecting the way pricing is displaying on the front end
- Go ahead with a conflict test, as detailed here, as it would help peel this as an onion
By the way, implementing taxes in such manner might not be best, with over 8 thousand entries in standard taxes, and a few of them are zero rate. Could you please also share a screenshot of the screen at
WooCommerce > Settings > Tax
?I hope this is helpful! Please let us know if you have any further questions about this matter. We will be happy to help you further.
- This reply was modified 4 months ago by anastas10s. Reason: typo
Forum: Plugins
In reply to: [WooCommerce] DB error Unknown column ‘posts.ID’ in ‘on clause’Hi @nilu1972
Thank you for reaching out — we’re happy to help!
I am seeing this error message in our server error log. Do you have any advice on what is causing this and a possible solution?
The error message “Unknown column ‘posts.ID’ in ‘on clause'” indicates that there is an issue with the SQL query where it tries to reference a column
posts.ID
that does not exist or is incorrectly referenced. Here’s a breakdown of what might be happening:Error Analysis
- Unknown Column: The query is attempting to join on
posts.ID
, but it seemsposts
is not defined in the query. - Possible Cause: There might be a missing table in the
INNER JOIN
clause that should define theposts
table.
SQL Query Breakdown
SELECT SUM(order_item_meta.meta_value) as qty, order_item_meta_2.meta_value as product_id FROM wp_wc_orders AS orders INNER JOIN wp_woocommerce_order_items AS order_items ON orders.id = order_id INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id INNER JOIN wp_postmeta AS currency_postmeta ON posts.ID = currency_postmeta.post_id WHERE orders.type IN ('shop_order') AND orders.status IN ('wc-completed', 'wc-processing', 'wc-on-hold') AND order_item_meta.meta_key = '_qty' AND order_item_meta_2.meta_key = '_product_id' AND orders.date_created_gmt >= '2024-07-01' AND orders.date_created_gmt <= '2024-07-18 08:17:17' AND currency_postmeta.meta_key = '_order_currency' AND currency_postmeta.meta_value = 'EUR' GROUP BY product_id ORDER BY qty DESC LIMIT 1;
Solutions
- Add the Missing Join: Ensure that the
posts
table is included in the join statements ifcurrency_postmeta.post_id
referencesposts.ID
. - Correct Table Reference: Verify if
currency_postmeta.post_id
should reference a different table that is already included in the joins.
Corrected Query Example
Assuming
orders.id
should be linked tocurrency_postmeta.post_id
instead ofposts.ID
:SELECT SUM(order_item_meta.meta_value) as qty, order_item_meta_2.meta_value as product_id FROM wp_wc_orders AS orders INNER JOIN wp_woocommerce_order_items AS order_items ON orders.id = order_id INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id INNER JOIN wp_woocommerce_order_itemmeta AS order_item_meta_2 ON order_items.order_item_id = order_item_meta_2.order_item_id INNER JOIN wp_postmeta AS currency_postmeta ON orders.id = currency_postmeta.post_id WHERE orders.type IN ('shop_order') AND orders.status IN ('wc-completed', 'wc-processing', 'wc-on-hold') AND order_item_meta.meta_key = '_qty' AND order_item_meta_2.meta_key = '_product_id' AND orders.date_created_gmt >= '2024-07-01' AND orders.date_created_gmt <= '2024-07-18 08:17:17' AND currency_postmeta.meta_key = '_order_currency' AND currency_postmeta.meta_value = 'EUR' GROUP BY product_id ORDER BY qty DESC LIMIT 1;
General Advice
- Check Table Schemas: Ensure the tables and columns referenced in the query exist and are correctly spelled.
- Consult Documentation: Verify the expected table relationships in WooCommerce’s database schema.
- Debug Step-by-Step: Test the query incrementally, adding one join at a time to identify where it fails.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
Forum: Plugins
In reply to: [WooCommerce] Checkout formHi @elimarom
Thank you for reaching out — we’re happy to help!
In which PHP file can you change the fields in the checkout form
From what I gather, you’d like to change the look and feel of the classic Checkout page, at the site at https://verpackung2go.com/checkout/.
The template files are included here, and further details on how to proceed are linked here.
I hope this is helpful! Please let us know if you have any further questions about this matter, or if we misinterpret your concern in any way. We will be happy to help you further.
Forum: Plugins
In reply to: [WooCommerce] fonctionnalités WoocommerceHey @fabio1964 ??
Hello, in fact it is not a button problem but the filters are no longer displayed in the front office even though they are present in the back office. In addition, I have blocks of incomprehensible content added at the bottom of my store page and I don’t understand what this corresponds to.
additional information
I had to delete the specific sidebar for woocommece that I had created in which I had integrated filtering widgets (stock, price, attribute) because they do not work or even are not displayed in navigation private (front office simulation). any ideas to correct this problem please?
Kindly note, this functionality is related with the site’s theme/builder and, it appears Divi is currently active.
I’d recommend reaching out to the plugin’s support, which can be accessed via this page, as they would be in a better position to assist you.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
Forum: Plugins
In reply to: [Facebook for WooCommerce] ViewContent & AddtoCart not workingHi @icepicknz
Thank you for reaching out — we’re happy to help!
What do I need to add to ensure ContentView and AddtoCart work and send browser data through to meta pixel? Or do I just ignore it and not worry as server transactions will cover this in the backend?
In order to tell if the Facebook Pixel has been properly installed on your site, best to go ahead with utilizing the?Pixel Helper?– a small Chrome extension provided by Facebook.
Further details can be found in the documentation (direct link here, for your convenience).
I hope this is helpful! Please let us know if you have any further questions about this matter, or if we misinterpret your concern in any way. We will be happy to help you further.
Thank you for reaching out — we’re happy to help!
From what I gather, this is about Digital Wallet functionality for the events created via the
wp-event-manager
found in the demo site’s source code.Both WooCommerce and Stripe can be seen on the
wp-event-manager
plugin’s integrations page.Feel free to reach out to its support channel (linked here), as they would be in a better position to assist you.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
- This reply was modified 4 months ago by anastas10s. Reason: typo
Forum: Plugins
In reply to: [WooCommerce Square] Modifying order after pre-authHi there @dqr79
Best to authorize payment first, then edit (removing the required items), and proceed with a refund.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
Forum: Plugins
In reply to: [WooCommerce] Printful Probs + Deleting Woocommerce from pluginsHmm. It sounds like you need to temporarily deactivate the plugins, before you are able to delete the one you need, in order to continue troubleshooting at your site. This is a recent WordPress functionality.
With regard to the 404 error, feel free to reach out to the support channels at Printful and the site’s hosting provider, as they would be in a better position to assist you.
Moreover, the site’s hosting provider might be in a position to assist with restoring from a backup of the site, also.
I trust that points you in the right direction, but if you have more questions, let us know.
We’re happy to help.
Forum: Plugins
In reply to: [WooCommerce] product price showing 50% higher than the input?Thank you for reaching out — we’re happy to help!
Could you please elaborate further on the issue, and provide us with a screenshot, so that we can see what you are describing?
If you don’t already have a screenshot service installed, https://snipboard.io is a good option – for uploading it there, and sharing the link here afterward.
There is also a walkthrough guide here: https://en.support.wordpress.com/make-a-screenshot/This is what I see on my end, for reference.
We look forward to your response. In the meantime, please let us know if you have any further questions or concerns.