Category import csv

[alwayspaws]

@Havouza Can you please edit the title to Category and Product import csv's or should I create a new forum topic?

[jnsgioia]

I found with prestashop 1.7 (which is what this upload is based on) I had to change the field separator to | and the multiple value separator to ~. The upload file I use for the prestashop site worked here without any problems.

[Havouza]

I have given up the csv upload and use a module I bought for PS. can also import excel which is easier to handle in my opinion.

[alwayspaws]

@jnsgioia said in Category import csv:

I found with prestashop 1.7 (which is what this upload is based on) I had to change the field separator to | and the multiple value separator to ~. The upload file I use for the prestashop site worked here without any problems.

@jnsgioia I'll try that. Thank you. I'm going to have to delete everything again. I'm stuck in "Groundhog Day" (the old movie with Bill Murray who has to keep repeating one day over and over until he finally gets it right. :)

[alwayspaws]

@Havouza said in Category import csv:

I have given up the csv upload and use a module I bought for PS. can also import excel which is easier to handle in my opinion.

@Havouza Did you tell me that module, already? If not, what is it, please? My store is new and I'm getting nowhere fast. It's not the fault of ThirtyBees. PS 1.6.1.11 cooperates to an extent, but it's slow.

[Havouza]

Its Prestashop Importer - import product from csv, xls, xlsx. in the addon shop. developer buy-addons

[spidawebs]

@alwayspaws When you import categories, they don't automatically appear in the top menu. You need to go into Modules & Services and search for the Community Theme Top Menu. Edit it to suit your needs.

To get rid of the categories in the footer, o to Modules & Services and search for Categories block. Click on it and change "How many footer columns would you like?" to zero and see if that works.

As for the import going wrong, with wrong images etc, can you email me your csv file and I'll take a look again. I thought we had this working fine, so something must be wrong with the fields.

[alwayspaws]

@spidawebs It may help to see My TB test website: https://prestatest.alwayspaws.com/

Community Theme Top Menu ​I tried that before but I still only have one Top Menu item.

My categories show up on the left side only when I search for a product. I searched for "tie" and it came up with "no results" but I uploaded several ties.

"To get rid of the categories in the footer..."

I changed to zero, cleared cache, cleared browser history and settings from firefox and safari. The categories in the footer are still there.​

In addition: Home shows 8 products in NEW ARRIVALS and in POPULAR. As far as I know, nothing should show in popular unless I made a sale, which I haven't.

I configured Prefs - Products - pagination to 16 to see if any more than eight products would appear on the home page so I could at least view them, but even after clearing cache, New Arrivals and Popular remain at eight products.

@mdekker created a bug fix for the importer, which is great, but you seem to have no problem. :)

I will send you the csv by email soon.

Thank you for all the help.

[spidawebs]

@alwayspaws To add more items to the menu, click the little plus sign near the top right when you are in the module. It's not very obvious. You can then create new menu items for categories or category trees.

Go to Preferences > Search and click add missing products to index. It looks like the index hasn't been updated since you added the products. It's a good idea to setup a cron job for this so you don't have to keep doing it manually.

Not sure why the categories are still displaying in the footer. I need to remove that on mine too so I will have a play and report back.

[alwayspaws]

OK, I will try to add the items to the menu. I don't know how to set up cron jobs and researched that for five months for magento and PS and begged my host to set one up for me, but they can't or whatever.

I hope you can resolve the categories in the footer problem. I emailed you the spreadsheets.

Thank you.

[spidawebs]

@alwayspaws Just disable the categories block in modules - that removes it completely.

You'd be better off using a Cron module within thirty bees so you don't have to mess about with your host. I use this one which is free:

http://bit.ly/crontab-for-prestashop

Just install it in the normal way, then copy the url in Preferences > Search and set it up to run every day at midnight, or more often if you wish.

[alwayspaws]

@spidawebs said in Category import csv:

@alwayspaws To add more items to the menu, click the little plus sign near the top right when you are in the module. It's not very obvious. You can then create new menu items for categories or category trees.

I don't see any little plus sign.

Go to Preferences > Search and click add missing products to index. It looks like the index hasn't been updated since you added the products. It's a good idea to setup a cron job for this so you don't have to keep doing it manually.

You were right about that. I forgot to reindex the products. Thanks! I'll check into cron jobs from your other post. Thanks, again!

[alwayspaws]

@spidawebs said in Category import csv:

@alwayspaws Just disable the categories block in modules - that removes it completely.

That worked great! The categories are no longer displaying in the footer.

You'd be better off using a Cron module within thirty bees so you don't have to mess about with your host. I use this one which is free:

http://bit.ly/crontab-for-prestashop

Just install it in the normal way, then copy the url in Preferences > Search and set it up to run every day at midnight, or more often if you wish.

Checking into this now. Thanks!

[spidawebs]

@alwayspaws Look just above and to the right of the word "Position" and you will see a small grey plus sign. It should be made a lot more obvious.

[alwayspaws]

@spidawebs said in Category import csv:

You'd be better off using a Cron module within thirty bees so you don't have to mess about with your host. I use this one which is free:

http://bit.ly/crontab-for-prestashop

Just install it in the normal way, then copy the url in Preferences > Search and set it up to run every day at midnight, or more often if you wish

Something went right! :) Installed the free Cron jobs module but should I pick "Server crontab"?

[alwayspaws]

@spidawebs said in Category import csv:

@alwayspaws Look just above and to the right of the word "Position" and you will see a small grey plus sign. It should be made a lot more obvious.

Now I see it! Thanks. New problem - I have to manually enter every category and subcategory here?

There's nowhere to pick and choose the categories I already uploaded?

[spidawebs]

@alwayspaws No use Shop Traffic

[spidawebs]

@alwayspaws If you select category tree then it will automatically select all the subcategories from your main category

[spidawebs]

I have to say the default top menu in thirty bees isn't great. You might want to find a better one to suit your needs. There are some very good modules out there.

[alwayspaws]

@spidawebs said in Category import csv:

@alwayspaws If you select category tree then it will automatically select all the subcategories from your main category

There's nothing there.

[Havouza]

@spidawebs I agree. I took the old one from PS. Simple but works OK.

[alwayspaws]

@Havouza How many things can you take from the old PS without ending up with all old PS? :)

[Havouza]

As long as the old is better than the new. If you did not take anything from PS the TD would be very skinny....

[alwayspaws]

@Havouza But everybody needs to do the same thing or we will all have different "versions" of thirty bees.

[alwayspaws]

Further up is a screenshot of my categories so they exist somewhere (in the ether or a blackhole) but I can't get them to show up on the home page or any page at the top.

In preferences - top menu items - I clicked the tiny gray plus sign and selected "Category Tree".

What else do I fill in on that page so that my categories will show up, please?