Use this tool to export bulk pricing rules assigned to your price lists. Then, utilize our Price List Bulk Pricing Updater to effortlessly update bulk prices for items within those lists.

This tool is not available a la carte, but is included at no additional charge for Premium subscribers or those who subscribe to the Price List Bulk Pricing Updater.

Select a name for your export file as well as the file type.  Available file types are Excel, or CSV.

Click Next.

By default, Your Store Tools will provide a notification on the dashboard as well as a notification via email when the job is complete.  If you choose not to receive a notification via email, you can turn this option off on this screen, or change the email address it will be sent to.

Once your selection is made, click Submit to finish.

By accessing the stacked menu in the upper right corner of the tool's tile from the dashboard, you can access the following:

  • History - a list of the last 7 days of processing history for this tool.
  • Help - a link to this support document.

You can also access the file by clicking on the stacked menu on the job itself.

The Price List Export Tool is designed to work in conjunction with our Price List Bulk Pricing Updater which allows you to upload a CSV that contains the following information:

  • SKU – the item’s SKU, this is not the BigCommerce Product ID, but the actual SKU. Our tool does not require the use of the BigCommerce Product ID.  SKUs for variants can be entered as well.
  • min qty - the minimum quantity of the item the customer must add to their cart in order to trigger the bulk pricing.  You can have multiple minimums for quantity breaks such as 1 - 5 no deal, 6 - 10 $2 off, 11 - 15 $5 off, etc.
  • type – the type of bulk discount to be offered based on the quantity, the acceptable values are:
    • fixed - a fixed price, such as $99.
    • percent - a percent to be taken off the regular price, such as 10%.
    • price - a flat dollar value to be taken off the regular price, such as $1.
  • amount – the fixed, percent or price value.  This field can also be used to delete bulk pricing rules.  Please see the step below called "How to Delete Bulk Pricing Rules on Items" for how to use this option.
  • price list - the EXACT name of the price list in your BigCommerce store that you want the pricing data applied to.

 

We do not allow selection of specific values for this export.  A sample export file is shown below:

Additional Options for Premium Plan Subscribers

Premium subscribers have access to schedule tools to run in advance.  This option will be displayed after you set your notification type.

By default, the scheduling option is set to No.  If you do not want to schedule the tool, click Submit.

If you want to schedule the tool to run at a later time, click Yes.

From here you can select to schedule the tool to run at a specific date and time:

The scheduled start time is the time the tool will run, not complete.

Once you set the day and time for the tool to run, click Submit.

Premium subscribers have access to schedule tools to run in advance.  This option will be displayed after you set your notification type.

By default, the scheduling option is set to No.  If you do not want to schedule the tool, click Submit.

If you want to schedule the tool to run at a later time, click Yes.

From here you can select to run the tool on a recurring basis:

Options for recurring jobs include:

  • Schedule Start Date and Time: The day and time the first instance will run.
  • Repeat: The recurring schedule for this tool, which can be:
    • Daily
    • Weekly
    • Monthly
  • Specify Hour: The hour of the day the tool will run.
    • Times are based on the time zone set up in your Company Profile.
    • Recurring runs can only be schedule at the top of the hour.
  • Ends: When the recurring job should stop. Options include:
    • Never
    • After a set number of runs have completed
    • On a specific date and time

The scheduled start time is the time the tool will run, not complete.

Once your recurring options are set, click Submit.

In addition to the regular scheduling option available on all tools with the premium plan, the Update Guest Order tool allows store owners an additional scheduling option for checking historical orders on a regular, recurring basis.

This additional schedule, allows you to do the following:

  • Schedule a daily run to check and associate orders from the previous day.
  • Schedule a weekly run to check and associate orders from the previous day, week, two weeks, or three weeks.
  • Schedule a monthly run to check and associate orders from the previous day, week, two weeks, three weeks, month, two months, or three months.

 

In order to use this method for scheduling, you must set the schedule by going to the tool's tile in the Your Store Tools dashboard and select Create Schedule from the stacked menu:

 

 

From there you can schedule the tool to run on a daily, weekly, or monthly basis.

Did you find an error or need additional support? Contact us at support@yourstorewizards.com to let us know!