About the product page slug when importing new products with CSV

  • Resolved tomitatsuyoshi

    (@tomitatsuyoshi)


    1 year, 3 months ago

    Hello. This is Tomita in Tokyo.

    Using WooCommerce, we are building a bilingual web shop for Kimono.

    Currently, we are manually uploading and displaying a small number of products as a trial.

    Finally, to upload a bunch of products, I first exported the current product data, then imported a CSV of the new products formatted exactly the same.

    There were two problems.

    One is that the slug on the product page becomes the Japanese product name.

    As a basic specification of WordPress, the title will be automatically reflected in the slug, but in Japanese, the URL will be too long when displayed to English-speaking people.
    Is it not possible to specify a separate alphanumeric slug for the import data?
    I think there are many needs for it.

    The other is that the registration of products with variations did not go well.

    I can create a product page, but the type is not reflected in the variations.

    Is it because I’m working in a Japanese environment?
    Or is it originally impossible to create variations with CSV import?

    Fortunately, there were only a few products with variations, so even if we manually entered the variation data, it was over in a short time.

    If anyone knows, please let me know.

    thank you!

    T.Tomita

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Shameem R. a11n

    (@shameemreza)

    Hello @tomitatsuyoshi

    WooCommerce allows you to specify a separate slug for your products when importing them via CSV. In your CSV file, there should be a column for Slug. You can enter the desired slug for each product in this column. If this column is left blank, WooCommerce will automatically generate a slug based on the product name, which is what you’ve been experiencing. By entering your preferred slug in English, you should be able to keep your URLs at a reasonable length for your English-speaking customers.

    As for your second issue, it is absolutely possible to create products with variations using CSV import. However, it’s a bit more complex than creating simple products. Each variation needs to be on a new line in the CSV file with its own SKU, and the Parent column should contain the SKU of the parent product. You also need to specify the Type as variation and fill in the Attributes column with the appropriate values.

    The language of your environment should not affect this process. If you’re still encountering issues, it might be due to the formatting of your CSV file. Please follow the guidelines in our Product CSV Importer and Exporter documentation.

    I hope this helps you in setting up your bilingual web shop for Kimono. If you have any other questions or need further clarification, please don’t hesitate to ask.

    Thanks!

    Thread Starter tomitatsuyoshi

    (@tomitatsuyoshi)

    Hello, Shameem!

    Thank you very much for your help.

    ?In your CSV file, there should be a column for?Slug.?

    Is that true? I can not find the column for Slug….
    You meen the column of “External URL” ?

    Please let me know.

    Thanks!

    T. Tomita

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @tomitatsuyoshi

    Apologies for the confusion; I meant to create/add a slug column. By default, the Slug column is not explicitly listed. The Slug is usually auto-generated based on the product title when you import your products. However, if you want to specify a particular Slug, you can add a column in your CSV file and name it Slug. Further information on adding a custom column can be found here: https://woocommerce.com/document/product-csv-import-suite-column-header-reference/#section-4

    Additionally, I found some resources via Google search that might help you add the custom Slug column:

    Hope this clarifies your doubts. Please don’t hesitate to get in touch in case you need our assistance with anything else.

    Thread Starter tomitatsuyoshi

    (@tomitatsuyoshi)

    Hello, Shameem!

    Thank you very much for your information.

    I understand.

    Hopefully, this functionality will become the default for WooCommerce importers/exporters.

    Thank you very much.

    Sincerely,

    T.Tomita

    Saif

    (@babylon1999)

    You’re very welcome, @tomitatsuyoshi! :?)

    I will mark the thread as solved. If you have a few minutes, we’d love it if you could leave us a review: https://www.ads-software.com/support/plugin/woocommerce/reviews/

    Cheers!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘About the product page slug when importing new products with CSV’ is closed to new replies.

Tags