May 4, 2011

Trouble creating categories from CSV import | CyberSEO Pro | CyberSEO support forum

Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Trouble creating categories from CSV import
Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 (0 votes) 
September 3, 2025
8:34 pm
Avatar
deadleighclothing
Member
Members
Forum Posts: 6
Member Since:
September 1, 2025
sp_UserOfflineSmall Offline

To seed my websites with content I am using ChatGPT to write original articles. My feed imports a CSV that includes a column "categories" that has values like "Ethics & Culture, Folklore & Origins".

In the basic settings I have configured:

Custom taxonomies: category,%categories%
Categories: Uncategorized [UN-CHECKED]
                 Test [UN-CHECKED]
Undefined categories: Create new categories defined in syndicating post

However when I create a post, the category is set to the default post category configgured in Wordpress Settings -> Writing

I do not see anything about this step in the Syndicator log. What am I missing in my setup that the post category - I am sure there must be something missed in my setup.

For what it is worth, my post tags look great with this value: %xml_tags[tags]%, but that is a placeholder allowed field.

Also I read the documentation, searched the forums, and tried to solve with dear GPTs assistance before making this post. Apologies if I missed something obvious.

September 3, 2025
11:49 pm
Avatar
deadleighclothing
Member
Members
Forum Posts: 6
Member Since:
September 1, 2025
sp_UserOfflineSmall Offline

Grinding on this issue with CyberSEO GPT.

I updated the column heading categories to csv_category to get away from any protected terms. I also made sure my CSV was correctly formatted with quotes for fields with commas in them. To no avail.

So I am trying to go simple - I am testing right now with a very basic dump:

title,csv_category
"Test Category Assignment1","Category A2,Category B3"
"Single Category Post4","Solo Category2"

With Treat as CSV clicked.

Custom taxonomies I've tried both category,%xml_tags[category]% and category,%xml_tags[csv_category]%
Categories: all unselected

Undefined categories: Create new categories defined in syndicating post.

No matter what I seem to try, I am unable to get the Categories set to anything but the default wordpress category.

September 4, 2025
2:09 am
Avatar
deadleighclothing
Member
Members
Forum Posts: 6
Member Since:
September 1, 2025
sp_UserOfflineSmall Offline

It looks like by far the easiest solution here is just to convert the spreadsheets into native XML data. Now, my categories finally get created. 

 

Moved on to troubleshooting why <category>Category B &amp; V</category> gets created as "Category B&V".

September 4, 2025
4:44 am
Avatar
CyberSEO
Admin
Forum Posts: 4183
Member Since:
July 2, 2009
sp_UserOfflineSmall Offline

The answer depends on how you import the CSV file and what the imported categories look like in your XML structure. If they are shown there as <categories>, you need to add the following rule into your "Custom fields" box:

Login to see the code

If it is presented as <csv_category>, then the rule will be as follows:

Login to see the code

The "Undefined categories" option must be set to "Create new categories defined in syndicating post".

You are absolutely right that the plugin searches for categories formatted in the standard RSS feed format:

Login to see the code

If the categories are represented by some other tag, then it should be mapped using the "Custom fields" text field, or using Custom PHP code, for example:

Login to see the code

or

Login to see the code

Please find more information in this manual: https://www.cyberseo.net/blog/how-to-automate-wordpress-custom-fields/

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 541

Currently Online:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ninja321: 87

harboot: 75

s.baryshev.aoasp: 68

Freedom: 61

Pandermos: 54

tormodg: 51

Member Stats:

Guest Posters: 337

Members: 3118

Moderators: 0

Admins: 1

Forum Stats:

Groups: 1

Forums: 5

Topics: 1723

Posts: 8889

Newest Members:

xrprightnow, mouckoumbi, our728, km.chandrashekaran, bluest.recap.0x.icloud, robinhind

Administrators: CyberSEO: 4183