Problem with the import

-- url of the page with the problem -- : acerbos.com/
-- HikaShop version -- : 1308282329
-- Joomla version -- : 2.5.14
-- PHP version -- : 5.3.27
-- Browser(s) name and version -- : Chrome

I have imported my products using the following spreadsheet. However none of my products are appearing up under products. The system says all the products were imported.

Hi,

Don't you have any error message displayed ?
Is your category "Flames" already created ?

Xavier,

I do get the following error message. And yes that category does exist already.

Hi,

In the categories column, you have to enter the id of the category and not the name.
Here is the csv documentation:
www.hikashop.com/support/documentation/73-hikashop-import.html

Finally, you can also have a categories column where you can put a list of categories id or a list of categories namekey.

For example:

product_code,product_name,categories

my_product_1,My first product,"2,13"



This will add one product with 2 categories attached: the category with the id 2 and the one with the id 13. You can find ids of categories on the category listing in the column called ID on the right of the listing.

HI,

I changed them to the category ids and it is still just saying the products are existing but none of them show up in the product listing. Could it have anything to do with the fact that I have a parent id for all of my products?

I tried removing the parent ID and re-uploading the spreadsheet but it didn't fix the problem. Do I need to create a variant first for each parent product?

Hi,

The categories must only be set on the main product, so you can let the parent id, but remove leave empty the category field when the line is for a variant.

Xavier,

I tried doing exactly what you said but all I get back is a message saying the products already exist however none of them display when I click on products or look at any of the parent products.

Hi,

I think that there is still an error in your csv file. Have you created it manually or is it a hand made csv ?
Thanks to try to let only the useful categories, remove all the categories with no data.

Are you sure that you don't already have products in your shop with the same product code ?
A product code must be unique.

Hi,

I got the CSV file from this video www.youtube.com/watch?v=t5-qzY83lsg . I then imported all the of the product data I have into the sheet.

These are all brand new products. The Shop is brand new to the website and this is the first set of products I am trying to get setup in the store.

Nicolas,

I removed all the extra columns except the parent ID because these products are children of the main products. So I guess they need to be a variant of parent. How do I set that up. The parent products were already imported into Hikashop and they appear in the products list just fine.

Hi,

I have tried several things you have suggested and I am stuck I can now get 1 product to import and put there is a variant however, it is not putting in any information that is supposed to be pulled from the child variant. I did as I read in the other tutorials about creating a variant first and then allowing that to pull the child product info as the characteristics it is supposed to do. I attached my csv file. Maybe someone can help me see what I am doing wrong.