Bring your products into Craftybase quickly and easily with our import options!
The best option to get your products into place is by connecting with one of our many popular sales channel integrations, however if you are currently using a sales channel we don't currently support you can also consider using our CSV importer to bring your products into Craftybase.
What you'll need
- Any Craftybase plan that allows importing of products
- A CSV file to import (this can be generated from any spreadsheet program)
Importing products into Craftybase
To upload your CSV file ( How do I create a CSV file of my products?):
1. Go to your Products List
2. Hover over the ⋮ icon that appears next to the header. Next, select the Bulk Add Products option that appears in the menu.
3. On the form that appears, click the Choose File button and select your spreadsheet from your file system.
4. Click the Upload File button. This will upload the file to Craftybase, but will not yet import the data - this will be done in the next step.
5. On your Mappings page, you'll need to confirm which Craftybase field is represented by each column in your spreadsheet if you have changed these from the example spreadsheet above. Once you are happy with all fields, click the Yes, Import File button at the bottom of the page.
6. Your import will begin and you'll be taken back to the Imports page. You'll see your import status as Importing. Refresh the page to see the updated status - when complete it will show as Complete. Click the View Results / Undo button to see which products have been imported, along with details about any skipped rows (if any).
7. On the details page, you'll find an option to Undo the import if you aren't happy with the results. Clicking this will remove all products linked to the import and then delete the import record.
How to create a CSV file
A CSV file is a Comma Separated Values file, which can be generated easily from any spreadsheet program.
Step 1 Download Template Spreadsheet
We will need your data in a fairly standard format for our importer to be able to read the information properly, so please download and use our example spreadsheet as a starting point:
Example Product Importing Spreadsheet
Step 2 Add your products to the spreadsheet
Remove the example rows and add in your own products you wish to import - you'll want to ensure that you add each one on a separate line.
Please note that this importer is not for manufacture information, only the attributes of the products themselves.
|SKU||(Optional) Your SKU is your unique code identifier for the product.|
|Name||This is the title that will appear in all list views in Craftybase and will typically be how you search for the product. If an name isn't found for the row, it will be imported as "Untitled".|
|Category||(Optional) The category you wish to place this product under. This is optional - if you don't yet have a category with this name in the system we will create it at the time of import.|
|Base Unit Price||This is the usual price you sell this item for. Additional prices for wholesale and consignment situations can added at a later stage via our Price Points feature.|
|Auto Manufacture||Determines if the product should automatically create a manufacture when an order is associated to it ( More information about the auto manufacture feature)|
|Batch Quantity Type||This is the measurement unit you wish to use for the product to describe a sellable unit. Most of the time, this can be left as item however if you wish to be more descriptive (i.e. "skirt", "necklace", "bar") then this is an available option.|
|Sale Batch Quantity||This is the number of units you send to the customer when a sale is registered. Again, this is usually set to 1, however it can be handy for items like earrings in which 2 items are sent to the customer.|
|Quantity Low Stock Limit||Whenever your in stock reaches this number, your product will automatically be marked as Low Stock. Read more about how Low Stock Limits work in Craftybase.|
|Starting Quantity||This is the quantity available on hand on your account start date. If you don't currently have any stock of this product, you'll want to set this as 0.|
|Starting Unit Cost||The total material cost to create each unit of all product stock you are bringing forward into Craftybase on your account start date. Important: if you are switching inventory valuation methods from indirect expensing to COGS, this will most likely be 0.00 (as you will have fully claimed all material usage before this point).|
Step 3 Export your spreadsheet to CSV
Once you have your spreadsheet ready, you'll need to export it as CSV.
CSV basically stands for "Comma Separated Values", meaning that the export will contain your data in rows, with each column value separated by a comma.
The process to do this differs between spreadsheet programs, instructions for some popular programs are as follows:
Exporting an Excel Spreadsheet to CSV
Exporting a Numbers Spreadsheet to CSV
How to Save as a CSV from Google Sheets
Undo a product import
To remove your product import:
1. Navigate to your Imports page
2. All imports will now be listed. Select the "View Results/ Undo" button to the right of the import you wish to remove
Tip: Depending on how large your CSV file is, this may take a few minutes to complete.