Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.mathership.com/llms.txt

Use this file to discover all available pages before exploring further.

​
Bulk Product Upload

Upload multiple products at once by importing a CSV file with your product data.

​
When to Use Bulk Upload

Use bulk upload when you need to:
  • Add many new products at once
  • Import products from another system
  • Update multiple products simultaneously

​
Preparing Your CSV File

​
CSV File Requirements

Your CSV file must be:
  • Format: CSV (Comma-Separated Values)
  • Delimiter: Comma (,), semicolon (;), or tab
  • Structure: First row contains column headers, subsequent rows contain product data

​
Required Columns

Your CSV must include these columns (though they can have any name - you’ll map them later):
  • Product Number: SKU/Article number (required in most cases)
  • Product Name: Name of the product (required)
  • Package Unit: Packaging unit like kg, piece, box (required)

​
Optional Columns

You can also include:
  • Product Description: Description of the product
  • Stock: Stock quantity

​
Example CSV

product_number,product_name,product_description,packaging,stock
PROD-001,Organic Tomatoes,Fresh organic roma tomatoes,kg,100
PROD-002,Whole Milk,Full fat organic milk,L,200
PROD-003,Brown Bread,Whole grain artisan bread,piece,50

​
Uploading Products

​
Step 1: Open Bulk Upload

  1. Navigate to Products
  2. Click Bulk Upload button
  3. The bulk upload modal opens

​
Step 2: Select CSV File

  1. Click Choose File or the file input field
  2. Select your CSV file from your computer
  3. The system will automatically:
    • Detect the delimiter (comma, semicolon, or tab)
    • Parse the CSV content
    • Display a preview of your data

​
Step 3: Preview and Map Columns

After uploading, you’ll see:
  • A preview table showing the first 5-6 rows of your CSV
  • A row of dropdowns below the header row for column mapping
For each column in your CSV:
  1. Click the dropdown under that column
  2. Select which field it corresponds to:
    • Product Number
    • Product Name
    • Product Description
    • Package Unit
    • Stock
  3. Or select “None” if you don’t want to import that column

​
Step 4: Validation

The system validates your mapping:
  • Green message: “Ready to upload” - All required fields are mapped
  • Red message: “Must select all options” - Some required fields are missing
You must map at least:
  • Product Name
  • Package Unit
  • Product Number (in most cases)

​
Step 5: Upload

  1. Once validation passes (green message appears)
  2. Click the Upload button
  3. The system processes your CSV and imports the products
  4. You’ll see a loading indicator while the upload is in progress
  5. Once complete, the modal closes and your products are added

​
After Upload

Once the upload completes:
  • New products appear in your product list
  • Products are added with the information from your CSV
  • You can edit any product individually if needed

​
Common Issues

​
File Format Errors

Issue: “File must be CSV” Solution: Ensure you’re uploading a .csv file, not an Excel file (.xlsx). If using Excel, use “Save As” and select CSV format.

​
Empty or Invalid File

Issue: “File empty or invalid” Solution: Ensure your CSV file has content and is properly formatted with at least a header row and one data row.

​
No Valid Delimiter

Issue: “No valid delimiter” Solution: Ensure your CSV uses commas, semicolons, or tabs as separators between columns.

​
Missing Required Fields

Issue: Upload button is disabled with red message Solution: Map all required columns using the dropdowns - Product Name, Package Unit, and Product Number (in most cases).

​
Tips for Successful Uploads

  • Test with a small file first (5-10 products) to verify the format works
  • Use a spreadsheet program like Excel or Google Sheets to create your CSV
  • Keep column names clear in the header row for easy mapping
  • Ensure consistent formatting across all rows
  • Don’t use commas within field values if using comma as delimiter (or enclose values in quotes)
  • Check for special characters that might cause parsing issues
  • Verify product numbers are unique to avoid duplicate issues

​
Delimiters

The system automatically detects which delimiter your CSV uses:
  • Comma (,): Most common, default for many systems
  • Semicolon (;): Common in European locales
  • Tab: Used by some systems
You don’t need to specify which one - the system will detect it automatically.