Make a selection

Bulk Import Prices with Quantity Breaks into Custom Pricing

Laurel
Laurel
  • Updated

Custom Pricing provides you with the flexibility of bulk importing your wholesale discounts along with Quantity Breaks through a spreadsheet file. Uploading this file bypasses having to set up the pricing discounts from within the app's admin.

Using the Shopify product export feature and a spreadsheet editing program (Excel, Google Sheets, etc.), you're able to set specific discounts for each of your price tiers and products.

Importing prices with quantity breaks requires the Premium Select or Complete plan. For more information, please visit Custom Pricing Pricing & Overview.

Note: If you are switching from the legacy standalone version of Quantity Breaks to Custom Pricing, the CSV file needs to be created from scratch, as there is currently no migration process from the legacy version of Quantity Breaks to Custom Pricing. For more information, please visit Switch from Quantity Breaks to Custom Pricing.

 

 

Requirements

  • 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 need to be on the Premium Select or Complete plan. For more information, please visit Custom Pricing Pricing & Overview.

 

 

Important considerations

Uploading a CSV file creates a queue in Custom Pricing to synchronize prices for each line in the CSV file. Any other updates made in Custom Pricing after uploading a CSV file will be added to the end of the queue and will complete in the order it was actioned. Updates can take significantly longer to complete with very large CSV files. 

 

 

Walkthrough

 

 

Step 1: Export and edit your product price list

  1. From Shopify's admin, select Products.
  2. Select Export.
  3. Under Export, select All products.
  4. Under Export as, select CSV for Excel, Numbers, or other spreadsheet programs.

  5. Select Export products.

    Note: This is emailed to you. You need to select the link and download it to your device to continue.

  6. Select the CSV file and open with Excel or comparable software.
  7. Delete all columns, except:
    • Handle
    • Variant SKU
    • Variant 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.

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

  10. Duplicate the product lines for each quantity break you want to import.
  11. Insert a QTY column beside the Variant SKU and specify the minimum quantities required for each break.
  12. Edit the price for each wholesale tier.
  13. 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 %.

  15. Select Save.

 

 

Step 2: Import the pricing into Custom Pricing

  1. From within Custom Pricing, select Import/Export.
  2. Select Choose File.
  3. Select the CSV file.
  4. Select Open.
  5. Select Import.
  6. Select the attribute that corresponds to each column.
  7. Select Upload.

    Note: Upon selecting Upload, Custom Pricing starts 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.