Bobblehead Posted October 13, 2020 Posted October 13, 2020 I was able to import around 983 products into my product page using the CSV import method; I was migrating from an existing site to a new one using the 7.1 platform, so exporting then importing was my best bet. I was able to apply multiple tags to all my products, and it worked great. My issue now is that I'd like to add the "Related Products" function to the product display pages, but I noticed that it will only (automatically) display products from the same category. (I like this solution because it won't require much input on my part.) I currently don't have categories assigned to any of the products, so I figured I'd export the inventory, edit the CSV to add a category to the products, using category names that have already been created. But after the import, nothing is updated and the error message reads, "Categories not assigned - Try assigning these categories manually". It lists the items as "Updated", but since the only change was the addition of a category, and that failed, nothing was really updated. Am I doing something wrong here? Like I said, the categories are already named on the back end; no products actually have a category, but I know they're there because they show up in the list of options when I go to select a category in the product edit window. Anyone have any tips on getting this to work?
Bobblehead Posted October 15, 2020 Author Posted October 15, 2020 Does anybody have any insight to why I can't assign categories to my products via the CSV import process? I have almost 1,000 products to assign categories to, and doing it manually is going to cost me a lot of time, and my client a lot of money if that's what I end up having to do. I know this import method has its limitations, but category assignation is specifically mentioned in the documentation as being one of the features.
creedon Posted October 15, 2020 Posted October 15, 2020 I just tested importing categories on both v7.0 and v7.1. With 7.0 I had no problem importing new categories and tags. Even multiple categories. With 7.1 tags came in no problem. Categories did not come in automatically. I had to first define each category once in Store Settings > Categories. Then importing any number of categories for an item works. Here is another potential gotcha. If you define a category like "abcd" and then you realize you made a mistake and go back in and make it "abc" but don't update the URL Slug you will get errors on import. The URL Slug is the key not the Name. Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.
Bobblehead Posted October 16, 2020 Author Posted October 16, 2020 Thanks for that; your experience mirrors mine somewhat. I can confirm that the categories I want to use for import do exist on the site, despite no item actually possessing a category: So seeing them here makes me think the import method will work, but it does not: Do I need to have at least one product actually have a category assigned to it for this to work? In other words, the categories exist on the back end, but perhaps since none of them are actually in use, the import method can't function properly. I'll have to run some more tests to find out, but if you could let me know whether or not you had product with category or categories defined only I'd appreciate it...
creedon Posted October 16, 2020 Posted October 16, 2020 8 minutes ago, Bobblehead said: Do I need to have at least one product actually have a category assigned to it for this to work? Not in my experience. I defined the category only in Store Settings > Categories. Then added those categories to the import file and then imported with no issues. I notice you have some categories with + in them. For example "Clothing + Jewelry". The URL Slug for that is "/clothing-jewelry". So is your category defined in your import file as "clothing-jewelry"? Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.
Bobblehead Posted October 16, 2020 Author Posted October 16, 2020 Quote I notice you have some categories with + in them. For example "Clothing + Jewelry". The URL Slug for that is "/clothing-jewelry". So is your category defined in your import file as "clothing-jewelry"? I'm spelling and using the same case the same way the categories are named on the back end. So "Home Decor", not "home-decor". There is no URL for categories, since all my products are on a single product page with its own URL. Do I have to account for how Squarespace converts characters like spaces and pluses? That doesn't make sense, since like I said those categories are effectively "tags" and not URLs...
Bobblehead Posted October 16, 2020 Author Posted October 16, 2020 (edited) Also, forgive my ignorance - where are "Store Settings?" I've looked through the entire menu and I can't find anything listed as such. ETA: Never mind, I found it. Edited October 16, 2020 by Bobblehead
Bobblehead Posted October 16, 2020 Author Posted October 16, 2020 (edited) Okay, so the issue is that categories must be assigned, as you suggested, by using the existing URL slug for that category. This is completely different than the process for adding tags in the spreadsheet, as plain text is used there. I feel like this is user unfriendly, and needlessly confusing. In any case, for clarity: Tags can be added in the CSV using plain text, with multiple tags requiring commas and a space between them. Categories can be added in the CSV, but entries must match the corresponding URL slug that must exist on the site prior to import. Each category's URL slug is available by going into your product page, clicking on a category, then clicking the gear icon to view settings. Multiple categories can be added using commas and a space between them, and using the slash (/) is not required. I feel like this should be made more clear in the documentation. Thanks again for your assistance. Edited October 16, 2020 by Bobblehead creedon and Jackie123 2
creedon Posted October 16, 2020 Posted October 16, 2020 (edited) On 10/16/2020 at 9:26 AM, Bobblehead said: This is completely different than the process for adding tags in the spreadsheet, as plain text is used there. I feel like this is user unfriendly, and needlessly confusing. Quote I feel like this should be made more clear in the documentation. I agree. Nice summary of the situation! Edited May 8 by creedon Bobblehead 1 Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.
Jackie123 Posted December 16, 2022 Posted December 16, 2022 On 10/16/2020 at 12:26 PM, Bobblehead said: Okay, so the issue is that categories must be assigned, as you suggested, by using the existing URL slug for that category. This is completely different than the process for adding tags in the spreadsheet, as plain text is used there. I feel like this is user unfriendly, and needlessly confusing. In any case, for clarity: Tags can be added in the CSV using plain text, with multiple tags requiring commas and a space between them. Categories can be added in the CSV, but entries must match the corresponding URL slug that must exist on the site prior to import. Each category's URL slug is available by going into your product page, clicking on a category, then clicking the gear icon to view settings. Multiple categories can be added using commas and a space between them, and using the slash (/) is not required. I feel like this should be made more clear in the documentation. Thanks again for your assistance. Thank you for writing the solution so completely! Just saved me.
mrjoelcarter Posted May 8 Posted May 8 Would anyone be open to still helping with this issue? I first created my product categories (Shop page > Gear > Categories) I copy/paste to match exactly But when I import, I still get "Categories not assigned" I've tested 7 different approaches to see if anything changes, and nothing happens. Thankful for any ideas, cheers!
creedon Posted May 8 Posted May 8 56 minutes ago, mrjoelcarter said: Would anyone be open to still helping with this issue? You need to use the the URL SLUG from the category. An example. Let us know how it goes. Find my contributions useful? Please like, upvote, mark my answer as the best ( solution ), and see my profile. Thanks for your support! I am a Squarespace ( and other technological things ) consultant open for new projects.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment