Bulk Import Prices with Quantity Breaks into Custom Pricing

Custom Pricing provides you with the flexibility of bulk importing your wholesale discounts and Quantity Breaks into Detailed Pricing. 

Using the Shopify product export feature and a spreadsheet editing program (Excel, Google Sheets, etc.), you can map out your discounts for each price tier, tag, and product, and then upload your pricing using a CSV file.

Requirements

• All products must have a SKU entered before beginning.

• To import prices with Quantity Breaks, you must be on the Complete plan.

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. 

Setup

Step 1: Export and prepare your spreadsheet

1. In your Shopify admin, go to Products, then click the Export button.

2. Under Export, select All products.

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

4. Click Export products.

   Note: Shopify will email you the file.

5. Open the CSV file in a spreadsheet program like Excel or Google Sheets.

6. Delete all columns, except Handle, Variant SKU, and Variant Price.

   

7. Change the name of the Variant SKU column to SKU.

8. Add a Price Type column to the right of the SKU column, and choose how your discounts will be calculated for each product:

   • Use % for a percentage discount.
   • Use - for a fixed amount off the original price.

   • Use $ for a fixed price (the new, lower price).

     Note: Fixed prices that are higher than the original price will be ignored.

     

9. To the right of the Variant Price column, add additional columns for each customer tag.

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

   

10. Based on the Price Type you’ve selected, enter the discount amount for each product variant and tag.

    Note: If your Price Type is $ enter the new (lower) fixed price. If it’s %, enter the percentage to be discounted. If it’s -, enter the amount to be discounted.

    

Step 2: Add Quantity Breaks

If you want to offer Quantity Breaks volume based discounts, follow the steps below.

1. Insert a Qty column to the right of the Variant SKU column.

   

2. If you want to offer Quantity Breaks to customers without tags, insert a default column to the right of the Price Type column.

   

3. Duplicate each product row for each Quantity Break tier you want to offer.

   

4. In the Qty column, enter the minimum quantity of products needed for each Quantity Break tier.

   

5. If you added a default column, enter the Quantity Break discount amount that non-tagged customers will receive (based on your Price Type).

   

6. Edit the Quantity Break discount amounts for the remaining tags.

   

Step 3: Finalize and import your file into Custom Pricing

1. Delete the Variant Price column.

   

2. Save your spreadsheet and export/download it to a CSV file.

3. In Custom Pricing, go to Import/Export.

4. Click Choose File.

   

5. Select the .CSV file and click Open.

6. Click Import.

7. In the preview screen, ensure the correct attribute is selected for each column.

   Note: If the preview has any empty columns, mark these columns as -Do Not Import-.

   

8. Click Upload.

   Note: A process begins to synchronize the new pricing. This can take some time, especially for large files. Pricing syncs at about 1000 variants per hour.