A must -see for those who are considering the transition to SHOPIFY! Data migration using MATRIXIFY [Product data]

by Hajime Ide

I would like to build my own EC site in SHOPIFY, but in order to answer such questions, "How should I migrate existing product data and customer information?" I will go.

1."Product data" (this article)

2. "Customer data"

3. "Order data"

Basic rules for file imports

  • In the case of CSV file format: "My-Goride- Products .csv "
  • In the case of Excel file format: Seat name "My-Goride- Products .xlsx "

Details of data items

[BASIC COLUMNS (basic column)]


1. ID

  • Number automatically generated by SHOPIFY to identify items
  • Used to identify and update existing products

2. Handle (handle

  • The end of the URL (eg, https: //goride.com/products/ Product name

3. Command (command)

  • NEW: Add only new products, and if you already have IDs and handles, it will be a failed process
  • Marge: Update if you have the same ID or handle, and if not, you will be registered as a new product (default)
  • Update: Update if you have the same ID or handle, if not, it will be a failure process.
  • Replace: If you have the same ID or handle, delete it and register the product, and if not, you will be registered as a new product.
  • Delete: Delete if you have the same ID or handle
  • IGNORE: Skip the product

4. Title (title)

  • Product title (for new registration) Essential )

5. BODY HTML

  • Product description (can also use HTML code)

6. Vender (seller)

  • Product seller (brand name)

7. Type (custom type)

  • Product type (for example, T -shirt, etc.)

8. Tags (tag)

  • Product tag (multiple specification can be specified by separating with comma ",")

9. Tags Command

  • Marge: Added tags to existing tags, describe the tags you want to add, import them, are not imported (default)
  • DELETE: Delete the import file tag and not delete the files that are not in the file
  • Replace: Replace all existing tags with the import file tag

10. Status (Product status)

  • Active (Active): A state that can be sold on online stores and sales channels
  • Archived: Not sold
  • Draft (draft): Transfer condition

[Inventory / Variants]


1. Variant ID

  • Product variation ID

2. Variant Command

  • MERGE
  • Update
  • Delete
  • Replace

* Same as "Command"


3. Option1 Name (name)

  • It will be the name of the option. Each product has three options.
  • Example: color, size, etc.

4. Option1 value (value)

  • It is the value of the options set above. Up to 100 optional values ​​can be set for each product
  • Example: RED, size, etc.

5. Other items

  • VARIANT SKU: Become a SKU of the product
  • Variant Barcode: Product barcode
  • Variant Image (image): Product image
  • Variant Price: Product price
  • Variant Compare at Price (Price before discount): Product before discount
  • Variant Inventory Qty (stock number): Inventory number

The following items can also be imported.

  • "Metafield"
  • "collection"
  • "Product image", etc.

summary

This time, we introduced the following as the basis of product data migration in SHOPIFY.

  • Basic Columns (basic column)
  • Inventory / variants (stock / variations)

In addition, you can import various data, such as metafields, collections, and product images.

Next time, we are planning an article about the transition of "customer data".

Please feel free to contact Go Ride for any questions and consultations regarding the transition to SHOPIFY.

Hajime IDE

Hajime IDE

Account Manager

TOKYO → FUKUOKA

この著者の記事一覧

WHITEPAPER DOWNLOAD

One -stop offered from EC construction to advertising operation.

WHITEPAPER DOWNLOAD inquiry