Import Supplier Products

Upload per Supplier at inventory > suppliers. Use the upload button on any of the available suppliers.

Create a seperate csv file for each supplier

Sample file: click here

Use the following fields:

Fields Mandatory Type Description
sku no Text(64) Clougistic SKU
pn yes Text(64) Partnumber Supplier
mpn no Text(64) Manufacturer Partnumber
brand no Text(64) Brand
gtin no Text(255) GTIN (EAN or UPC)
name yes Text(255) Productname
weight no Numeric used for picking calculation, use same unit (g of pounds) as in settings > general > measurement
length no Numeric used for picking calculation, use same unit (m of inch) as in settings > general > measurement
width no Numeric used for picking calculation, use same unit (m of inch) as in settings > general > measurement
height no Numeric used for picking calculation, use same unit (m of inch) as in settings > general > measurement
unit_price yes Numeric Price per unit in supplier currency, set in inventory > suppliers > use the pencil to change settings
unit_qty no Numeric Quantity per unit
qty no Numeric Quantity in stock at supplier
eta no Text(64) Back in stock at supplier
supply_mbom no Numeric Use the product to supply in manufactur Bill of Material. 0=don't use, 1=use, if not imported the value is use (1)

Product dimensions are optional but is recommended.

It's important to add products to the Clougistic catalog first, to be able to match.

Match order

If the Clougistic SKU is not available in the Supplier Products list, Clougistic will match the supplier products against the product list. The match order is:

  1. GTIN/EAN
  2. MPN+Brand (If no GTIN/EAN exists)
  3. PN+Brand (If the partnumber is the manufacturer partnumber)

If there is a match, the supplierproducts list will show the corresponding product SKU or the info [No Match].