Supplier price comparator
Shops: the comparator is on AFASIN Pro, in My space → Comparator: one card per product, the best price per kg / litre, your purchase price and the possible saving, then See the offers to order or contact the supplier. The association manages the price lists here, in the application.
Purchases → Price Comparator compares the trade prices of the suppliers the association follows (Purchases → Suppliers to Follow: wholesalers and importers in France, Belgium, the Netherlands, the United Kingdom…). Search a product, a brand or a barcode, and filter by supplier, country or category.
- One line per product (default display): the same product sold by several suppliers appears once, recognised by its association catalog sheet (shown with our SKU; a supplier line with the sheet's barcode is attached to it too), else its barcode (EAN), else its name. The line shows the number of suppliers, their references, the best price and who offers it, and the price range (up to + %). Click it to see every supplier: reference, the product name they use, EAN, pack, price, payment and delivery terms. Sorts: product name, cheapest per kg / L or per unit, most suppliers, best for my address.
- Every supplier line: the lines one by one, the cheapest of each product marked Best price and the others with how much more they cost (+ %); the association edits or deletes a price there.
- Our SKU: every product of the association catalog has our own reference (AF000123); the supplier's code stays on its line as Ref.. Products without a shared barcode are matched across suppliers by brand, size and name; when a line is not recognised, the association opens Every supplier line and uses the link icon (Associate with a product) to put it under the right product, or to detach it.
- Pages: 25 lines per page, with the page numbers under the table; a new search or filter starts again at page 1.
- Per unit and per kg / litre: each price is for a pack (carton of 12 × 400 g, sack of 25 kg…). The comparator divides it by the number of units and, when the size is known, by the weight or volume, so different packs can be compared.
- Currencies: prices in pounds or dollars are converted to euros with the rates of Settings → Currencies.
- My purchase price (member shops): when one of your products has the same barcode or comes from the same catalog sheet, its purchase price is shown, with the saving per unit when a supplier is cheaper. My products only keeps just those.
- The table is exported as CSV with the icon at the top right.
Filling the prices (association)
- Add Price: one line (supplier, product, pack, price, date, link). Typing “Carton 12 x 400 g” fills the units and the size.
- Import Price List: a supplier's CSV file (sample in the window; French headings work). Importing a newer list updates the prices of the same product and pack.
- The MCP Super Admin AI assistant can add the prices read from a price list, a catalogue or a supplier's website.
- Price on request: a supplier's catalogue often lists products without prices. Leave the price empty: the line shows “Price on request” and takes no part in the comparison until a price arrives. The photo and labels come from the linked catalog sheet.
- Same reference everywhere: the supplier's reference (Ref.) is also the SKU of the catalog sheet, and the barcode (EAN) is the same on both. When a newer price list carries the reference, it updates that line even if the product name is written differently.
- In Suppliers to Follow, the association adds, edits or stops following a supplier (currency of its prices, contacts, categories, minimum order, notes).
Automatic update every day
- Price list address (supplier form): a CSV file, a Google Sheets or Google Drive file shared with “anyone with the link”, or the supplier's own price-list link. Every day the list is imported again (same columns as the import): new products are added, prices are updated, products no longer in the list are hidden. The address is visible to the association only.
- Link to the product (price line): every day the price is read again on the supplier's page, when the page publishes it (schema.org markup used by most online shops). Pages that need a login cannot be read: the reason is shown under the date for the association.
- Read prices from the website (supplier form): when the supplier's site shows its prices to any visitor, AFASIN Pro reads them every day: the public product feed of a WooCommerce or Shopify shop, otherwise the product pages of the sitemap with schema.org markup. The pack is read from the product name (“10x100Gr”, “25kg”, “1ltr”). The site's robots.txt is respected and pages are read slowly. Prices shown only after signing in cannot be read. On 22/10/2026 this works for Exotique Pro and African Choice; the other sites hide their prices or show none.
- The Automatic update column shows the last update or the error; Update now (under the supplier's name) runs it at once for one supplier, and Update Prices Now at the top of the comparator for all of them (the list fills in as prices arrive). In the comparator, an arrow shows how much the price changed since the previous one.
Prices are the suppliers' trade prices on the date shown, usually excluding VAT and delivery. Check the conditions (minimum order, delivery costs) with the supplier before ordering.
