Updating products via CSV
Learn how to update multiple products in bulk using our import feature
The recommended way to update your products is in bulk via the Product Bulk Update feature. This feature allows you to bulk update products from a spreadsheet.
The Bulk Update feature is available only on STUDIO and above subscription plans.
To use the Product Bulk Updater:
Go to your Product List page and apply searches or filters to generate the list you require.
Click the Export button in the top right of the list.
Next, head to your Notification page to download the generated file.
Tip: Make a copy of the file that downloads (so that you have a backup in case you wish to revert) and then edit the other in your spreadsheet program.
- Once your spreadsheet is ready, you'll need to export it as a CSV file. CSV stands for "Comma Separated Values," which means the export will contain your data in rows, with each column value separated by a comma. The process to export as CSV varies depending on your spreadsheet program. Here are instructions for some popular programs:
- Return to your Products List and hover over the ⋮ icon next to the header. Next, select the Bulk Update Products option in the menu.
Product attributes that can be imported by the bulk updater are:
- Code / SKU Name / Title
- Category
- State
- Base Unit Price
- Auto Manufacture?
- Sale Batch Quantity
- Low Stock Limit Quantity
- Starting Quantity
- Starting Material Unit Cost
NOTE: Additional columns will show the current stock quantities for each of your integrated e-commerce platforms. Based on the stores you have connected, our product export file will include additional fields such as:
- shopify_stock_qty
- etsy_stock_qty
These values can be used to help calculate the value to be entered in the "starting_quantity" field.
Fields that cannot be updated:
It isn't possible to update the following attributes via the bulk updater as these are calculated automatically by Craftybase:
- Stock on Hand
- Stock Consigned
- Stock Available
- Stock Shipped
- Manufacture Count
- Sold Count
- Base Sale Cost