How to import CSV (products & categories – separated files)?

  • Resolved mamandis

    (@mamandis)


    4 years, 5 months ago

    Hello,

    was looking an answer for a while and have not found it yet, so asking you for a help.

    The situation is that I want to import products to my Woocommerce store, but bumped into a problem – have two CSV files (categories and products), do not know how to import them (when have all data in one file, I know how to import).

    So, I show few lines of categories CSV:

    id______name_____parent_id
    14511…Gifts….14497
    14512…Hair…..14497
    18069…Men……18027
    (here are categories as we see)

    and here are few lines of products.csv:
    id_______ean______________categories —> other info (ex. brand, name, etc.)
    235…..20714001100……14497/14510/14799………..lets call this: A
    245…..20714004569……14497/14510/14799………..lets call this: B

    Products A and B goes to same categories (Hair and Gifts)

    I understand a relation between categories and products, but the biggest question is How to import these files?

    When categories are in same file like products, I know how to (can use WP all import or Woocommerce product import (builtin)).

    Help me, please..

    • This topic was modified 4 years, 5 months ago by mamandis.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    @mamandis Out of the box, the WooCommerce CSV importer will only import categories as part of a product CSV import. The categories need to be attached to a product in the correct format for them to be recognized. You cannot import categories separately on their own file.

    I’d recommend reading the following document about the way the built-in product importer works:

    https://docs.woocommerce.com/document/product-csv-importer-exporter/

    It includes a sample of how the CSV file needs to be imported. That is the only format that will be recognized by the plugin, and as you’ll notice, it is built to import products, not categories on their own.

    Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    Just to add a bit of clarity, what I meant to say is that in order to create categories on your site, you’ll need to either:

    * Create them manually, or
    * Import them as part of a product import.

    They can’t be imported on their own.

    Thread Starter mamandis

    (@mamandis)

    Thank you, Fernando @fhaps, for your response,

    WooCommerce CSV importer can not do this.

    How bout WP all import plugin?

    *Create manually is imposible – there are lot of items.
    *Import them as part of a product import – how to understand this, do you mean edit product.csv file (fill it with categories.csv file’s data)? If yes, every line needs to coincide to categorie value, in a file can not be few columns with IDs and eans, am I right?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to import CSV (products & categories – separated files)?’ is closed to new replies.