Bulk Price Editor/Price Change CSV Upload FAQ

Can I upload a CSV file with my price changes and schedule those changes for a certain date?

Yes, CSV files can be used to perform price changes right away, or you can schedule them for a future date.

What is the easiest way to generate a CSV file for my price changes?

  1. Click the ‘Get CSV template’ button and confirm your email. The template should be emailed to you shortly (if you have a very large number of products this might take a little while).
  2. Open the CSV template in a program like Google Sheets or Microsoft Excel.
  3. Change the “Variant ID” formatting to not be scientific notation if you are using Microsoft Excel (see below).
  4. Delete the rows for any product variants that you do not want to change.
  5. Modify the price and compare at price of products as desired.
  6. Export the file as a CSV and upload the file to the Bulk Price Editor app.

How can I set my “Variant ID” column to not be formatted as scientific notation on Microsoft Excel?

Microsoft Excel will automatically format Variant IDs as scientific notation. You need to fix this before your CSV upload will work correctly with the Bulk Price Editor app.

As an example, the Variant ID should show as “35724590514334”, not as “3.57246E+13”

You can fix this issue by formatting the Variant ID column as a fraction. Please view the video below for an example:

I want to generate my CSV file in a different way. Is that possible?

Yes, you can prepare a CSV file in any way that works best for you. You just need to make sure that your file meets the following requirements:

  • You can use the ‘Get CSV template’ button to see an example of how the CSV should be formatted
  • You must have either a “Variant ID” column or a “Variant SKU” column. Either will work, but “Variant ID” is recommended if possible. If you have both then “Variant ID” will be used.
  • You must have either a “Variant Price” column, a “Variant Compare At Price” column, or both.
  • Prices must be a number.
  • Compare at prices must be a number or be blank. A blank indicates that the product variant does not have a compare at price.
  • Column ordering does not matter