Jump to content
thirty bees forum

Has anyone used the csv import for combination products?


alwayspaws

Recommended Posts

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

0_1490620989190_IMG_1219.PNG

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

@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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...