Import & Export Prices into Custom Pricing

 Warning

This feature requires the premium version of Custom Pricing. Visit Custom Pricing: Information & Overview for more information on how to enable these modules.

Overview

Custom Pricing provides you with the flexibility of bulk importing your wholesale discounts 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.

 


 

  1. From the Shopify admin, select Products, then Export.
  2. Under Export, select All products.
  3. Under Export as, select .CSV for Excel, Numbers, or other spreadsheet programs.
  4. 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.

  5. Select the .CSV file and open with Excel or comparable software.
  6. Delete all columns, except:
    • Handle
    • Variant SKU
    • Variant Price

    Remove Handle & Variant SKU/Price

  7. 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

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

    Enter Prices

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

    Duplicate Product Lines

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

    Insert QTY Column

  11. Edit the price for each wholesale tier.

    Edit Wholesale Prices

  12. Delete the Variant Price column.

    Delete Variant Price Column

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

    Note: You can use either $, -, or % as the Price Types. To set a Fixed Price use $. This must be lower than the amount of the product price. To discount a set amount use, -. To discount by percentage, use %.

    Add Price Type Column and Specify

  14. Select Save.
  1. From within Custom Pricing, select Import/Export.
  2. Select Choose File.

    Select Choose File

  3. Use the file manager to select the .CSV file and select Open.
  4. Select Import.
  5. Select the attribute that corresponds to each column.

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

    Select Attributes

  6. 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.

Was this article helpful?
0 out of 0 found this helpful