How to deal with leading zeros when uploading COGS

If your SKU starts with "0" and you noticed that it is being omitted when viewing the downloaded template in an Excel spreadsheet, here's your step-by-step guide on how to fix it.

The quick answer is, it's actually an Excel issue. if you look at the raw CSV you'll notice that zeros are there.

Here's how you can resolve this issue:

1. Go to Profitability > Product Profit > then download the COGS Template.
2. Open a new GSheet and import the COGS template you just downloaded.
   Note: Before you hit the "Import data" button, untick the box that says "Convert text to numbers, dates, and formulas".
   
3. After you have updated your COGS data in the GSheet, download the file as CSV.
   
4. You can then proceed to upload your CSV file to your MerchantSpring account.
   See Uploading Cost of Goods (COGS) for more details.