Unable to Import product

Using my Dolibarr
1

I am new to dolibarr, I have version 3.6 installed.
I am trying to import over 155000 products
I go to the tools/import/new import. I have selected products with CSV and clicked on the symbol on the right at the end of the line.
I select the file and click on add file. The system then takes a very long time trying to upload the file. But there is no icon on the right hand side of the line in step 3. However as the file seems to have finished uploading, the screen flicks back to step 1, wanting me to select a type of file to import next.

What am I doing wrong? or is this some sort of bug. I have gone thru the bugs section and read the how to section without any result unfortunately. I did however find some answers to other issues but not this one.

Does anyone know how to fix this? Am I uploading too many products in one go.

2

Something I forgot to mention is that there is no error messages being displayed, it simply moves straight from Step 3 to Step 1.
I have tried different computers and different browsers, to upload the file. I have read the posts I can find and even made sure the date was the correct format. Is there anything else that I should make sure is in the right format.

I can upload the file if needed, however it is about 9MB.

3

There are a number of things that could be wrong.

firstly try to create a small chunk of say 10 products.

Run a test upload, this will help you check data integrity and match fields to the import fields.

Once you do this and the data result is okay to upload, save the profile for the import under a name you will remember.

The most common worry is the date and duplicate entries or duplicate ID/SKU

Date should be manually forced to read yyyy-dd-mm by using the format field, custom option and making sure you scan through.

Because you are uploading to an sql database, there will likely be timeouts on large files

That is because your server will be set to a specific number of seconds to execute any given query and when you exceed that unexpected things happen that you don’t want

So What you may find helpful is to split your csv

Do this by selecting say 500 products and moving them to a new sheet within the same workbook in excel and copy over the headers too.

in each new sheet keep about 500 products max.

then save each file as a csv for example

product import 1, product import 2 etc.

Then upload them one by one.

If there are still problems, check with your server administrator that you have not got too low a number for your max time script execute.

Its unsafe to set it too high, but also depending on which server you will be able to identify what is an allowable parameter.

hope this helps.

4

Thank you for your reply. You have kept my interest in dolibarr. I had stopped testing it because I was unable to get past this point. You idea of splitting the CSV is a great one. After I received your message I revisited the software and found that imports are apparently limited to 2Mb each, something I missed the first time round… Hence why your Idea of splitting the csv is perfect.

5

Try to change maximum size for uploaded files to Security will find Home -> Setup -> Security click tab Miscellaneous and change:
“Maximum size for uploaded files (0 to disallow any upload). Note: your PHP limits each file upload’s size to 102400 Kb, whatever this parameter’s value is.”

1 Like
6

Hello!
Tell me budlastka
I am importing one product, the volume of which is more than 2 MB
The system says that the file is not loaded…
I changed the maximum size, but it didn’t help
Changed the php.ini max size along the path etc/php/8.1/apache2/ but that didn’t help either
What else can be fixed to make it squeak?
Thank you!