Context
This is an article dedicated to step 7 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?
Once you have defined your pricing and pricing models, you need to import the data into the tool. The first step on how to create your data files is outlined in this step and the second step is to import this file, which this article will explain below:
Login to Mirakl
More information on how to do that can be found here: Login to Mirakl
A step-by-step:
1/ Once you are logged in your shop account, go on "My inventory"
2/ then on "Import from file"
Visual reference below:
3/ Select the price segmentation template you wish to upload as a "Source". You may find the template: here.
4/ Then select the "Price(CSV only) as the file content
5/ Click on "Import"
A visual example of a Price Segmentation File you need to upload:
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
Final steps:
6/ You will receive the notification “Use this import mode carefully” and you can then click on “Import”
7/ Check your imports via “Track Price Imports”
8/ If your Import was successful it will show up in “Green”