Using Templates and Variations. With Libre Calc?

[collecor_50]

Well like many I have spent countless hours attempting to save time using templates and  Variations to list sports cards.  It sure would be nice if Ebay could provide us with a basic template that would work or agents who could answer our questions. Has anyone had success  using Libre spreadsheets saved as a CVS? It seems when I download results I get a getfile message or the following. 

Failure

21916664

Error - Variation Specifics provided does not match with the variation specifics of the variations on the item.|

I know many have  the same problem but it seems impossible to ask a ebay rep for an answer I have spoken to 5 with no success. Any help would be appreciated. 

[shipscript]

The VariationDetails column for your master record does not match the VariationDetails for the individual variation combinations.  There is a mismatch.

Let us assume that the label for your variation drop list is Card#.

Then we will assume your cards are

1. Adam

2. Betty

3. Charles

Your master record's VariationDetails cell should be encoded as:

Card#=1. Adam;2. Betty;3. Charles

Your individual VariationDetails rows would be:

Card#=1. Adam

Card#=2. Betty

Card#=3. Charles

The online VariationBuilder tool will help create both the Master record and the variation rows for the VariationDetails column in your spreadsheet. It can build multi-variations or simple variations.

https://www.isdntek.com/ebaytools/VariationBuilder.htm

Below is a screenshot of the tool that will help build the VariationDetails cells for a simple variation with only a single drop list (as are most trading cards) :

1. At the bottom of the tool is a single-variation concatenator.
2. Put the label of your drop list on the first line (Card#).
3. Copy and paste your entire list of cards into the box with green lines.
4. Click the button to "Make Cell data".
5. Below that button, copy the single row to the master record's VariationDetails cell in your spreadsheet.
6. And then copy the multi-row list of individual VariationDetails to your spreadsheet column (as a multicell "paste" operation). 

Variation Builder - Simple list