Import Error Could not insert post into datapase

  • Resolved qutubabbasi

    (@qutubabbasi)


    2 years, 4 months ago

    Getting this error while import product from 1 domain to another domain, how can we resolve this ?

    07-28-2022 @ 19:00:47 – —[ New import started at 2022-07-28 14:00:47 ] PHP Memory: 256 MB, WP Memory: 40 MB
    07-28-2022 @ 19:00:47 – Preparing for import.
    07-28-2022 @ 19:00:47 – Row :1 – Parsing item.
    07-28-2022 @ 19:00:47 – Row :1 – Parsing failed. Reason: Could not insert post into the database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WebToffee

    (@webtoffee)

    Hi @qutubabbasi,

    Thank you for contacting us

    The error message “Could not insert post into the database” is displayed when the importing CSV file contains unidentified characters and is not UTF-8 encoded. Please make sure that the CSV file is saved as UTF-8 encoded before importing to overcome this issue. Please go through the article on How to save CSV as UTF-8 encoded.

    If you still face the issue after saving the file as UTF-8 encoded then please share the importing file so that we can check it. You can share the CSV by uploading it to Google Drive or WeTransfer or any similar service and sharing the link.

    Thread Starter qutubabbasi

    (@qutubabbasi)

    Hello, i have converted file using MS Excel but still getting same error, here is the link to download a file

    https://drive.google.com/file/d/1xks3Wbg2BEgr6XWbX-etsdHKYAw98XiS/view?usp=sharing

    Plugin Author WebToffee

    (@webtoffee)

    Hi @qutubabbasi,

    Thank you for sharing the file. We have gone through your CSV file and noticed that the file contains unidentified characters in it. Please refer to the screenshot. Due to this reason the import is failing

    This is because the CSV is not properly UTF-8 encoded. You can try using spreadsheet applications like LibreOffice to create CSVs with UTF-8 encoding. LibreOffice has proven to be better in handling UTF-8 encoding in our experience.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Import Error Could not insert post into datapase’ is closed to new replies.