pablog

Hi,

GREAT! I have sent you a message using your contact form.

Thanks a lot!

YES! This is it!

Thank you very much for your fast reply

Hi @xue28,

Thanks for the help! Everything is very clear.

Happy holidays!

Hi @doublezed2 and @om4csaba,

Thanks for your help. We haven’t been able to fix the issue but I believe we are getting closer.

The next question seems like another topic but I would like to continue this support thread: When using the native WooCommerce Import Products feature, are the CSV files used (uploaded) hosted/saved in any folder inside WooCommerce?

We are asking this because we believe an admin user “damaged” the products database using this feature and it’s causing the inventory issue. When we make tests with new created products, the inventory management works perfect.

Thanks again for you time.

Hi @babylon1999,

Thanks for the fast reply.

It’s strange because we don’t use Cloudflare.

However, we have created an staging site, upgraded WooCommerce and works perfect!

We see that the action woocommerce_deliver_webhook_async is still executed multiple times but the final amount of units (inventory) is calculated correctly in our staging site.

Is this normal? Should the action woocommerce_deliver_webhook_async be executed multiple times for the same order?

Thanks again for your time.

Hi Pepe,

I really don’t know what happened but it’s now WORKING!!!

I have enabled the log errors if needed for future cases. I will get back to you if we detect any other errors about products sync.

Thanks for your time and effort!

Hi Tamrat,

Thanks a LOT for your help. This is my progress:

• Confirmed that the “Sync inventory” option was enabled.
• When manually syncing from Woo, data is synced correctly.
• The issue is when creating a new product inside Woocommerce with a an amount of units (inventory) assigned, the product is created in Square but with 0 inventory.
• My system report:

` WordPress Environment

WordPress address (URL): https://casa401.com
Site address (URL): https://casa401.com
WC Version: 7.7.2
REST API Version: ? 7.7.2
WC Blocks Version: ? 10.0.6
Action Scheduler Version: ? 3.6.1
Log Directory Writable: ?
WP Version: 6.2.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: – Server Environment

Server Info: LiteSpeed
PHP Version: 7.4.33
PHP Post Max Size: 512 MB
PHP Time Limit: 120
PHP Max Input Vars: 5000
cURL Version: 7.84.0
OpenSSL/1.1.1p

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.19-MariaDB-cll-lve
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 7.7.2
WC Database Prefix: wp_
Total Database Size: 33.38MB
Database Data Size: 26.54MB
Database Index Size: 6.84MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 1.52MB + Index: 0.83MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.52MB + Index: 0.48MB + Engine InnoDB
wp_addonlibrary_addons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_addonlibrary_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_jet_post_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_jet_taxonomies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_options: Data: 3.52MB + Index: 0.14MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 8.52MB + Index: 3.03MB + Engine InnoDB
wp_posts: Data: 9.52MB + Index: 0.27MB + Engine InnoDB
wp_post_smtp_logmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_post_smtp_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_sd: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_sd_presets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpvivid_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB Post Type Counts

acf-field: 7
acf-field-group: 3
acf-taxonomy: 1
attachment: 273
brand: 1
custom_css: 1
customize_changeset: 6
elementor_library: 12
elementor_snippet: 2
elementskit_content: 6
iksm: 7
jet-engine: 4
nav_menu_item: 6
page: 7
post: 3
product: 650
product_variation: 55
revision: 425
shop_coupon: 1 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (16)

Post SMTP: by Post SMTP – 2.5.8
Admin Menu Editor: by Janis Elsts – 1.11
Advanced Custom Fields: by WP Engine – 6.1.6
Elementor Pro: by Elementor.com – 3.13.2
Elementor: by Elementor.com – 3.13.4
ElementsKit Lite: by Wpmet – 2.8.8
UPS Live Rates and Access Points: by Octolize – 2.0.2
Iks Menu Pro: by IksStudio – 1.11.0
JetEngine: by Crocoblock – 3.1.6.1
Rank Math SEO: by Rank Math – 1.0.119
The Plus Addons for Elementor: by POSIMYTH – 5.2.8
The Plus Addons for Elementor - Pro: by POSIMYTH – 5.2.9
TinyPNG - JPEG, PNG & WebP image compression: by TinyPNG – 3.4.1
WooCommerce Square: by WooCommerce – 4.0.0
WooCommerce: by Automattic – 7.7.2 (update to version 7.9.0 is available)
WPvivid Backup Plugin: by WPvivid Team – 0.9.87 Inactive Plugins (5)

Custom Post Type UI: by WebDevStudios – 1.13.6
Iks Menu: by IksStudio – 1.11.0
LiteSpeed Cache: by LiteSpeed Technologies – 5.4
WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 3.3.5
WP All Import Pro: by Soflyy – 4.8.0 Settings

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: ?
HPOS feature screen enabled: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – WC Pages

Shop base: #5 - /products/
Cart: #6 - /cart/
Checkout: #7 - /checkout/
My account: ? Page ID is set
but the page does not exist

Terms and conditions: ? Page not set Theme

Name: Hello Elementor
Version: 2.7.1 (update to version 2.8.1 is available)
Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ? Templates

Overrides: – Square

Environment: Production
Tokenization Enabled: –
Debug Mode: Off Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: product-block-editor
minified-js
new-product-management-experience
product-variation-management
settings

Daily Cron: ? Next scheduled: 2023-07-25 12:46:44 -05:00
Options: ?
Notes: 73
Onboarding: completed Action Scheduler

Complete: 3,742
Oldest: 2023-06-23 17:03:43 +0000
Newest: 2023-07-24 14:52:07 +0000

Failed: 5
Oldest: 2023-05-25 19:24:57 +0000
Newest: 2023-06-15 15:00:44 +0000

Pending: 5
Oldest: 2023-07-24 15:22:07 +0000
Newest: 2023-07-27 20:06:18 +0000 Status report information

Generated at: 2023-07-24 09:53:46 -05:00
`

• No fatal error found in logs.

Thanks again for your help and please let me know any other data you need.

Hi Lester,

Thanks a lot for your fast reply!

YES it worked! Thanks a LOT!

Question: When exporting the settings of the plugin, does it include this kind of “Misc settings codes”?

Thanks.

Hi Alex,

Wasn’t able to find the issue and exported the data with another plugin. I suppose it is a hosting problem.

As feedback, it could be great if Advanced Order Export For WooCommerce can process data by 50, 100, 150 entries and “pack” exported files in groups of 1.000, 2.000, 3.000 entries.

Maybe this could help hostings with lower capacity.

Thanks again for your help!

Hey David,

Thanks for your fast reply.

I will notify the Monster Insights team with your answer.

Thanks for your time.

Hi Alex,

Thanks for the help. My answer for each topic:

1. No. We don’t use Transient Manager plugin. Here is the list of active plugins.

Advanced Custom Fields
All-in-One WP Migration Unlimited Extension
All-in-One WP Migration
Color Your Bar
Coordinadora
Departamentos y ciudades de Colombia para WooCommerce
Elementor Pro
Elementor
Email Log
Facebook for WooCommerce
MonsterInsights - eCommerce Addon
MonsterInsights Pro
GP Premium
Smash Balloon Instagram Feed
Loco Translate
Multiple Post Thumbnails
Protegido con contrase?a
Really Simple SSL
String Locator
Ultimate Addons for Elementor
Quantity Plus Minus Button for WooCommerce
Conditional Discounts for WooCommerce por ORION
Checkout Field Editor for WooCommerce
Advanced Order Export For WooCommerce
Product Feed PRO for WooCommerce
Variation Swatches for WooCommerce
WooCommerce Bulk Stock Management
WooCommerce Conditional Content
WooCommerce Order Status Manager
WooCommerce PayU Latam Payment Gateway
Shipping by City for BETRS
WooCommerce Table Rate Shipping
WooCommerce Zapier
WooCommerce
Yoast SEO
Smush
YITH Infinite Scrolling
YITH WooCommerce Ajax Search Premium

2. What is load balancer? How can we set a sticky session?

3. Sure. What time limit would you recommend?

Thanks again for everything.

Sorry, my mistake. Everything works perfect (cache issues).

Have a great day!

YES! Thanks @mmbsf

Everything seems perfect. I hope the following versions may contain the coupon prefix feature.

Thanks again and have a GREAT day!

Hey @bhshravankumar !

Sorry for the mistake. Thanks for the help.