📂 Uploading & Scanning Supplier Sheets
🟦 Overview
Click the image above to watch the full tutorial on YouTube.
Uploading supplier sheets is the foundation of your ASIN sourcing workflow in Source Correct.
This feature allows you to import supplier .csv files and convert them into structured product data — enabling ASIN matching, pricing analysis, purchase order creation, and long-term cost tracking. Unlike traditional tools that stop at UPC scans, Source Correct builds a full audit trail between your catalog, POs, and shipments.
🔁 Step-by-Step Instructions
✅ Step 1: Access the Supplier Sheet Uploader
-
From the left sidebar, click Supplier Sheets
-
Click the Upload Supplier Sheet button (top-right corner)
✅ Step 2: Select or Create a Supplier
You’ll be prompted to connect your file to a supplier:
Option A – Add New Supplier
-
Click Add New +
-
Input:
-
Supplier Name
-
Supplier Initials (used internally to mask name from team members)
-
-
Click Save Data
Option B – Select Existing Supplier
-
Choose from the dropdown
-
Drag and drop your
.csvfile or use the file picker -
Click Upload
✅ Step 3: Map Your Columns
If the supplier has been uploaded before, Source Correct will auto-map headers. You can override or manually match columns using dropdowns.
Common Fields:
| Field | Description |
|---|---|
| UPC / EAN | Product identifier (used to match to ASINs) |
| UPC / EAN (Button) | Select if your column contains UPCs or EANs |
| Item Number | Internal supplier SKU |
| Brand | Manufacturer or brand |
| Description | Product name or descriptor |
| Product Size | e.g., 12 oz, 10-pack |
| Price Type | Pricing structure (Each, Dozen, Case, or Column Specific) |
| Price Type Column | Use when price types vary row-by-row |
| Case Size | Units per case |
| Price | Cost per case, dozen, or each (based on Price Type) |
| Discount | Optional % or $ discount |
| Supplier Quantity | Available inventory (units or cases) |
| Custom 1 / 2 / 3 | Flexible fields (e.g., expiration dates, alt SKUs, internal tags) |
✏️ You can rename custom fields after upload to keep your system consistent.
🔐 Required Fields for Scraping
| Required If... | Field |
|---|---|
| Always | UPC / EAN |
| Always | Price |
| Always | Price Type |
| If Price Type = Case | Case Size |
| If Price Type = Column Specific | Price Type Column |
✅ Step 4: Preview & Save
-
Once your columns are mapped, click Save
-
You’ll see a row-by-row preview
-
Check for errors before submitting
⚠️ Step 4A: If Errors Are Found
-
A red banner will alert you
-
Fix errors by:
-
Reviewing inline messages in the preview
-
Downloading the error CSV
-
Re-uploading the corrected file
-
-
Or continue anyway by clicking “Source Now!” (if the remaining data is usable)
✅ Step 4B: If No Errors Are Found
-
Review the final preview
-
Click Source Now! to begin scraping and ASIN matching
✅ Step 5: Monitor Scraping Progress
-
You’ll return to the Supplier Sheet Table
-
View scraping progress via % bar
-
Track ASIN match rate
-
Click into the row to open the finished sheet
⚠️ Common Issues & Fixes
| Issue | Cause | Solution |
|---|---|---|
| Unsupported file type | Not a .csv
|
Re-export and upload as .csv
|
| Auto-mapping didn’t trigger | Header names don’t match past uploads | Map columns manually |
| “Source Now” not clickable | Missing a required field | Confirm all required columns are mapped |
| Invalid/duplicate rows | Bad formatting or structure | Clean up the file before upload |
💡 Pro Tips
-
Use the Source Correct CSV Template for consistent formatting
-
Stick to consistent column names for auto-mapping
-
Always preview the file before scraping — this is your chance to catch bad data early