The video shown above is of the old WPD app dashboard. The steps are similar, but with a slight UI change.
Please check the steps below for the latest app dashboard:
- Go to the Volume Discounts in the left menu bar of the WSH Wholesale Pricing app.
- Then, click on Import.
Select the discount group you’d like to make changes to in bulk.
(a) If you want to import/export a discount group that has a volume discount set, you can easily do it by clicking on the Download excel File button.(b) If the volume discount for a discount group is not set, it will show you the following screen: with an additional step to Export as an Excel file in Variants or Products format.
- Select the Export as radio button, whether you want to bulk edit discounts for Variants or Products.
- Click on the Download Excel File button to export the Variants/Products.
- Make your required changes to Variant/Product details and save the Excel file on your local computer.
- Now, to import the updated data, go back to the app and click the Upload updated Excel file button. Then, choose the Excel file you saved after making the changes, and upload it.
This will automatically implement the changes you made in the sheet for the variants/products and their pricing, as you specified. The solution is ideal if changes need to be made in bulk.
Note: what can and cannot be exported
Import and export cover volume discount tiers that are set up per product or per variant, the "buy more of this item, get X% off" type.
They do not cover:
- Collections. There is no export option for collection level volume discounts.
- Cart based tiers. Discount rules where "Applies to" is set to Cart total or Cart quantity are not included in the export file.
Bulk import and export of pricing rules is available on the Enterprise plan.