For a better understanding of how to fill the table of base prices, read the full description of each field below.

• SKU ID: The SKU ID is the number that a specific SKU is identified by. Have a look at our article to find out how you can find a SKU ID

• Cost Price: Your SKU's production cost. If no such information is available, you can fill this field out with the same value as that of the Base Price.

• Base Price: A product's reference sales price.

• List Price: The list price functions as a SKU's former price assumed to be on sale. It's also known as the "original price" and can be shown in your store's window display. This field is optional when registering a price.

When filling out the spreadsheet for the Cost Price, Base Price and List Price fields, the characters must be the General type. Using other formats will result in errors when importing the spreadsheet.

In Cost Price, Base Price and List Price, you can insert decimal values separated by dot. Example: 4.95.

The next spreadsheet fields are optional, used only to make SKU identification easier. To view these fields in the spreadsheet, you'll need to select the include metadata in exported tables export option.

• SKU name (View Only): SKU's registered name

• Product ID (View Only): A product's ID as registered in the catalog.

• Product Name (View Only): Product's name to which the SKU is linked.

• Ref ID (View Only): Unique reference code, usually created by a store's internal systems, that facilitates the catalog's product organization.

• EAN (View Only): SKU's identification code (barcode)