alwayspaws Posted June 5, 2017 Share Posted June 5, 2017 Only the first product in each category is getting imported even though the import confirmation page shows 3515 products validated and imported: Screenshot of only one product in the category and it should have at least 20. Link to comment Share on other sites More sharing options...
0 jnsgioia Posted June 6, 2017 Share Posted June 6, 2017 @alwayspaws Don't you have to import the products using the product import file and then import the combinations? I don't import combinations so don't know, but looking at the sample combination csv file it looks like the product has to already be in the database. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 6, 2017 Author Share Posted June 6, 2017 Yes and I did. It worked before. I don't know what went wrong. Link to comment Share on other sites More sharing options...
0 jnsgioia Posted June 6, 2017 Share Posted June 6, 2017 @alwayspaws Can you see the products in the back office? Link to comment Share on other sites More sharing options...
0 spidawebs Posted June 6, 2017 Share Posted June 6, 2017 Can you share a few lines of your csv file so I can see what is wrong? Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 @jnsgioia - Yesterday I did. Today I deleted all products and combinations & reimported the updated csv's because there were several updates to fix - images, meta tag one character too long, etc. I reindexed, cleared cache, cleared browser cache and restarted the browser. Today products are not associated to any category after importing products and combinations. Now, admin only shows five products and none are associated with any category. Maybe because I don't have a home category showing in admin? @spidawebs Here are a few lines that include single and combination products. 014968392494476-6-17-products-few-lines.csv I think I reimported wrong so will try again but I also need to learn how to do things right, so if there's something wrong with my csv, please let me know. Thanks for the replies! Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 Ok, thanks very much Michael. I hope it will help thirty bees. Link to comment Share on other sites More sharing options...
0 spidawebs Posted June 7, 2017 Share Posted June 7, 2017 @alwayspaws I think the category names need to be in every row. So for product ID 19 for example, put Dog Dresses;Dog Birthdays in every row not just the last one. That's what I do on mine and it works fine. Link to comment Share on other sites More sharing options...
0 spidawebs Posted June 7, 2017 Share Posted June 7, 2017 Why is your store's code different? Have you had some custom changes made? Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 @spidawebs said in Combinations csv only imports first product in each category: @alwayspaws I think the category names need to be in every row. So for product ID 19 for example, put Dog Dresses;Dog Birthdays in every row not just the last one. That's what I do on mine and it works fine. That sounds great! I don't know why it worked until this a.m. without that. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 Wow! I will contact my host and tell them to allow you or whatever. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 Ok, I will try that. Thanks, Michael Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 @mdekker said in Combinations csv only imports first product in each category: Yeah a few changes to the way products and categories were imported, there were bugs. Oh. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 Imported a 75k file for five products. Four singles and one combination. Only one of the four singles showed up on the site. Created new product import csv for just those four products and imported. All four single products show up in the BO but only one still shows up on the site. Back office - dog treats - first four products: Site - only one product is showing up: 014968463593516-7-17-products-only-4-single-products.csv Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 Because one of the products is a combination. OpenSource Calc - ods files are much smaller. Converted to csv it's triple the size. Link to comment Share on other sites More sharing options...
0 jnsgioia Posted June 7, 2017 Share Posted June 7, 2017 @alwayspaws After the import did you go to Preferences - Search and make sure that they are indexed. You may need to click Add missing products to the index for them to show in the front office. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 Yes, re-indexed and cleared cache but thank you. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 I'm testing a product csv that only has four products. Three are not being associated with any category. They should at least be in the dog treats category. One of four products got associated with the correct category. Do I have to create a "home" category in admin? Or what? The screenshot shows there is no default category to select. I can manually select the dog treats category but I need to do this with csv. The categories field shows you can assign multiple categories, so I tried three separated by a comma and no space. Didn't work. Next I tried separating the 3 categories with a space. Didn't work. Next, I tried with only one category and three of my single products are still not correctly associated with any category. One product shows in admin dog treats category and 3 show in admin home category: Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 7, 2017 Author Share Posted June 7, 2017 I want my products to be associated with each category I add on the csv, which it did for this product on a previous csv. Link to comment Share on other sites More sharing options...
0 jnsgioia Posted June 8, 2017 Share Posted June 8, 2017 @mdekker @alwayspaws Out of curiousity I checked my catalogs and found that catalogs that have been added to since the fix to the classes/product.php only showed one item. I replaced the file with the old one, did a complete upload of the inventory and now it is as it should be, so it must be a problem with the "fix". Link to comment Share on other sites More sharing options...
0 jnsgioia Posted June 8, 2017 Share Posted June 8, 2017 @mdekker https://github.com/thirtybees/thirtybees/compare/99b9484de714a90f801bb363f8cc45ec446f7cf7…f0da5266e8d64d363ac3f9c9afc845f9004bdb9a It wasn't just the import that was the problem. If I added a product to a category in the back office it deleted all other products from that category. After I replaced the classes/product.php with the old one it now adds the product but doesn't delete the other products in that category. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 8, 2017 Author Share Posted June 8, 2017 @jnsgioia thank you so much for this thorough investigation. It was so nice of you to take so much time to do this. Michael, in my case what do I do to fix this since I apparently have some different coding. Thanks very much to both of you! Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 9, 2017 Author Share Posted June 9, 2017 My unsuccessful results are posted in this forum: https://forum.thirtybees.com/topic/363/csv-import-categories-bug/22 Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 9, 2017 Author Share Posted June 9, 2017 @jnsgioia said in Combinations csv only imports first product in each category: @mdekker https://github.com/thirtybees/thirtybees/compare/99b9484de714a90f801bb363f8cc45ec446f7cf7…f0da5266e8d64d363ac3f9c9afc845f9004bdb9a It wasn't just the import that was the problem. If I added a product to a category in the back office it deleted all other products from that category. After I replaced the classes/product.php with the old one it now adds the product but doesn't delete the other products in that category. What is the date of the classes/product.php you used, please? I'm getting confused between this forum discussion and the one in the bug reports: https://forum.thirtybees.com/topic/363/csv-import-categories-bug/22 Link to comment Share on other sites More sharing options...
0 jnsgioia Posted June 10, 2017 Share Posted June 10, 2017 @alwayspaws I used the the one included in the 1.01 folder released April 26th. The current one on github is the one with the problem (unless @mdekker has it fixed by now.) Link to comment Share on other sites More sharing options...
0 alwayspaws Posted June 10, 2017 Author Share Posted June 10, 2017 I'll replace the file again. Thanks. Link to comment Share on other sites More sharing options...
Question
alwayspaws
Only the first product in each category is getting imported even though the import confirmation page shows 3515 products validated and imported:
Screenshot of only one product in the category and it should have at least 20.
Link to comment
Share on other sites
Top Posters For This Question
38
9
3
3
Popular Days
Jun 12
16
Jun 7
14
Jun 10
6
Jun 6
4
Top Posters For This Question
alwayspaws 38 posts
jnsgioia 9 posts
spidawebs 3 posts
Havouza 3 posts
Popular Days
Jun 12 2017
16 posts
Jun 7 2017
14 posts
Jun 10 2017
6 posts
Jun 6 2017
4 posts
53 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now