ERROR No such product

  • Resolved Kevin Burkholder

    (@kevinburkholder)


    1 year, 10 months ago

    Reporting this error although I think I found the source and work-around…

    Using WordPress 5.9.3, WooCommerce 6.5.1 with WooCommerce Payments 4.2.1

    After exporting products from one domain and importing to another domain (live->test) using the export/import buttons on the “All Products” admin page, I get this error in the woocommerce-payments log when attempting a new purchase/subscription:

    
ERROR No such product: 'prod_LlyBPjME9cxIJI' (resource_missing)
INFO There was a problem creating the WCPay subscription. Error: No such product: 'prod_LlyBPjME9cxIJI'

    Apparently this product id (prod_LlyBPjME9cxIJI) is related to / used by Stripe and was created on my live site (still in test mode), imported to my test site, but does not exist in Stripe under the test domain context.

    Word-around:

    The error / problem seems to be resolved by deleting from postmeta any record(s) with meta_value = ‘prod_LlyBPjME9cxIJI’ (specifically) OR meta_key = wcpay_product_id_test (or wcpay_product_id_live as the case may be).

    My concerns are that if I continually repeat this process of exporting/importing, (1) am I creating a flood of orphaned wcpay product ids in Stripe, and (2) that I can’t export/import through WP admin without manual phpmyadmin intervention to clean-up after the import.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • MayKato

    (@maykato)

    1 year, 10 months ago

    Hello,

    Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.  Once you’ve done that, paste it here in your response.

    Thread Starter Kevin Burkholder

    (@kevinburkholder)

    1 year, 10 months ago

    Indeed…

    
### WordPress Environment ###

WordPress address (URL): https://dev.earthasylum.net
Site address (URL): https://dev.earthasylum.net
WC Version: 6.5.1
REST API Version: ✔ 6.5.1
WC Blocks Version: ✔ 7.4.3
Action Scheduler Version: ✔ 3.4.0
Log Directory Writable: ✔
WP Version: ❌ 5.9.3 - There is a newer version of WordPress available (6.0)
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.15
PHP Post Max Size: 40 MB
PHP Time Limit: 120
PHP Max Input Vars: 1000
cURL Version: 7.75.0
OpenSSL/1.1.1i

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.40-MariaDB-log
Max Upload Size: 40 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 6.5.1
WC Database Prefix: wp_dev_
Total Database Size: 7.50MB
Database Data Size: 5.31MB
Database Index Size: 2.19MB
wp_dev_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_dev_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_dev_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dev_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dev_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_actionscheduler_actions: Data: 0.31MB + Index: 0.39MB + Engine InnoDB
wp_dev_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_actionscheduler_logs: Data: 0.22MB + Index: 0.17MB + Engine InnoDB
wp_dev_atpcustom_salesorder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dev_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
wp_dev_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_options: Data: 3.06MB + Index: 0.09MB + Engine InnoDB
wp_dev_postmeta: Data: 0.33MB + Index: 0.27MB + Engine InnoDB
wp_dev_posts: Data: 0.44MB + Index: 0.06MB + Engine InnoDB
wp_dev_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_dev_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_dev_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_dev_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dev_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_dev_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_dev_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_dev_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_dev_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dev_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dev_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

### Post Type Counts ###

attachment: 12
custom_css: 1
customize_changeset: 59
nav_menu_item: 22
page: 9
post: 16
product: 9
product_variation: 26
revision: 94
shop_coupon: 2
shop_order: 6
shop_subscription: 3
softwareregistry: 10
wp_global_styles: 1

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ❌Error messages should not be shown to visitors.

### Active Plugins (15) ###

ATP Custom: by Kevin Burkholder @ EarthAsylum Consulting – 4.0.5
Code Snippets: by Code Snippets Pro – 3.1.0
{eac}Doojigger: by Kevin Burkholder @ EarthAsylum Consulting – 1.1.0
{eac}Readme: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.4
{eac}SimpleSMTP: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.3
{eac}SoftwareRegistry: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.3
{eac}SoftwareRegistry Custom Hooks: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.1
{eac}SoftwareRegistry Distribution SDK: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.0
{eac}SoftwareRegistry WooCommerce Webhooks: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.3
{eac}SoftwareRegistry Subscription WebHooks: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.4
Enable Media Replace: by ShortPixel – 3.6.3
WooCommerce Payments: by Automattic – 4.2.1
WooCommerce: by Automattic – 6.5.1
WordPress Importer: by wordpressdotorg – 0.7
WP Crontrol: by John Blackbourn & crontributors – 1.12.1

### Inactive Plugins (4) ###

Akismet Anti-Spam: by Automattic – 4.2.4
Hello Dolly: by Matt Mullenweg – 1.7.2
Jetpack: by Automattic – 11.0
WooCommerce Shipping & Tax: by WooCommerce – 1.26.0

### Must Use Plugins (2) ###

{eac}Doojigger Auto-Loader: by Kevin Burkholder @ EarthAsylum Consulting – 2.0.5
{eac}Doojigger Environment: by Kevin Burkholder @ EarthAsylum Consulting – 1.0.1

### Settings ###

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

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: ✔

### WC Pages ###

Shop base: #489 - /shop/
Cart: #490 - /cart/
Checkout: #491 - /checkout/
My account: #492 - /my-account/
Terms and conditions: #815 - /terms-and-conditions/

### Theme ###

Name: Spiral Notebook Child
Version: 1.0.0
Author URL: 
Child Theme: ✔
Parent Theme Name: Spiral Notebook
Parent Theme Version: 1.1.15
Parent Theme Author URL: http://tradesouthwest.com/
WooCommerce Support: ✔

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: spiral-notebook-child/woocommerce/single-product/product-attributes.php

### Subscriptions ###

WCS_DEBUG: ✔ No
Subscriptions Mode: ✔ Live
Subscriptions Live URL: https://dev.earthasylum.net
Subscription Statuses: wc-active: 3
WooCommerce Account Connected: ✔ Yes
Active Product Key: ❌ No

### Store Setup ###

Country / State: United States (US) — Pennsylvania

### Subscriptions by Payment Gateway ###

WooCommerce Payments: wc-active: 3

### Payment Gateway Support ###

WooCommerce Payments: products
refunds
multiple_subscriptions
subscription_cancellation
subscription_payment_method_change_admin
subscription_payment_method_change_customer
subscription_payment_method_change
subscription_reactivation
subscription_suspension
subscriptions
gateway_scheduled_payments
tokenization
add_payment_method

### WooCommerce Payments ###

Version: 4.2.1
Connected to WPCOM: Yes
Blog ID: 206422608
Account ID: acct_1KymTC2EIde4lk5S

### Action Scheduler ###

Canceled: 1
Oldest: 2022-05-20 02:12:44 -0400
Newest: 2022-05-20 02:12:44 -0400

Complete: 865
Oldest: 2022-05-12 21:55:33 -0400
Newest: 2022-06-10 09:29:05 -0400

Failed: 2
Oldest: 2022-05-28 15:00:25 -0400
Newest: 2022-06-08 13:29:21 -0400

Pending: 5
Oldest: 2022-06-10 12:33:05 -0400
Newest: 2022-07-10 00:39:41 -0400

### Status report information ###

Generated at: 2022-06-10 10:39:01 -04:00
    Mirko P.

    (@rainfallnixfig)

    1 year, 10 months ago

    Hi @kevinburkholder,

    Thanks for the system status.

    Please update WordPress to the latest version on your dev environment and run a conflict test leaving only WooCommerce core and WooCommerce Payments enabled along with a default theme like Storefront.

    If your WooCommerce Payments logs still show errors related to the product, please submit a support ticket with us and also include a link to this forum thread via: https://woocommerce.com/my-account/create-a-ticket/.

    We’ll be happy to assist you further there.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘ERROR No such product’ is closed to new replies.