Videos and Webinars

Create Customer Specific Price Lists

Merchants on Shift4Shop Enterprise and End-to-End eCommerce plans can set customer-specific pricing lists to further expand their pricing strategies.

The following steps will show you how to use the Price List Module:

  1. Log into your Shift4Shop Online Store Manager.

  2. Using the left navigation menu, go to Modules.

  3. Once you get to Modules, use the search bar at the top of the page and search for "Price Lists" to locate the module.

  4. Mark the Enable checkbox.

  5. Click Save at the top right.

These steps will enable the module. The next steps will show you how to create your lists.

Creating Your Price List 

6. With the module still visible, click on its Settings button.

7. Click on the Add List button.

8. Provide a name for your list.

9. Click Save to finish adding the list.

Next, you will add products to this list.

10. Using the search bar, locate the items you would like to add to this price list.

After you search for the first item, it will be added to the list. Then, each subsequent item you search will also be added to the list.

Additional Information
When searching for products, you can set the search to locate products based on the following:

  • GTIN
    (also applies to GTIN on product Advanced Options.)

  • ID/SKU
    (also applies to "code" for product Advanced Options.)

    (Only applies to the product's main MPN.)

  • All
    (Searches for all 3 listed above at once)

Please note when searching, you need to enter the full GTIN, ID, or MPN in the field. Partial searches will not return any results.

Once you've created your list, use the "New Price" field on each entry to set the item's price for the item(s) present on the list.

11. Click Save List at the top right to complete the list.

Assigning Customers to Lists

Once your list(s) is/are completed, you will assign customers to the list by following these steps:

  1. Using the left navigation menu, go to Customers > Customer List.

  2. Locate the customer record you'd like to edit and click on the name.

You will see a new "Price Lists" tab added to the customer record.

3. Click on the new Price Lists tab.

4. Next, click on the Select Price List button.

A pop-up window will appear with your configured price list(s).

5. Click Select to add a specific price list to the customer record.

6. Afterward, if you need to add additional lists to the customer record, click on the + Select a Price List button to add more lists to the customer.

Additional Information
If the customer record is linked to multiple price lists - and those lists have products that they share in common - the system will favor the higher price to the customer.

In other words, let's say you have two separate price lists. Price list 1 marks a product at $5, and price list 2 contains the same product marked at $10. If you assign both these lists to the customer record, the system will show the customer the $10 price for that shared item.

CSV Export/Import

Exporting the CSV

To generate an export CSV of your created Price Lists, follow these steps:

  1. Using the left navigation menu, go to Modules.

  2. Once you get to Modules, use the search bar at the top of the page and search for "Price Lists" to locate the module.

  3. Click on the Settings button for the module.

  4. Next, click on the Export/Import button found on the top right of the page.

You can use the Export function to generate a CSV file of the store's created Price Lists.

Additional Information
When you generate the CSV file, you can use the "Price Lists" drop-down menu to select individual price lists for the CSV export or select All to export all of them into the same CSV file.

Importing the CSV

You can also use the import function on the same page to import your Price List CSV file. This can be used to update existing Price Lists as well as create new ones when necessary.

Whether exporting or importing, the CSV file will use the following column headers:

  • List_Id
    The database ID of the list. This is needed for imports when updating your existing price lists. When using the import function to create new price lists, leave this column in place but with the cell blank/empty.

  • List_Name
    The name of the Price List using the entered data.

  • Catalog_ID
    The is the database/catalog ID of the product for the list.

  • Product_Sku
    The ID/SKU of the item for the list.

  • Product_Price
    The product's price on the custom price list.