Customer Prices: How to bulk import prices?
It is possible to import prices in bulk using spreadsheet (.csv and .xlsx) for easier price management.
Go to Catalog → Customer Price → Create New → Import :
The Import prices window will pop up with description and a sample file:
Import Prices Template:
The Template shows what is needed in order to import the new pricing configurations.
Once the Template has been filled in with all the necessary details - you can proceed with importing the prices - click on Select File → Import
Note! The From date in the Import file for customers with active subscriptions or orders CANNOT be earlier than or equal to [Today's date] - the earliest From date should be the next day (UTC); for customers without active orders or subscriptions, it can be earliest [Today's date]. Date is determined according to platform date & time, in more detail: Platform Time Zone
In case of unsuccessful import, the error message will pop up describing the reason of the failure:
Further import of the file will not be possible until all the necessary corrections are made to the data in the file.
1
1
Was this article helpful?
1 out of 1 found this helpful
Articles in this section
- What is Price Source?
- What is Soft and Hard Limit?
- What is Usage based calculator
- How to: Configure mark-up for Azure Marketplace offers?
- Customer Prices: Change Existing Markup on the Portal?
- Customer Prices: Price Configuration
- Customer Prices: How to Delete Price Configuration
- Customer Prices: How to promote offer(s) with a "Special Price" (badge)?
- Customer Prices: How to create markups with overlapping future dates?
- Customer Prices: How to bulk import prices?
Pity that a Customer-Vendor combo price still cannot be accommodated