Versions Compared

Old Version 2

changes.mady.by.user Leonardo Medeiros (Deactivated)

Saved on

compared with

New Version 3

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

Saved on

Key

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

Summary

Creates new product price records from a text file.

Separator

...

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.

“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 Sample

...

Header

...

Key?

...

Validations

Image Added

Image Added

Example