Process Wholesale Help Center

Price list CSV import problems

Most Process Wholesale price list import problems come from the file: a price column with an unrecognized header (such as Variant Price from a Shopify product export), SKUs that do not match the store, or thousands separators in prices. Problems with the list itself usually come from a customer missing the B2B tag or the list's tag, or from saving a list of more than 200 products in the editor. Price lists need the Professional plan. Find your symptom below.

Quick checks

  1. The store is on the Professional plan.
  2. The file has a header row with a price column (Price or Fixed Price) and a SKU or Handle column.
  3. Prices have no thousands separators: 1299, not 1,299.
  4. The customer is logged in and has both the B2B tag and the price list's tag.
  5. The list has 200 products or fewer if you save it from the editor.
  6. No other import is running.

CSV file rejected as soon as it is added#

The import window shows Couldn't detect the required columns. The file needs a price column (e.g. “Fixed Price” or “Price”) and at least one of “SKU” or “Handle”.

Confirm it. Open the file and look at the first row. Process Wholesale accepts these headers, ignoring capitals: sku, skus, variant sku for SKU; handle, url handle, product handle, slug, url handle slug for Handle; fixed price, price, wholesale price, wholesale, amount for price.

Fix it.

  • A Shopify product export has its price in Variant Price, which is not accepted. Rename that header to Price.
  • Make sure the header is in the first row, with no title rows above it.
  • If the window shows Failed to parse the CSV file., save the file again as CSV (comma separated) from your spreadsheet program.

The full list is in the Price list CSV format reference.

Some price list rows are skipped or unmatched#

The preview shows {count} skipped (missing key or invalid price), or the result shows {count} unmatched.

Confirm it. After the import, select Download unmatched rows. The file unmatched-<name>.csv lists each row with its line number and reason, for up to 2,000 rows.

Fix it by reason.

Reason Fix
Invalid price Enter a number in the price cell, such as 12.50.
Negative price Enter 0 or a positive price.
SKU matches multiple variants in store Give each variant a unique SKU in Shopify admin.
Handle has multiple variants — provide a SKU Add the variant's SKU. A handle alone matches only products with one variant.
No matching SKU or handle in store Check the SKU and handle against Shopify admin for typos, renamed SKUs or deleted products.
Row is missing both SKU and handle Add a SKU or handle, or delete the row.

Then upload the complete, corrected file with Update from CSV. Upload all rows, not only the fixed ones, because an update replaces the whole list.

If no row matched at all, the import fails with No rows matched a product by SKU or Handle. Check that the SKU or Handle column holds your store's values and not, for example, a supplier's item numbers.

The price list import will not start#

The import window shows an error after you select Import prices or Update prices.

Message Cause Fix
Couldn't start the import. A store export may already be running — please try again in a minute. Another import is running in your store Wait a minute and try again. Run one import at a time.
A price list with the tag name "" already exists. Please use a different tag name. Import from CSV was used with the name of an existing list Enter a new name, or open the existing list and use Update from CSV.
Enter a valid price list name (letters and numbers only, no "B2B") before importing. The Name field is empty or invalid Enter a name with lowercase letters and numbers only.
Imports are limited to 50000 rows. The file has more than 50,000 rows Remove rows you do not need. Do not split one list across several files: each Update from CSV replaces the list.
The CSV has no rows to import. The file has only a header Add data rows.
Couldn't start the import. Please try again. The connection was interrupted Try again.

The price list import seems stuck#

The progress bar stays on Starting…, Reading your product catalog… or Publishing prices to checkout….

Confirm it. The import runs in the background, and the window says it "may take a minute for large catalogs". Stores with many products take longer.

Fix it.

  • Wait at least 20 minutes. An import that was held up continues on its own within about 20 minutes of its last progress. Reading a very large catalog takes longer.
  • You cannot close the import window while it runs, but you can leave the page. The import keeps running. Open the list later from the Price Lists tab to check its products.
  • If progress has not moved after 20 minutes, reload the app and open the Price Lists tab. If a new list with your name appears with no products, open it and use Update from CSV with the same file. Otherwise, start the import again.

Prices imported 1,000 times too small#

A product meant to cost 1,299 shows a list price of 1.299 or similar.

Cause. Process Wholesale treats a comma on its own as a decimal separator, so 1,299 is read as 1.299. A value with both a comma and a dot is read correctly: 1,299.99 and 1.299,99 are both 1299.99.

Fix it. Remove thousands separators from the price column (format the column as a plain number with no separators), then upload the complete file with Update from CSV. Check a few prices in the editor or in an export afterward.

The wrong price at checkout#

A customer pays the retail price.

  • The customer is not logged in, or is missing the B2B tag or the price list's tag. Open the customer in Shopify admin and check both tags. The list tag must be spelled exactly like the price list name. Pending customers tagged B2B_Registeration (spelled this way) pay retail until you approve them.
  • The variant is not on the list. Open the list and check that the product and every variant has a price.
  • The store is not on the Professional plan.

A customer pays a different list price than expected.

  • The customer has more than one price-list tag. The Priority order on the Price Lists tab does not decide which list checkout uses, and Quick Buy can show a different list price than checkout charges. Remove all but one price-list tag from the customer.
  • The list was updated from a file with a wrong price. Export the list and check the Price column.
  • A deleted price list had the same name. When a list is deleted, its prices stay on the products, and a new list with the same name brings them back for products the new list does not price. Give new lists a new name, or add those products to the new list with the right price.

The customer pays in another currency. Checkout converts the list price at Shopify's exchange rate for that checkout. The Product Wholesale block and Quick Buy show the list amount without converting it, so the storefront and checkout amounts differ for these customers.

For discounts in general, see Wholesale discount not applying at checkout.

The price list does not apply to a customer#

Confirm it. In Shopify admin, open the customer and check the tags. Both B2B and the list's name, for example wholesale, must be there.

Fix it. Add the list's tag with Manage discount tags on the Process Wholesale Customers page, with Bulk assign discount, or by hand in Shopify admin. See How to assign discounts to wholesale customers. If the customer is still pending, approve them first. Make sure the customer logs in before checking out.

Products missing from a price list after saving in the editor#

The Products count dropped after you edited a list and selected Save, or after an update.

Cause. The editor loads at most 200 products, and at most 200 variants of each product. Saving from the editor removes the products and variants it did not load. Update from CSV also removes every product that is not matched in the file.

Fix it.

  1. Rebuild the full list in a CSV file, from your own records or an earlier export.
  2. Open the list and select Update from CSV, then upload the complete file.
  3. From then on, change lists with more than 200 products only with Export to CSV and Update from CSV, never with Save in the editor.

Price list export file shorter than expected#

Causes.

  • Variants that were deleted from your store are left out of the export.
  • An export that is interrupted can download as a shorter file without an error message.

Confirm it. Open the file and check that the number of rows matches the number of variants you expect on the list. An interrupted export can end on a complete row, so count the rows rather than looking at the last one.

Fix it. Select Export to CSV again. If the file is still short and no products were deleted, try again later.

Plans: Professional · Last verified · View this page as Markdown