Category import csv

[Havouza]

Hi! I try to import a category tree using the csv function. It is important that I can set also the ID:s because I use a xml feed from the supplier and it has to match. But the import just give the categories numbers from 3 and up. Is there a way to fix this? There seem to be no error, the import just dont bother about the id field

[nickon]

Hi,

Did you enable "force ID" ?

[Havouza]

Yes I did. It is strange it works with some cats and some not. I have to look deep to the csv file

[nickon]

You will have probably problems with subcat's. You have to asign a root cat

[Havouza]

I have given up. It behaves different every time. Sometimes create a category 2-3 times, next time create all categories as parents and no tree.. All when you try to force the ID. When you let it Autoincrement ID:s then it works as it should

[nickon]

Seems you bumbed into a bug:-) Reporting it would be the best option we have so @mdekker and @lesley can fix it

[Havouza]

I do that as soon as I run into them. However before I report it I will have a test on a PS i have up.

[alwayspaws]

I have no experience with this but did a search and found this module. Maybe it can help you?

XML feeds Module https://addons.prestashop.com/en/data-import-export/2381-xml-feeds.html

[Havouza]

It EXPORT from the shop ;-)

[nickon]

Assuming there is an xml I always pay a developer to create an import script for this. It's worth every penny. The time and effort for importing via csv is simply not worth my time + it's prone to errors.

[alwayspaws]

Three issues I need help with, please:

1. I looked at Preferences - Top Menu Items - so I could arrange them but they aren't there.

2. All my categories are in one big long list in the footer, on the left side.

3. The images I associated with the categories are either not there, or the wrong image is there:

A dog tie is not a dog dress! lol

https://prestatest.alwayspaws.com/dog-dresses

[Havouza]

I gave up and use the old Top Menu. Simple but stable

[alwayspaws]

@Havouza said in Category import csv:

I gave up and use the old Top Menu. Simple but stable

@Havouza Uh-oh. Is this the same situation for importing products? I'm not a coder and don't know how to do this. I know how to use sublime to edit files but I don't know which files I'm supposed to be using and where to copy them to.

@mdekker no pressure at all I promise, but if this is something that's going to be fixed soon I can wait since my live site is working.

I really hate using old junk like code, etc, because I have no idea how to integrate updates.

Thanks!

[alwayspaws]

What files do I copy from PS 1.6 for the top menu categories?

How do I delete the list of categories that went into the footer after category import since the category section doesn't show anything?

[Havouza]

I copied the blocktopmenu folder tp modules in TB and then installed it. The footer links is another module

[alwayspaws]

@Havouza thanks! I'll do that to import the categories. Did the products import work?

@mdekker Also, I still need to know how to remove those categories from the footer because they were put there by TB categories import.

[Havouza]

When the module is installed you configure it by adding the categories you want to the menu. They will all show up on the config page

[alwayspaws]

TB has two files in the blocktopmenu folder: blocktopmenu.tpl index.php

Live site has only one: blocktopmenu.tpl

Do I just copy the blocktopmenu.tpl file into the TB blocktopmenu folder or do I also delete the index.php file that is already in the TB blocktopmenu folder?

Footer problem is cleared up: My categories in the footer finally showed up in admin, so I deleted them all.

[Havouza]

I just copies the folder from PS and the copied it to TB

[alwayspaws]

@Havouza TB folder has two files and PS has only one file. I have backups, so I'll go for it... soon.

Here are the screenshots of the contents of each folder. blocktopmenu in thirtybees

blocktopmenu folder in PrestaShop 1.6.1.11

Does anyone have an opinion on what I should copy, since my live site theme was not generated by PS, but by TemplateMonster.

Thanks!

[Havouza]

Mine looks like this

[alwayspaws]

@Havouza - how do you get images directly in the post?

Thank you for the screenshot. I was looking much further into subcategories.

So I'm supposed to copy the whole folder from here?

public_html/modules/blocktopmenu

[Havouza]

Pictures you can only add in the post if you use the Reply button, not Quick Replay. There is a button top right to use. Second from the right

Yes the whole folder. Then you need to install it from BO

[alwayspaws]

@Havouza Thank you. In case anyone needs extra help, this is what I did:

Admin - cPanel - Filemanager:

1. public_html/modules/blocktopmenu

2. downloaded the blocktopmenu folder in zip format

3. Went to modules and services "add a new module" uploaded the zip file

4. Message said: "module was successfully downloaded"

5. Searched for blocktopmenu - didn't see it, but the categories show up in admin.

Categories - click "empty categories" to see your categories.

Note (because this is the step I'm up to now) - since the categories are currently empty, they won't show up on the site until products are in them.

1. Next I added attributes.

2. Backed up TB site.

[alwayspaws]

I uploaded a products csv which is associated with the categories I created. I made sure each product - all 142 of them - was associated with the correct categories.

Categories are not showing up at the tops of the pages but they are listed in the footer again.

I have a LOT of problems with product import csv and had to revise it and manually associate the categories that were incorrectly associated. Some product images and descriptions are scrambled. This is not correct:

A dog barrette is NOT a dog cooling vest. O.o

:anguished: