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):

ColumnRequiredMeaning in Afosto
SKU*YesThe unique product code of the existing product.
LabelNoThe display name of the product.
BarcodesNoOne or more barcodes linked to the SKU.
SlugNoThe technical URL identifier of the product.
MPNNoManufacturer Part Number.
BrandNoThe brand of the product.
CategoriesNoThe category structure of the product.
ImagesNoImage references.
Cost PriceNoThe cost price (purchase value) of the product.
Cost CurrencyNoCurrency of the cost price (e.g. EUR).
HS CodeNoCustoms code for international shipping.
Country of OriginNoCountry 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

SKUBrandCost PriceCost CurrencyHS CodeCountry of Origin
SHIRT-BLACK-MAfostoWear12.50EUR61091000China

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.