Advanced Import Csv Extremely Slow

Hi,
i have cs-cart 4.11.3. I must import a big csv file with 180000 rows. Import with advanced import it's extremely slow (i must update only availability of products, for this reason i select only product code row and quantity).
To import this file i spent a lot of time (generally 1.30H). There is no way to import this file faster?
I have a dedicated server with Intel Xeon with 10 cores, 64GB of memory and SSD.
Thanks for support

If you like to extremely fast import of products availability please have a look our addon

Our addon was optimized for large XML and CSV files.

If you like to extremely fast import of products availability please have a look our addon

Our addon was optimized for large XML and CSV files.

Thanks, but i want to know if it's possible resolve with Advanced import of cs-cart

Does your csv only contain those columns? Or are you providing all data and telling the mapping to only utilize certain fields? If the latter, you might try getting rid of all the unnecessary columns and see if that helps.

Does your csv only contain those columns? Or are you providing all data and telling the mapping to only utilize certain fields? If the latter, you might try getting rid of all the unnecessary columns and see if that helps.

Everything is done iteratively in CS-Cart, not collectively / in batches. So everything requiring a lot of iteration is just a pain. Now, if you have 180000 lines, its indeed going to take a while.

My point was that if he has 100 columns in his data and is only using 5, reducing the number of columns COULD help performance. It will certainly cut down on memory. Yes, 180K rows will take a while no matter what. But if you can reduce the memory requirement by 90% you might find that it actually runs faster.

My point was that if he has 100 columns in his data and is only using 5, reducing the number of columns COULD help performance. It will certainly cut down on memory. Yes, 180K rows will take a while no matter what. But if you can reduce the memory requirement by 90% you might find that it actually runs faster.

file has only three columns. for import this file faster, i have split this csv in five parts and import in the same time. it's only solutions to resolve this problem. i have contact cs-cart but i have to pay to have support. :-(

Old post I know, but I have a similar experience with export. I try ot export 99,000 product image paths, 2 columns, product code and image pair, export starts off real fast and a sit gets past 10,000, 20,000 etc it slows , and slows, 8mb file,
is this normal, 40 minutes maybe ?