How to create your own Export CSV Template (Shopify and others)

Modified on Fri, 20 Dec at 4:49 PM

(Some more details on the Export feature HERE)


Now that Kronozio has a new template mechanism for exporting CSV files, you can load most of your Kronocard inventory onto any website that supports CSV imports. On this page, we will explain how to adjust a CSV file from any marketplace or website to match Kronozio's data. This ensures the data is consistently well-formatted and ready for import without requiring further manipulation in Excel.


By default, we provide two templates: a standard Kronozio template that exports all card attributes, just as it did before without templates, and a second template called "eBay My Collection." This allows you to load some of your inventory onto eBay without listing the cards for sale. It’s not a draft, active, or archived listing—it's specifically for "My Collection."


However, even if you're not interested in listing on "My Collection," we will show you how to create your own template for any site.




When a template is created, save it in the folder:   C:\ProgramData\Kronozio\Metacard\Templates




The filename is the name that will appear in the Kronocard template selector (without the .csv extension).




Create your own template


Template creation is quite straightforward. Based on the site's CSV import example file, you keep only the column headers and, under each column, add the corresponding data from Kronocard, as shown below.



Let’s take a look at the eBay My Collection template. This is the preconfigured Kronozio template, ready for use.

Ok it's too small... ?


For the sake of this example, I will present the columns and their corresponding information vertically instead of horizontally, as they would typically appear.



From the eBay example they provided (similar to any other website), we get the column header names:

Title, Sport, Purchase Price, etc. (left column). These come from eBay.


On the right, we map the corresponding Kronocard attributes, which will be replaced by the card information when exported.


As you can see, in the Title field, you can combine multiple attributes into the same field.

Below is the list of Kronozio UPPERCASE attributes that you can add to a template.                                      

Kronocard AttributesMeaningNote
LOCATIONThe inventory location (Kronocard sku)
CATEGORYThe sport (Baseball, Football, Pokemon, etc)
QUALITY:A=A,B=B,C=CThe quality of the cardAs you know, Kronocard use quality ABCD. Here you can match the quality to other terms as you need.
Ex: A=Mint,B=Excellent,C=Good,D=Poor
YEARThe year
PRODUCTThe Product
SETSet
TEAMTeam
CARDNUMBERCard number
DESCRIPTIONPlayer name / Description
SALESTATUSStatus like EBF, NOT, RDY, DOC
SALEPRICEThe sale price
AUCTIONThe auction price
VALUEThe value of the card
ROOKIERookie or not
AUTHOGRAPHAutograph or not
MEMORABILIAMemorabilia information
SERIALNUMBERThe serial number
SPECIALThe Special field
GRADEThe grade value
GRADERThe grader company
GRADED_YNWill put Yes or No if the card is graded or not
SUBTITLEThe subtitle
CSKUYour custom sku if you are using that option
SOLDPRICEThe sold price if sold
RECTO_FILENAMEThe path to the image frontYou need to upload the image yourselve online in most case.
VERSO_FILENAMEThe path to the image backYou need to upload the image yourselve online in most case.




As you can see in the official eBay My Collection CSV example they provided, we simply added the matching Kronocard attribute on the second line and deleted everything after that line.


Now, when the cards are exported using this new template, all the information will be well-structured, saving you a lot of time by eliminating the need to manipulate data repeatedly.













Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article