Does CSV import allow combinations with only two products?

[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?

[Traumflug]

Could you craft one of your nice short CSVs demonstrating the issue? Last time this helped a lot.

[alwayspaws]

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:

[spidawebs]

@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

[alwayspaws]

@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.

[spidawebs]

@alwayspaws I can't see the csv file - something has gone wrong with the upload. Can you try again?

[alwayspaws]

@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

[spidawebs]

@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.

[alwayspaws]

@spidawebs here is a screenshot of part of it:

[alwayspaws]

@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!

[spidawebs]

@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?

[alwayspaws]

It only uploads one price for these two products that have two different sizes. The top screenshots show the problem.

[alwayspaws]

When you select one size, you see the unique ID but the price doesn't change.

[spidawebs]

@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.

[spidawebs]

@alwayspaws OK, so the combinations are uploading correctly, it's just you're not using the impact on price field.

[alwayspaws]

@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!

[alwayspaws]

Is this what you mean? Or do I use the same prices for the combination products for the price column?

[spidawebs]

@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

[alwayspaws]

@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. :)

[alwayspaws]

@spidawebs I can't find a matching field for "impact on price" in the products import in admin.

[spidawebs]

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?

[alwayspaws]

@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

[spidawebs]

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.

[alwayspaws]

@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?

[spidawebs]

You can probably change that under Preferences > SEO & URLs but I can't see it being a problem how it is

[alwayspaws]

@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.