CSV import removes previous directory location associations

  • Resolved montebianco

    (@montebianco)


    1 year ago

    Hi,

    Having created several directories and importing the listings by CSV, the import is overwriting the directory the location is associated to, instead of adding the new directory to it… It is logical that the same town or district location will have several different directories associated with it… The import removes the previously associated directories and adds only the current directory import.

    This has removed the locations for 1000s of entries over several directories and as there is no way to update the location taxonomy in bulk, this requires going to hundreds of locations and adding it to each directory, but a new csv import will wipe this again.

    To note, we did not notice this at first, because the admin director listing page shows the listings with the location, but the Location pages for the directory do not show anything for the location, only for the last imported directory.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter montebianco

    (@montebianco)

    Although I can see a reason to have Locations only associated to certain directories, in our case of cities and towns, all the locations are relevant to all directories.

    Is there a function that will associate all directories to all locations by default please?

    superclassics

    (@superclassics)

    Hi Montebianco,

    No official support, but the problem exists longer, at locations you can assign the correct locations to the directories again.

    A pain in the *** but it works.

    Regards,

    Peter

    Thread Starter montebianco

    (@montebianco)

    As a quick interim fix, and as we have all locations associated with all directories for the moment, we can do a global update with phpmyadmin and running this code,

    UPDATE wp_termmeta SET meta_value= ‘a:7:{i:0;i:25487;i:1;i:25488;i:2;i:31426;i:3;i:25348;i:4;i:25486;i:5;i:25361;i:6;i:25715;}’ WHERE meta_key=’_directory_type’;

    where 7 is the number of directories and the following 5 digit numbers are the ids of the directories.

    We would need to run that after each csv import.

    Plugin Support Mahfuzul Alam

    (@mahfuz87)

    Hi

    Thank you for reaching out.

    We have released a hot fix today – https://prnt.sc/5o1vhP_67TYF. Could you please try and inform us if this change works for you?

    Regards

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘CSV import removes previous directory location associations’ is closed to new replies.

Tags