Who Is This For?
StoreHub merchants who need to edit multiple products at once, export their product list, or upload product descriptions and online prices using a CSV file.
Overview
This article covers three ways to manage your products at scale in BackOffice.
Bulk editing lets you apply changes to many products in one go, such as setting categories, adding tags, or making products available online.
Exporting lets you download your full product list as a CSV file.
Uploading via CSV lets you add product descriptions and online prices for your e-commerce, Beep Delivery, or QR Order and Pay channels without editing products one by one.
Before You Begin
Access to BackOffice (log in at your StoreHub BackOffice URL).
Products already added in BackOffice. If not, see this article first.
For CSV operations: a spreadsheet program (Microsoft Excel, Google Sheets, or similar).
For uploading online prices and descriptions: 'Sell Online' must be enabled on your products. The online price and description columns only appear in the CSV template once 'Sell Online' is turned on.
A stable internet connection.
Step-by-Step Guide
Edit Products in Bulk
You can select multiple products and apply a single action to all of them at once.
1. In your BackOffice, go to 'Products'.
2. Search for the products you want to edit. You can filter by 'Name/SKU/Barcode', 'Category', or 'Tag'.
3. Select the products by ticking the checkbox next to each product name.
Notes:
Click 'Visible' to select all products on the current page.
Click 'All' to select all products across all pages.
4. Click 'Group Action' and choose the action you want to perform.
The available actions are:
Action | What it does |
Set Category | Set or replace the category of the selected products |
Set e-Invoice Product Classification Code | Assign or update the classification code for the selected products |
Sell On Channel | Add the selected products to your online channel |
Add Tags | Add tags to the selected products |
Remove Category | Remove the category from the selected products |
Remove From Channel | Remove the selected products from your online channel |
Remove Tags | Remove tags from the selected products |
Delete | Delete the selected products from BackOffice |
Export Products to CSV
You can download your product list as a CSV file for reporting, editing, or backup.
1. In your BackOffice, go to 'Products'.
2. Click 'Export to CSV' in the top right corner above the product table.
3. The export will work in one of two ways depending on the number of products:
2,000 products or fewer: The CSV file will download immediately. Check your downloads folder.
More than 2,000 products: A pop-up will appear informing you that the file will be sent to your email. Check your inbox in a few minutes and click 'Download CSV Export' in the email. The file will download as a ZIP folder.
4. Open the CSV file with a spreadsheet program (e.g., Google Sheets, Microsoft Excel, or Apple Numbers).
Notes:
You can filter products by Name/SKU/Barcode, Categories, or Tags before exporting to export only specific products.
You can edit details in the CSV file and import it back into BackOffice to update your products.
You can use the exported data to create Pivot Tables for further analysis.
Handle Export Errors
If the export process encounters an error, the system will notify you in two ways:
1. A notification will appear in BackOffice.
2. An email notification will be sent with a button to retry the export.
Click the button in the email to try the export again. If the problem continues, contact the Customer Care Team.
Upload Product Descriptions and Online Prices via CSV
If you sell products online (Online Store, Beep Delivery, or QR Order and Pay), you can use the CSV import template to set product descriptions, online prices, and online discounted prices in bulk.
1. In your BackOffice, go to 'Products', then 'Import Products CSV'.
2. Click 'Download Template' to get your current product list.
3. Open the CSV file in a spreadsheet program. You will see columns for:
'Online Price'
'Online Discounted Price'
'Product Description'
Note:
These columns only appear if 'Sell Online' has been enabled for your products.
4. Fill in the online prices, discounted prices, and descriptions for your products. Save the file as CSV.
5. Back in BackOffice, click 'Select file' and choose your updated CSV file.
6. Tick 'Update description' if you want to update the product description field, then click 'Import'.
Note:
The 'Update description' checkbox must be ticked to update the description field. If you only want to update prices, leave it unticked.
Attach Modifier Groups Using the Products CSV
The products CSV template has a 'Modifier Groups' column at the end. Use it to attach Shared Modifier Groups to many products at once.
1. Create your Shared Modifier Groups first, either by hand in BackOffice or by importing them. See How to Set Up Product Modifiers & Variants.
2. In your BackOffice, go to 'Products', then 'Import Products CSV', and download the template.
3. In the 'Modifier Groups' column, type the name of each group you want on that product, spelled as it appears in BackOffice. To attach more than one group, separate the names with a semicolon ( ; ), for example Size;Sugar Level.
4. If the product has variants, put the group name on the parent product's row only, and leave the 'Modifier Groups' cell blank on the variant rows. Every variant picks the group up from the parent.
5. Save the file as CSV, then upload it on the same page.
Important:
Import your Shared Modifier Groups before your products. This column only adds groups to products. so clearing it does not remove a group from the product; removal stays in BackOffice, and leaving it blank leaves already attached groups alone. A variant row that carries a group name is not imported; the error file reads 'Modifier Groups can only be set on the parent product, not on a variant'. A row naming a group that does not exist is rejected in full and that product is skipped, so check your group names before you upload.
Troubleshooting
Issue | Solution |
Export CSV is taking too long | For large product lists (over 2,000 products), the file is sent via email instead of downloading directly. Check your email inbox in 5 to 10 minutes. |
Online Price and Description columns are missing from the CSV template | Make sure 'Sell Online' is enabled on your products. These columns only appear when online selling is turned on. |
CSV import failed | Check that the file is saved in CSV format (not .xlsx). Make sure the product names or SKUs in your file match the products in BackOffice. |
Export email went to spam | Check your Spam or Junk folder for an email from StoreHub. |
Group Action is greyed out | Make sure you have selected at least one product using the checkboxes. |
Export or import error: Price Type cannot be empty | Open the CSV and fill the Price Type column for every row that needs it. Use the same values BackOffice expects for your pricing type (for example, Fixed or Variable as per your template header). Re-upload after saving as CSV. |
Export or import error: Barcode must be unique | Two products cannot share the same barcode. Search BackOffice for the barcode, remove the duplicate from one product, then import again. |
Import error: The value of Track Stock Levels cannot be updated when importing | Turn on or off stock tracking from the product page in BackOffice first. Many bulk templates cannot flip Track Stock Levels from CSV alone. Update the flag per product, then import other fields. |
I removed Ideal Stock or Warning Stock columns from my export and the import failed | Only remove columns if the import template allows it. If the template requires those columns, leave the headers and fill values or export a fresh template before editing. |
My products imported but the modifier groups did not attach | Import your Shared Modifier Groups before your products, because the products file can only attach groups that already exist. If the groups do exist, check the group name in your file against the name in BackOffice. |
My import says 'Modifier Groups can only be set on the parent product, not on a variant' | Modifier groups are set on the parent product, not on each variant. Clear the 'Modifier Groups' cell on the variant rows, keep the group name on the parent product's row, and upload the file again. Every variant of that product gets the group from the parent. |
FAQs
1. Can I add new products using the CSV import?
This guide covers uploading descriptions and online prices for existing products. To learn about importing new products via CSV, refer to the product import guide in BackOffice.
2. Can I export only specific products?
Yes. Use the search and filter options (Name/SKU/Barcode, Category, Tag) to narrow down your product list before clicking 'Export to CSV'. Only the filtered products will be exported.
3. Can I undo a bulk action?
Bulk actions cannot be undone automatically. If you need to reverse a change (e.g., remove a category you just added), use the corresponding reverse action (e.g., 'Remove Category').
4. What is the e-Invoice Product Classification Code action for?
This is used to assign or update the classification code required for e-Invoicing compliance. It applies to merchants in regions where e-Invoicing is mandatory.
5. Can I delete all products at once?
Yes. Click 'All' to select products across all pages, then use the 'Delete' group action. Be careful, as this cannot be undone.
6. Why does my product CSV show warnings about ideal stock or warning stock?
Those fields support low-stock alerts when inventory tracking is on. You can fill them or leave them at zero depending on your process. If you only want to change quantity, use inventory workflows (stock take or purchase orders) as described in the Inventory Management articles.
7. Can I edit modifiers in Excel?
Shared Modifier Groups, yes. On the 'Products' page, click 'Import Modifier Groups CSV'. You can also download the groups you already have: go to 'Products', then 'Modifier Groups', and click 'Export to CSV'. See How to Set Up Product Modifiers & Variants for the steps. Custom Modifier Groups, the Single Choice and Multiple Choice modifiers on one product, are edited in BackOffice.
Need Help?
Contact StoreHub Support via live chat in your StoreHub app or email [email protected].
Was This Article Helpful?
Let us know below or contact support for further assistance.