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.