Import Pricing Updates via a CSV File

Note: This feature is only available to subscribers of the ADVANCED plan and above.

The Import file

The CSV file must be in UTF-8 format, and all special characters should be encoded correctly. Microsoft Office is not recommended for creating the file; instead, we recommend using Google Sheets or LibreOffice.

To ensure that your file has the correct format, we recommend exporting your pricing from the All Products > Pricing section. At the top, you will see a button to export a CSV file, which we suggest using to adjust the new pricing for your products.

---

Fields

Name	Description and Important Observations
Permalink	Unique identifier of the product. Mandatory.
Product Name	Name of the product. Mandatory.
Product Option Property	Name of the product variant. Mandatory if product has variants.
Price List Name	Name of the Price List. Must already exist in the store.
Minimum Quantity	Mandatory. It should always be set to 1 if you want to update the regular price or the price of a specific price list defined in the “Price list name” column.
Unit Price	Mandatory. Represents the product’s price or the unit price associated to a given quantity.
Compare at Price	Optional: A referential price. It will show the price as a discounted rate vs this value.
Cost per Item	Optional: It allows to estimate the revenue per item.

The process of importing new prices and/or volume prices into your store

Importing new prices and volume pricing into your store is a straightforward process that allows you to efficiently update product pricing. Follow these steps to ensure a successful import:

1. Export your current pricing

• Go to All Products > Pricing in your store’s admin panel.
• Click the Export button to download a file with your existing pricing structure.
• Use this file as a template to make the necessary price adjustments.

2. Prepare your CSV file

• Ensure that the Permalink matches an existing product in your store.
• Ensure that the Price List Name matches an existing price list in your store.
• Set the Minimum Quantity column to 1 if updating the regular price or a specific price list price.
• Enter the new prices in the corresponding column, using integer or decimal values.
• For products with variants, include the Product Option Property column. If a variant is not found for the product’s permalink, validation will fail.

3. Import the updated CSV

• Navigate to the Import section in your store’s admin panel under All Products > Pricing.
• Upload the modified CSV file.
• The system will validate the data before applying the changes and will report errors.
• If the CSV file is valid you’ll see a button to proceed with the Import.
• You’ll receive an email once the process has finished.

---

Some notes and validations to ensure a smooth operation

• We recommend using our exported file and Google Sheets to avoid conversion issues.
• Since our system performs a pre-validation of the CSV and its content, large files (more than 1500 rows) may take some time to validate. Therefore, as already recommended for product imports, we suggest that if your file is large, you split it into several smaller files with approximately 1000-1500 rows.
• At the end of the import, you will receive an email with the status of the operation. It will indicate whether it was successful or not, and if it was unsuccessful, the reason will be provided.
• Only one import can be processed at a time. If you have an import in progress, you will not be able to proceed with a second import until the first one is completed.

Some common reasons a CSV may be invalid

• The Unit Price is either absent, not an integer or decimal, or negative.
• The Minimum Quantity is either absent, not an integer, or less than 1.
• If present, the Compare at Price and Cost per Item are either not integers or decimals, or negative.
• When Compare at Price is present and the Minimum Quantity is 1, it must be bigger than the unit price

• The Price List Name does not exist.
• The Permalink does not exist.

• The product name associated with a given permalink is different from the value in the Product Name field in the CSV.
• The value of the Product Option Property differs from the variants already available in the store.
• In cases with volume pricing (minimum quantities > 1), the unit prices must decrease as the minimum quantity increases.
• Unit prices for volume pricing must always be lower than the standard pricing for that product (lower than the price list’s price when specified).

Price import behavior and volume pricing considerations

Please note that the import process only creates or updates prices; it is not responsible for deleting any existing prices, except for volume pricing.

This means that if a price already exists for a product, such as the Yellow Tennis product, and the new CSV does not contain that line, the price will remain unchanged.

For volume pricing, deletions may occur. For instance, if a product has the following volume pricing: 2 -> 10, 3 -> 9, 4 -> 8, and the CSV does not include entries for volume pricing, then nothing will be modified. However, if the CSV contains new entries for the same product, such as a minimum quantity of 5 and a unit price of 7, then the values for quantities 2, 3, and 4 will be deleted, as they do not exist in the CSV.

To retain the existing volume pricing and only add the new entry for min quantity = 5, the previously existing entries should remain in the imported CSV file.

---

Notes about dealing with CSVs in Excel

Please be aware that Excel can be a useful tool for working with CSV (Comma Separated Value) files, but it may not be the best option for converting files to CSV. This is because Excel may not always preserve the formatting and structure of the original file when converting it to CSV.

For example, Excel may use different delimiters (such as semicolons or tabs) than what is commonly used in CSV files (which typically use commas). This can cause issues when importing the file into other applications that expect CSV files to be formatted in a specific way.

Additionally, Excel may add formatting or special characters that are not compatible with CSV files, which can result in errors or data loss when importing the file into other applications.

Therefore, it is often recommended to use specialized tools or scripts designed for converting files to CSV, which can ensure that the resulting file is properly formatted and compatible with other applications. A simple trick to overcome this problem: Upload an Excel file in Excel format to Google Sheets and then download the CSV, this way your CSV will be compatible with most platforms.