40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Import Issue

This topic contains 7 replies, has 3 voices, and was last updated by  Joy 7 years, 2 months ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • September 21, 2017 at 10:54 pm #396851

    Joy
    Buyer
    Post count: 1076

    Hello, I did an import and goofed up. I have since deleted the duplicates, but there are a few that remain that I am very confused by.

    They share the same post ID’s. I can see one listing on page one and again on page two. But if I do a search of my listings, only one appears. I see this with about 5-6 of my listings.

    Any way to resolve this? Otherwise, I think I will try to manually remove and re-input the listings that are being affected. Thank you.

    September 21, 2017 at 10:56 pm #396852

    Joy
    Buyer
    Post count: 1076
    This reply has been marked as private.
    September 21, 2017 at 11:44 pm #396864

    Guust
    Moderator
    Post count: 29970

    I cannot find any duplicates on the frontend.
    I added an alphabetic sort, and still no duplicates.

    September 21, 2017 at 11:53 pm #396866

    Joy
    Buyer
    Post count: 1076

    Yes, as I said, it’s not reflecting on the front-end. Just in the back.

    September 22, 2017 at 12:17 am #396868

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    September 22, 2017 at 12:22 am #396870

    Joy
    Buyer
    Post count: 1076

    Okay. It’s very strange. 🙁

    Thank you.

    September 22, 2017 at 2:39 pm #396951

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Joy,

    This seems to be becasue the sort order is by post date and they are all exactly the same, this is a quirk with SQL where it can show duplicates on other pages, a solution would be to also add another sort order like title but though this would sort things in the short term it would slow things down a little when you are viewing many many listings, so in this situation i would say its best to make sure the post publish dates are unique even by 1 second, or leave them blank when importing to give it the current time and you wont have duplicates.

    Thanks,

    Stiofan

    September 22, 2017 at 9:33 pm #397013

    Joy
    Buyer
    Post count: 1076

    Oh! Okay. I understand. Thank you for figuring that out.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 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