Update Product Identifiers
Manual: Update Product Identifiers via Bulk Action (OMS/WMS)
With this bulk action, you can update multiple product identifications and basic product data at once within afosto.app (OMS/WMS).
Use this when you want to:
-
Add or change barcodes.
-
Correct MPN or brand.
-
Add HS codes or country of origin.
-
Update cost prices.
-
Adjust slugs or categories.
Step 1 Go to the bulk action
Log in to afosto.app. Go to Processes. Open Bulk actions. Choose Update product identifications. You will now see a spreadsheet input screen.
Step 2 Unique name
-
Give your bulk action a unique reference.
-
Click Next to continue.
Step 3 Paste your data into the spreadsheet
You can copy and paste your data directly from Excel or Google Sheets. The following columns can be used (* = required):
| Column | Required | Meaning in Afosto |
|---|---|---|
| SKU* | Yes | The unique product code of the existing product. |
| Label | No | The display name of the product. |
| Barcodes | No | One or more barcodes linked to the SKU. |
| Slug | No | The technical URL identifier of the product. |
| MPN | No | Manufacturer Part Number. |
| Brand | No | The brand of the product. |
| Categories | No | The category structure of the product. |
| Images | No | Image references. |
| Cost Price | No | The cost price (purchase value) of the product. |
| Cost Currency | No | Currency of the cost price (e.g. EUR). |
| HS Code | No | Customs code for international shipping. |
| Country of Origin | No | Country where the product was produced. |
What is required?
SKU (required)*
The unique product code within Afosto.
Important:
-
The SKU must already exist.
-
Spelling must match exactly.
-
All updates are linked based on this SKU.
-
SKU is always leading — not the product name.
Explanation of optional fields
**Label **The commercial name of the product. This is what users see in overviews and order lines.
**Barcodes **Here you add one or more EAN/GTIN codes. Important for:
-
Warehouse scanning
-
External sales channels
-
POS
**Slug **The technical URL identifier of the product. Mostly used in frontend or channel integrations.
**MPN **Manufacturer Part Number. Important for marketplaces and technical products.
**Brand **The product brand. Used in reports, filters, and channel integrations.
**Categories **Assign the product to one or more categories. Used for filtering and structure.
**Images **Reference to product images. Note: requires a correct file or URL structure.
**Cost Price + Cost Currency **The purchase value of the product. Important for:
-
Margin reports
-
Profit calculations
-
Financial analysis
Always use a valid currency (e.g. EUR).
**HS Code **Customs code for international shipping. Used in export documents and shipping integrations.
**Country of Origin **Country where the product originates. Important for customs and international logistics.
Step 4 Check your input
Always verify:
-
Do all SKUs exist?
-
Are brand names and categories consistent?
-
Are cost price and currency correct?
-
Are barcodes unique?
Note: incorrect identifications can impact scanning, sales channels, and reporting.
Step 5 Execute the bulk action
Click Execute.
-
The system validates the rows.
-
Any errors are shown per row.
-
If successful, product data is updated immediately.
Changes take effect instantly in:
-
Product overviews
-
Purchasing
-
Reports
-
Channel integrations
-
Order processing
Practical example
| SKU | Brand | Cost Price | Cost Currency | HS Code | Country of Origin |
|---|---|---|---|---|---|
| SHIRT-BLACK-M | AfostoWear | 12.50 | EUR | 61091000 | China |
After processing:
-
The brand is updated.
-
Cost price is set to €12.50.
-
Correct customs data is linked.
Important notes
-
Only SKU is required.
-
Work in a structured way to prevent data pollution.
-
Always verify cost prices carefully.
-
Changes apply in real time in OMS/WMS.