Set up B2B pricing through import price

Import Pricing allows you to create or update wholesale pricing for multiple product variants in bulk using a CSV or Excel file. Instead of configuring prices one by one, you can upload a file and assign pricing to thousands of variants within minutes.

This feature is ideal when:

• Setting up wholesale pricing for the first time.
• Updating prices for a large number of products.
• Migrating pricing data from another system.
• Managing seasonal or promotional B2B price lists.

Before you start

Before importing your pricing, make sure that:

• Your pricing file is in CSV or XLSX format.
• The file contains the product information required for mapping, such as Variant ID, SKU, or Product ID.
• The pricing values are correct before importing.
• You have decided whether to create a new pricing campaign or update an existing one.

Recommendation

For large catalogs, prepare your pricing file first, then import all prices at once instead of editing products individually.

Prepare your import file

If you don't already have a pricing file, you can use Shopify AI Sidekick to generate one from your store data.

For example, ask Sidekick:

Export all product variants with Product ID, Variant ID, SKU, Product Handle, Product Title, Variant Title, and Price as a CSV file.

Or:

Create a CSV containing all product variants for wholesale pricing.

Once the file is generated:

1. Open the CSV file.
2. Update the pricing column with your desired wholesale prices.
3. Save the file.
4. Import it into Snap B2B Wholesale Pricing.

Tip

Keeping the existing product identifiers (such as Variant ID or SKU) unchanged helps the app match products correctly during import.

Step 1: Open Import Pricing

1. Open Pricing from the app menu.
2. Click Import.

After that, you will be transferred to the import pricing page.

Choose one of the following options:

Import into a new campaign

Select this option if you're creating a new wholesale pricing campaign.

You'll need to enter:

• Campaign Name
• Priority

Import into an existing campaign

Select an existing campaign if you want to update its pricing.

After selecting the campaign, upload your pricing file.

Supported file types

• CSV
• XLSX

Step 2: Map your columns

After the file is uploaded, the app reads the data and displays the mapping page.

If your column names match the expected fields, they may be mapped automatically.

Otherwise, select the correct field for each column manually.

Common fields include:

Tip

Variant ID is the most reliable identifier when importing pricing.

Step 3: Preview your import

Before importing, the app validates your file and displays a preview.

You may see different validation statuses:

Review the preview carefully to confirm:

• The correct variants are matched.
• Current and new prices are accurate.
• There are no unexpected validation errors.

Once everything looks correct, click Import Variants.

Step 4: Complete the import

After the import finishes successfully, the app displays an import summary, including the total number of imported variants.

Click Edit Price Setting to open the pricing page for the campaign you just created or updated.

From there, you can:

• Review all imported pricing.
• Edit individual variant prices.
• Add or remove pricing rules.
• Verify that everything was imported correctly before making the campaign available to your B2B customers.

Troubleshooting

My columns are not mapped automatically

Ensure your file contains recognizable product identifiers such as Variant ID, SKU, or Product ID.

You can also map each column manually before importing.

Some rows show errors

Review the validation message for each row.

Common causes include:

• Missing Variant ID
• Invalid price value
• Duplicate records
• Products or variants that no longer exist in Shopify

Correct the data and import the file again.

Duplicate records were found

If multiple rows reference the same variant, the app marks them as duplicates.

Remove duplicate rows before importing to avoid unexpected pricing.

I imported successfully but don't see my prices

Open the pricing campaign by clicking Edit Price Setting after the import completes.

Confirm that:

• The prices appear in the campaign.
• The correct campaign is enabled.
• The products included in the import match your intended variants.

Best practices

• Use Variant ID whenever possible for the most accurate matching.
• Double-check pricing before importing.
• Test with a small file before importing thousands of variants.
• Keep a backup copy of your original pricing file.

Need more help?

If you encounter any issues or have questions, feel free to reach out to our support team via [email protected] or via our live chat - we're happy to help!