Uploading CoGS Data

Details on how to upload your Cost of Goods Sold data

Interested in enabling this feature? Please contact: support@autopilotbrand.com

Landed Cost of Goods Sold (CoGS) Component

  • The Landed Cost of Goods Sold component can be found on the Settings page for both sellers and aggregators

  • From here, you can enter the upload process by clicking on the button as indicated below

  • You can also access two reports once the initial data processing and CoGS upload is complete

    • All SKUs and Uploaded CoGS report: overview of all SKUs we have tracked and the CoGS values for those that have been uploaded previously

    • Missing SKUs report: overview of only the SKUs that are missing CoGS data

CoGS Upload Requirements

  • Three columns are required for a successful CoGS upload - SKU, Landed Cost of Goods Sold, Currency. These should represent the latest total costs for the sellers SKUs and also include inactive SKUs that were sold historically

  • The data can be uploaded via a file that contains the data or can be manually pasted into the 3 columns shown in the screenshot

  • Typically, the file upload option is chosen as sellers can use spreadsheets exported from commonly used tools such as Sellerboard.

Please note: uploading CoGS for SKUs that had received CoGS data in the past will always overwrite the previous CoGS data

CoGS Upload: File Upload, Column Matching

  • After uploading the file, confirm which columns in their spreadsheet should map to the SKU, Landed Cost of Goods Sold and Currency

  • If the currency is not included in the spreadsheet, it can be added manually in the next step

CoGS Upload: Editing on the Fly

  • Once the columns from the spreadsheet are mapped, any missing data will be highlighted and can be added manually by the user as they would in a spreadsheet

  • For example, the seller's spreadsheet will often not include the currency code by default. Sellers can simply click into the currency field, choose the relevant currency from the list and then double click in the bottom right corner of the field to apply it to all

CoGS Upload: Confirmation

  • Once you have completed the spreadsheet upload and editing, you can finalize the submission by clicking on Continue

  • Any incomplete data that is not actually required can be discarded at this stage and the total amount of SKUs uploaded will be confirmed

Last updated