40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Listing Imports

This topic contains 3 replies, has 2 voices, and was last updated by  Alex Rollin 5 years ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • November 25, 2019 at 11:32 am #518598

    vivek
    Full Member
    Post count: 246

    Hi, I have a query about import of listings for updating existing listings, ie the update if Id exists is selected

    As i understand now, ALL the fields in the export csv file MUST be in the import sheet (earlier i have many times imported only 1-2 fields which were to be updated but last few times that has not worked and update happens only when ALL fields are there in the same order as in export file)

    In the import file, if i delete some values for a particular fields (ie the field is BLANK for some or all records), then the field value is UNCHANGED

    So, if i want to DELETE the existing values of a particular field (for all or some records), how can i do that, as blank cell keeps the value unchanged?

    thanks,
    Vivek

    November 25, 2019 at 7:49 pm #518643

    Alex Rollin
    Moderator
    Post count: 27815

    That isn’t possible for custom fields you have created yourself when using the built in importer, those blank fields will be skipped. If you have a field that is ‘y,n’, for example, you may want to add a 3rd value like ‘y,n,unknown’ and then you can pass ‘unknown’ to change the value.

    November 26, 2019 at 3:15 pm #518755

    vivek
    Full Member
    Post count: 246

    Thanks, Alex – i have values which i may want to delete for hundreds of records eg. i in a custom field “Area” I have text values which are displayed on the site. Now if i want to remove some text values say “abcd” then i need to delete those, while records having “efgh” , “ijkl” etc will remain with those values

    Another case is i have made a mistake in importing some ID numbers (say VAT ID) which are obviously incorrect ( have too many or too few digits – say i did not use regex check) – now i want to delete those numbers rather than show incorrect numbers, as i do not have the correct ones, this is for a few hundred records.

    Any suggestions how to do these 2 cases? thanks

    November 27, 2019 at 2:47 am #518805

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    you can replace values with a 0. If you have a whole column you can simply delete the field and then add the field again.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount