What I’m trying to achieve: I have a Make.com scenario that reads product data from a CSV file via FTP and needs to search for products in WooCommerce using their SKU to update stock quantities. The products definitely exist in my WooCommerce store, but the search module consistently fails to find them.
Current Setup:
-
Step 1: Get CSV File (FTP)
-
Step 2: Parse CSV File
-
Step 3: Search Woocommerce Product Using sku
-
Step 4: Update stock quantity of the product
The Problem: The WooCommerce “Search for a Product” module cannot find products even though:
-
Products exist and are published in WooCommerce
-
SKUs are correct and match exactly
-
I’ve tried different search parameters: “SKU”, “sku”, and even product titles
What I’ve tried:
-
Using the exact SKU values from WooCommerce admin
-
Searching by product title instead of SKU
-
Verifying products are published and in stock
-
Checking for extra spaces or formatting issues
Any help would be greatly appreciated! 