CSV import

  • Resolved benf18

    (@benf18)


    3 years ago

    I am trying to CSV import products with 1 meta-value column
    The column contains this type of string-
    a:3:{s:7:”qty_min”;i:36;s:7:”qty_max”;i:1036;s:8:”qty_step”;i:1;}

    However, when inspecting the SQL data the string changes to –
    s:65:”a:3:{s:7:”qty_min”;i:46;s:7:”qty_max”;i:1046;s:8:”qty_step”;i:1;}”;

    When excluding the first 2 colons it works correctly.

    What must I do get the string to import as is.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Saif

    (@babylon1999)

    3 years ago

    Hello @benf18,

    I did some digging and found this thread on StackOverflow. As I understand it, this is a serialized data format and when importing it via CSV it’s serialized again.

    If you’d like to learn more about the Serialize() function in PHP, I suggest checking this guide.


    You can check if the snippet provided in the thread can help you solve this. You can add it to your functions.php file or use a plugin like Code snippet, please make sure to create a backup after doing so just in case things go wrong.

    Alternatively, you can import the data as plain text as mentioned in the import guide.

    Hope this helps!

    Igor H

    (@ihereira)

    2 years, 11 months ago

    Hi,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘CSV import’ is closed to new replies.