CSV Import (Categories) Bug

[Eezee]

I'd just installed TB on a localhost to make sure it does everything as expected. Unfortunately, there seems to be a problem with the CSV Import feature. I was thinking the issue was with the CSV file, but when I tried importing the same file using Prestashop. It was imported successfully without any problems.

The CSV file is encoded in UTF-8 and on the BO I made sure it was being separated by , Below is the screenshot of the CSV structure and the error message I'm getting. Anyone know why this is happening? Is there an update or a setting I need to change prior to importing any CSV's in the backend?

CSV Structure.

Error Message

[Traumflug]

I see no column active in your table, but a column Active (0/1). For a human it's easy to guess these mean the same, for a computer it's not. What happens if you rename that column to just active?

[Eezee]

@Traumflug I've changed Active (0/1) to active, but the result was still the same. I've even tried replacing the 1's next to each item to active but that did not change the outcome. I've uploaded the file for anyone to try uploading to see if they will get the same error.

Here is the file 01496405917063TB_Cat.csv

[Havouza]

That cvs look absolutely normal how it should be. But the CSV import has never worked for me so I got tired of it and bought a module to handle it. And it does perfectly

[Eezee]

@Havouza I was hoping not to spend any dime this early on, especially since TB is supposed to be a better version of Presta. Anyways, which module did you end up buying and what version?

[Havouza]

I think it will be better. The csv import comes from PS 1.7 if I remember correct. Not everything can be fixed at the same time unfortunately. Import/Update Bulk Product from any Csv/Excel File. Latest version about 60 Euro

[Eezee]

@Havouza That's too steep of a price - I might just go back to Presta.

[Havouza]

There is many on the forum that has succeded, wait for an answer before you leave.

[Traumflug]

I've created a Github issue for this, so this well done problem description doesn't get lost: https://github.com/thirtybees/thirtybees/issues/252

Looking at the test file provided, it displays as .csv file above, but the link behind this is a .xls file. Surprise, surprise ...

[Eezee]

@mdekker So, will these changes find their way into the v1.0.1 zip downloadable through the TB website or everybody will have to get v1.0.x from github?

[jnsgioia]

I updated the two files and it fixed the problem I was having with the product import where it was setting all products to inactive. Thank you @mdekker for the fix.

[Traumflug]

Thanks for the confirmation, @jnsgioia. Marking this thread and the Github issue as solved.

[Eezee]

@mdekker Good stuff, well thanks again for promptly resolving the issue. :relaxed:

[jnsgioia]

@alwayspaws had a problem with only one product showing in a category. I confirmed that when a product was added to a category either by import or in the back office all other products in that category were removed. I restored the product.php file that was replaced by the change above, but left the AdminImportController.php alone. The problem with the products being removed from the category is now fixed and the problem I was having with the products not being marked as active on import also seems to be fixed (so that bug must have been in the AdminImportController.php)

[alwayspaws]

@jnsgioia it isn't fixed for me because there is some code that is different according to a comment made to @spidawebs by @mdekker in my original post.

[alwayspaws]

@jnsgioia just in case this fix will work for me, I check that link last week and a couple of times this week and I just don't understand how to implement this update.

Without giving you a lot of work to do or a long explanation for you to type, how do I do this please?

[Eezee]

@alwayspaws Download the zip folder from the Github link. (https://github.com/thirtybees/thirtybees). From the downloaded folder copy the two files below into your shop folder.

1. classes/Product.php
2. controllers/admin/AdminImportController.php

That's how I got it to work.

[jnsgioia]

@alwayspaws You need the original file classes/product.php file that is in the 1.01 release and the AdminImportController.php file that was corrected the end of May. From the errors you were having I am guessing that you have both of the files that were corrected the end of May, so you just need to replace the Product.php one. You can get it by downloading the file from here, unzipping it on your computer and then uploading just the classes/Product.php file to your site on Siteground.

[alwayspaws]

@Eezee said in CSV Import (Categories) Bug:

@alwayspaws Download the zip folder from the Github link. (https://github.com/thirtybees/thirtybees). From the downloaded folder copy the two files below into your shop folder.

1. classes/Product.php
2. controllers/admin/AdminImportController.php

That's how I got it to work.

@Eezee @jnsgioia Thank you for this. I updated those two files since the github files are later updates than what's on our forum download page: https://thirtybees.com/download/

Image problems now / again:

I also split my 792kb csv into seven files. I imported each of these files as products and then as combinations..

There are no product images. All my category images are gone or in the wrong category.

This is a dog cupcake squeaky toy, but it is now in the collars category instead of dog toys. The screenshot shows "collars and leashes" is highlighted (moused over).

Any suggestions, please.

[alwayspaws]

@Traumflug said in CSV Import (Categories) Bug:

I've created a Github issue for this, so this well done problem description doesn't get lost: https://github.com/thirtybees/thirtybees/issues/252

@mdekker (just in case you want to see this again)

This issue was closed because we thought it was working but I just posted more information:

https://github.com/thirtybees/thirtybees/issues/252

I'm attaching 01501376676657testing-categories-and-tags.csv here because I couldn't attach it to the git post.