re-importing issues

I do not know how to clean in in the “database” so that is a no go…
I will have to work harder… how do I merge the locations?
Since I see this is a gigantic mess in location it is also a mess in SEO as well. How do I correct the SEO area?

Thank you kindly. I will keep you informed and I have learned a valuable lesson.

This search and replace is beyond my understanding currently. I am going to wipe the entires manually all 6k of them. What a waste of time…

Since this is only the first major import of CPT and no one has claimed them it is faster to delete / trash all 6000, correct the Regions field and upload again.

Valuable lesson learned. One I hope I do not have to repeat.

I did reach out the the developers of the Search and Replace to obtain an estimate.

Time is the problem.. I cannot wait two days to get some kind of an answer from them and then two days later decide if I can afford it. I can just delete and start over within a couple of hours.

Kind regards and thank you for your support.

SEO is taken care of.. Wordfence was the culprit.

Hello again. So I deleted the entire CPT post and started from scratch. I can get the GD to acknowledge the data but it still will not import. I have gone through each column.

I believe it may be a “date” format issue. Is this possible? What day, month, year format are we suppose to use or does it even make a difference?

for example.. should it be Year/Month/Day? or Year-Month-Day or Day/Month/Year or Day-Month-Year. going on week five now.. this import issue is startling.

I have been saving the file / filter as Western Euro latin. I am going to try the utf8 and see if that gets it done. Comma delimit3ed.