If you have a large volume of inventory items, but don't have the time to enter them into your system one-by-one, you can instead import a .csv file directly into your Checkfront account. This is a spreadsheet similar to those you may have used for accounting purposes in the past, or maybe still do. You can create a .csv file using Microsoft Excel on a PC, or Numbers if you are on a Mac. There are other programs you can use to create these files too, but these are the main ones you are probably already using.
Preparing Your Spreadsheet For ImportBack to top
Preparing your data for import is easy. You don't need to worry about your information importing into the wrong database fields, as there is a built-in mapping feature which we'll look at in a moment. Create a column in your spreadsheet for each field of data that needs to be entered in the Checkfront database. These columns will be labeled Name, SKU, Price... and things like that. You can label the columns however you wish, just make sure it's clear to you what each column of data contains, as you'll need to know this during the mapping process. The spreadsheet should also include columns for any custom parameters you have created. Here's an example of what your final spreadsheet might look like when ready for import.