How to add a new column for custom prices to your CSV
To add another column to your CSV you’ll need to create a new customer tag.
Then, download a new CSV from the app. A column for that new tag will appear on the spreadsheet and you can add prices to it.
Tip: It’s important to not manually add new columns or product rows to a CSV. If you make new tags or products, download a fresh CSV and it will contain those entries automatically.
Here is an example of the format of columns Shopify provides when you download a CSV, and the correct order you should maintain when you go to upload the file after editing it:
Note: The order of column titles should always be Product Type, Product Title, Variant Title, Variant ID, SKU, Price, Compare at Price.
These columns are then followed by your B2B Wholesale Hub tags which each gets its own dedicated column to enter your custom prices.
Confirm that your Custom Prices are discounts
Custom prices must be lower than the product's regular price, and Shopify prevents the app from applying a price that is higher than this.
Custom prices are intended to represent a discount and cannot raise a product's price.
Leaving a field blank applies no custom price at all, and the regular price for that product is used instead. This is particularly handy for any products that you don’t want to discount.
Important considerations for CSV formatting
Shopify expects a specific format for CSV uploads, so some edits to your CSV might cause it to break.
Consider these best practices to ensure your upload always works:
Supported CSV changes:
Adding, editing, or removing custom prices under any discount tag column.
Removing complete product rows. You can do this if you want to work on a shorter spreadsheet. For example, you can remove the top half of the rows if you only want to edit products on the bottom half.
Unsupported CSV changes:
Editing any value under the columns for Product Title, SKU, Variant ID, Type, the regular product Price, or Compare at Price. If you want to edit these, only do this in your Shopify admin on the products themselves or with a Bulk Edit before downloading your custom prices CSV.
Changing the order of any of the columns on your CSV, or removing some.
Tip: Custom prices must be lower than the product's regular price. Custom prices are intended to represent a discount and cannot raise a product's price.
Not seeing discounts on storefront shortly after uploading.
CSV uploads and edits require time to sync and cannot display on your online storefront until this process is complete.