Updating Product Prices using a CSV file
- Leonardo Medeiros (Deactivated)
- Hugo Gomez (Deactivated)
- Mahtab Haj Ali (Deactivated)
Product Prices Importer
You can create or update many product prices at once in Jasper by uploading a CSV file on our tool located at “Import/Export” > “CSV Importers” > “Product Prices”.
Importer Requirements
The product prices importer requires a properly formatted CSV file to map to the products pricing fields inside the PIM.
CSV Format
The importer can read data from a number of columns. Each column is detailed below.
Keep in mind that the importer is case sensitive and pay attention to typos, so it is important to review your file before uploading.
“product_id”
Gets mapped to the product’s id in Jasper. The importer will try to locate the product with the given ID if the SKU is blank, if none is found it will create a new one with that value.
“product_sku”
Gets mapped to the product’s SKU in Jasper. This column is mandatory. The importer will try to locate a product with the given SKU, if none is found it will create a new product and assign that SKU into it. If the SKU is blank, it will try to locate the product by ID.
“sell_price”
Gets mapped to the Sell Price of the product.
“cost”
Gets mapped to the Cost of the product.
“msrp”
Gets mapped to the MSRP of the product.
“map”
This column is mapped to the Base Price of the product.
“starts_at”
Gets mapped to the Start Date (UTC) on the product pricing. Although this field is not mandatory, it is important to note that if it is left blank the price will expire automatically but it won’t be synced with your storefront.
“ends_at”
Gets mapped to the End Date (UTC) on the product pricing.
Column Separator
Each value must be separated by a comma.
File Layout Template
Below you can see the example CSV template file. You can download a copy of this template file on the Import/Export” > “CSV Importers” > “Product Prices”, by clicking on the “Download Example CSV Template” button.
Sample CSV File
In the example below the importer will try to find if there is any product with the SKU “99267”. If found, the product price will be updated with the Sell Price:119.99, Cost:34.56, MSRP: 129.99, Price Base: CAD, Start Date: 2022-04-28 12:00, and End Date: 2022-05-05 12:00. The importer will try to locate a product price with the given SKU, if none is found it will create a new product and assign that SKU into it. If the SKU is blank, it will try to locate the product by ID.
