Top

Bulk Import Prices with Quantity Breaks into Custom Pricing (Premium Feature)

Notes:

  • Before you begin, ensure that all store products have a SKU entered.
  • All products that have an associated quantity break need a "QTY" field in your import sheet with the break ranges specified.
  • You will need to be on the Premium Custom Pricing plan with Quantity Breaks ($69.99/month) for this import to work correctly.

To import wholesale prices that have associated quantity breaks into Custom Pricing, follow these steps:

  1. From Shopify's admin, select Products.

    select products

  2. Select Export.

    select export

  3. Under "Export", select All products.

    select all products

  4. Under "Export as", select CSV for Excel, Numbers, or other spreadsheet programs.

    select CSV for Excel, Numbers, or other spreadsheet programs

  5. Select Export products.

    Note: This will be emailed to you. You will need to select the link and download it to your computer to continue.

    select export products

  6. Select the CSV file and open with Excel or comparable software.

    select the CSV file

  7. Delete all columns, except:
    • Handle
    • Variant SKU
    • Variant Price

    Remove Handle & Variant SKU/Price

  8. To the right of the Variant Price column, add additional columns for each customer price group (tag).

    Note: If you have one tag (ie. Wholesale), add one column. If you have three tags (ie. Gold, Silver, Bronze), add three columns.

    Add Customer Tag Columns

  9. Enter the exact price for each variant in the corresponding cell.

    Enter Prices

  10. Duplicate the product lines for each quantity break you want to import.

    Duplicate Product Lines

  11. Insert a QTY column beside the "Variant SKU" and specify the minimum quantities required for each break.

    Insert QTY Column

  12. Edit the price for each wholesale tier.

    Edit Wholesale Prices

  13. Delete Variant Price column.

    Delete Variant Price Column

  14. Add a Price Type column and specify how your prices are set.

    Note: You can use either $ or % as the price types. If you're entering the direct cost of the product at each price tier, use $. If you're specifying the discount amount, use %.

    Add Price Type Column and Specify

  15. Select Save.

    Select Save

  16. From "Shopify Admin", select Apps.

    select apps

  17. Select Bold Custom Pricing (Wholesale & Quantity Breaks).

    Select Bold Custom Pricing

  18. Select Import/Export.

    Select Import/Export

  19. Select Choose File.

    Select Choose File

  20. Select the CSV file.

    select the csv file

  21. Select Open.

    select open

  22. Select Import.

    Select Import

  23. Select the Attribute that corresponds to each column.

    Select Attributes

  24. Select Upload.

    Note: The app will start the process of creating the pricing variants. Depending on the number of products and variants that need to be created, this can take some time to complete. A general rule of thumb is about 1 hour per 1000 variants. 

    Select Upload

That's it!

Next Steps:

Blog Posts: