Thread Starter
mcdeth
(@mcdeth)
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
Plugin Author
Trey
(@ix3)
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.
Thread Starter
mcdeth
(@mcdeth)
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 9 months, 3 weeks ago by
mcdeth.
Plugin Author
Trey
(@ix3)
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: http://www.wpallimport.com/support/. We are only able to help with our free plugins/features on this forum.