Set up price lists
Where prices come from
Bay Order checks these sources in order and stops at the first one that has a price:
- Shopify B2B catalog assigned to the customer's company. Bay Order uses the catalog of the company's first location.
- Bay Order price list assigned to the customer.
- No source found. The PO shows a "No price source" warning and can't be approved until a price exists.
The price a buyer writes in the PO is shown for reference only. It is never used as the selling price, and neither is your regular retail price.
Option 1: Use your Shopify B2B catalogs
If your companies already have Shopify B2B catalogs, you don't need to do anything. Catalogs sync automatically every hour, and you can sync them right away from the Price Lists page.
Option 2: Create a price list in Bay Order
- Go to Price Lists and click Create.
- Add products with the Shopify product picker.
- Enter a price for each product. You can add quantity tiers, so larger orders get a different price.
- Click Save.
- Open the customer in Master Data → Customers and assign the price list there.
Edit prices in bulk with Excel
- On the price list, click Export to download a template with your real products.
- Edit prices, minimum quantities and tiers in Excel.
- Import the file. The SKU and price columns are required. Rows with missing data or an invalid SKU are skipped, and Bay Order tells you how many were skipped.
Import adds rows. It doesn't replace them. Existing rows stay, and if the file has a duplicate of a variant that's already on the list, both rows are kept. Check for duplicates before you click Save.
Good to know
- Prices are in your store's currency. Bay Order doesn't convert currencies.
- A price list applies to the whole customer, not to individual company locations.
Related articles
Last updated
Was this page helpful? Email us