Problem with product import

[kalman]

My problem is the next

When I import a csv file, the products from I wan't it in some categories, but when the import is done all the products appair in category with ID 1, not in the categorie what I want. What can I do ??? my csv file in the attachment

Attached File(s)

•  comenzi speciale 100809.csv (1bytes)
  Number of downloads: 568

[Mobius2000]

Hi there, I have only just sorted this out myself.

I have attached a work sheet below, roll over the heading titles and there is a little note outlining each point and what it does, this should help you sort it out.

To import this data do the following:

1./ Save this data sheet as a .CSV file and name it Products (or whatever you want). Make sure it is easy to recognise as you may end up with CSV's for categories and attributes etc.

2./ Upload it either through the tools>import>upload option or via ftp (upload to admin>import folder)

3./ In tools>import>importation, s=first select what you want to import, in this case you are selecting products.

4./ Now select your Products.CSV (or whatever you named it)

5./ Leave "iso-8859-1 encoded file" unticked (not sure what it does but it works unticked).

6./ Change "Field separator: " to comma ( , ) not including brackets or spaces.

7./ Leave "Multiple value separator:" as is.

8./ Click "Next Step".

9./ At the top of the next page, you need to mark "Skip" as "1" in order to skip the titles line of the CSV.

(image 2 shows this)

10./ Now in the table below, this is the break up of all your fields, check and make sure all the titles match the drop down options of that column (they should).

11./ Click the right arrow near the table to go to the last few entries which are the features fields. When you get to the first of the features field, click the drop list of that column and select "feature" from the drop list, this will open up a new text field in the drop list row, here you need to fill in what the title of that feature will appear as. In the case of the first feature, put here "Network" and the response for that will be as shown in the CSV for that column; "3G", repeat this for all the other features or change as you need to for your specific features.

(image 3 shows this)

12./ Hit import.

13./ GO LOOK AT YOUR SIGHT AND ENJOY THE FACT THAT YOU DIDN'T HAVE TO ADD 5,000 ITEMS ONE BY ONE!!!

REMEMBER: You can not use the file attached here directly, you must save it as a CSV.

NOTE: You can also tick the "Delete all products before import ?" which will clear all products currently in your store, this good for the first import but remember not to tick this once your up and running otherwise it will reset quantities etc.

Enjoy...

Attached File(s)

•  Products-MasterSheet.xls (19bytes)
  Number of downloads: 707
•  2.jpg (34bytes)
  Number of downloads: 2391
•  3.jpg (37bytes)
  Number of downloads: 2428

[Freds]

Hi
I havent tryed the worksheet you posted yeath I am reinstalling presta at the moment.
How is it with product id can it be both numbers and letters?
And what fields do I realy have to have included?

Best regards
Fredrik

[Freds]

Getting error

Black thing # 14 (ID 1001) cannot be saved
Product->name = Black thing # 14 for language 1

Any idea what it can be that do it?

[shenderson]

Does anyone have an answer for the error? Went through that whole process he has above, but getting the same error, "Kitchen (ID ) cannot be saved & Kitchen (ID 40 ) cannot be saved. HELP PLEASE!!!!

[rocky]

@Freds

I think # is a character that is not allowed to be used in names. That is probably the cause of your error.

[jon22]

I am having major problems with this and need help asap, i did a test csv in openoffice.org and it was fine however i hav now put together about 120 products and am trying to import but having no luck, ive tried lots of combinations for field delimiter etc, i save in openoffice as csv, with ; as field delimiter and " as text delimiter, and then import leaving values as ; for field and , for multiple value sep, but when i import there are only 10 products and there are no arrows to skip across fields to matchs columns with titles so does anyone hav any idea? if i post my csv does someone mind having a look please.

[jon22]

anyone please help me??

[manlox]

i have same probleme
only 10 products or gategories
i will try an other import module

[Ciscowrig]

Per Rocky's post above, I just had this same issue. # = other symbols may not be allowed. Try doing a search and replace in your editor. I replaced # with Num and = with EQL or a space depending on the situation. Everything imported perfectly.

[skinnysdrumshop]

I'm having issues with the .csv import. Several test files worked fine, I ticked "Delete all categories at import?" and now my site is broke. The homepage loads and literally nothing is on the page, just a white window. I've tried uploading other files after this issue and can't seem to get things "reset". Also, I'm using the Clean-Simple theme.

I've already reverted to a backed up database and backed up files and that didn't fix it. Really don't want to have to reinstall. Any suggestions?