As of 13 August 2026, AI can create a wholesale price list.

What to actually do

1. Use a tool built for this

   The route this page recommends

2. Do it yourself

   Second choice

   A chat interface, chat-fluent skill, and roughly 30 minutes until you can act on the result.

   How to actually do it

   1. Open your current product, cost and sales records, then gather the latest product names, SKUs, sizes, unit costs, recommended retail prices, case quantities and stock information.
   2. Write down the commercial rules that apply, including VAT treatment, currency, minimum order quantities, volume discounts, payment terms, delivery charges, lead times and the period for which prices are valid.
   3. Paste those records and rules into the prompt, replacing each bracketed slot and adding your product table under the product data heading.
   4. Ask the chatbot to return the customer-facing table, internal checking table, missing information and confirmation notes specified in the prompt.
   5. Compare every product name, SKU, cost, price, quantity, discount, VAT label and term in the draft against your current records, and recalculate the margins in a spreadsheet.
   6. Correct the flagged gaps and contradictions, then ask the chatbot to regenerate the list using only the corrected information.
   7. Send the final draft to a colleague who handles orders or accounts to check that customers will understand the terms before you publish or email it.

   Prompt

   Create a wholesale price list from the business information below. Use only the figures and facts I provide. Do not invent products, costs, prices, discounts, VAT treatment, delivery terms, payment terms, stock levels or lead times. If information is missing or contradictory, flag it in a separate issues section instead of guessing.
   
   Business name: [BUSINESS NAME]
   Currency: GBP
   VAT treatment: [VAT REGISTERED, NOT VAT REGISTERED, OR CONFIRM]
   Price validity: [DATE OR PERIOD]
   Customer type: [WHOLESALE CUSTOMER DESCRIPTION]
   Payment terms: [TERMS]
   Delivery terms and charges: [TERMS]
   Order minimum: [ORDER MINIMUM]
   
   Product data:
   [PASTE YOUR PRODUCT TABLE OR NOTES HERE]
   
   For each product, include where available: product name, SKU, variant or size, unit cost, recommended wholesale price, recommended retail price, margin, case quantity, minimum order quantity, volume discount, lead time and stock status. Calculate margins only where the required figures are supplied, show the formula used, and label whether prices include or exclude VAT according to the supplied VAT treatment. Preserve all supplied product names and SKUs exactly.
   
   Return:
   1. A clean customer-facing wholesale price list in a table.
   2. An internal checking table showing each calculation and any supplied assumptions.
   3. A list of missing or contradictory information.
   4. Five concise notes on terms that I should confirm before sending it to customers.
   Do not decide what prices my business should charge. Where a price is absent, leave it blank and explain what is missing.

   Open it prefilled in ChatGPT or Claude, or copy it into Gemini, which takes no prefill link.

3. Hand it to a person

   The distant third

   A person who owns the outcome does this end to end, worth it when the failure is dear.