When bulk uploading your product costs or product groups to Link My Books you may receive an error message if your file contains an error.
This guide will help you to troubleshoot and identify the issue.
Is your file using the correct headings?
The first thing to check is that you have downloaded the product file from Link My Books and that you haven't edited any of the headings.
To download your product file follow the instructions in this help article.
The file will have 4 columns:
Sku
Product Name
Landed Cost
Product Group
To resolve: It's easiest to keep the headings exactly as they are in the downloaded file. If your file uses different headings or has extra columns, you'll see a mapping screen when you upload it, where you can match each column. See Uploading Product Costs with Custom CSV Columns.
Have you edited or added SKUs?
If you have edited anything in the SKU column or added new SKUs to the file, those rows won't be uploaded unless Allow SKU Creation is switched on.
To resolve: Don't change the existing SKUs in the SKU column. To add products that aren't in the Link My Books file yet, switch on Allow SKU Creation first. See Allow Bulk Upload of New SKUs.
Does your file contain duplicates?
If your file contains multiple entries for the same SKU then this can cause an error.
To resolve: Check that your file doesn't contain any duplicates. An easy way to do this is to use Excel's built-in duplicate checker.
Has Excel automatically changed your data?
Sometimes if your SKUs begin with a number then Excel can convert them without you knowing.
To resolve: Follow these instructions to ensure you open the product file correctly.
Have you saved your file as a CSV?
We only accept uploads in CSV format. If you try to upload a file in another format the upload will fail.
To resolve: When you have finished working on your product file you should save it as a CSV, not as an xls or xlsx file format.