Yoast SEO and Woocommerce Product CSV Import Suite

  • dbengston

    (@dbengston)


    10 years ago

    Hello,

    After much investigation and experimentation, I have the Woocommerce Product CSV Import Suite importing and populating Yoast SEO fields. There are several Yoast SEO fields:

    _yoast_wpseo_focuskw
    _yoast_wpseo_title
    _yoast_wpseo_metadesc
    _yoast_wpseo_metakeywords
    _yoast_wpseo_meta-robots-noindex
    _yoast_wpseo_meta-robots-nofollow
    _yoast_wpseo_meta-robots-adv
    _yoast_wpseo_canonical
    _yoast_wpseo_redirect

    …but for this illustration I’m using just the Focus Keyword field, _yoast_wpseo_focuskw.

    Woothemes Instructions for adding custom fields got me started: in your field column list, just add META: to the beginning, right? Well, not really. I used META:_yoast_wpseo_focuskw in my field list, and it imported. However, this places a new custom field in the product’s custom field area, rather than populating the Yoast SEO fields.

    Looking at the data in the postmeta table in MySQL, I could see that the imported records had a meta_key of META:_yoast_wpseo_focuskw, while manually-entered SEO had a meta_key of _yoast_wpseo_focuskw.

    After several rounds of trying to fake out the Import Suite, I gave up and set my field column name to just plain old _yoast_wpseo_focuskw. At the Import screen, the built-in mapper can’t match this field to anything, so it sets a popup to “Do not import.” I changed the popup to “Custom Field with column name” and let it fly. Once the import was complete, all my Yoast SEO focus keywords were populated.

    I know this is a bit off-topic for posting here, but I hope this helps others to reach a bulk-import resolution faster than I did. Maybe in the future, Woothemes will offer native support for Yoast SEO fields.

    https://www.ads-software.com/plugins/wordpress-seo/

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

  • Dear dbengston

    I am really struggling to get this working. I previously purchased ‘CSV Import’ from allaerd which is really useful to upload over 7000 products, however now I am stuck as I would like to do the SEOs using Yoast for the key words, etc and doing it manually product page by page will take years!!!
    I have also downloaded WP Ultimate CSV Import (free version not pro) and when I click on ‘Imports’ menu it gives me three options (post, page, custom post). I have tried all three options and added the fields in my CSV and each time a new page is created by the plug in – I don’t want a new page as my products are already uploaded (using allaerd’s plug in) what I would like to do is to upload directly into each product page which is already uploaded (and not to create additional new pages). Are you able to share any advice or guide me what I may be doing wrong?

    In my CSV I have created different columns i.e. _yoast_wpseo_focuskw and have added a focus word and these do load directly into where they should go.Also not sure in settings, for ‘Select Post Type’ do I need to choose wcps; wooframework or anything else. I look forward to your urgent reply as I am stuck now.thanks

    Thread Starter dbengston

    (@dbengston)

    wave000,

    My instructions are for the “Product CSV Import Suite” available from WooCommerce. I bought this extension specifically because it will merge new data in a CSV file with existing WooCommerce product records.

    I have no experience with WP Ultimate CSV, or whether it will merge with existing data. Perhaps you’d be money ahead in the long run if you just purchased the Product CSV Import Suite.

    Thank you for your swift reply. I could be wrong but for some reason thought that you are linked to Spin Trust, where the instructions in Step 1 are to Install the free https://www.ads-software.com/extend/plugins/csv-importer/ but in step 2: image shows ‘WP Ultimate CSV Importer’ (this is different importer than what is stated in step 1) o I was a bit confused. Are you or anyone on this forum aware of any free product which may allow me to do as per my last post. thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Yoast SEO and Woocommerce Product CSV Import Suite’ is closed to new replies.