Context
This is an article dedicated to step 5 in the process of creating a Price Per Customer Group Segmentation.
Price per customer segmentations have been created to meet your business needs and allow you to charge different prices for one product to either one or most customer segmentations.
More information about the details of the Price Per Customer Group Segmentations can be found here: What is the Price Per Customer Group Segmentation?
Download the price segmentation file
How to do that can be found here: Download the correct Price Segmentation template
Below we have a price file with "Offer SKU" written twice each time, with 2 different prices per offers.
1/ the first price is the original price for the offer, without segmentation
2/ the second price is the one for a special segmentation Coffee
3/ do not use column H as the technical flows are not in place yet – it is a defunct column
Clarification of the columns that should be used in this context:
Column A: Enter the offer SKUs of the products you want to apply the offer SKU to
Column B: Add in the default and the segmentation price(s)
Column C: The format notation for price ranges should be:
| 5|6.80,10|6.20 |
The quantity is 5, the price is 6.80.
For the quantity 10, the price is 6.20.
Column D: Default price lines stays emtpy (D2 in this example) and add in the discount price in the lins below (here, D3).
Column E: The format notation for discount ranges should be:
| 5|6.40,10|5.80 |
A quantity of 5 products, will cost 6.40.
A quanitity of 10 products, will cost 5.80.
Column F: You can indicate a discount start date if relevant
Notation guidelines are as followed if a dedicated time needs to be specified:
| 2023-01-19T11:00:00Z |
Notation guidelines are as followed if no dedicated time needs to be specified:
| 19-1-2023 |
Column G: You can indicate a discount end date if relevant
Notation guidelines are as followed if a dedicated time needs to be specified:
| 2023-02-30T23:00:00Z |
Notation guidelines are as followed if no dedicated time needs to be specified:
| 2023-02-30 |
Column H: Please do not use this column for customer organization ids, it is a defunct column
Column I: Insert the name of the customer group ID that you want to include
Once you have completed this file according to your needs, you need to import it. How to do this will be outlined in: Step 7