Skip to content
Afosto
NL

Add lookup products

Manual: Add Lookup Products via Bulk Action (OMS/WMS)

With this bulk action, you can add multiple lookup products at once within afosto.app (OMS/WMS).

Lookup products are simple products mainly used for:

  • Quick order entry

  • Manual order lines

  • POS or counter sales

  • Administrative or service items

  • Non-stock-managed products

Lookup products are lightweight and usually not linked to warehouse stock.

What does this bulk action do?

You create multiple lookup products at once based on a list of SKUs and optional product information.

After processing:

  • The lookup products are immediately available in orders.

  • You can select them in manual order lines.

  • They are visible in the product overview.

Step 1 Go to the bulk action

Log in to afosto.app. Go to Processes. Open Bulk actions. Choose Add lookup products. 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):

[object Object]

What is required?

SKU (required)*

This is the unique product code of the new lookup product.

Important:

  • The SKU must not already exist.

  • The SKU must be unique within the system.

  • SKU is leading — not the product name.

  • Without a valid and unique SKU, the row will be rejected.

Explanation of optional fields

**Label **The name of the product, visible in order lines and overviews. If you do not provide a label, the SKU is usually used as identification.

**Barcodes **Allows the lookup product to be scannable.

Use this when:

  • The product is scanned at the counter.

  • You use scanners or POS.

**Image **An image of the product.

This is mainly relevant for:

  • POS

  • Clear order entry

  • Visual recognition

Make sure the image is correctly available according to the configured structure.

Step 4 Check your input

Always verify:

  • Are all SKUs unique?

  • Do these SKUs not already exist?

  • Are barcodes not duplicated?

  • Are labels correct?

Step 5 Execute the bulk action

Click Execute.

  • The system validates the rows.

  • Any errors are shown per row.

  • If successful, the lookup products become active immediately.

The products are now available in:

  • Order entry

  • Manual sales

  • POS (if connected)

Practical example

[object Object]

After processing:

  • SERVICE-INSTALL can be added as an order line.

  • BAG-COTTON can be scanned via barcode.

Important notes

  • Only SKU is required.

  • SKU must be unique.

  • Lookup products are usually not stock-managed.

  • Changes apply immediately in real time.