Support » Plugin: WooCommerce » Error when Fetching Product from Woocommerce (using Tradegecko)

  • We’ve run some tests and get the same error: incorrect back-end parameters in Woocommerce store that keeps on showing errors when we try to fetch products from your store. Problem occurred unexpectedly, with no upgrades or new plugins involved. Worked one minutes and hasn’t worked since. As a result we’re unable to fetch the products and therefore all product syncs have ceased.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Jesse Pearson

    (@jessepearson)

    Automattic Happiness Engineer

    Can you confirm the errors you are receiving?
    Do you know if the errors are from the API, or are they generated from the code you are using to connect to the API?

    Can you also give an example of what you are trying to query? IE, a specific product, all products, etc.

    Plugin Support RK

    (@riaanknoetze)

    Could also be a result of server side changes, particularly if you haven’t run any updates on your side. Would also help if you could post your status report here (as found under **WooCommerce > System Status**).

    Hey guys, providing all that I know as I wait for Tradegecko Support to chime in.

    We found out that whenever we send a request to retrieve the products from Woocommerce, it is sending us back an error.
    The error occurs when the request get passed filterpost_status=publishedas a parameter.

    The way it works is we have TG request info from Woo via API connection (to my understanding). After pulling the info, TG and Woo sync products and some product parameters. The initial breakdown is that we cannot pull the info from Woo and therefore products are not syncing. What is interesting is that no changes occured before the breakdown to cause the breakdown. What we did try is upgrading WP to latest version and ensuring with Host that all security parameters are in good and updated working order.

    MySQL shouldn’t be a problem after constulting with TG and Host, as WP will work with current version and Host has no plans on updating to 5.6 for a little while longer.
    Woocommerce System Status;

    
    ### WordPress Environment ###
    
    Home URL: http://grandprixdance.com
    Site URL: http://grandprixdance.com
    WC Version: 2.6.4
    Log Directory Writable: ✔
    WP Version: 4.6
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 5.6.24
    PHP Post Max Size: 10 MB
    PHP Time Limit: 480
    PHP Max Input Vars: 3000
    cURL Version: 7.24.0
    OpenSSL/1.0.0
    
    SUHOSIN Installed: –
    MySQL Version: ❌ 5.5.42 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
    Max Upload Size: 10 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 2.6.4
    : 
    woocommerce_sessions: ✔
    woocommerce_api_keys: ✔
    woocommerce_attribute_taxonomies: ✔
    woocommerce_downloadable_product_permissions: ✔
    woocommerce_order_items: ✔
    woocommerce_order_itemmeta: ✔
    woocommerce_tax_rates: ✔
    woocommerce_tax_rate_locations: ✔
    woocommerce_shipping_zones: ✔
    woocommerce_shipping_zone_locations: ✔
    woocommerce_shipping_zone_methods: ✔
    woocommerce_payment_tokens: ✔
    woocommerce_payment_tokenmeta: ✔
    
    ### Active Plugins (26) ###
    
    Contact Form Maker: by WebDorado – 1.8.35
    Stripe Gateway: by DenonStudio – 1.4.1
    Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.0
    Google XML Sitemaps: by Arne Brachhold – 4.0.8
    MailChimp for WordPress: by ibericode – 4.0.3
    PDF Light Viewer Plugin: by Teamlead Power – 1.3.6
    PDF Viewer: by Envigeek Web Services – 0.1
    Pinterest Verify Meta Tag: by Marvie Pons – 1.3
    VarkTech Pricing Deals for WooCommerce: by Vark – 1.1.6.7
    VarkTech Pricing Deals PRO for WooCommerce: by VarkTech – 1.1.6.7
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6
    WooMedia WooCommerce UPS: by WooMedia Inc. – 2.2.4
    Syon Easy Privacy Policy And Terms Of Use Plugin: by Syonplugins – 1.1.0
    USPS (BASIC) WooCommerce Shipping: by WooForce – 1.1.4
    WooCommerce - All in One SEO Pack: by Visser Labs – 1.3.4
    WooCommerce Extended Coupon Features: by Jos Koenis – 2.3.4
    WooCommerce Bulk Discount: by Rene Puchinger – 2.4.2
    Custom Price Labels for WooCommerce: by Algoritmika Ltd – 2.1.0
    WooCommerce Product Badge: by Terry Tsang – 1.0.4
    WooCommerce: by WooThemes – 2.6.4
    WooDojo: by WooThemes – 1.5.4
    WooSidebars: by WooThemes – 1.4.3
    WooThemes Helper: by WooThemes – 1.6.2
    WP Max Submit Protect: by Academe Computing – 1.1.2
    WordPress Music plugin by righTune: by righTune – 1.0.2
    YITH WooCommerce Ajax Product Filter: by YITHEMES – 3.0.8
    
    ### Settings ###
    
    Force SSL: ✔
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    
    ### API ###
    
    API Enabled: ✔
    
    ### WC Pages ###
    
    Shop Base: #4 - /shop/
    Cart: #5 - /cart/
    Checkout: #6 - /checkout/
    My Account: #7 - /my-account/
    
    ### Taxonomies ###
    
    Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    ### Theme ###
    
    Name: Kaching WordPress WooCommerce Theme
    Version: 1.8
    Author URL: http://www.themesforge.com
    Child Theme: ❌ – If you're modifying WooCommerce on a parent theme you didn't build personally
    then we recommend using a child theme. See: How to create a child theme
    
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: kaching/woocommerce/archive-product.php
    kaching/woocommerce/content-product.php
    kaching/woocommerce/content-single-product.php
    kaching/woocommerce/global/wrapper-end.php
    kaching/woocommerce/global/wrapper-start.php
    kaching/woocommerce/single-product/product-image.php
    kaching/woocommerce/single-product/product-thumbnails.php
    kaching/woocommerce/single-product/related.php
    kaching/woocommerce/single-product/short-description.php
    kaching/woocommerce/single-product/up-sells.php
    kaching/woocommerce/single-product.php
    kaching/woocommerce/taxonomy-product_cat.php
    kaching/woocommerce/taxonomy-product_tag.php
    
    
    Plugin Support Thomas Shellberg

    (@shellbeezy)

    Automattic Happiness Engineer

    I’m afraid we can’t provide much help if the solution is custom-coded through the API. If you can provide the cURL request you’re using to query a product we could perhaps see if you’re doing something incorrectly(maybe you’re using the old API?), but we couldn’t troubleshoot the custom integration.

    Take a look at the updated API docs:

    http://woothemes.github.io/woocommerce-rest-api-docs/

    By the way, there is a TradeGecko plugin already developed here:

    TradeGecko

    Plugin Author Justin Shreve

    (@jshreve)

    We found out that whenever we send a request to retrieve the products from Woocommerce, it is sending us back an error.

    The error occurs when the request get passed filterpost_status=publishedas a parameter.

    Hi @obliviance – Can you include the error here? That will help us rule out things or know what to look for.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error when Fetching Product from Woocommerce (using Tradegecko)’ is closed to new replies.