This article covers editing multiple products in a bulk operation.
There are two ways to bulk edit and modify products and variations in Qoblex. The bulk editor offers you a spreadsheet-like user interface that allows you to edit multiple products and their variants at once. Another way to edit products in bulk is by using a CSV file which we will cover below.
Spreadsheet-like editor
To access the spreadsheet-like editor:
From your Qoblex account, click on Inventory
Select the products you would like to edit
Under Bulk Actions, click on Edit products
The bulk edit action will load all selected products in memory and edit them all at once. This operation can be slow depending on the number of products selected at once.
The Bulk editor page displays the products that you selected and some of their editable properties such as the SKU or barcode in a table. The table will not display all properties at first.
You can select the columns you would like to edit by toggling their visibility on or off via the column visible (eye icon) toggle button available on the upper right-hand side corner of the bulk edit table.
Edit products via CSV
Another effective way of amending one or more of your products and variations properties at once is by using the Bulk edit by CSV feature.
To access the spreadsheet-like editor:
From your Qoblex account, click on Inventory
Under Bulk Actions, click on Edit by CSV
Editing your products using a CSV file is done in 3 steps:
1. Export products information
On the bulk edit by CSV window, click Download Template to download our template in a CSV file.
Depending on your products and variations count, it might take up to one minute for the CSV data to download to your computer.
2. Edit the downloaded file
Open the downloaded CSV file in your favorite CSV file editor (Microsoft Excel, Numbers, Google Sheets…). We highly recommend you use Google Sheets for this operation.
Remove all the columns you do not want to edit. The ID column must not be deleted as the system requires it to identify your products when the file is uploaded back.
Change the CSV file and save it back to your computer.
3. Upload the downloaded file back
Now that you made all the required changes to the CSV file, you need to upload it back by clicking on “Upload your file” as highlighted below:
The ID column is the mandatory field and must not be deleted as the system requires it to identify your products when the file is uploaded back.
The Edit Products template file has the following structure:
ID
The unique identifier or reference number assigned to the product.
Product Name
The name or title given to the product.
Variant Name
If the product has different variations (such as different sizes or colors), the variant name specifies a particular version or option of the product.
Product Description
A detailed description that provides information about the product, including its features, specifications, and any other relevant details.
SKU
Stock Keeping Unit, a unique code or number used to identify and track inventory for the product.
Supplier SKU
The SKU code or number assigned by the supplier to identify the product.
Weight
The weight of the product.
Weight Unit
The unit of measurement used to express the weight. In this case, kilogram is the default weight unit.
Cost
The cost of manufacturing the product.
Purchase Price
The price at which the product was purchased from the supplier or manufacturer.
Wholesale Price
The price at which the product is sold to wholesale buyers or retailers.
Wholesale Compare Price
An optional field that can be used to compare the wholesale price with a suggested price.
Retail Price
The price at which the product is sold directly to consumers.
Retail Compare Price
An optional field that can be used to compare the retail price with a suggested price.
Tags
Keywords or labels associated with the product to help categorize and organize it.
Brand
The brand or manufacturer of the product.
Product Type
The category or type of the product (e.g., electronics, clothing, furniture).
Supplier
The company from whom the product is sourced or purchased.
URL Handle
The part of the product’s URL or web address that uniquely identifies it.
Is Archived
This is to mark whether the product is archived or no longer active.
Tax Name
The name of the tax or tax rate applicable to the product.
Barcode
The barcode or unique identifier used for scanning the product.
Quantity to Order
The desired or recommended quantity of the product to be ordered from the supplier.
Is Bundle
This is to specify if the product is a bundle or a package containing multiple items.
Allow Over Selling
A setting that determines whether selling more products than the available inventory is permitted.
Unit of Measure
The unit used to measure or quantify the product (e.g., each, a box of 6, a dozen)
Track Inventory
This is to specify whether inventory for the product should be tracked and updated.
Harmonized System Code
A code used for international classification and identification of products for customs and trade purposes.
Country of Origin
The country in which the product was manufactured or produced.
It is important to delete the fields or columns you don’t need to edit.
