COGS Bulk Upload (Summary – Read This first)

This guide is a bird’s-eye view of managing your COGS in bulk, from downloading your current costs to uploading updated data and resolving errors.

The procedural details you will need to perform the whole cycle can be found in COGS Bulk Upload Details

✅ Step 1: Download Current COGS Sheet

🎯 Goal: Retrieve the existing COGS data so you can edit it.

1. From the main menu, navigate to Products and Inventory > Products List.

2. Click the Import/Export (top right corner, next to the Getting Started button).

3. In the Import/Export Panel, under the EXPORT section, choose between:

   • COST_OF_GOODS_SIMPLE_VIEW_FORMAT (if you only need Start/End Dates and Unit Cost)

   • COST_OF_GOODS_DETAILED_VIEW_FORMAT (if you include Currency, Units, Total Paid, Notes, etc.)

4. Click the EXPORT button.

5. An Excel file will be generated and downloaded, containing your current COGS data for the selected marketplace.

✍️ Step 2: Update the COGS Sheet

🎯 Goal: Edit existing cost periods or add new ones.

1. Open the Excel file in Microsoft Excel or Google Sheets.

2. Edit existing rows or add new ones:

   • Ensure SKU spelling matches exactly what’s in SellerLegend.

   • Use YYYY-MM-DD date format only.

   • Do not add extra tabs or rename the sheet.

   • Make sure not to add any formulas in the sheet

3. In Simple View, each row in the sheet should have:

   • SKU

   • Start Date

   • End Date (optional)

   • Unit Cost

4. In Detailed View, you may also include:

   • Units, Total Paid, Currency, Exchange Rate

   • Provider, Notes

5. Save the file as .xlsx or .csv, depending on your platform’s preference.

⬆️ Step 3: Upload Updated COGS Sheet

🎯 Goal: Submit your changes back into SellerLegend.

1. Return to the Download/Upload COGS screen.

2. Switch to the Upload tab.

3. Click Browse or Drag-and-Drop your updated Excel file.

4. Select the target marketplace if prompted.

5. Click the Upload button.

SellerLegend will now process the file.

🧪 Step 4: Check for Errors

🎯 Goal: Review feedback and validate that your upload was processed correctly.

1. After upload, SellerLegend will show one of three results:

   • ✅ DONE: All rows uploaded successfully.

   • ⚠️ DONE_WITH_WARNINGS: Some rows had issues; the rest were uploaded.

   • ❌ FAILED: No rows were uploaded — check for a major format issue.

2. Scroll down to view row-by-row feedback.

3. If there are any errors:

   • Read the message for each failed row.

   • Common errors include:

     • Invalid SKU

     • Overlapping date periods

     • Missing required columns

     • Wrong date format

     • Invalid currency codes

🔁 Step 5: Fix Errors and Re-upload (If Needed)

🎯 Goal: Correct the file and ensure all data is accepted.

1. Open your Excel file again.

2. Fix any rows that were skipped or errored.

3. Save the updated file.

4. Re-upload using the same steps as before.

5. Repeat the cycle until you receive a ✅ DONE message.

🧪 Step 6: Confirm Upload Was Successful

🎯 Goal: Verify that the correct cost values are now in effect.

1. Go to Products List and select a product you updated.

2. Click the Kebab Menu (⋮) ➜ Select Edit Product.

3. Scroll to the Cost of Goods section:

   • Check that the new cost period appears.

   • Confirm the correct start/end dates and cost values.

4. Optionally, navigate to:

   • Product Dashboard > Order List to check if unit costs are being applied to actual orders.

   • Sales Per Day Per Product to verify profit and margin calculations.

🧠 Pro Tips

• Keep a master Excel file with all your cost periods per SKU for future uploads.

• Always define an open-ended cost period for your active products.

• Consider using Detailed View if you need to document supplier info or currency conversion.

Now head this way for the nitty-gritty detailed procedure