Overview
You can update the cost (COGS) for your existing inventory items using a bulk upload feature. This helps ensure accurate reporting for profitability, valuation, and sales analysis.
Required Fields for Upload
To successfully upload cost data, your file must include the following columns:
MSKU – Unique identifier for the item
On Hand – Current quantity available
Cost/Unit – Cost per unit of the item
Supplier – Name of the supplier/vendor (Optional)
Date Purchased – Purchase date of the inventory (Optional). If not given it will take the default today's date .
Steps to Upload Cost for Inventory
1. Prepare the File
Create an Excel or CSV file with the required columns:
MSKU | On Hand | Cost | Supplier | Date Purchased
Ensure:
MSKU matches exactly with existing inventory
Cost/Unit is numeric (no symbols like $)
Date format is consistent (e.g., MM-DD-YYYY)
2. Navigate to Upload Section
Go to the Inventory > IL Import > Step 3 — Import FBA Inventory
Select Drag and drop or click to upload button
3. Upload the File (Upload the file only once)
Choose your prepared file
Upload and confirm the import as it shows below
4. Verify Data
After upload:
Check the buylist item is created for the items and would be in archived state.
Confirm that cost values are updated correctly
Validate supplier and purchase date fields
Important Notes
Upload the file only once to avoid duplicate entries
Ensure MSKUs already exist in the system
Incorrect formatting may result in failed uploads
Best Practices
Always keep a backup of your file before upload
Double-check cost values before importing
Use consistent supplier naming for reporting accuracy