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 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.
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. |
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?
No. Modifiers are edited in BackOffice. This article covers product list CSV, online price and description CSV, and serial number import paths.
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.