packlink-dev / woocommerce_module Goto Github PK

At the moment adding a product to the cart takes 20 seconds. While researching why, I discovered it's caused by the Packlink plugin, and seems to happen due to the large wp_packlink_entity table.

If I disable the plugin or empty the table, adding an item to the cart takes less then a second.

We currently have 1680 orders, and the wp_packlink_entity table has 20597 entries. The majority are of the type 'ShippingMethodMap', 'QueueItem' and 'Process'.

When I remove them, the site speed increases dramatically. Is is safe to remove old items? Can they be removed automatically so the website continues to be fast? Or can the database queries be optimised so the speed is not effected as much by this table?

For reference: when checking New Relic, the packlink plugin is the most time consuming on the site.

If it's helpful to share a sql file of the table, I'm happy to do so.

Dear team,

Right under WooCommerce / Shipping Zones / Shipping Method, you can configure Packlink's shiping methods (or not) to be displayed to the user (and to add shipping to the order).

No matter what settings are configured (in my case, I completely remove all packlink shipping methods and I configure my own, with the shipping prices I want), there should be some cron job or something that is removing my configuration once a week (every sunday).

This is a big problem for some users (for example in my case), because I have my own shipping prices configured for each shipping zone and I do not want the user to be able to select Packlink's shipping methods by himself (sometimes I need to send the goods refrigerated which is not possible with Packlink).

I am using:

• Ubuntu 20.04 LTS
• Wordpress 5.5.1 (latest)
• LiteSpeed Cache 3.5.0.2 (latest)
• Woocommerce 4.6.0 (latest)
• Packlink Pro 3.0.4 (latest)

This bug is not new for me, it's happeing from the first time I started using Packlink Pro (about 2 months ago) even with old versions of all plugins previously mentioned.

If you need any further info or logs. please let me know.

Thanks

Hi!

I'm using wp+woocommerce with Packlink Pro plugin.

My woocommerce is configured so that the weight units are grams, not kg.

Every time the plugin are upgrades, I need to change class-shop-order-service.php file to divide for 1000 the weight.

I attach a file with a patch
packlink-weight-fix.patch.txt