Contents
On this page

Price tables - Plugixa Extra Product Options

A price table prices an option from a list of sizes, the way blinds, glass, frames and banners are sold: “a blind up to 120 wide and 80 high costs 22”. You paste the table from a spreadsheet, and the plugin finds the price for the sizes the customer types.

A Width field priced by a price table pasted from a spreadsheet, with Drop picking the rows, Width the columns, and a preview of the prices

Two kinds of tables

Two-way: sizes across the top and down the side, prices in between. Leave the first cell empty.

100 150 200
50 10 14 18
100 16 22 28
150 22 30 38

One-way: one size and one price per line.

Size Price
50 8
100 12
200 20

Setting up a table

  1. Add the Number fields that give the sizes, for example Width (cm) and Height (cm).
  2. Select the field that should carry the price, usually the last size field.
  3. Under Pricing, set Price to Price table.
  4. Paste the table into Price table, straight from your spreadsheet.
  5. Pick the fields that choose the price: for a two-way table, Rows are picked by and Columns are picked by; for a one-way table, Size is picked by.

You can also pick Quantity ordered as a size, which turns a one-way table into prices by quantity: up to 10 items, up to 50 items, and so on.

How sizes are matched

Sizes are up to: a value takes the first size at or above it. With the table above, a blind 120 wide and 80 high is priced as 150 by 100: 22. A value smaller than the first size takes the first size.

Above the largest size there is no price. The customer cannot add the product to the cart, and sees We have no price for this size. Please choose a smaller size. Set the size fields’ Maximum to your largest sizes so customers know the limit before they type.

Pasting from a spreadsheet

Copy the cells in Excel, Google Sheets or LibreOffice and paste them. Tabs, commas and semicolons all work as separators. When cells are separated by tabs or semicolons, a comma in a number is read as the decimal mark, so 12,50 is 12.50.

The editor checks the table and tells you what is wrong:

  • The price table has a cell that is not a number, with the cell.
  • Line 3 of the price table should have 4 cells.
  • The price table lists the same size twice.

A group cannot be published while a table has an error or its size fields are not chosen.

The price is per item

A table price is charged once per item, like any field price, and only when the field carrying it is filled in. It is not affected by sale prices or discounts by role: the table is the price.

Quick Links

Share