New And Improved Bulk COGS Upload
We have deployed today an improved version of the Bulk COGS Upload process and I am sure you’re gonna like it!
The main changes are in the error reporting method.
We are now using a native Excel spreadsheet instead of a CSV as the bulk uploading vehicle. So that eliminates all the frustrating format changes which Excel was forcing on the data in the CSV files, therefore, no more date issues, numeric field transformation issues, and other pesky Excel transformation-provoked errors.
And we are now also using the Excel cell formatting abilities to our benefit.
Once you upload a COGS update file, SellerLegend will process it and regurgitate a new Excel file for you to download and inspect what has been updated and what has been rejected. Rows for accepted changes are highlighted in green, rows with errors are highlighted in red.
When a COGS change row has errors, hovering over the individual fields of that row will reveal an Excel comment box which will tell you why the field is erroneous. You can then fix the error in the same file which you are inspecting and upload the correction from there.
Also, the upload process is no longer an all or nothing affair. We will update all the valid COGS even if there are errors elsewhere.
Plus, the download now reports on zero-COGS periods or missing COGS periods. These are highlighted in amber.
Lastly, the upload process will show the actual file name you have used for upload rather than the internal name of the file.
Click here to see the updated knowledgebase article for the new process:
How Do I Bulk-Download/Upload COGS For All My Products?
IMPORTANT :
Please DO NOT use old Excel or CSV files as these will not work any longer. You MUST start the process with a freshly-downloaded COGS file!