Wholesale table add to cart

Wholesale table add to cart

(17) 4.65 stars
205 Sales

WooCommerce Wholesale is a WooCommerce e-store extension that allows to create custom product tables, which make buying far more quicker and convenient. Although it can be useful for retail buyers, Wholesale is directed to wholesale buyers, who buy many different variations. Wholesale allows them to complete their order on one page through clear tables, increasing their productivity significantly.

Completing orders with Wholesale is really easy. A user specifies a desired number of products and then clicks “Add to cart”. It is really that simple.


Well, all you have to do to add a table to a page is to type something like this:
[!wholesale columns="buy,sale-price/,tally/,total/" products="40|130" buy="vertical-attribute/Color Combo|Mod,label/M|W,horizontal-attribute/Size"]
but without ’!’ before ‘wholesale’.  

A shortcode consists of following optional tags:
  • columns – Put there names of columns, you want to display. You can rearrange them as you wish. Available columns are:
    • SKU – displays product SKU
    • image – displays product image
    • rating – displays product rating
    • regular-price – displays product regular price
    • sale-price – displays product sale price. If a product is not on sale, then a regular price is displayed. Use it to display a final price.
    • buy – In case of one simple product, an input is displayed, allowing a user to specify how many products is ordered. If there are more simple products or variations, it displays a label for each product and/or attributes and inputs
    • tally – displays how many products from a row a user have added.
    • total – displays total sum a user will pay
    • stock – displays total amount of items available.
    • title – displays product’s title
    If you do not specify columns, default columns are displayed: image, buy, sale-price, tally and total. By default, a column heading are the same as a column name, you can easily change that by adding ’/’ at the end of a column name, just like ‘sale-price/Price’. If you do not want a heading, just add ’/’, like ‘sale-price/’ – This creates a column with an empty heading. This applies to all columns except ‘buby’, because it prints attributes.
  • products – Put products IDs there. If you want to connect two or more products under one title, use ’|’ symbol to connect them. For instance, ‘products=”1|2|3|4”’ creates a connection of products with IDs 1, 2, 3 and 4. You can add a name to every connection, as in case of a column, by adding ’/your-name’ at the end of a connection. Especially ’/’ left at the end of a connection creates an empty title. Remember that you can have as many connections as you want, use commas to separate them, like ‘products=”1|2/First title,3|4/Second title,5|6/’. Remember to add every item in connection a label. You can use it with categories and tags.
  • categories – Put categories slugs there. You can add mutliple categories, like ‘categories=”category1,category2”’.
  • tags – Put products tags there. You can add multiple categories, like ‘tags=”tag1,tag2”’. You can freely use this option with categories.
  • buy – add this tag if you:
    • have connected products in a ‘products’ tag
    • have added variable products
    In this tag, you can specify attributes and labels which are used to generate a table, in detail:
    • vertical-attribute – add ’/’ after this and write atrributes you want to add, connected by ’|’, like ‘buy=”vertical-attribute/Color|Type|Size”’
    • horizontal-attribute – add ’/’ after this and write atrribute you want to add e.g. ‘buy=”horizontal-attribute/Size”’. There can be only one attribute name!
    • label – add ’/’ after this and write labels you want to add to each product in connection connected by ’|’, like ‘label/Man|Woman|Child”’
  • one_product_one_image – add this tag with value ‘yes’ to last wholesale shortcode if you want every table to have one image for every product variation.
  • button_for_every_table – add this tag with value ‘yes’ to last wholesale shortcode if you want every table to have it’s own button – button_for_every_table=”yes”. By default it’s value is ‘no’.
  • grand_total – add this tag with value ‘yes’ to last wholesale shortcode if you want every table to have it’s own button – button_for_every_table=”yes”. By default it’s value is ‘no’.
  • link_in_title – add this tag with value ‘yes’ to last wholesale shortcode if you want every table to have a link to a product in the title.
  • hide_empty_rows – add this tag with value ‘yes’ to remove displaying rows in which all products variants are not available for purchase (out of stock).
  • order_by – add this tag with value like ‘title’ to change default order (by date).
  • element_type – add value “select” to show select instead of input for quantity
This image shows a relation between a shortcode and a table:

General recipe for shortcode:

[!wholesale columns="SKU/Title,image/Title,rating/Title,buy/Title,regular-price/Title,sale-price/Title,tally/Title,total/Title" products="ID1|ID2/Title,ID3|ID4/Title,ID5|ID6/Title" buy="vertical-attribute/Attribute1|Attribute2,label/label1|label2,horizontal-attribute/Attribute3"]
Remove ’!’ at the beginning, remove unwanted columns, change titles, attributes and labels and it is ready!

We can recommend you a Wholesale Pricing Pro plugin. If the plugin doesn’t work with your discount system – let us know and we’ll check it out!


* 1.4.5
    * fixed minor issues
    * changed attributes names to slugs matching for better compatibility

* 1.4.4
    * added wholesale_filter_format_cart_total_text to allow "Add to cart" text manipulation
    * added JS event "optart_wholesale_update_row" when updating row
    * JS function "add_items_to_cart" returns now AJAX promise for custom action to be applied after "Add to cart" button clicked
    * JS function "update_add_to_cart_button" can now be used to update a custom "Add to cart" button

* 1.4.3
    * added live update for total column with "format_price" class for total price formatted by woocommerce
    * added "show_tables_total" shortcode tag to format "Add to cart" button with wholesale summary (items and total value)

* 1.4.2
    * added format_price="yes/no" tag to the wholesale shortcode, default is "no" 
    * added heading set for qty column, if qty name not set, header is empty

* 1.4.1
    * Fixed: broken product variations for attribute names with comma "," 

* 1.4.0
    * New: ability to use selects instead of inputs for changing items count.
    * New: ability to replace missing item element.
    * New: brazilian UI translation.

* 1.3.1
    * Fixed: `hide_empty_rows` works correctly now, displaying all available options.

* 1.3.0
    * New: ability to set `hide_empty_rows` to skip rows that cannot be bought.
    * New: ability to sort items by date or title using `order_by` attribute.

* 1.2.5
    * Updated compatibility with the latest WooCommerce and WordPress
    * Fixed: Invalid names in the multiple variable products scenario