Products & Inventory
Bulk CSV Product Import & Export
Learn how to import large product catalogs from CSV spreadsheets and export inventory records with verified column schemas and validation rules.
Supported CSV Schema & Column Headers
BusinessPlus uses a standardized 8-column CSV format for importing and exporting products:
CSV Column Validation Rules
When preparing your import spreadsheet:
- name (Required): Text string up to 100 characters. Rows with empty names are flagged as invalid.
- price (Required): Numeric price value (e.g. 12500 or 12500.50). Currency symbols and commas are automatically stripped.
- category (Optional): Text category name. Defaults to "general" if omitted.
- sku (Optional): Alphanumeric stock keeping unit code.
- discount_percent (Optional): Numeric discount percentage (0 to 100). Defaults to 0 if omitted.
- image_url (Optional): Public HTTPS URL pointing to the product photo.
- is_available (Optional): "true" or "false". Defaults to "true" if omitted.
Step-by-Step CSV Import Workflow
To import products into your business site:
- Open Import Modal: Navigate to Dashboard -> Inventory and click "Import CSV".
- Select Destination Site & File: Choose the destination site and select your `.csv` file. The client-side parser validates headers and rows.
- Review Validation Results: Inspect the preview table showing valid rows and any errors (e.g. missing name or invalid price).
- Execute Ingestion: Click "Import Valid Rows". Records are inserted in batches of 50 items and an administrative audit log (`PRODUCTS_CSV_IMPORTED`) is generated.
Exporting Product Catalogs
Click "Export CSV" on the Inventory page to download a clean `.csv` file containing all active products formatted with proper cell escaping for instant backup or editing.