Versions Compared

Old Version 5

changes.mady.by.user Mahtab Haj Ali (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Hugo Gomez

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Info

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.

Image Added

Sample

Image Removed

Image Removed

Example

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.

Image Added