alwayspaws Posted August 14, 2017 Share Posted August 14, 2017 I have products that only have two sizes. When I uploaded the spreadsheet it only took the first product. The combination numbers look like this: 275-1 275-2 Is that allowed? Link to comment Share on other sites More sharing options...
0 Traumflug Posted August 14, 2017 Share Posted August 14, 2017 Could you craft one of your nice short CSVs demonstrating the issue? Last time this helped a lot. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 14, 2017 Author Share Posted August 14, 2017 Yes @Traumflug - I was just doing that. Thank you! I also have screenshots. 01502717049125one-combo-grooming-product-two-sizes.csv Product only shows one price instead of both: Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws In your spreadsheet you have one product not two. A product has to have a unique ID. So by using product ID 500 twice, you are uploading one product with two combinations. As you have two different product names it will upload the first and then overwrite it with the second. So your product name should be: At Home Dog Spa Girl Dogs Shampoo Natural Gentle Girl Dog Grooming You shouldn't put the combination values in the title - let the shopper select them from the dropdown menu which will be created with your combination values. The alternative is to leave it as it is and create two separate products. So the second product would have an ID of 501 and the combination reference would be 501-1 Hope that helps Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs Spidey, you're back! :) I'm attaching my actual spreadsheet. That was a short, but incorrect (sorry) example I created when mine didn't work. [01502792998264grooming-products-test.csv](Uploading 100%) Something has gone wrong with file uploading. Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws I can't see the csv file - something has gone wrong with the upload. Can you try again? Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs Thank you. I attempted the UL again: [01502794419060grooming-products-test.csv](Uploading 100%) There is a forum issue and I just created the topic for it here: https://forum.thirtybees.com/topic/702/uploading-files-to-forum-suddenly-is-not-allowed-unless-image-format Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws In the meantime can you do a screenshot of your open office csv file and I might be able to work out the problem from that. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs here is a screenshot of part of it: Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs said in Does CSV import allow combinations with only two products?: @alwayspaws In the meantime can you do a screenshot of your open office csv file and I might be able to work out the problem from that. I was just creating it! Like minds! Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws :-) That looks correct. It will create four products, two of which will have combinations, two of which won't. What is the problem you are having? Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 It only uploads one price for these two products that have two different sizes. The top screenshots show the problem. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 When you select one size, you see the unique ID but the price doesn't change. Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws I can't see why it wouldn't upload the combinations. They look correct. I might be wrong but maybe it's because you're using commas to separate multiple values in fields like tags. I don't use tags so I'm not 100% sure, but if you have your field separator set to commas and your multiple value separator set to semi colons I would have thought you need to use semi colons to separate each value. Try it and see if it works. To use different prices for different combinations I think you need to create a field called "Impact on price" and for the combination with the higher price enter the price difference. Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws OK, so the combinations are uploading correctly, it's just you're not using the impact on price field. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs said in Does CSV import allow combinations with only two products?: @alwayspaws OK, so the combinations are uploading correctly, it's just you're not using the impact on price field. That's what it has to be. I haven't used an impact on price before. I'll try that now. Thanks! Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 Is this what you mean? Or do I use the same prices for the combination products for the price column? Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 @alwayspaws Yes, that's it, but keep the price the same, so for the first product both prices should be 11.95 then keep the impact on price at 10.00 for the more expensive combination Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs said in Does CSV import allow combinations with only two products?: @alwayspaws Yes, that's it, but keep the price the same, so for the first product both prices should be 11.95 then keep the impact on price at 10.00 for the more expensive combination I have another question about CSV uploads for combinations. Do I have to reindex right after uploading products? Or do I upload the combinations and then reindex? Thank you for your help, as usual. :) Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs I can't find a matching field for "impact on price" in the products import in admin. Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 The impact on price field is in the combinations upload. So do your new product upload, then do you combinations upload and you will see the impact on price field. Not sure what you mean about reindexing. Are you talking about reindexing the search engine? Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 15, 2017 Author Share Posted August 15, 2017 @spidawebs said in Does CSV import allow combinations with only two products?: The impact on price field is in the combinations upload. So do your new product upload, then do you combinations upload and you will see the impact on price field. Not sure what you mean about reindexing. Are you talking about reindexing the search engine? That's good. Thanks. I mean this: INDEXING The "indexed" products have been analyzed by thirty bees and will appear in the results of a front office search. Indexed products 257 / 257. Building the product index may take a few minutes. If your server stops before the process ends, you can resume the indexing by clicking "Add missing products to the index". Add missing products to the index Re-build the entire index Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 15, 2017 Share Posted August 15, 2017 You can add missing products to the search index manually after importing products and their combinations, or just do what I do and setup a CRON job to do it automatically each day. Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 16, 2017 Author Share Posted August 16, 2017 @spidawebs said in Does CSV import allow combinations with only two products?: The impact on price field is in the combinations upload. So do your new product upload, then do you combinations upload and you will see the impact on price field. It worked great! Thank you very much. Now when the customer selects the size, the price changes, as it should. yay! :) Is it normal for this to be in the URL: #/293 https://www.alwayspaws.com/grooming/at-home-dog-spa-boy-dogs-shampoo-natural-gentle-boy-dog-grooming-made-in-the-usa#/293-size-20_ounces is there a better way to write sizes for the URLs? Link to comment Share on other sites More sharing options...
0 spidawebs Posted August 16, 2017 Share Posted August 16, 2017 You can probably change that under Preferences > SEO & URLs but I can't see it being a problem how it is Link to comment Share on other sites More sharing options...
0 alwayspaws Posted August 16, 2017 Author Share Posted August 16, 2017 @spidawebs I'll leave it alone. I have enough to do already. Thanks for helping me get my products up. The grooming one was the little project to start with before putting up 50 pieces of art with two sizes and two different wood frames. Link to comment Share on other sites More sharing options...
Question
alwayspaws
I have products that only have two sizes. When I uploaded the spreadsheet it only took the first product.
The combination numbers look like this: 275-1 275-2
Is that allowed?
Link to comment
Share on other sites
30 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