Sort products from csv file

  • Resolved exclusivecars

    (@exclusivecars)


    6 years, 12 months ago

    Hi!

    How can I sort products after a specific column in a csv file that is numbered 1,2,3 and so on? For example one category has 5 products, and another has 10, but I want them sorted after the column named “sort” in the csv.

    Please help me out!

    Regards

    Tomas

Viewing 6 replies - 1 through 6 (of 6 total)
  • Kenin

    (@kbassart)

    Automattic Happiness Engineer

    6 years, 12 months ago

    Hi there,

    I’m sorry but we’re not certain what you’re trying to sort here (are you sorting the CSV itself or sorting on the site?). Can you please clarify your question and how we can assist?

    Thread Starter exclusivecars

    (@exclusivecars)

    6 years, 12 months ago

    I have a product CSV file with a column called “sort”. It contains numbers 1,2,3,4 and so on. I want to be able to sort my products on the page after this column.

    Every category has it’s own numbers starting with “1”.

    I can do this manually, but with several hundreds of articles it will take forever.

    Hope this makes it more clear:
    Picture: https://ibb.co/mR08jMC

    Kenin

    (@kbassart)

    Automattic Happiness Engineer

    6 years, 12 months ago

    Hi there,

    “Sort” isn’t a default column header for WooCommerce Product Imports, you can see the column headers used here and here.

    You can use the menu_order for custom sorting values if you’re using the premium Product CSV Import Suite or Position if you’re using the built in importer.

    Thread Starter exclusivecars

    (@exclusivecars)

    6 years, 12 months ago

    Ok so I could make this work if I use the Product CSV Import suite? Any link to it, or where do I find it?

    Regards

    Kenin

    (@kbassart)

    Automattic Happiness Engineer

    6 years, 12 months ago

    Hi there,

    You can import the menu oder using either the premium Product CSV Import Suite or the built in CSV Importer for Products that’s included in core.

    • This reply was modified 6 years, 12 months ago by Kenin.
    smacksupport

    (@smacksupport)

    6 years, 11 months ago

    Hi,

    Install WP Ultimate CSV Importer Free Plugin and Import WooCommerce Free plugin, and try the WooCommerce Product bulk import. You can give the menu_order in the CSV header and save the number in the CSV file to sort the products in the desired order.

    Hope it helps.

    Thanks.

    • This reply was modified 6 years, 11 months ago by smacksupport.
Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Sort products from csv file’ is closed to new replies.