Skip to main content

Tracking SKU COGS over multiple Marketplaces

To be used when you would like to track the same SKU over different marketplaces

Kaylie Worbey avatar
Written by Kaylie Worbey
Updated yesterday

We have a feature whereas you can now track the COGS of the same SKU over multiple marketplaces.

To enable this, please get in touch with support at [email protected].

Once we have confirmed this is now active, you will need to take a couple of steps;

Firstly, head to Inventory > Product SKUs;

A screenshot of the "Product Groups" section within a financial management application. The page explains the purpose of product grouping: "Product grouping can be a useful tool if you want to apply different account codes or tax rates to groups of products. If, for example, most of your items have one tax rate but a few items have another tax rate then you could create a product group for those other items and then assign a separate tax rate to that group on the accounts & taxes page. Learn More!" It also instructs how to enable product groups: "To enable product groups please do so in the Account & Taxes Wizard, via the Accounts & Taxes menu." Below this explanatory text, there's a "BULK UPLOAD" button. Further down, there are two tabs: "Product SKUs" (currently selected) and "Product Groups". Under the "Product SKUs" tab, a list of products is displayed with two columns: SKU: "RB-0820-CAN" PRODUCT NAME: "Spin-and-Read Montessori Phonetic Reading Blocks with CVC Phonics Flashcards for Beginner Readers, Montessori Reading Wooden Toys for 3 Years +" On the right side of this product entry, there's a dropdown for "Product Group" which currently shows "Default Product Group".

Download the Bulk Upload CSV file;

A screenshot of a "Bulk Upload COGS" (Cost of Goods Sold) dialog box. The dialog provides two main sections: Download Template File: Text: "Fill in your landed costs, save and then upload below." Button: "DOWNLOAD" (with a download icon). Upload File: Text: "Drag & drop file here, or click" within a dashed-line box, indicating a drop zone. Button: "UPLOAD" (with an upload icon). In the top right corner of the dialog, there's a close "X" icon.

Below is an example of the file you will see;

A spreadsheet showing product data. There are five columns: SKU, Product Name, Landed Cost, Product Group, and Marketplace. There are 10 rows of data, each representing a product. All products have a Landed Cost of 1.99, a Product Group of "Default ProductGroup", and a Marketplace of "default". The SKUs are sku1 through sku10, and Product Names are product1 through product10.

The next step is to add each SKU below the 'Default List' for each marketplace you'd like to track along with the costs. For example, here's what the file may look like if you wanted to track Amazon.fr

A spreadsheet displaying product information. It has five columns: SKU, Product Name, Landed Cost, Product Group, and Marketplace. There are 20 rows of data. The first 10 rows (sku1 to sku10) have a "default" Marketplace, while the next 10 rows (also sku1 to sku10) have "Amazon.fr" as the Marketplace. All products across both sets have a Landed Cost of 1.99 and a Product Group of "Default ProductGroup". The Product Names correspond to their SKUs (e.g., product1 for sku1).

It's important to spell the marketplace EXACTLY the same as we do.

You'll then need to re-upload the file;

A screenshot of a "Bulk Upload COGS" (Cost of Goods Sold) dialog box. The dialog provides two main sections: Download Template File: Text: "Fill in your landed costs, save and then upload below." Button: "DOWNLOAD" (with a download icon). Upload File: Text: "Drag & drop file here, or click" within a dashed-line box, indicating a drop zone. Button: "UPLOAD" (with an upload icon). In the top right corner of the dialog, there's a close "X" icon.

When the reports for the SKU's are generated, it will then detect the assigned marketplace.

If there are any missing, it will use the 'Default' group.

👉 If you have any follow up questions after reading this article then please get in touch with support via the blue message widget at the bottom right of this page.

Related Articles
Navigating the Product Costs page
How to use product groups
How to use the Cost of Goods Sold feature
How to separate Shopify sales in Xero by source when imported via Mirakl
Common issues with bulk upload files and how to fix them
Did this answer your question?