cre8ivewave
Forum Replies Created
-
Hello @shahzeenfarooq
Thanks for the helpful hint! It sparked the idea to use PHP escape characters, which led me to successfully escape commas within category names before the separator comma. Here’s how to correctly add comma-separated category names in a product import CSV file:
Starters\,\ Breakfast & Refreshment, Chinese & Salads, BBQ\,\ Sandwiches & SeafoodHere is the outcome
Please update the guide at the provided link to better assist future users.
https://woocommerce.com/document/product-csv-importer-exporter/#general-guidelines
Hello, @lovingbro
Thanks so much for looking into this! I’ve confirmed the issue. I was able to recreate it with a brand new WordPress install on my machine. I’ve attached some screenshots that hopefully give you a clearer picture of what’s happening.
My Environment
01 – All Products Screen
02 – Categories Section before running the importer.
03 – Added a sample CSV file into the importer provided by @mahfuzurwp listed above
04 – Continue with the process
05 – Completion of the import process without any error.
06 – All Products view
07 – Categories Section where the issue is persisting again.
No problem and thank you again for your prompt support. I used your CSV file to import the product list along with the categories you specified in the designated column. Unfortunately, I am still encountering the same unexpected results. I am curious why the script is unable to process the commas that are enclosed in quotes. I have attached a screenshot of the import results for your reference.
@mahfuzurwp Thank you for your prompt reply and advice. However, when I followed your instructions and entered various options for the categories in the designated column, I encountered the same issues in the Category section after running the importer. Below is the outcome of the import process.
“BBQ
“Starters
Breakfast & Refreshment”
Breakfast & Refreshment”|”Chinese & Salads”|”BBQ
Sandwiches & Seafood”
