Search

Talk to Sales

Product COGS upload

Product COGS upload

Upload COGS securely to Reason Automation

This feature allows users of the Seller Profit Toolkit and Vendor Profit Toolkit to upload cost of goods sold (COGS) into the profit & loss data model. This data is stored securely and encrypted in your private Reason Automation database and is never transmitted to an Amazon server.

How to upload your COGS file

Vendor and Seller Profit Toolkit dashboards will automatically integrate your uploaded COGS data for use in profitability reporting.

  1. Log in to our client portal and browse to Manage Your Data > Upload Data. You should see the following (please reach out to us to request this function be activated if you do not see it):
image
  1. Click on the down arrow to download a sample template (CSV format). The column headers should be: date, sku, COGS.
  2. Add your COGS data. You’ll want to have a COGS per unit value for every possible SKU-month combination in the data. You can use a SQL query to help you create a starter file if desired. Note that the file must contain only unique SKU-month combinations.
  3. Save the completed file as a CSV (not an XLSX), and click or drag to upload to the portal.
  4. Your COGS data will appear in your schema, in a table called seller_profit_cogs

Note for Vendors

In the SKU column of the upload template, please use the Amazon ASIN instead of the SKU number.

Notes for Excel users

1) Dates in the CSV need to be in YYYY-MM-DD format, but Excel will reformat them as mm/dd/yyyy when you open the file. Before saving your file as CSV for upload, make sure the dates column is switched back to YYYY-MM-DD format (in Excel ‘Format’ dropdown, select Category > Date and then '2012-03-14'

2) Excel often adds a blank row at the end of a CSV file, even if you delete blank rows. If you get upload errors, check for the presence of a blank row at the bottom of the file using a text editor such as Notepad (note - we will be launching an update soon that will allow for blank rows at the end of a file to eliminate this issue).

3) If you have SKUs that are long numbers, Excel might turn these into scientific notation, causing an error when you go to upload because of duplicative SKU-date combinations. To set the right format, select the Excel Format dropdown (it will likely say ‘General’), select More Number formats > Custom > 0 (see image below).

image