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.
Tip: create your discount with a 0% rate and target the collections containing products that require a custom price.
You can pick individual collections, but we recommend targeting a single collection containing every product. This will make all products eligible to receive a custom price with one simple collection target.
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.
It’s important to not manually add new columns or product rows to a CSV. If you make new tags or products, download a new 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.
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.
After uploading a CSV, new custom prices are shown in the app but not on the storefront
Custom prices will only show on your online shop if the product with that custom price is found in a collection targeted by your tag.
Check that the product you are testing is found in at least one collection that is targeted where you initially created your tag.
Below is an example of a tag's targeted collections. Custom prices can display on any product found within the Candy, Chips, and Drinks collections. Custom prices will not display in products not found in at least one of those collections, even if assigned.
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.
Be sure to wait until your sync status in the app’s main dashboard shows that prices are up to date before testing. Check here for more info on syncs.