Skip to content

Import and Export

Alerts move in and out of the plugin as CSV files. Both buttons sit at the top of the Alerts screen.

Export CSV downloads the alerts in the current view. It keeps the status view, the product filter and the search, so you can export only the notified alerts on one product, for example.

The file is named price-alerts- plus the date, with one row per alert and these columns:

ID, Email, Customer, Product ID, Product, SKU, Status, Alert Type, Price At Signup, Target Price, Notified Price, Current Price, Created On, Notified On, Clicked On, Converted On, Order ID, Revenue and Coupon.

Customer is the account name or Guest. A cell that starts with =, +, - or @ gets a leading apostrophe, so a spreadsheet does not run it as a formula.

Import CSV opens a three step wizard: Select File, Mapping and Data Import.

Drop a .csv file on the box or click to browse. The file needs an email and a product ID or SKU on every row. Download a sample CSV file gives you one to copy.

The Select File step

Once a file is read, its name, row count and size show under the box, and Continue opens the mapping.

The import’s Select File step with a file chosen

Each field gets a column from your file. Columns named the usual way are matched for you: Customer Email to Email, Product SKU to SKU, Price to Price At Signup, Subscribed On to Created On. Anything else you pick by hand, like Wanted Price for Target Price here.

The Mapping step with Wanted Price mapped to Target Price

  • Email: Required.
  • Product ID or SKU: One of them is required. A variation’s ID or SKU sets the alert on that variation.
  • Status: Optional. Active, notified, purchased, unsubscribed or expired, or the names on screen such as Watching.
  • Target Price: Optional. Empty means an any-drop alert.
  • Price At Signup: Optional. The price the shopper saw. Empty uses today’s price.
  • Created On: Optional. Keeps the original date.

Status for rows without one sets the status of rows that have no status column or an empty cell. Default Watching.

Rows are imported in batches of 100. The summary counts the rows imported and lists every row that was not, with the reason.

The import summary with two rows not imported

  • Product not found: No product has that ID or SKU.
  • Already watching this product: That email already has an alert on the product that is watching.
  • Invalid email address: The email cell is not an email.

Nobody is emailed during an import, and no webhook is sent. See How to Import Price Alerts from a CSV File.