[Resolved] Bulk Import

[Author]

Posts

[CSS Web]

Tell us what you are trying to do?

Bulk import custom posts with custom categories.

Everything works perfectly except that the categories are only created, but NOT checked off.

I am missing something simple?

Is there any documentation that you are following?

https://toolset.com/documentation/user-guides/export-import/how-to-import-content-into-wordpress-using-csv/

And documentation and examples provided by the CSV Importer plugin

Is there a similar example that we can see?

I hope the screenshots are useful.

What is the link to your site?

Password protected during dev.

[Waqar]

Hi,

Welcome to Toolset support and I'd be happy to assist.

I've performed some tests on my website with the CSV Importer plugin ( https://wordpress.org/plugins/csv-importer/ ) and noticed that as mentioned in the plugin's notes ( at https://wordpress.org/plugins/csv-importer/ ), "0," needs to be appended before parent level hierarchal taxonomy terms:

Hierarchical taxonomies

The syntax for hierarchical taxonomies is more complicated. Each hierarchical
taxonomy field is a tiny two-column CSV file, where the order of columns
matters. The first column contains the name of the parent term and the second
column contains the name of the child term. Top level terms have to be preceded
either by an empty string or a 0 (zero).

Please see the attached screenshot taken from the example CSV file that I used.

I hope this helps and for questions specific to the CSV Importer plugin, you can get in touch with the plugin author at:
https://wordpress.org/support/plugin/csv-importer/

regards,
Waqar

[CSS Web]

Waqar - THANK YOU!! Works perfectly!!

I would never have been able to decode the CVS Importer instructions without your help.

I wish their sample files contained the detail you offered in your screenshot.

It makes perfect sense once I see it.

----

Any guesses to the syntax if a user wants 2 categories checked during import?

I've tried:
0,example,0,example2
0,example, 0,example (with a space between)
0,example,example2

No luck so far.

[Waqar]

Thanks for the update and glad that my message helped.

During further testing, I was able to add multiple taxonomy terms ( in hierarchal taxonomy ), by including each record in a new line.
( as shown in the attached screenshot )

In Excel on Windows, "Alt + Enter" works to add a line break in a cell, but you may have to use a different key combination based on the CSV editor and operating system in use.

[CSS Web]

AMAZING - Thank you Waqar!!

I really appreciate your help on this one - esp. considering it dealt with importing through a 3rd party plugin.

Please have a wonderful day 🙂

[CSS Web]

My issue is resolved now. Thank you!