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

Daniel Little avatar
Written by Daniel Little
Updated over 2 weeks ago

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.

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
Navigating the Product Costs page
How to upload costs from SellerBoard to Link My Books
Common issues with bulk upload files and how to fix them
Some of my products are missing the product costs/groups page
Allow Bulk Upload of New SKUs
Did this answer your question?