Order file for Metro, Transgourmet & Chefs Culinar: web shop orders without retyping
After reading this article you'll be able to download a supplier order as a file for your wholesaler's web shop, maintain customer number, order cut-off and delivery days per supplier, and import wholesaler price lists with item numbers and purchase prices into your item catalogue.
With Metro, Transgourmet or Chefs Culinar you usually order in the web shop. Instead of retyping the list from Univents there, download it as a file and upload it in the shop or use it as a template.
Download the file
- Open the order: in the event, on the Bookings tab in the suppliers section, or in Inventory on the Order tab under the open orders.
- Click Download file for Metro next to the supplier (the name follows the wholesaler in the ordering settings; without settings the button is called Download order file).
- The dialog shows how many lines the file contains, which delivery day is written into it and which items have no supplier item number.
- Click Download. The file is a CSV file that opens directly in Excel.
- Once you have ordered in the shop, click Mark as ordered now. The order then shows up in goods receipt, and the supplier gets no email.
Downloading sends nothing and changes nothing on the order.
What the file contains
- The supplier's item number. If an item has several suppliers, the number of exactly this supplier is used.
- The quantity in whole packs, always rounded up. For 30 pieces and a case of 12, the file says 3 cases. Items without a pack size use their unit, also rounded up to a whole number, and are listed in the dialog.
- Description, pack size and unit for checking.
- Customer number and delivery day from the ordering settings.
For Metro, Transgourmet and Chefs Culinar, items without an item number are not written as order lines, because the shop would reject them. They appear in a note block at the end of the file and in the dialog before the download. For the wholesaler Other they are written as a normal line with an empty number. Lines declined by the supplier never appear in the file.
For Transgourmet there is also the openTRANS XML format, which Transgourmet accepts for electronic orders.
Ordering settings per supplier
At the top of the dialog you maintain for the supplier:
- Wholesaler: Metro, Transgourmet, Chefs Culinar or Other. Button, file name and formats depend on it.
- Customer number at supplier, for example your Metro customer card number.
- Order cut-off (time), lead time in days and delivery days.
If the order has no delivery or pick-up time, Univents calculates the next possible delivery day: before the cut-off, today counts as order day, afterwards tomorrow. The lead time is added, then the supplier's next delivery day is used. Example: cut-off 10:00, lead time 1 day, delivery on Tuesdays and Fridays. Ordering on Monday at 9 am gives Tuesday, at 11 am it becomes Friday.
If the order belongs to an event, Univents uses the latest possible delivery day before the event day instead, so the goods arrive fresh and are not stored for weeks. Example: event on Tuesday, 15 December, delivery on Tuesdays and Fridays → delivery day Friday, 11 December. If there is no delivery day left before the event, the next possible delivery day goes into the file.
Saving requires the right to edit the inventory.
Import item numbers from a price list
For a complete file your items need the supplier's item number. The quickest way into the catalogue is the wholesaler's price list:
- Open Inventory → Import and upload the price list (Excel or CSV).
- In the Mapping step, choose for example Metro price list under Template for a wholesaler price list.
- Enter the name or email address of the supplier contact under Supplier.
- The template maps typical columns such as item no., description, price, pack, contents, unit, allergens and EAN. Check the mapping and change it by hand if needed.
With a template, the import works like this:
- In the price list, item number is the wholesaler's number, not your own.
- Existing items are matched first by supplier and supplier item number, otherwise by name. The name of a matched item stays as it is.
- The purchase price is updated if it differs. All other fields are only filled if they are still empty on the item.
- A price list needs no sales price. New items then start at 0, existing ones keep theirs.
- Overwrite existing values is not available with a template.
If the purchase price should only change from a certain date, use Import supplier price lists instead.
Good to know
- The exact upload formats of the shops may differ. If a column does not fit, open the file in Excel, adjust it and save it as CSV again.
- In the AI assistant, the order-file tool creates the same file without saving anything.