Ordering.co's Multi Importer stores categories, products and modifiers in a row-by-row spreadsheet. Hyperzod expects one product row with its option groups nested inside it. CSV Pilot recognizes the importer headers, deduplicates repeated product rows, rebuilds the modifier hierarchy, validates the result and exports a Hyperzod-ready CSV.
You do not need to rename all 23 columns. The important part is using the original Multi Importer file and reviewing fields that the source format does not contain.
What the Ordering.co file contains
The supported file is identified by fields such as:
External business id, External category id, Categories name, External product id, Products name, Products price, Products description, Products images, Products enabled, External extra id, Extras name, External extra option id, Extra options name, Extra options min, Extra options max, External extra option suboption id, Extra option suboptions name and Extra option suboptions price.
Ordering.co uses external IDs to connect each row to the correct business, category, product and modifier. Its modifier structure has three levels:
- Extra — the broad modifier area, such as “Meal choices.”
- Extra Option — the selection group and its minimum/maximum rules, such as “Choose a drink” with min 1 and max 1.
- Sub-option — the customer-facing choice, such as “Cola,” with its price adjustment.
The same product fields repeat for every sub-option. CSV Pilot groups those rows by External product id, so they become one Hyperzod product rather than duplicate products.
How the automatic conversion works
Upload the file and ask: “Convert this Ordering.co CSV to Hyperzod format.” CSV Pilot then:
- Groups repeated rows by
External product id. - Maps the product name, base price, description, image, category and enabled status.
- Builds one Hyperzod option group for each Extra Option.
- Carries each Sub-option's price as a price delta over the product base price.
- Sets the group to required when
minis at least 1. - Uses a MULTIPLE group when
maxis greater than 1. - Enables an explicit minimum/maximum range when
minis 2 or higher. - Keeps context by prefixing the group with the Extra name when one Extra contains several option groups.
Small example
Assume “Burger Meal” has a base price of 8.00. Its “Choose a drink” group contains Cola at 0.00 and Juice at 1.50, with min 1 and max 1. The Hyperzod result is one 8.00 product with a required, single-select group. Choosing Juice produces a final price of 9.50; CSV Pilot does not add the full product price twice.
Field mapping
| Ordering.co field | Hyperzod result |
|---|---|
External product id | Product grouping key |
Products name | Product name |
Products price | Base selling price |
Products description | Description |
Products images | Product image |
Categories name | Category |
Products enabled | Active/inactive status |
Extras name + Extra options name | Option group name |
| Sub-option name + price | Choice + price delta |
| Extra Option min/max | Required, SINGLE/MULTIPLE and range rules |
Source gaps you should know about
The verified Multi Importer structure does not carry every Hyperzod field:
- SKU: there is no SKU column. CSV Pilot creates a stable product SKU in the form
ORD-{external product id}. - Inventory: there is no quantity column, so inventory remains untracked. Set stock after import if your Hyperzod workflow requires it.
- Cost price: there is no source cost field. The conversion uses 0 because the target structure requires a value.
- Compare price: the file has no regular/compare-price column.
- Images: one product image is carried from
Products images. - Multiple businesses: CSV Pilot converts the first business in the file and reports how many rows from other businesses were skipped. Split multi-business exports before conversion when you need every business.
These are source-format boundaries, not guesses. CSV Pilot does not manufacture inventory or financial values that are absent from the file.
Preflight and verification
Ordering.co's importer documentation recommends unique external IDs, decimal prices written with a dot, and a small test before processing a large menu. Follow the same checks in the reverse direction:
- Keep the external ID columns unchanged.
- Confirm that all rows for one product use the same external product ID.
- Check one required group, one multiple-select group and one product without modifiers.
- Verify that a Sub-option price is a delta, not a second full product price.
- Review generated SKUs and set inventory after conversion if needed.
See the official OrderingPlus importer instructions for the source file's external-ID and modifier model.
Open CSV Pilot to convert the export. The original Ordering.co file remains unchanged, and the preview lets you verify the result before download.
CSV Pilot is an independent tool and is not affiliated with Ordering.co, OrderingPlus or Hyperzod.