Import Problem

Hello,

I encounter this problem in normal transfer, that is, when selecting the file from the computer and transferring it

Can you provide a copy of the CSV file? You can use a public Google Drive or Dropbox URL so that we can check.

We’ll look forward to hearing from you.

• This reply was modified 2 years, 10 months ago by Igor H.

I solved the problem. If I remove the product description, the problem is solved. Product descriptions are written in HTML. Is there such a precaution? That is, descriptions written in HTML cannot be exported?

Hello,

Product descriptions can have HTML, but some servers can have issues with that. Please see the workaround shown here: https://woocommerce.com/document/product-csv-importer-exporter/#permission-error-when-importing

Also, make sure you avoid Microsoft Excel for editing the CSV, it can cause issues with formatting. You can find alternatives here: https://woocommerce.com/document/product-csv-importer-exporter/#create-your-csv

Let us know how it goes.

Thank you very much for your reply.
Unfortunately this constant did not fix the problem: `define( ‘ALLOW_UNFILTERED_UPLOADS’, true );
`

When I remove the HTML, the installation takes place. However, the problem persists with HTML, that is, with the product description. Also yes, the upload is done via FTP as well.
Should I talk to the server owner about this? Is there any alternative solution?

• This reply was modified 2 years, 10 months ago by loopforever.

Hello,

For us to be able to reproduce the issue, you can provide a copy of the CSV file, at least with 1 product. That will help to check better.

We’ll look forward to hearing from you.

Hello,
I have created a sample template below. I replaced the column names with the corresponding normally hook. Therefore, it may seem different to you, there is no problem there.

All the links in the Product Description section work flawlessly under normal conditions.
As I said before, sometimes I import products without any problems. But sometimes i get the following warning: “Sorry, you are not allowed to upload this file type.”

In such a case, I can still upload the file, that is, the products, via FTP. But I am not installing it with the export-import tool. However, “if I delete the product description” the file (products) import without issue. Just like the file I sent you. When I delete the product description containing HTML code in this file, it can be imported without any problems.

CSV File Link

• This reply was modified 2 years, 10 months ago by loopforever.
• This reply was modified 2 years, 10 months ago by loopforever.
• This reply was modified 2 years, 10 months ago by loopforever.

Hello @loopforever!

The file link you attached is not available. Can you please re-upload that CSV file and share the link with us?
For sharing files you can use https://www.file.io/, Dropbox, or Google Drive (Links need to be public) – you will want to upload the file and then send us the URL generated.

Cheeers!

I’m sorry for this. Can you look again please ?
File IO link
DropBox IO Link

• This reply was modified 2 years, 10 months ago by loopforever.

Hello,

It looks like there are some CSV column names that WooCommerce doesn’t support – e.g. Product Attribute, Low Stock Quantity, Core Attribute etc… If you are using the built-in product importer, please make sure to use the correct format. You can download a sample CSV file here: https://github.com/woocommerce/woocommerce/tree/master/sample-data

Also, csv elements are generally separated by comma (,) but your CSV file uses semicolon (;) instead – in which case, you’ll need to specify that in CSV Delimiter

Link to image: https://snipboard.io/LZVfmN.jpg

If you have some products that are uploaded already, the easiest way would be to export those existing products, replace the values, and import back into your store. – that way you’ll have a CSV with the correct formatting to use as a template.

To learn more about the product importer exporter, please visit this page: https://docs.woocommerce.com/document/product-csv-importer-exporter/

Thank you for your answer.
As I said before, I changed the column names myself with the hook defined by Woocommerce. I am able to add products using these column names. But sometimes I can’t add.

From my research it is said that in some cases HTML code (the code I used in the Description column) is seen as unsafe. Therefore, it is said to be a security measure taken by WordPress. However, this is not always the case.

As I said before, if I remove or change the product description, I can successfully import the products.
What I don’t understand is is there a way to get around this? Or, how is this security criterion (if there is such a thing) determined?

Hello,

Upon checking the file it will not work because of the format ??

You can get a copy of a valid CSV by checking the previous response from Maykato.

On the other hand, regarding the original question, please note that using HTML will flag the file, this is due to security reasons.

An alternative solution is to use a plugin like
https://www.ads-software.com/plugins/disable-real-mime-check/

That will help bypass the flag when the CSV contains HTML. Once you have uploaded a file properly you can disable this plugin.

I hope this helps.

• This reply was modified 2 years, 10 months ago by Igor H.

Thank you very much for your interest.

You’re welcome! Do let us know if you need further help.