Sync Failed with errors: 413 error

I should add that my hosting support reviewed the server reqs too and could find no issue.
Larry

Hi,

I wish the message “data is too large for your server” with line numbers I can’t look up was more helpful in determining what limit was encountered. The 413 error is not a shopify error, it is coming from the plugin.
Here are some config details:
https://mcbrady-mcmahon.us/phpinfo.php
PHP 7.2
WP 5.3.2
max_execution_time 6000
max_file_uploads 20
post_max_size 500M
memory_limit 2000M
upload_max_filesize 128M
NginX 512M
apache/PHP max size 128M
Connection Green, no firewall issues.
WP disk space allowed is “unlimited” with some 12G available.

So what config setting is too small?

Larry

Hi,

In the readme.txt says “Requires PHP: 5.6”.
The min requirement listing says “PHP 5.6 or greater”

Is anyone else using PHP 7.2?

Maybe I will try the PHP compatibility checker.

Larry

Hi, Well the PHP Checker says Shopify is to be to check. So I tried using PHP 5.6 and 7.0, but still get the error so I went back to 7.2.

I tracked line numbers for these errors to this code for each of the failures:
if ( $this->expired_from_server_issues($items, __METHOD__, __LINE__) ) {
return;

This made me think it was an SSL or firewall issue, but my SSL is working just fine.
I can’t add “.myshopify.com” to my firewall, but I did add 23.227.38.65 which made no difference. Not really sure what IP address, but I tried this one even though the Connect indicator is green in the Shopify Connection screen.

@larry-mcmahon

Hey Larry,

First, apologies for the delay in getting back to you.

The plugin requires at least PHP 5.6, so the language in the readme.txt could be improved.

Regarding the “data is too large for your server to handle” error, this is usually a database error. Sometimes this happens if you have products with exceptionally long descriptions inside Shopify or something similar.

Can you try changing the Items per request setting to 20, and also enabling Synchronous requests? Adjusting these will force the syncing process to “chunk” the data into more manageable processes which should help your web server.

Let me know if this helps!

Hi,

No problem, it is a holiday weekend.

I set the items per request to twenty. Sync requests is on. Then tried 10 items.
The error persists.

I did not set up shopify, so I have no idea how long the descriptions are but will check.

Hi,

Some of the titles are a bit long:
MORSE MODEL 24 CLAMP+GO DOLLY HANDLE (PATENTED DESIGN), DETACHABLE & ADJUSTS FOR 2″ TO 3″ DRUM DOLLY SIDEWALL. US Patent # US8424886

But the descriptions seem short or blank and not many images have been addded yet.

Larry

hi,

Just to be clear, the 413 Error did not go away after making those adjustments, which I had tried b4 as they are part of your troubleshooting documentation.

Larry

@larry-mcmahon

Hey Larry,

Thanks for the additional info. I just checked the plugin to see what the length restrictions is for product titles and it appears to be larger than the title you provided. So I don’t think that’s the issue.

I’ll need to debug further using your Shopify API credentials. Would you mind emailing me here: [email protected] and reference this forum thread? If you can provide me the API credentials you have set within the Connect tab then I can find the root cause within my test environment.

Thanks!

Hi,
Let me know if you need anything else.
Larry

Hi,

I increased some of the php limits. Working on upgrade to php 7.3. Just need the wp sql extension.

Reviewed some Security settings. Allowed access to xmlrpc.php.
Some other tweaks, but nothing yet.

Larry

@larry-mcmahon

Hey Larry, I should have a response for you soon. Thanks for being patient.

@larry-mcmahon

I just finished testing your store using the development version of the plugin.

The sync finished fine (no 413 error). However no products were synced. I believe this is due to one of two things:

Either your products are not assigned to the custom “sales channel” you made, or you don’t have the proper API permissions set within your Shopify private app.

Can you make sure to review steps 2-7 on from doc article? https://docs.wpshop.io/#/getting-started/syncing

In particular, make sure you have “read and write” set for everything.

Let me know if this helps!

Hi.

I deleted the exiting Shopify APP and recreated it using the doc article.
None of the products had been available to a Sales Channel or APP, so I made them available to all sales channels and the newly created APP.
There are no collection, maybe that causes a problem?
I updated the APP info in the Shopify Plugin settings.
I reviewed these for R/W:
Product Information
Customer details and customer groups
Orders, transactions and fulfillments
Price rules
Products, variants and collections
However, there is no “Price Rules”. This is RW:
Discounts – PriceRule REST and GraphQL API
read_price_rules, write_price_rules

Tried changes to sync Type Lite or Post and just get fewer 413s under lite.

No change, still the 413 error.

The products and collections pages must be created by by the plugin?
There is a https://mcbrady-mcmahon.us/products/ page with some items, but no products of collections data listed under the dashboard shopify tab. Not clear to me what is going on. Will talk to my client about the site activities..

What next?

Larry
BTW PHP 7.3 is now in use.

Hi,

So I changed the number of products/page to 20 and https://mcbrady-mcmahon.us/products/ does change to reflect this. So this page is being generated by WP-Shopify.

How can there be a product on a Page w/o a working sync or products listed in the Shopify Products tab?

The page with images is poorly laid out as the images are not the same size even though 70×70 has been set for the image size.

Larry