Import / Export

Use Import / Export to load or download warehouse data with spreadsheet files (XLS / XLSX).

Section: Top menu Warehouse > Import/Export, or go to Import/Export.

The page has two tabs: Export and Import.

Export

Export builds an Excel file with multiple sheets (for example Products, Stock entries, Locations, Suppliers, Customers, and related order/transfer data).

1. Open the Export tab.
2. Optionally set a date range for transactional sheets.
3. Start the export. The job runs in the background (Pending → Processing → Completed or Failed).
4. When finished, download the file. Large exports may also send a download link by email.

Only one export (or import) job can run at a time per point of sale.

Import

1. Open the Import tab.
2. Download the template for Products, Locations, or Customers.
3. Fill the spreadsheet (first sheet only; up to 10,000 rows). On the web app the upload size limit is 2 MB.
4. Upload the file, review the preview, then confirm.

Products template

Typical columns include: ID, Code, Name, Barcode, Description, Quantity, prices and tax, Reorder Threshold, Categories, Default Supplier, Default Location, Custom Fields, Photo URL.

When the Lot numbers and/or Expiry dates modules are enabled, optional columns Lot number and Best before date are added at the end. Use one row per stock receipt line; the same product can appear on multiple rows with different lots or dates. Use the date format yyyy-MM-dd (for example 2026-12-31).

How products are matched

On import, WAMA tries to match each row to an existing product in this order: ID, then Barcode, then Code. Matched rows update the product; unmatched rows create a new product.

Locations and customers

• Locations are matched by ID or Code.
• Customers are matched by ID or Email.

See also Lot numbers for more detail on lot and expiry columns.