Import Problem
-
Hello,
I am trying to import products using CSV file. But strangely, while some files are transferred, I get the following warning: “Sorry, you are not allowed to upload this file type.”What is the reason of this ? Can you help me ? There is no problem with transferring via FTP. However, I encounter this problem in normal transfer, that is, when selecting the file from the computer and transferring it.
I’m also wondering if this might have something to do with hosting. Because in the beginning there was no problem.
Note: There is no mime constraint.
Thank you.
-
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 4 years 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 4 years 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.
-
This reply was modified 4 years ago by
loopforever.
-
This reply was modified 4 years ago by
loopforever.
-
This reply was modified 4 years 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 4 years 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.jpgIf 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://ww.wp.xz.cn/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 4 years ago by
Igor H.
Thank you very much for your interest.
You’re welcome! Do let us know if you need further help.
-
This reply was modified 4 years ago by
The topic ‘Import Problem’ is closed to new replies.