Jump to content

Import Products to SubCats


Recommended Posts

Hi Guys

 

Using the new version 1.5.3

 

I have a small test Product CSV File with the following

 

2,1,Test1,Accessories;air,1.20,,0.80,,,,,,,, and so on

This is made from excel 2010 and exported as CSv using comma (I do change the import in admin from ; to , and vice versa

 

Categories are Home:

 

Tropical Fish (with Subs)

Chiclids (With Subs)

Accessories

Air

Food

 

Whenever I try to import this csv file all goes well untill I check the shop and Test1 product is under home and I would have to manually change this through admin panel to Accessories - Air

 

Am I missing something?

Edited by coolcatkelso (see edit history)
Link to comment
Share on other sites

  • 2 weeks later...

Hi m8

 

Yes I managed to figure it out

 

If you are using csv to import, instead of using the category name use the I'd number

 

Mines is like

 

Category's:

 

Main:

Tropical fish (1)

Marine fish (2)

 

And sub cats for tropical:

 

Guppies (12)

Mollies (13)

Etc

 

So in csv do it like

 

Id Name. Unit price. Whole sale. Category

1. Fish 1. 1.99. 0.79. 1;12

 

1 being tropical fish and 12 being subcategory

 

I used use excel to create the csv file but this is done using comma, so just make sure you thing that setting in upload setting

 

Field separator , ; is default

 

Multiple items. ; , is default

 

And hit upload

Link to comment
Share on other sites

Hi m8, thank you for the quick response!

 

Although, after I used the category IDs the products still are being put in the home category. I used the default CSV file (http://localhost/ps/docs/csv_import/products_import.csv) from my installation of prestashop and changed the category names to category IDs. I'm using version 1.5.3.1 and using a language other than the default "English (English)"

 

I'm going to:

  • check my php error log
  • read the documentation of how to create a category (just in case I'm creating the categories wrong)

Any suggestions?

Eric

Link to comment
Share on other sites

×
×
  • Create New...