Invalid page template

Ok so the product was created by wp all import. Then I wanted to update and I couldnt due to the error as above. After I saved product manually, import started workin. There are few thousand products still that have invalid page template error

Hi @mcdeth,

Could you please post screenshots of the following:

• The “Custom Fields” section of your import template.
• The “Other Product Options” section of the import template.
• The Import Settings (Manage Imports ? Import Settings).
• The versions of our plugins that you’re using.

The problem is not related to custom fields but rather to the product itself. Observations:

• Updating only the title failed.
• Other Product Options remained unchanged and are consistent with the default settings and other working imports.

• I checked in SQL _wp_page_template of the problematic product, and it turns out the issue is related to a custom meta field.
• The specific custom field I intended to update (b2b_link) with value: b2bdomain/?s={name}[1] wasn’t added, but instead _wp_page_template was updated

Once I set

UPDATE wp_postmeta SET meta_value = 'default' WHERE wp_postmeta.meta_id = 58104171 AND wp_postmeta.post_id = 416651 AND wp_postmeta.meta_key = '_wp_page_template'; 

I could use wp all import to update product again.

It is bit weird this option was updated because I’ve set in Custom Field b2b_link and then within settings I’ve set to update only this custom field too.

View post on imgur.com

• This reply was modified 1 week, 4 days ago by mcdeth.

Hey @mcdeth,

Thanks for clarifying. It sounds like the product might have already had an invalid value in the “_wp_page_template” custom field before WP All Import tried to update the other custom field. This might have happened during the initial import that created it. I would suggest checking the original import to see if that’s the case, and if so, fix it and re-run it so that your update import works.

That said, importing data via the Custom Fields section is actually a Pro feature, so if you have more questions we’ll need you to contact us about this here: https://www.wpallimport.com/support/. We are only able to help with our free plugins/features on this forum.