Skip to main content

How to bulk upload your product costs

Using the bulk upload tool to update the costs of all your SKUs in one go

Written by Daniel Little

For accounts with large numbers of SKUs who do not want to manually update the product costs on the Product Costs settings page itself, we have 2 options to bulk upload.

Option 1 - Use our template. This option is covered in the steps below

Option 2 - Directly import from Seller Toolkit. This option is covered in another help article
​

Step 1

Click the Bulk Upload link just above the product costs table and you will then see the screen below:

A close-up screenshot of a "Bulk Upload COGS" (Cost of Goods Sold) pop-up window from the "LINK MY BOOKS" software. The pop-up has a gray background, indicating it overlays another screen. The text inside the pop-up reads: "Download the product costs template, fill in your landed costs and upload below." A red rectangular outline highlights the hyperlinked text "product costs template." Below this text, there's a file input field with a "Choose file" button on the left and "No file chosen" displayed next to it, indicating no file has been selected yet. At the bottom of the pop-up, there's a blue "Upload" button. The rest of the screen is blurred in the background.

Step 2

Download your product costs template by clicking the link shown above.
This file will include a list of all of your SKUs with their corresponding Product Titles and current Landed Costs as shown below:

A screenshot of an Excel-like spreadsheet or a CSV file, likely a template for product costs. The spreadsheet has three columns: Column A: Sku - Lists SKUs from "SKU-1" to "SKU-10". Column B: Product Name - Lists corresponding product names from "Product Name 1" to "Product Name 10". Column C: Landed Cost - Contains numerical values representing costs. These values range from 1.35 to 14.25 and include both integers and decimals. This column is highlighted with a prominent red rectangular outline, indicating its focus. The first row contains the headers (Sku, Product Name, Landed Cost), and rows 2 through 11 contain the data for 10 different products.

Step 3

Enter your updated landed costs in column C and then save the file in its current CSV format, as shown above.
Go back to Link My Books and choose the file and click Upload.

A close-up screenshot of a "Bulk Upload COGS" (Cost of Goods Sold) pop-up window from the "LINK MY BOOKS" software. The pop-up has a gray background, implying it is an overlay. The text inside the pop-up instructs: "Download the product costs template, fill in your landed costs and upload below." Below the text, there's a file input field. A red rectangular outline highlights the "Choose file" button on the left of this field. To its right, "No file chosen" is displayed, indicating no file has been selected yet. At the bottom of the pop-up, a blue "Upload" button is present, also highlighted by a red rectangular outline. The rest of the screen behind the pop-up is blurred.

Depending on the number of SKUs being updated the bulk upload could take a few minutes to complete.

A quick refresh of the page will show if the bulk upload is complete.

⚠️ An upload replaces the cost of every SKU in the file

When you upload a costs file, Link My Books replaces the cost of every product listed in it with the value in your file. If a cost cell is blank, it is saved as 0.00, and a cost of 0.00 counts as missing. Any settlement containing that SKU will then show Missing COGS again, even if you entered the cost before.

To avoid this:

  • Fill in a cost for every row before you upload.

  • Download a fresh template from the Product Costs page immediately before you edit it, so an older file can’t overwrite costs you’ve entered since.

  • After uploading, turn on Show only SKUs with no cost on the Product Costs page to check nothing has been reset to zero.

If costs have been overwritten, re-enter them, then open each affected settlement and choose Action → Refresh.

If you encounter an error with this bulk upload it is likely because Excel has changed the CSV file format. Please see this article on how to resolve that: https://help.linkmybooks.com/en/articles/3448423-how-to-open-csv-files-safely-with-microsoft-excel

COGS are always in one currency, and so if you are purchasing in multiple currencies you would need to pick one currency and convert the others to that one.

Related Articles
Did this answer your question?