How do I add products in bulk?
If you have a large number of products to load into Craftybase and you use a sales channel we do not currently support, you can do this via uploading a spreadsheet.
Importing products is available for PRO accounts and above.
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:
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.
Step 3 Export your spreadsheet to CSV
Once you have your spreadsheet ready, export it as CSV. The process to do this differs between spreadsheet programs, instructions for some popular programs can be found here:
Step 4 Upload your spreadsheet to Craftybase
To upload your spreadsheet:
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.