Let us imagine that you have installed the add-on Wholesale and wish to set wholesale prices for your products that will apply depending on the buyer's membership level and the number of product units being ordered. You can, of course, do so by editing the details of each of your products - via the Wholesale pricing tab of the product details. However, on large product numbers, it is more convenient to set wholesale prices using the import/export feature.

Let us show, how you can do it.

For example, you have a product SKU 10000000094 “Oversized Hoodie In Grey” priced at $9.99, and you want to set the following wholesale pricing tiers for it:

  • 1-4 units (for all customers) - $9.99

  • 5 or more units (for all customers) - $8.99

  • 10 or more units (for all customers) - $7.50

  • 10 or more units (for customers of the Wholesaler membership level) - $6.50

In the Wholesale pricing section, this setup would look as follows:

We are going to achieve the same result without editing the Wholesale pricing section directly. Let’s do it:

  1. Use the “Export” page of your store’s Admin area (Catalog > Export) to export existing products:

  2. Download the resulting export file and open it in a spreadsheet editor.

  3. Edit the file removing the columns whose contents will not need to be updated.


    According to CSV import: Products, the columns required for importing products with wholesale prices are sku and name (required for products) + wholesalePrices and variantWholesalePrices (the fields added by the add-on Wholesale). So, keep those columns in your file.

    It may also be a good idea to keep the columns price and stockLevel - so that you have information about the product’s base price and quantity in stock close at hand. You can safely remove the rest of the columns.



    Now, if you look at the line of SKU 10000000094, you should see something like the following:

  4. Add the wholesale price tiers you require.
    In our example, SKU 10000000094 “Oversized Hoodie In Grey” is a simple product without variants, which means we need to add our wholesale prices in the wholesalePrices column.

    The format to write out wholesale price tiers in your file is as follows: N1(Membership1)=Price1&&N2(Membership2)=Price2, where:

    • N is the minimum number of product units starting from which the price is available,

    • Membership is the name of the membership level to which the price is available (you can omit it to provide a price for non-members),

    • Price is the price corresponding to the specified number of product units and membership,

    • && is a delimiter used to separate the pricing tiers from one another.

    According to the said format, we need to add the pricing information for SKU 10001 “Planet Express Babydoll” as follows: 5=8.99&&10=7.50&&10(Wholesaler)=6.50

  5. Save the file and import it back via the “Import” page in your store’s Admin area (Catalog > Import).

After the import process is completed, you should see the wholesale prices you have imported in the Wholesale pricing section of the product details.

For products with variants, the process of adding wholesale prices is similar. You only need to add the wholesale pricing information via the variantWholesalePrices column.

Below you can see an example of a file that will add wholesale pricing for the variants of SKU 10000 (variantSKUs 100001, 100002, 100003, and 100004):

Did this answer your question?