Last verified: 2026-02-18
Overview
When you need to add dozens or hundreds of products, bulk importing is faster than manual entry. Upload a spreadsheet or paste data directly, and StockApp maps your columns to product fields automatically using AI.
Who this is for: Vendors who want to add multiple products from existing spreadsheets or data exports.
What happens in the system
Your spreadsheet data is parsed and displayed in a preview grid
AI detects which columns contain product names, SKUs, prices, etc.
You confirm or adjust the column mappings before importing
Products are created in your selected product list
If AI enrichment is enabled, products are enhanced with additional details in the background
What does NOT happen
No duplicate SKUs - If a SKU already exists in your catalog, that row is skipped
No automatic publishing - Products are created as unpublished and may need review before going live
No data validation beyond format - StockApp accepts your data as-is (empty fields stay empty)
No undo - Once imported, products must be deleted individually if you made a mistake
Prerequisites
An active StockApp account with vendor permissions
A spreadsheet file (.csv, .xls, or .xlsx) with your product data, or data you can copy-paste
Column headers in the first row
Preparing Your Spreadsheet
Supported Formats
CSV files (.csv)
Excel files (.xls, .xlsx)
Copy and paste from any spreadsheet application
Recommended Columns
Essential | Recommended | Optional |
Product Name | SKU, Description | MPN, UPC, GTIN, ASIN |
Price | Cost, Brand | MOQ, MXQ, Weight |
Quantity / Stock | Lead Time | Dimensions, Category |
Data Requirements
Column headers in the first row
At least one column with product names
Numeric values for prices (no currency symbols)
Unique SKUs
No empty rows between products
Step-by-Step Instructions
Step 1: Open the Import Wizard
Click the Home icon in the left sidebar to go to Products
Click the dropdown arrow next to the Add product button (a separate small arrow button on the right side of the button)
Click From your spreadsheet
The Map Columns wizard opens showing an empty spreadsheet grid.
Step 2: Upload or Paste Your Data (Step 1/3)
Option A: Upload a File
Click the Upload file button in the top-right corner of the wizard
Select your CSV or Excel file
Data appears in the grid
Option B: Copy and Paste
In your spreadsheet app, select all data including headers
Copy (Ctrl+C / Cmd+C)
Click into cell A1 in the StockApp grid
Paste (Ctrl+V / Cmd+V)
If your Excel file has multiple sheets, tabs appear at the bottom to switch between them.
The footer shows the total number of rows in the spreadsheet (including the header row).
Click Choose columns to import to continue.
Step 3: Confirm Column Mappings (Step 2/3)
StockApp uses AI to auto-detect column mappings based on your headers and data.
Each column shows a dropdown label with the detected mapping:
Product Title (required)
SKU, Description, Brand, Manufacturer
Price, Cost, Currency, Quantity / Stock
MOQ, MXQ, Lead Time (days)
UPC/Barcode, MPN, GTIN, ASIN
Weight, Dimensions, Category
Ignore (skip this column)
Row 1 (headers) is dimmed and will be skipped during import.
Click any column label to change the mapping if the AI detected incorrectly.
The footer shows how many columns are being mapped.
Click Review import to continue.
Step 4: Review and Import Products (Step 3/3)
The final step shows all products that will be created.
Choose a product list:
At the top, click the Add to: dropdown
Select which product list to add products to
Select products to import:
All products are checked by default
Uncheck individual products to exclude them
Click the header checkbox to select/deselect all
The footer shows how many products are selected
Enable AI enrichment (optional):
Check Enrich product information with AI in the footer to auto-fill categories, specs, and descriptions
This is checked by default and uses credits (the count shows next to the button)
This runs in the background after products are created
Click Add [N] products to start the import. When complete, you return to your products page.
What changes over time
After import with AI enrichment:
Products may show "Needs review" status
AI adds categories, descriptions, and specs over the next few minutes
Refresh the page to see enriched data
Common Issues
Issue: File upload fails or doesn't parse
Symptom: Error message or empty grid after upload
Solution:
Verify file is .csv, .xls, or .xlsx format
Open file in Excel to confirm it's not corrupted
Remove empty rows at the top of your data
Try copy-paste instead of file upload
Issue: Columns mapped incorrectly
Symptom: AI maps columns to wrong fields
Solution:
Click each column header dropdown and select the correct field
Use standard header names: "Product Name", "SKU", "Price"
Issue: "Choose columns to import" button is disabled
Symptom: Cannot proceed to step 2
Solution:
You need at least one row of data in the grid
Upload a file or paste data into the grid first
Issue: "Missing required fields" warning
Symptom: Cannot proceed to step 3
Solution:
Ensure at least one column is mapped to Product Title
If your spreadsheet lacks product names, map the most descriptive column (like Description) to Product Title
Issue: Duplicate SKU errors
Symptom: Some products skipped with "SKU already exists"
Solution:
Search your products to find existing items with those SKUs
Use different SKUs in your spreadsheet
Or map the SKU column to Ignore if you don't need SKUs
Issue: Prices appear as zero or incorrect
Symptom: Prices don't match your spreadsheet
Solution:
Remove currency symbols ($, EUR) from price cells
Use periods for decimals (1299.99, not 1.299,99)
Format price cells as "Number" in Excel, not "Text"