Preface

Sometimes you will have more than a few kits, and so manually creating them in GroovePacker wouldn't make sense. In this scenario, it's wiser to have or create a CSV file to then import your kits into the system. This article will demonstrate how.


Kit CSV Format Information

Refer to: This Demo Spreadsheet

(also attached to this article is an example Kit CSV file that you can download. If you like you can remove the kit data and add your own kit data below the headers in this file.)


Notes on the Kit format:

- Notice that each kit SKU gets it's own line and the kit SKU Name and Barcode are repeated, one row for each of the Part SKUs.

- The kits are shown grouped by color here for clarity.



If a kit only has one SKU it will only require one row. The three examples in the above spreadsheet begin with H-
This is how a Case comprised of a multiple of the same SKU would appear. 


The PART-QTY defines the quantity of each kit part item or the case quantity when setting up cases.

The KIT-SKU, PART-SKU, PART-QTY and SCAN-OPTION are required. The KIT-BARCODE is not required while importing but each kit will need a placeholder barcode in order to be active. The easiest way to add this is to duplicate the KIT-SKU column in your CSV file. Rename the duplicate KIT-BARCODE. Later, when you import the file you'll map it to the Kit Barcode field. Other kit and part product data can be added using the regular product importer.

SCAN-OPTION - This is **REQUIRED**
- Scan option 1 is used when the kit is prepackaged and the kit barcode is scanned. 

- Scan option 2 is used when the individual items in the kit are scanned. (used in most cases)

- Scan option 3 is used only in cases where kits are sometimes but not always prepackaged. They will be prompted for scanning as a single kit but if the items within the kit are scanned the rest of the items will be prompted.


NOTE: The KIT-BARCODE is never scanned unless the Scan option 1 is used but as mentioned above every kit needs a barcode, even if it's just a placeholder barcode. So if the part items are always being scanned (as in option 2) you can just copy the KIT-SKU column and paste it to be used as the KIT-BARCODE.



How to Import a Kit File


Once you have created your file and saved it as a CSV (UTF8 format, comma delimited if possible) you can import it into GroovePacker.


Please follow the How to Backup article to create a backup of your current products before importing kits.


When you're ready to import your kit file click on Settings at the top of the GroovePacker site.


You should see the Stores list. The Order, Product and Kit importers are all found in the CSV store. Click it's name in the list to open it. If you do not have a CSV store yet you can click Create store to create one. You'll give it a name (CSV for example) and you'll choose CSV from the Store type dropdown.



Inside the CSV store window scroll to the bottom to find the Kits import options:



Click Choose File and select the kit csv that you created.


If you've imported kits before the last map you used will already be loaded and you can click Import Kits to begin the import.


If this is your first time importing kits, no map will be selected and clicking the Edit Map or the Import Kits button will open the map editor so you can create a map.


To create a map first give it a name, this will allow you to re-use it later to update kits if needed.


Next you'll click the drop down above each column header in the file displayed in the table.


In the dropdown you'll choose the GroovePacker field that the column's data should be imported into. (see image below)


When all of the columns you are importing are mapped click the green Import button to begin the import.