Create a Marketplace Orders Hub Catalog
This document provides an introduction to Marketplace Orders Hub catalogs and how to create and curate them.
Your Marketplace Orders Hub catalog is a comprehensive listing of your product offerings. Marketplace Orders Hub (“the Hub”) offers a simple process to create and update your catalog. Read on to find out how to get started.
About catalogs
With one catalog on the Hub, you can create listings on multiple marketplaces.
Your catalog is created from the product listings you supply. You specify product listings in a catalog file. The catalog file contains listing information that is “global” and available to all marketplaces.
The product listings in your catalog are enhanced by the dynamic attributes you supply. Dynamic attributes are information that changes or is local to the marketplace, like price or inventory. Dynamic attributes files give you the flexibility to adapt to the needs of each marketplace. You specify dynamic attributes for your listings in a dynamic attributes file.
The products in your catalog must be included in dynamic attribute files to be listed on marketplaces.
Create your catalog
To create a catalog, you create both catalog and dynamic attributes files. These are your listing files. We upload your listing files to the marketplace. Send your catalog and dynamic attributes files to us at [email protected].
Change your catalog
To change basic listing information, edit your catalog file. To change the dynamic attributes of a catalog listing, edit the associated dynamic attributes file. For example, to indicate that a listed item is no longer available, change its availability in the dynamic attributes file. Use the template files as guides to the correct format.
You can change your catalog as often as you like. After you make your changes, send us new copies of the catalog and dynamic attributes files. The new files will overwrite the old files. Your updates are effective after we process and publish your files to the Hub.
Catalog file basics
Specify your product listings in an XLSX format file. Save the file with the .xlsx filename extension.
You must include the columns that are marked “Mandatory” in your catalog file. The fields in mandatory columns must not be empty. You can enhance your listings further by adding custom columns to your catalog file and using them to provide additional information of interest to customers. The fields of custom columns can remain empty.
A typical catalog file includes the columns shown in the following table.
Column | Mandatory | Description |
---|---|---|
SKU | ✓ | The retailer-defined identifier of the product. SKU numbers should not fluctuate over time. This value must not exceed 40 characters. |
UPC | ✓ | The UPC identifier of the product. This value must not exceed 40 characters. |
Category | ✓ | The name of the top-level category that includes the product. Categories are user-defined. Category names must not exceed 200 characters. |
Subcategory | ✓ | The name of the lower-level category that includes the product. Category names must not exceed 200 characters. |
Product Name | ✓ | The name of the product. The product name must not exceed 255 characters. |
Alcohol | ✓ | Enter ‘Y’ (yes) if the item contains alcohol. Otherwise, enter ‘N’ (no). |
Tobacco | ✓ | Enter ‘Y’ (yes) if the item contains tobacco. Otherwise, enter ‘N’ (no). |
Category Timings | ✓ | The range of time, specified in UTC, for which the product will be available on the marketplace. Set the range in hours (HH) and minutes (MM) in the format HH:MM-HH:MM. |
Description | ✓ | A text description of the product. The description must not exceed 1000 characters. |
Image URL | ✓ | The URL location of a product image to include in the listing. The URL must not exceed 1000 in length. |
Product Type | ✓ | A label that describes the classification of the product. For example, “BEVERAGE” or “FOOD”. Use no more than 1000 characters. |
Brand | ✓ | The brand name of the product. |
ABV | The alcohol content of the item, by volume percentage. The percentage value must not exceed two decimal places. |
|
Substitutes | The SKU numbers of one or more candidate items for replacement. Each SKU number is limited to 40 characters in length. Specify multiple SKU numbers in a comma-separated string. |
|
Volume Restriction | The maximum number of product units that the customer can purchase in one order. |
Dynamic attributes file basics
Use dynamic attributes files to specify information that is “local” to a specific marketplace. For example, use a dynamic attributes file to change the price of an item by UPC, for one specified marketplace. The price of the item remains the same for the other marketplaces. Alternately, you can use the dynamic attributes file to remove an item from one or more marketplaces. To do so, set availability to ‘N’ (not available) for items of the given UPC at the specified marketplaces.
Specify the dynamic attributes of your listings in an XLSX format file. Save the file with the .xlsx filename extension.
A typical attributes file includes the columns shown in the following table. These columns are mandatory and must be specified.
You can add custom columns to a dynamic attributes file. The name and format of the custom columns in the dynamic attributes file, however, must match those of the catalog file. Mismatches prevent old data from being overwritten by new data. The fields in custom columns can be left empty.
Column | Mandatory | Description |
---|---|---|
SKU | ✓ | The retailer-defined identifier of the product. SKU numbers should not fluctuate over time. This value must not exceed 40 characters. |
Price | ✓ | The price of the item before markup. The currency type is determined by the retailer region. Specify the value with the precision of 2 decimal places. |
Availability | ✓ | If the item is available, enter ‘Y’ (yes). If not, enter ‘N’ (no). Catalog Items that are marked as unavailable do not appear in the marketplaces that you define in your dynamic attributes files. |
Vendor | The marketplaces on which this product is listed. To specify multiple marketplaces, use a comma-separated list. The product is listed only on the specified marketplaces. If a marketplace is not specified, the product is listed on all subscribed marketplaces. |
|
Store | The stores with which this product should be listed for the specified marketplaces. You can include multiple store IDs, in a comma-separated list. Each store ID is limited to 40 characters in length. If this field is empty, the product is listed on all stores for the specified vendors. |
Updated 2 months ago