# Modern Price Ladder ## Introduction Whenever a customer purchases more quantity of a product, the seller benefits from such a transaction primarily due to 2 reasons: 1. Logistics and packaging costs incurred for sending 'n' quantity of products to a single customer are less than the costs incurred while sending 1 quantity of product each to 'n' customers. 2. The seller can restock the inventory quicker when products/articles are sold in bulk quantity. To promote bulk purchases (seen commonly in B2B transactions), sellers can pass on the benefits to their customers by reducing the product prices as per the quantity added to their cart. In short, the more a customer buys, the lesser the price. Once you have installed this extension, it will be available in the **Extensions** section on Fynd Platform. ## Ladder Pricing Modern Price Ladder helps you to set different prices based on the quantity. There are 2 ladder types: **Fixed** - If you’re selling a packet of wafers for ₹50, you may allow a customer to purchase 5 quantities for ₹45 each, thus giving a discount of ₹5 per packet. And you can sequentially add steps to the ladder, for e.g. 10 quantities for ₹40 each, 30 quantities for ₹35 each, and so on. **Percentage** - If you’re selling a cake for ₹500, you may allow a customer to purchase 2 quantities for a 10% discount. And you can sequentially add steps to the ladder, for e.g. 3 quantities for 15% discount, 4 quantities for 20% discount, and so on. ## How to use Modern Price Ladder 1. Once you have installed the extension, choose the sales channel (website) where you want to show the ladder prices. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/select-saleschannel.png) Figure 1: Selection of Sales Channel 2. You can view the existing list of ladders you created. However, this list will be blank if you're creating a ladder for the first time. Click **Create New** to prepare a new ladder. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/ladder-listing.png) Figure 2: Ladder Listing 3. Give a name to the ladder, and download the sample CSV file. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/create-ladder.png) Figure 3: Ladder Creation 4. The sample file will contain prefilled data for your reference. Delete all the data. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/sample-file.png) Figure 4: Sample File 5. You need to change the data type of the first column to string/text. Select the entire first column and right-click. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/first-column.png) Figure 5: Changing Data Type of Seller Identifier 6. If you are using MS Excel, choose **Format Cells**. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/format.png) Figure 6: Format Cells in MS Excel 7. Choose **Text**. This will consider all the data in the first column as a string/text. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/string.png) Figure 7: Choosing Text as the Data Type 8. Here is the format of a 4-step fixed ladder. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/4-step-ladder.png) Figure 8a: Fixed Ladder with 4 Prices * The first column **seller_identifier** contains the unique seller identifier of the product to which we are applying the ladder price. You can get the seller identifier from your product on Fynd Commerce as shown below. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/seller-identifier-1.png) Figure 8b: Locating Seller Identifier * The second column **description** contains the product name. You can write any description of your choice. * The third column **ladder_type** contains the type of ladder you wish to create. Acceptable values: `fixed` or `percentage`. * The fourth column **min_qty** contains the minimum quantity of the product that the customer should have in the cart to avail the ladder price. * The fifth column **ladder_price** contains the new price applicable to the product if the customer has added the quantity as specified in the **min_qty** column to the cart. * The sixth column **is_active** accepts boolean values such as `true` or `false`. This column is for specifying whether the product is eligible for ladder pricing or not. This is especially useful if you want to eliminate a product from an ongoing promotion by reuploading the CSV file and setting the **is_active** field to `false`. Here, we have also shown what a 4-step percentage ladder looks like. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/percentage.png) Figure 8c: Percentage Ladder with 4 Prices 9. In this example, we have created a 4-step fixed ladder for a product, and a 4-step percentage ladder for another product. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/2-ladder-types.png) Figure 9: Fixed + Percentage Ladder for 2 Products You can add as many steps in the ladder. The ladder prices will be applied to the MRP, and the existing selling prices in the inventory will not be considered. 10. Upload the file. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/file-upload.png) Figure 10: CSV File Upload 11. Now it's time to add the selling locations. Ladder prices will be shown on the website only if the pin code of the customer is serviceable by the selling locations added by you. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/adding-locations.png) Figure 11: Adding Selling Locations 12. Choose the selling locations from the ones you have added to your business account. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/choosing-locations.png) Figure 12: Choosing Selling Locations 13. Next, schedule the validity of the ladder pricing. Beyond the end date, the ladder pricing won't be available. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/scheduling.png) Figure 13: Duration of Ladder Promotion * You can change the end date of an existing ladder pricing. * You can add or remove products from an ongoing ladder promotion 14. Save the configuration. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/save-config.png) Figure 14a: Saving the Configuration Your ladder will be validated before creation. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/successful-validation.png) Figure 14b: Validating the Ladder 15. Your new ladder will show up on the list. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/ladder-listed.png) Figure 15: New Ladder in the Listing 16. On your website, your customers would be able to view the ladder prices. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/fixed.png) Figure 16a: Fixed Ladder for Product 1 ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/percentage-yjazdpPLH.png) Figure 16b: Percentage Ladder for Product 2 ## What to do if the validation fails? If the file contains any discrepancy the upload would fail (as shown below) during the validation phase (see step no. 14) ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/failed2.png) center em Figure 17: Validation Failed 1. Click the failed ladder promotion from the listing. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/failed-ladder.png) Figure 18: Ladder Listing 2. There will be an option to download the response CSV file. It contains the possible reasons for failure. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/download-response.png) Figure 19: Downloading the Response CSV Response CSV is not only available for failed ladders but also successful ladders. ### Common reasons **Reason 1**: Ladder conflict - This means that the product is part of some other ladder promotion. We recommend you remove the product from the ladder promotion you have created, or you may deactivate the previous promotion containing the same product. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/failure-reason.png) **Reason 2**: Item not found - This means that the product doesn't exist or the seller identifier might be incorrect. ![QG1](https://cdn.pixelbin.io/v2/doc/original/searchlight/extensions/ladder/failure-reasons-2.png) **Reason 3**: Invalid ladder-type - The value in the **ladder_type** column is incorrect. Valid values are `fixed` and `percentage`. **Reason 4**: Invalid percentage - In the case of percentage ladder type, the value in the **ladder_price** column should be less than 100. Finally, you may fix the issues in the original file and reupload it.