Bulk Import Prices into Custom Pricing (Premium Feature)



To bulk import prices into Custom Pricing, please 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

    delete all but three columns

  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 price group columns

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

    Note:  You can use regular spreadsheet formulas. For example: If the variant price is in cell C2, and the wholesale price is 25% off the variant price, is to appear in cell D2, a formula of =C2*.75 can be entered in cell E2. If you don’t want a price for a specific tag/variant combination, leave that cell blank.

    enter the exact prices

  10. Delete Variant Price Column.

    delete variant price column

  11. Select Save.

    select save

  12. From Shopify's admin, select Apps.

    select apps

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

    Select Bold Custom Pricing

  14. Select Import/Export.

    Select Import/Export

  15. Select Choose File.

    select choose file

  16. Select the CSV file.

    select the csv file

  17. Select Open.

    select open

  18. Select Upload.

    select upload

  19. Select the CSP Attribute that corresponds to each "File Column".

    select upload

  20. Select Start Importing.

    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 start importing

That's it!

Next Steps:

Blog Posts:

Related Files:

0 out of 0 found this helpful


1 comment
  • I can see that the end result of this is a bunch of metafields added to each product.

    Is it possible to add these metafields manually?

    I ask because I'd like to add custom pricing via CSV, but I'm using Excelify to manage my product imports on a scheduled basis, and I'd like to include custom pricing to my Excelify CSV.

    If I can add my own Custom Pricing metafields to my products, that will mean I can add them to my Excelify import, and won't have to create a separate spreadsheet and import for managing my custom prices.

Please sign in to leave a comment.