About wholesale

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.

How does it work?

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.

output_MwbAKa

Any compatible plugins?

We can recommend you a Wholesale Pricing Pro plugin.

 

How do I create a table?

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’.

 

How do I create such a shortcode?

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 how many items are in stock
    • title – displays product 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.
  • 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”‘
  • 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:
Screenshot_13

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!

Examples

[!wholesale columns="buy,regular-price/MSRP,sale-price/WHLSL,tally/Tally,total/Total" products="40|130/General - all possibilities" buy="vertical-attribute/Color Combo|Mod,label/M|W|A|ZX|B,horizontal-attribute/Size"]
General - all possibilities
Color ComboMod123MSRPWHLSLTallyTotal
black/redmod2M251000
W302000
mod5M00
W302000
blue/redmod2M251000
W302000
mod5M251000
W302000
[!wholesale columns="buy,regular-price/MSRP,sale-price/WHLSL,tally/Tally,total/Total" products="40|130/General - Labels first" buy="label/M|W|A|ZX|B,vertical-attribute/Color Combo|Mod,horizontal-attribute/Size"]
General - Labels first
Color ComboMod123MSRPWHLSLTallyTotal
Mblack/redmod2251000
mod500
blue/redmod2251000
mod5251000
Wblack/redmod2302000
mod5302000
blue/redmod2302000
mod5302000
[!wholesale columns="buy,regular-price/MSRP,stock/In stock,sale-price/WHLSL,tally/Tally,total/Total" products="40|130/Only vertical attributes" buy="vertical-attribute/Color Combo|Mod|Size,label/M|W|A|ZX|B"]
Only vertical attributes
Color ComboModSizeIn stockMSRPWHLSLTallyTotal
black/redmod21M00
W61302000
2M251000
W61302000
3M251000
W00
mod51M00
W61302000
2M00
W61302000
3M00
W00
blue/redmod21M251000
W61302000
2M251000
W61302000
3M00
W00
mod51M251000
W61302000
2M251000
W61302000
3M00
W00
[!wholesale columns="buy,regular-price/MSRP,sale-price/WHLSL,tally/Tally,total/Total" products="40|130/As previous but with a few connections,40|130/Next connection,40|130/Another connection" buy="vertical-attribute/Color Combo|Mod|Size,label/M|W|A|ZX|B"]
As previous but with a few connections
Color ComboModSizeMSRPWHLSLTallyTotal
black/redmod21M00
W302000
2M251000
W302000
3M251000
W00
mod51M00
W302000
2M00
W302000
3M00
W00
blue/redmod21M251000
W302000
2M251000
W302000
3M00
W00
mod51M251000
W302000
2M251000
W302000
3M00
W00
Next connection
Color ComboModSizeMSRPWHLSLTallyTotal
black/redmod21M00
W302000
2M251000
W302000
3M251000
W00
mod51M00
W302000
2M00
W302000
3M00
W00
blue/redmod21M251000
W302000
2M251000
W302000
3M00
W00
mod51M251000
W302000
2M251000
W302000
3M00
W00
Another connection
Color ComboModSizeMSRPWHLSLTallyTotal
black/redmod21M00
W302000
2M251000
W302000
3M251000
W00
mod51M00
W302000
2M00
W302000
3M00
W00
blue/redmod21M251000
W302000
2M251000
W302000
3M00
W00
mod51M251000
W302000
2M251000
W302000
3M00
W00
[!wholesale columns="image/,buy,regular-price/MSRP,sale-price/WHLSL,tally/Tally,total/Total" products="325|325/Only horizontal attributes" buy="label/M|K,horizontal-attribute/Size"]
Only horizontal attributes
123456MSRPWHLSLTallyTotal
M15015000
K15015000
[!wholesale columns="SKU,image,rating/,buy,regular-price/MSRP,sale-price/WHLSL,tally/Tally,total/Total" products="56/Simple product"]
Simple product
SKUimageMSRPWHLSLTallyTotal
Test sku3500350000
[!wholesale columns="image/,rating/,buy,regular-price/MSRP,sale-price/WHLSL,tally/Tally,total/Total" products="99|96|93/Simple products" buy="label/Woo Single #2|Woo Album #4|Woo Single #1"]
Simple products
MSRPWHLSLTallyTotal
Woo Single #23200
Woo Album #49900
Woo Single #13300