Supplier stock in Clubify

You'll find it under Shop → Inventory → Suppliers.

You can upload the supplier's stock list and see what they have in stock alongside your own. It is only a view. You cannot sell from the supplier's stock, and your own stock is not changed.

How to find it

  1. Open Shop in the side menu
  2. Choose Inventory
  3. Open the tab Suppliers
  4. Click New supplier and choose the CSV file

Before you start

  • Ask the supplier for the stock list as a CSV file. It can be opened in Excel. The file must have one column with barcode or SKU and one with quantity. Price is optional
  • Your products must have the same barcode or SKU as the supplier uses. Add it to the product or variant under Shop → Products

Upload a list

  1. Open Shop in the side menu and choose Inventory
  2. Open the tab Suppliers
  3. Click New supplier and type the name, for example Mastersport
  4. Choose the CSV file. Clubify suggests which columns are barcode, SKU, quantity and price. Correct them if they are wrong
  5. Check the first rows in the preview and click Import

The report shows how many rows were imported, how many matched your products, and which rows did not.

See the supplier's stock

In the Stock levels tab there is the column At supplier with the quantity and the date of the last import. If it says "–", the item is not in the list, or the supplier uses a different code from the one you entered. If the supplier has the code on the product and not on the size, the number is shown on all the sizes with "Whole product" below.

Update the list

Click Upload list next to the supplier and choose a new file. The new list replaces the previous one, and items that are not in the new file disappear from the view. Clubify does not fetch the list itself, so you upload it whenever you want fresh numbers.

If something goes wrong

  • Many rows matched nothing: check that barcode or SKU is on your products, and that you chose the right column
  • Barcodes show as 7.04E+12: Excel has shortened them. Save the column as text and upload again
  • Rows were skipped: the report says which row and why, for example that barcode and SKU are missing, or that the quantity is not a whole number
  • A file can have up to 20,000 rows

Who sees this

Administrators and staff with access to Shop. Staff who are limited to certain departments do not see supplier stock, because it applies to the whole club. Customers never see it.