For suppliers
Upload your catalogue in one pass.
A real catalogue is not typed in. Export the CSV, change the cells that moved, dry-run the upload to see what would happen, then upload for real. This guide walks through it and explains every column.
Five steps.
The columns.
One row is one offer: your price for one product variant in one market and currency.
| Column | What it holds | Notes |
|---|---|---|
| ProductVariantCode | The catalogue code of the product variant the offer prices | Required. Identifies the row together with MarketCode and Code |
| Code | Your own reference for the offer | Required. How a re-import recognises the same offer |
| MarketCode | The market the offer competes in, for example AU | Required |
| CurrencyCode | The currency of the price, for example AUD | Required |
| UnitPrice | Your unit price, ex GST | Required. A published offer needs a price above zero |
| ListPrice | An optional list price, ex GST | Cannot be lower than the unit price |
| MinimumOrderQuantity | The smallest quantity you sell | Blank means 1 |
| StockStatus | Unknown, InStock, Limited, MadeToOrder or OutOfStock | An out-of-stock offer cannot be published |
| AvailableQuantity | How many you can supply now | Optional; not allowed when out of stock |
| LeadTimeDays | Days from order to delivery | Optional |
| ValidFrom | First day the offer applies | yyyy-MM-dd |
| ValidTo | Last day the offer applies | yyyy-MM-dd; drives the expiring queue. Not before ValidFrom |
| IsPreferred | A mark set by Modern GBQ staff only | A supplier's value is ignored, and the mark does not affect which offer wins a line |
| SupplierProductCode | Your own product code | Optional; travels with the offer |
| DeliveryTerms | Shipping terms for overseas offers (the Incoterm and the named place) | Optional for Australian offers |
| Notes | Anything your buyer should know | Optional |
| MasterItemCode | The catalogue item a new product belongs to | New products only: fill all four of MasterItemCode, ProductCode, ProductName and UnitOfMeasureCode |
| ProductCode | The code of a product not yet in the catalogue | New products only |
| ProductName | Its name | New products only |
| VariantName | The variant's name, for example a size or colour | New products, optional |
| UnitOfMeasureCode | The unit the product is measured in | New products only. A new product is created as a Draft under your organisation; its offer is added once the catalogue team activates it, so re-run the import then |
Upload questions.
Can I price any product in the catalogue?
No. A row for an existing product that is not listed under your business is refused, just as the on-screen form refuses it. You price your own products; a product nobody owns yet can be created by the import as a Draft under your organisation.
Why was my row set aside with a warning?
Every price passes the same check before it can price an estimate line: the unit must be the unit the item is measured in, and the figure should sit within a band around the item's usual rate where it has one. A price per box for an item measured per square metre is what the check catches. Correct it, or raise a Support ticket if the figure is right.
Do my quotes change when I upload new prices?
Edits apply from the next estimate priced. Estimates already priced keep the figures they were priced with, so history stays honest on both sides.
How many products can I list?
That depends on your plan: Listed is free once verified with up to five listed products (a product with at least one published, in-date offer); Silver, Gold and Platinum list more. Uploading more rows than your plan allows leaves the extra offers as Drafts until a place is free.
Where do I download the template?
From Offers & pricing in your supplier workspace, once you are signed in: Export CSV. The export is the template.
Get your prices into real estimates.
Free listing, conditions apply.