Has anyone used the csv import for combination products?

[alwayspaws]

Do you see anything wrong here, so far? I upload my CSV and match the headings and do an import. My product shows up with no combinations at all.

Single products work fine. The T-shirt on this page has several colors and sizes but when you click on it you go to a page not found

[Havouza]

No but the module can be buggy. I tried to upload categories with preset id. It just dont work so I gave up. That module is known to be buggy and a addon developer said it is so.

[alwayspaws]

Hopefully the fix that Michael just posted will work just fine!

[alwayspaws]

I will do this soon. Of course, I'll make backups. I was busy editing the docs. :)

[alwayspaws]

@mdekker said in Has anyone used the csv import for combination products?:

Can you try replacing the contents of the file /controllers/admin/AdminImportController.php with this: https://raw.githubusercontent.com/thirtybees/ThirtyBees/master/controllers/admin/AdminImportController.php ? We took the 1.7 importer, but it was utterly broken. Since then we have applied a lot of fixes to get it working properly for 1.0.1.

Once I've accomplished this daring feat :) I'll post my results. Thank you very much for the fixes.

[alwayspaws]

I replaced the contents of the AdminImportController.php file as indicated. I still have the same problem:

A double slash where the category should be:

https://prestatest.alwayspaws.com//dog-t-shirt-tee-shirt-printed-with-love-is-a-four-legged-word

The category page is correct - https://prestatest.alwayspaws.com/dog-clothes but clicking to get to the subcategory of dog tee shirts brings me here:

https://prestatest.alwayspaws.com/index.php?controller=404

Admin - imported two combination csv's, (obviously one at a time), to see if either would work. Neither did. I've actually been experimenting for several days, to make them work.

One spreadsheet has a comma as the separator for multiple values and the other has a semicolon as the separator for multiple values.

I tried each of them with import settings of:

field separator semicolon and multiple value separator as a comma

and

field separator comma and multiple value separator as a semicolon

Each time I uploaded the combination csv admin displayed "import successful".

I then reindexed, cleared cache - forced compilation and tried two browsers - FF and Chrome.

What could I be doing wrong? My host installed TB for me in my subdomain. I think they knew what they were doing. :)

Mistakes like this are often attributed to "operator error", so I'm open to further suggestions until I get this right.

[jnsgioia]

@alwayspaws I haven't imported any combinations but do use attributes. When I first set up the product import file I found I needed to avoid both commas and semicolons so used | for the field separator and ~ for the multiple value separator. This was for the PrestaShop 1.7 store but it has been working on the TB one too. You need to make sure you change the separator values on the import page to match your csv file.

[alwayspaws]

@jnsgioia i'm going to try that soon. How did you ever figure that out?

I'll change the spreadsheet and the settings on the import page. Thank you!

[jnsgioia]

From years of dealing with Microsoft Access and exporting and importing :)

I have found that I need to check the settings on the import page each time because mostly it doesn't remember the change.

[alwayspaws]

I fled from MS as soon as I could. :)

[jnsgioia]

I have tried other databases but none will do what I need it to do. Access is the only MS application I use though :)

[alwayspaws]

You never tried Microsoft Expression? I took one look and ran in the other direction! lol

[jnsgioia]

I haven't heard of that one. I tried the db application in libreoffice and looked at filemaker, neither worked for me. I guess I am just used to Access.

[alwayspaws]

@jnsgioia said in Has anyone used the csv import for combination products?:

I haven't heard of that one. I tried the db application in libreoffice and looked at filemaker, neither worked for me. I guess I am just used to Access.

I was using Microsoft excel for the Mac ( from Microsoft office for the Mac)

You may like this. It's open source and free. It does the same thing, but doesn't put extraneous characters in the files:

https://www.openoffice.org/product/calc.html

[jnsgioia]

I think that is basically the same as libreoffice Calc which I do use. Access is comparable to Base but has a lot more ooph and is a lot more complicated :|

[alwayspaws]

@jnsgioia get uncomplicated :)

[jnsgioia]

Sometimes that makes things more complicated :)

[alwayspaws]

Lol. I know the feeling.