Adding a new column
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: Do not manually add new columns or product rows to a CSV. If you add new tags or products, download a fresh CSV to include them.
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: Keep columns in this order:
Product Type
Product Title
Variant Title
Variant ID
SKU
Price
Compare at Price
After these columns, each B2B Wholesale Hub tag has its own dedicated column for Custom Prices.
Confirm that your Custom Prices are discounts
Custom prices must be lower than the product's regular price. If the field is blank, the regular price applies (no custom price). 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 remove Custom Prices in any discount tag column.
Remove entire product rows to shorten the 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, Product 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.
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. After you upload a CSV, wait for the sync to finish before testing on your online store. If you still do not see the discount after syncing, re-check that the Custom Price is lower than the regular price and that the CSV format matches the template.