Whenever a customer purchases more quantity of a product, the seller benefits from such a transaction primarily due to 2 reasons:
- 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.
- 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.
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.
Once you have installed the extension, choose the sales channel (website) where you want to show the ladder prices.
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.
Give a name to the ladder, and download the sample CSV file.
The sample file will contain prefilled data for your reference. Delete all the data.
You need to change the data type of the first column to string/text. Select the entire first column and right-click.
If you are using MS Excel, choose Format Cells.
Choose Text. This will consider all the data in the first column as a string/text.
Here is the format of a 4-step fixed ladder.
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.
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:
fixedorpercentage.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
trueorfalse. 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 tofalse.
Here, we have also shown what a 4-step percentage ladder looks like.
- In this example, we have created a 4-step fixed ladder for a product, and a 4-step percentage ladder for another product.
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.
Upload the file.
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.
Choose the selling locations from the ones you have added to your business account.
Next, schedule the validity of the ladder pricing. Beyond the end date, the ladder pricing won't be available.
- You can change the end date of an existing ladder pricing.
- You can add or remove products from an ongoing ladder promotion
- Save the configuration.
Your ladder will be validated before creation.
Your new ladder will show up on the list.
On your website, your customers would be able to view the ladder prices.
If the file contains any discrepancy the upload would fail during the validation phase (see step no. 14)
Click the failed ladder promotion from the listing.
There will be an option to download the response CSV file. It contains the possible reasons for failure.
Response CSV is not only available for failed ladders but also successful ladders.
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.
Reason 2: Item not found - This means that the product doesn't exist or the seller identifier might be incorrect.
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.