Import Pricing
7 min
overview the import modified price feature enables administrators to update product and option pricing in bulk using an excel file this is especially useful when different products require different price adjustments and manually updating each product, size variant, or additional option would be time consuming by downloading pricing data into an excel file, administrators can review and modify multiple prices offline and then upload the updated file back into the system this streamlines pricing management and helps maintain pricing accuracy across large product catalogs purpose this feature is designed to simplify large scale pricing updates by allowing administrators to update prices for multiple products simultaneously modify product size pricing and additional option pricing in bulk reduce manual effort and minimize pricing errors manage store specific and default pricing through a structured excel template import modified price for importing the modified pricing, navigate to the products > product price > product price excel step 1 download file before downloading, specify the required filters to generate the appropriate pricing template these filters will help you find your product better and download all its size options and additional options in the form of an excel sheet product type – select the product type to filter out the required products i e standard or pre defined price defining method – choose the price defining method of the products the price defining method is entered while adding a product this would become easy for admin to update the prices price type – select the price type i e default store price, store price, option price (additional options price) or option combined price when you select option price, then a new dropdown will ask you for the options price type you can select ‘the common price for all sizes’ or ‘size based’ prices selection method – if there is large data then it is recommended to go for single product rather than multiple products products – finally select the products of which you want to modify the prices step 2 fill up data open the downloaded excel file and enter the new pricing details the template includes instructions and guidelines to help you correctly update the pricing information for the selected price type additionally, the file contains a separate sheet listing all available stores along with their corresponding store ids, which can be used when updating store specific pricing carefully review and update the required fields before saving the file step 3 upload file at last upload the excel file with the new pricing details the system will require you to select the price type i e for whom the pricing will be applicable, default store, store, option price, or combined option price note at a time you can upload only one excel sheet validate and import pricing data before importing the pricing updates, the system performs a validation check to ensure the uploaded data is accurate and complete a summary report is displayed showing correct records – records that contain valid information and are ready to be imported invalid records – records containing missing, incomplete, or incorrect information that require correction skipped records – records that were not processed because they failed validation requirements review the validation results, correct any identified issues if necessary, and proceed with the import to apply the updated pricing